pixiReportInventoryItemsToRefillMinStock
Since pixi version: AVA Official - Update 23 (8.4.23.27873) Additional notes:
Request
Request body
Name | Type | Required | Description |
---|---|---|---|
Type | integer | false | -- 1 From Location Open Cust Order + AddLocation Missing Qty -> ToLoc
Type: int Default value: NULL Example: 123 Available from: AVA 17.03 (8.4.27.29272) |
SortBy | string | false | 1 means sorting by ToLocID bins otherwise FromLocID bins are sorted Type: varchar(1) Default value: NULL Example: abcdefg Available from: AVA 17.03 (8.4.27.29272) |
ToLocID | string | false | Location to Pick From Type: varchar(3) Default value: Example: abcdefg Available from: AVA 17.03 (8.4.27.29272) |
MinStock | boolean | false | Also include MinStock Refill Type: bit Default value: 1 Example: 0 or 1 Available from: AVA 17.03 (8.4.27.29272) |
FromLocID | string | false | Location to Fill to Type: varchar(3) Default value: Example: abcdefg Available from: AVA Official - Update 23 (8.4.23.27873) |
AdditionalLocID | string | false | Add a 2nd Location ID to refill from Type: varchar(3) Default value: NULL Example: abcdefg Available from: AVA 17.03 (8.4.27.29272) |
Request Example
<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
<Body xmlns="">
<pixiReportInventoryItemsToRefillMinStock>
<FromLocID>string</FromLocID>
<MinStock>true</MinStock>
<ToLocID>string</ToLocID>
<AdditionalLocID>string</AdditionalLocID>
<SortBy>string</SortBy>
<Type>0</Type>
</pixiReportInventoryItemsToRefillMinStock>
</Body>
</Envelope>
Response
Name | Type | Description |
---|---|---|
EanUpc | string | Item barcode Type: varchar (13) Available from: 25.06 (25.6.0.58802) |
SortBy | string | 1 = ToLocBin- Sortnumber, 0 = FromLocBin- SortNumber Type: varchar (1) Available from: 25.06 (25.6.0.58802) |
ItemName | string | Item name Type: varchar (120) Available from: 25.06 (25.6.0.58802) |
ToLocQty | integer | Location quantity target location Type: int Available from: 25.06 (25.6.0.58802) |
FromBinqty | integer | Item stock on From Bin Type: int Available from: 25.06 (25.6.0.58802) |
FromLocQty | integer | Location quantity source location Type: int Available from: 25.06 (25.6.0.58802) |
MissingQty | integer | Quantity that needs to be refilled Type: int Available from: 25.06 (25.6.0.58802) |
ParToLocID | string | Value from parameter ToLocID Type: varchar (3) Available from: 25.06 (25.6.0.58802) |
SupplPrice | number | Supplier price of the item Type: money Available from: 25.06 (25.6.0.58802) |
MinStockQty | integer | Minimum stock quantity for the item Type: int Available from: 25.06 (25.6.0.58802) |
ParFromLocID | string | Value from parameter FromLocID Type: varchar (3) Available from: 25.06 (25.6.0.58802) |
PicLinkLarge | string | URL to picture of the item (large size) Type: varchar (512) Available from: 25.06 (25.6.0.58802) |
PicLinkSmall | string | URL to picture of the item (small size) Type: varchar (512) Available from: 25.06 (25.6.0.58802) |
ToLocIDbinName | string | Name target bin Type: varchar (50) Available from: 25.06 (25.6.0.58802) |
OrdersOnHoldQty | integer | Quantity sum of orderlines on HOLD Type: int Available from: 25.06 (25.6.0.58802) |
FromLocIDbinName | string | Name of source bin Type: varchar (50) Available from: 25.06 (25.6.0.58802) |
OpenCustOrdersQty | integer | Quantity sum of open customer orders Type: int Available from: 25.06 (25.6.0.58802) |
ToLocIDbinSortNum | integer | Sort number target bin Type: int Available from: 25.06 (25.6.0.58802) |
FromLocIDbinSortNum | integer | Sort number of source bin Type: int Available from: 25.06 (25.6.0.58802) |
Response Example
<PixiReportInventoryItemsToRefillMinStockPost200TextXmlResponse>
<FromLocIDbinName>string</FromLocIDbinName>
<FromLocIDbinSortNum>0</FromLocIDbinSortNum>
<ToLocIDbinName>string</ToLocIDbinName>
<ToLocIDbinSortNum>0</ToLocIDbinSortNum>
<EanUpc>string</EanUpc>
<ItemName>string</ItemName>
<ToLocQty>0</ToLocQty>
<FromLocQty>0</FromLocQty>
<MinStockQty>0</MinStockQty>
<SupplPrice>0</SupplPrice>
<OpenCustOrdersQty>0</OpenCustOrdersQty>
<OrdersOnHoldQty>0</OrdersOnHoldQty>
<ParFromLocID>string</ParFromLocID>
<ParToLocID>string</ParToLocID>
<SortBy>string</SortBy>
<MissingQty>0</MissingQty>
<FromBinqty>0</FromBinqty>
<PicLinkSmall>string</PicLinkSmall>
<PicLinkLarge>string</PicLinkLarge>
</PixiReportInventoryItemsToRefillMinStockPost200TextXmlResponse>
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:pixiReportInventoryItemsToRefillMinStock>
<Type xsi:type="xsd:integer">123</Type>
<SortBy xsi:type="xsd:string">abcdefg</SortBy>
<ToLocID xsi:type="xsd:string">abcdefg</ToLocID>
<MinStock xsi:type="xsd:boolean">0 or 1</MinStock>
<FromLocID xsi:type="xsd:string">abcdefg</FromLocID>
<AdditionalLocID xsi:type="xsd:string">abcdefg</AdditionalLocID>
</ns1:pixiReportInventoryItemsToRefillMinStock>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
PHP Example
<?php
getPixiSoapClientResponse('pixiReportInventoryItemsToRefillMinStock', [
'Type' => '123', // integer
'SortBy' => 'abcdefg', // string
'ToLocID' => 'abcdefg', // string
'MinStock' => '0 or 1', // boolean
'FromLocID' => 'abcdefg', // string
'AdditionalLocID' => 'abcdefg', // 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);
}