Description: Gets a list of open supply orders
Resource: OpenSupplyOrderLineDetail/
Verb: GET
Returns: JSON Array of OpenSupplyOrderDetail objects
Example Response JSON:
[{
"AlertKeyId": 14,
"AlertType": 6,
"PrimaryId": 104,
"PrimaryIdProperty": 1,
"PrimarySupplierName": "",
"DURD": -10,
"DUSD": -10,
"ITQ": 42.000000000,
"ITD": 0.0,
"CO": 0.00000000000,
"CR": 0.0,
"CIT": 0.0,
"WO": 26.25000000000000000,
"WR": 26.250000000000000000000,
"WIT": 26.250000000000000000000,
"ErpON": "0002",
"SupplyType": 8,
"ShipperId": 4,
"ItemId": 51,
"SiteId": 14,
"ItemSiteSupplierId": 105,
"SupplierId": 37,
"SupplierItemCategoryId": 0,
"BuyerId": 5,
"ItemSiteCategory1Id": 3,
"ItemSiteCategory2Id": 21,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ItemSiteCategory6Id": 1,
"ItemSiteCategory7Id": 1,
"ItemSiteCategory8Id": 1,
"UnitCubes": 0.000000,
"I": "0106022",
"SiteCode": "139",
"SC": "V0041",
"BuyerCode": "jfangio",
"BuyerName": "Juan Fangio",
"SN": "Contoso Assemblies",
"ISC1": "Audio",
"ISC2": "Bluetooth Headphones",
"ISC3": "Unassigned",
"ISC4": "Unassigned",
"ISC5": "Unassigned",
"ISC6": "Unassigned",
"ISC7": "Unassigned",
"ISC8": "Unassigned",
"D": "NT Wireless Bluetooth Stereo Headphones M402 Purple",
"SIC": "0106022",
"ActiveSupplierLevel": 1,
"ActiveOrderPolicy": 2,
"ResolvedItemStatus": 1,
"IP": 8,
"PrimarySupplierId": 37,
"BoMPosition": 1,
"WPIP": 4,
"IPLT": 4,
"SupplyOrderLineId": 14,
"SupplyOrderId": 7,
"ErpLN": 30.00000,
"ItemSiteId": 104,
"StockIqStatus": 32,
"ErpLineStatus": 1,
"ReleaseQuantity": 42.00000,
"RRQ": 42.00000,
"PurchaseCost": 0.00000,
"ExpectedShipDate": "2024-06-07T00:00:00",
"EDD": "2024-06-07T00:00:00",
"PlannedReceiptDate": "2024-06-07T00:00:00",
"RctQty": 42.000000000,
"RRctQty": 42.000000000,
"StandardPrice": 0.00000,
"OriginalReleaseQuantity": 42.00000,
"OriginalReceiptQuantity": 42.000000000,
"OESD": "2024-06-07T00:00:00",
"OEDD": "2024-06-07T00:00:00",
"Abc": "A",
"Xyz": "X",
"OpenDollars": 0.000000000,
"LinePurchaseCost": 0.000000000,
"UnitOfMeasure": "EA",
"OCD": "2024-05-21T00:00:00",
"RD": "2024-05-21T00:00:00",
"ExpectedReleaseDate": "2024-05-21T00:00:00",
"UnitWeight": 0.625000000000,
"AQ": 318.00000,
"OH": 336.00000,
"TotalOnOrderQuantity": 90.00000,
"SS": 297.00000,
"MRDS": "2024-05-31T00:00:00",
"QS": 42.00000,
"AlertSummaryId": 1758,
"AMsg": "Supply Order 0002, Line #30.00 from supplier V0041, remaining quantity 42 is 10 days overdue.",
"DateCreated": "2024-06-17T00:00:00",
"DateUpdated": "2024-06-17T00:00:00-05:00",
"ASt": 1,
"APri": 2,
"Rank": 196,
"AlertTypeName": "LateSupplyOrder"
},
...
]
Abbreviations:
- "DURD": Days Until Receipt Due
- "DUSD": Days Until Shipment Due
- "ITQ": In Transit Quantity
- "ITD": In Transit Dollars
- "CO": Cubes Ordered
- "CR": Cubes Remaining
- "CIT": Cubes In Transit
- "WO": Weight Ordered
- "WR": Weight Remaining
- "WIT": Weight In Transit
- "ErpON": ERP Order Number
- "I": Item Code
- "SC": Supplier Code
- "SN": Supplier Name
- "ISC1": Item Site Category 1
- "ISC2": Item Site Category 2
- "ISC3": Item Site Category 3
- "ISC4": Item Site Category 4
- "ISC5": Item Site Category 5
- "ISC6": Item Site Category 6
- "ISC7": Item Site Category 7
- "ISC8": Item Site Category 8
- "D": Description
- "SIC": Supplier Item Code
- "IP": Inventory Position
- "WPIP": Worst Inventory Position
- "IPLT": Inventory Position @ LT
- "ErpLN": ERP Line Number
- "RRQ": Remaining Release Quantity
- "EDD": Expected Dock Date
- "RctQty": Receipt Quantity
- "RRctQty": Remaining Receipt Quantity
- "OESD": Original Expected Ship Date
- "OEDD": Original Expected Dock Date
- "OCD": Order Creation Date
- "RD": Release Date
- "AQ": Available Quantity
- "OH": On Hand Quantity
- "SS": Safety Stock
- "MRDS": Most Recent Date Shipped
- "QS": Quantity Shipped
- "AMsg": "Alert Message
- "ASt": Alert Status
- "APri": Alert Priority