pixiReport_StockValue
API call exposes Stock value report.
Since pixi version: AVA 17.03 (8.4.27.29272) Additional notes:
Request
Request body
Name | Type | Required | Description |
---|---|---|---|
LocID | string | false | [optional] pixi* Location ID (filter). Type: varchar(10) Default value: Example: Available from: AVA 17.03 (8.4.27.29272) |
SupplNr | string | false | [optional] pixi* Supplier number (filter). Type: varchar(10) Default value: Example: Available from: AVA 17.03 (8.4.27.29272) |
Category | string | false | [optional] pixi* category ID (filter). Type: varchar(10) Default value: Example: Available from: AVA 17.03 (8.4.27.29272) |
ParamDate | string | false | [optional] Date used to show the data of Stock value report. If left empty it defaults to end of current day. Type: datetime Default value: Example: Available from: AVA 17.03 (8.4.27.29272) |
Request Example
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body xmlns="">
<pixiReport_StockValue>
<ParamDate>string</ParamDate>
<LocID>string</LocID>
<Category>string</Category>
<SupplNr>string</SupplNr>
</pixiReport_StockValue>
</Body>
</Envelope>
Response
1. Result set
Name | Type | Description |
---|---|---|
EK | number | EK Type: money Available from: 25.06 (25.6.0.58802) |
LocID | string | LocID Type: varchar Available from: 25.06 (25.6.0.58802) |
Sum_EK | number | Sum_EK Type: money Available from: 25.06 (25.6.0.58802) |
Barcode | string | Barcode Type: varchar Available from: 25.06 (25.6.0.58802) |
Bestand | integer | Bestand Type: int Available from: 25.06 (25.6.0.58802) |
MwStSatz | number | MwStSatz Type: numeric Available from: 25.06 (25.6.0.58802) |
VK_Netto | number | VK_Netto Type: numeric Available from: 25.06 (25.6.0.58802) |
Kategorie | string | Kategorie Type: varchar Available from: 25.06 (25.6.0.58802) |
Rohertrag | number | Rohertrag Type: numeric Available from: 25.06 (25.6.0.58802) |
Rohertrah | number | Rohertrah Type: numeric Available from: 25.06 (25.6.0.58802) |
SupplName | string | SupplName Type: varchar Available from: 25.06 (25.6.0.58802) |
VK_Brutto | number | VK_Brutto Type: money Available from: 25.06 (25.6.0.58802) |
par_LocID | string | par_LocID Type: varchar Available from: 25.06 (25.6.0.58802) |
Artikelname | string | Artikelname Type: varchar Available from: 25.06 (25.6.0.58802) |
par_SupplNR | string | par_SupplNR Type: varchar Available from: 25.06 (25.6.0.58802) |
CurrencyCode | string | CurrencyCode Type: varchar Available from: 25.06 (25.6.0.58802) |
Sum_VK_Netto | number | Sum_VK_Netto Type: numeric Available from: 25.06 (25.6.0.58802) |
par_Category | string | par_Category Type: varchar Available from: 25.06 (25.6.0.58802) |
Artikelnummer | string | Artikelnummer Type: varchar Available from: 25.06 (25.6.0.58802) |
Sum_VK_Brutto | number | Sum_VK_Brutto Type: money Available from: 25.06 (25.6.0.58802) |
par_paramdate | string | par_paramdate Type: datetime Available from: 25.06 (25.6.0.58802) |
LieferantenArtikelnummer | string | LieferantenArtikelnummer Type: varchar Available from: 25.06 (25.6.0.58802) |
Response Example
<PixiReport_StockValuePost200TextXmlResponse>
<LieferantenArtikelnummer>string</LieferantenArtikelnummer>
<Artikelnummer>string</Artikelnummer>
<Barcode>string</Barcode>
<Artikelname>string</Artikelname>
<Kategorie>string</Kategorie>
<SupplName>string</SupplName>
<LocID>string</LocID>
<Bestand>0</Bestand>
<VK_Brutto>0</VK_Brutto>
<VK_Netto>0</VK_Netto>
<EK>0</EK>
<Rohertrag>0</Rohertrag>
<Sum_VK_Netto>0</Sum_VK_Netto>
<Sum_VK_Brutto>0</Sum_VK_Brutto>
<Sum_EK>0</Sum_EK>
<MwStSatz>0</MwStSatz>
<Rohertrah>0</Rohertrah>
<CurrencyCode>string</CurrencyCode>
<par_paramdate>string</par_paramdate>
<par_LocID>string</par_LocID>
<par_Category>string</par_Category>
<par_SupplNR>string</par_SupplNR>
</PixiReport_StockValuePost200TextXmlResponse>
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:pixiReport_StockValue>
<LocID xsi:type="xsd:string"></LocID>
<SupplNr xsi:type="xsd:string"></SupplNr>
<Category xsi:type="xsd:string"></Category>
<ParamDate xsi:type="xsd:string"></ParamDate>
</ns1:pixiReport_StockValue>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
PHP Example
<?php
getPixiSoapClientResponse('pixiReport_StockValue', [
'LocID' => '', // string
'SupplNr' => '', // string
'Category' => '', // string
'ParamDate' => '', // 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);
}