Reports Read

pixiReportOrdersOnPicklist

Returns the number of distinct orders that currently have order lines on an active (non-expired) picklist, optionally filtered by shop.

Counts how many orders are currently on a picklist.

An order line counts if its orderLineKey is referenced by a picklist item (PLItem.PLIorderlineRef) with Expired = 0.
The result is the number of distinct order numbers (ordernr) among these order lines, so an order with several lines on picklists counts once.
If ShopID is empty or NULL, all shops are included. Otherwise only order lines whose OrdShopId equals ShopID are counted.

The call returns one row with the single column NrOfOrders.

Notes

Both tables are read WITH (NOLOCK); the count may include uncommitted changes and is meant as a dashboard figure.
The header comment mentions output parameters, but the procedure declares none; the value is only returned as a result set.
The shop filter is applied to the order line's OrdShopId.

Tables used

Orderlines · Read PLItem · Read

Parameter	Type	Default	Description
`ShopID`	varchar(3) string	–	Shop ID to filter by. Empty or NULL counts orders of all shops. Example: `001`

Result set 1 · Always

One row with the number of distinct orders on active picklists.

Column	Type	Description
`NrOfOrders`	int	Number of distinct orders with at least one order line on a non-expired picklist item.

Response example

<SqlRowSet1>
  <row>
    <NrOfOrders>42</NrOfOrders>
  </row>
</SqlRowSet1>

POST https://apigateway.descartes.com/tms/pixi/
Content-Type: text/xml; charset=utf-8
Authorization: Basic BASE64(USERNAME:PASSWORD)

<?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/">
  <SOAP-ENV:Body>
    <ns1:pixiReportOrdersOnPicklist>
      <!-- <ShopID>001</ShopID> -->
    </ns1:pixiReportOrdersOnPicklist>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

curl -X POST 'https://apigateway.descartes.com/tms/pixi/' \
  --user 'USERNAME:PASSWORD' \
  --header 'Content-Type: text/xml; charset=utf-8' \
  --data-binary @- <<'XML'
<?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/">
  <SOAP-ENV:Body>
    <ns1:pixiReportOrdersOnPicklist>
      <!-- <ShopID>001</ShopID> -->
    </ns1:pixiReportOrdersOnPicklist>
  </SOAP-ENV:Body>
</SOAP-ENV:Envelope>
XML

<?php

$soapClient = new SoapClient(null, [
    'login' => 'USERNAME',
    'password' => 'PASSWORD',
    'location' => 'https://apigateway.descartes.com/tms/pixi/',
    'uri' => 'https://apigateway.descartes.com/tms/pixi/',
]);

$arguments = [
    // 'ShopID' => '001',
];

$soapArguments = [];
foreach ($arguments as $name => $value) {
    $soapArguments[] = new SoapVar($value, XSD_STRING, '', '', $name);
}

$response = $soapClient->__soapCall('pixiReportOrdersOnPicklist', $soapArguments);

SQL object:: dbo.pipiReportOrdersOnPicklist