NOTE: This is an article for the legacy API. To access updated information on this endpoint, please reference the HTML guide attached to the bottom of the REST API Access document
Description: Gets a list of open supply orders
Resource: SalesOrderDetail/
Verb: GET
Query String Options:
- demandSeriesId- Default, demandSeriesId=1
- includeClosed - boolean which allows you to see closed orders as well. Recommend limiting just to open orders, so includeClosed=false
- startDate - Optional, can limit result set to orders with demand date on or after a particular date
- endDate - Optional, can limit result set to orders with a demand date on or before a particular date.
Returns: JSON Array of SalesOrderDetail objects
Example Response JSON:
[{
"AlertKeyId": 836783,
"OpenQuantity": 7.00000,
"OpenBalance": 66.5000000000,
"DaysUntilDue": -49, //negative indicates late/overdue
"AVL": -13593.00000, //available quantity
"DaysUntilNextFulfillment": 0,
"DaysUntilFullyFulfilled": 0,
"ItemId": 1552,
"SiteId": 16,
"CustomerId": 28056,
"ItemCode": "07025001",
"SiteCode": "WHS-001",
"CC": "000770", //customer code
"CN": "Bob's Electronics", //customer name
"CustomerShipToCode": "604667",
"CSTN": "Bob's Electronics - Fort Collins", //customer ship-to name
"SalesOrderId": 836783,
"DemandSeriesId": 1,
"OrderNumber": "SO047492",
"LineNumber": 1.000000000000,
"ItemSiteId": 2035,
"CustomerShipToId": 32170,
"DemandType": 1, //Demand Type enum value
"LS": 1, //Line status enum value
"DemandDate": "2021/04/30",
"RSD": "2021/05/07",
"Quantity": 7.00000,
"InvoicePrice": 9.50000,
"InvoicePriceCurrency": "USD",
"InvoiceCost": 0.0,
"IsExceptional": false,
"Note": "iPhone 12 case",
"DateOrdered": "2021/04/30",
"QuantityShipped": 0.00000,
"D": "iPhone 12 case", //description
"IP": 16, //Inventory Position enum value
"UP": 1, //Usage Pattern enum value
"OH": 870.00000,
"StateCode": "TX",
"Abc": "N",
"NextFulfillmentDate": "2021/06/25",
"DateFullyFulfilled": "2021/06/25",
"ASt": 1, //alert state (active or suspended)
"APri": 1, //alerty priority
"AMsg": "Sales Order SO047492, Line #1, for customer 000770, quantity 7.00 is late, and you do not have enough on hand to satisfy all open demands for this item.",
"AT": 128, //alert type
"ATN": "Backorders" //alert type name
},
....
]