pixiReportStockValueHistEKPrice
Multi Currency: Return database currency code in field dbCurrency depend on if Multi Currency is Enabled then we:
- calculate and return data in database currency else
- calculate and return data in order / original currency (with value NULL for currency code).
Since pixi version: LOU Official - Update 46 (6.9.46.27927) Additional notes:
Request
Request body
| Name | Type | Required | Description |
|---|---|---|---|
| DateTo | string | false | Filter: Return only records till this InvoiceDate. Type: datetime Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
| ShopID | string | false | Filter: Return only records for this shop. Type: varchar(3) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
| ItemTag | string | false | Filter: Return only records for this item tag. Type: varchar(50) Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
| DateFrom | string | false | Filter: Return only records from this InvoiceDate on. Type: datetime Default value: NULL Example: Available from: LOU Official - Update 46 (6.9.46.27927) |
Request Example
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body xmlns="">
<pixiReportStockValueHistEKPrice>
<ShopID>string</ShopID>
<ItemTag>string</ItemTag>
<DateFrom>string</DateFrom>
<DateTo>string</DateTo>
</pixiReportStockValueHistEKPrice>
</Body>
</Envelope>Response
1. Result set
| Name | Type | Description |
|---|---|---|
| Anzahl | integer | Anzahl Type: int Available from: 25.06 (25.6.0.58802) |
| Gesamt | integer | Gesamt Type: int Available from: 25.06 (25.6.0.58802) |
| Artikel | string | Artikel Type: varchar Available from: 25.06 (25.6.0.58802) |
| dbCurrency | string | dbCurrency Type: varchar Available from: 25.06 (25.6.0.58802) |
| Artikelnummer | string | Artikelnummer Type: varchar Available from: 25.06 (25.6.0.58802) |
| EK-Preis netto | string | EK-Preis netto Type: varchar Available from: 25.06 (25.6.0.58802) |
| EK Gesamt netto | integer | EK Gesamt netto Type: int Available from: 25.06 (25.6.0.58802) |
| Anschaffungsdatum | string | Anschaffungsdatum Type: varchar Available from: 25.06 (25.6.0.58802) |
| Bewertungsabschl�ge | integer | Bewertungsabschl�ge Type: int Available from: 25.06 (25.6.0.58802) |
Response Example
<PixiReportStockValueHistEKPricePost200TextXmlResponse>
<Artikel>string</Artikel>
<Artikelnummer>string</Artikelnummer>
<Anschaffungsdatum>string</Anschaffungsdatum>
<EK-Preis_x0020_netto>string</EK-Preis_x0020_netto>
<Anzahl>0</Anzahl>
<EK_x0020_Gesamt_x0020_netto>0</EK_x0020_Gesamt_x0020_netto>
<Bewertungsabschl_xFFFD_ge>0</Bewertungsabschl_xFFFD_ge>
<Gesamt>0</Gesamt>
<dbCurrency>string</dbCurrency>
</PixiReportStockValueHistEKPricePost200TextXmlResponse>HTTP Example
POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
# echo -n '{{username}}:{{password}}' | base64 | pbcopy
Authorization: Basic {{token}}
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns1="https://apigateway.descartes.com/tms/pixi/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<ns1:pixiReportStockValueHistEKPrice>
<DateTo xsi:type="xsd:string"></DateTo>
<ShopID xsi:type="xsd:string"></ShopID>
<ItemTag xsi:type="xsd:string"></ItemTag>
<DateFrom xsi:type="xsd:string"></DateFrom>
</ns1:pixiReportStockValueHistEKPrice>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>PHP Example
<?php
getPixiSoapClientResponse('pixiReportStockValueHistEKPrice', [
'DateTo' => '', // string
'ShopID' => '', // string
'ItemTag' => '', // string
'DateFrom' => '', // string
]);
function getPixiSoapClientResponse(string $method, array $arguments = [])
{
$soapArguments = [];
foreach ($arguments as $key => $value) {
$soapArguments[] = new SoapVar($value, null, '', '', $key);
}
$soapClient = new SoapClient(null, [
'login' => '...',
'password' => '...',
'uri' => 'https://apigateway.descartes.com/tms/pixi/',
'location' => 'https://apigateway.descartes.com/tms/pixi/',
]);
return $soapClient->__call($method, $soapArguments);
}