pixiReport_LogisticQuality_NonCached

Wrapper used by the pixi* Seal app and the Dashboard app. NULL values are replaced by the defaults (14, '', 1). The call then runs pipiReport_LogisticQuality_Details with @CalcSeal = 1, which computes the data directly (not from a cache).

Order selection

Date range: from the start of the day @DaysBack days ago until the end of today.
The order creation date is the first ANG status change of its orderlines in OrderHistory within the range. The ship date is the earliest ShipDate of its orderlines.
Only orders whose OrderHeader.ShipDate is empty and that have at least one orderline in status ANG or AUS. If ShopID is not empty, that orderline must belong to this shop (OrdShopID).
Orders of customers that were locked (CustomersHist.HSLocked = 'Y') during the range are excluded.

Exclusions

Orders that were changed manually: the orderline creation times differ by more than 5 minutes.
Orders where the stock was not sufficient at the order date. Stock is calculated from InvBinItemLog on locations without special stock, minus the cumulated open demand per Artikel.
Orders with an orderline in status ANG whose Artikel stock is at most 1. The stock is ItemLocationSpecific.LocationQuantity if special stock locations exist, otherwise Items.Quantity.

Date adjustments

Orders created on Friday, Saturday or Sunday are moved to the following Monday.
Days without an invoice with total > 0 count as holidays. Orders on such a day, or on a day whose next day is such a day, are moved to the first invoice date of a later working day.

Result

Only orders with a ship date are counted.
DaysToShip is the number of full 24-hour periods between the adjusted creation date and the ship date. Negative values become 0.
One row is returned per DaysToShip value, with the count and its share of all counted orders.
An additional fixed row with DaysToShip = 99 and 0 orders is always appended.
The rows are sorted by DaysToShip.

Notes

The parameter OnlyItemsOnStock is passed on to pipiReport_LogisticQuality_Details, but that procedure does not use it. It has no effect.
All reads use NOLOCK, so the numbers can include uncommitted data.
The calculation runs on every call and can be expensive for large DaysBack values.
If no order qualifies, only the row with DaysToShip = 99 is returned and AllPackages is 0.
Columns Percentage and AllPackages are floating-point values. Percentage is a fraction between 0 and 1, not a value multiplied by 100.
Holidays are derived from days without invoices, so days without invoicing also count as non-working days.

pixiReport_LogisticQuality_Details

Tables used

Location · Read OrderHeader · Read Orderlines · Read OrderHistory · Read CustomersHist · Read Reservation · Read InvBinItemLog · Read OrderStates · Read ItemLocationSpecific · Read Items · Read Invoices · Read

Parameter	Type	Default	Description
`DaysBack`	int	14	Number of days back from today that are evaluated. `NULL` becomes 14. Example: `14`
`ShopID`	varchar(3) string	–	Shop filter on the orderline shop (`OrdShopID`). Empty or `NULL` means all shops. Example: `SH1`
`OnlyItemsOnStock`	bit boolean	1	Passed on to the detail procedure but not evaluated there; has no effect. Example: `1`

Result set 1 · Always

One row per number of days to ship, plus a fixed row with DaysToShip = 99, sorted by DaysToShip.

Column	Type	Description
`DaysToShip`	int	Full 24-hour periods between the adjusted order date and the ship date (minimum 0). The value 99 marks the fixed closing row.
`NRofORders`	int	Number of orders with this `DaysToShip` value (0 in the row with `DaysToShip = 99`).
`Percentage`	float decimal	Share of these orders in all counted orders, as a fraction between 0 and 1.
`AllPackages`	float decimal	Total number of counted shipped orders.

Response example

<SqlRowSet1>
  <row>
    <DaysToShip>0</DaysToShip>
    <NRofORders>152</NRofORders>
    <Percentage>0.76</Percentage>
    <AllPackages>200</AllPackages>
  </row>
  <row>
    <DaysToShip>99</DaysToShip>
    <NRofORders>0</NRofORders>
    <Percentage>0</Percentage>
    <AllPackages>200</AllPackages>
  </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:pixiReport_LogisticQuality_NonCached>
      <!-- <DaysBack>14</DaysBack> -->
      <!-- <ShopID>SH1</ShopID> -->
      <!-- <OnlyItemsOnStock>1</OnlyItemsOnStock> -->
    </ns1:pixiReport_LogisticQuality_NonCached>
  </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:pixiReport_LogisticQuality_NonCached>
      <!-- <DaysBack>14</DaysBack> -->
      <!-- <ShopID>SH1</ShopID> -->
      <!-- <OnlyItemsOnStock>1</OnlyItemsOnStock> -->
    </ns1:pixiReport_LogisticQuality_NonCached>
  </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 = [
    // 'DaysBack' => '14',
    // 'ShopID' => 'SH1',
    // 'OnlyItemsOnStock' => '1',
];

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

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

Notes

Related calls

Tables used

Result set 1 · Always

Response example