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
},
....
]