pixiGetStockMovementTypes
Returns all stock movement types defined in Pixi with their key, name and system flag, sorted by name.
Returns the complete list of stock movement types from the table StockMovementTypes.
- The call has no parameters and applies no filter.
- Each row contains the key
SMTKey, the type nameTypeand the flagIsSystemType(the source columnSystem), which marks types that are predefined by the system. - Rows are sorted by
Typein ascending order.
Use the call as a lookup to translate the stock movement type keys that other stock-related calls return or expect.
Notes
The table is read with NOLOCK, so uncommitted changes may be visible. The SQL data types of the columns are not visible in the code; the types given are assumptions based on the column names.
Tables used
This call has no parameters.
Result set 1 · Always
One row per stock movement type, sorted by Type ascending.
| Column | Type | Description |
|---|---|---|
SMTKey
|
int |
Key of the stock movement type. |
Type
Nullable |
string |
Name of the stock movement type. |
IsSystemType
Nullable |
boolean |
Flag from column |
Response example
<SqlRowSet1>
<row>
<SMTKey>3</SMTKey>
<Type>Inventory</Type>
<IsSystemType>1</IsSystemType>
</row>
<row>
<SMTKey>12</SMTKey>
<Type>Rebooking</Type>
<IsSystemType>0</IsSystemType>
</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:pixiGetStockMovementTypes/>
</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:pixiGetStockMovementTypes/>
</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 = [
];
$soapArguments = [];
foreach ($arguments as $name => $value) {
$soapArguments[] = new SoapVar($value, XSD_STRING, '', '', $name);
}
$response = $soapClient->__soapCall('pixiGetStockMovementTypes', $soapArguments);
- SQL object:
- dbo.pipiGetStockMovementTypes