Skip to main content

API: Open Supply Orders (Legacy)

Updated

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: 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

 

Related articles