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: Returns the discontinued items grid from the Discontinued Items screen in the Inventory module
Resource: DiscontinuedItemDetail/
Verb: GET
Returns: JSON Array containing records matching: Discontinued Items grid
Example Response JSON:
[{
"DaysUntilDepleted": 25,
"ItemSiteId": 1067,
"ShipperId": 5,
"ItemId": 568,
"SiteId": 6,
"PrimarySupplierId": 54,
"ItemCode": "0401041",
"SiteCode": "96",
"BuyerName": "Michael Schumacher",
"ItemDescription": "A. Datum Point Shoot Digital Camera M500 Pink",
"ResolvedItemStatus": 2,
"DiscontinuedReason": 1,
"ActiveOrderPolicy": 64,
"PrimarySupplierCode": "V0056",
"SupplierName": "Schrader Intl",
"AbcClass": "B",
"XyzClass": "X",
"CurrentCost": 33.71000,
"StandardCost": 33.71000,
"OnHandQuantity": 627.00000,
"TotalOnOrderQuantity": 0.00000,
"TotalAvailableQuantity": 627.00000,
"TotalAvailableQuantityAtLeadTime": 627.00000,
"EffectiveDateObsolete": "2024-06-20T00:00:00",
"FinalDepletionDate": "2024-07-12T00:00:00",
"UsagePattern": 2,
"InventoryPosition": 24,
"FirstSaleDate": "2020-09-01T00:00:00",
"LastSaleDate": "2024-05-24T00:00:00",
"OnHandBalance": 21136.17000,
"ExcessQuantity": 0.00000,
"ExcessBalance": 0.000000000,
"TotalHistoricalDailyUsage": 31.325581395348834,
"TotalForecastedDailyUsage": 14.024523809523808,
"TotalDailyUsageAtLeadTime": 10.988095238095237,
"CustomerShipToCount": 1,
"CustomerCount": 1,
"TotalHits": 942,
"ItemSiteCategory1Name": "Cameras and camcorders ",
"ItemSiteCategory2Name": "Digital Cameras",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"SupplierItemCode": "0401041"
},
{
"DaysUntilDepleted": 28,
"ItemSiteId": 1066,
"ShipperId": 5,
"ItemId": 568,
"SiteId": 8,
"PrimarySupplierId": 57,
"ItemCode": "0401041",
"SiteCode": "95",
"BuyerName": "Michael Schumacher",
"ItemDescription": "A. Datum Point Shoot Digital Camera M500 Pink",
"ResolvedItemStatus": 2,
"DiscontinuedReason": 1,
"ActiveOrderPolicy": 64,
"PrimarySupplierCode": "V0059",
"SupplierName": "Contoso Hub Warehouse",
"AbcClass": "B",
"XyzClass": "X",
"CurrentCost": 37.73000,
"StandardCost": 37.73000,
"OnHandQuantity": 348.00000,
"TotalOnOrderQuantity": 0.00000,
"TotalAvailableQuantity": 348.00000,
"TotalAvailableQuantityAtLeadTime": 348.00000,
"EffectiveDateObsolete": "2024-08-21T00:00:00",
"FinalDepletionDate": "2024-07-15T00:00:00",
"UsagePattern": 2,
"InventoryPosition": 24,
"FirstSaleDate": "2020-08-31T00:00:00",
"LastSaleDate": "2024-05-24T00:00:00",
"OnHandBalance": 13130.04000,
"ExcessQuantity": 0.00000,
"ExcessBalance": 0.000000000,
"TotalHistoricalDailyUsage": 12.302325581395348,
"TotalForecastedDailyUsage": 8.115,
"TotalDailyUsageAtLeadTime": 6.3761904761904766,
"CustomerShipToCount": 1,
"CustomerCount": 1,
"TotalHits": 918,
"ItemSiteCategory1Name": "Cameras and camcorders ",
"ItemSiteCategory2Name": "Digital Cameras",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"SupplierItemCode": "0401041"
}
,
... ]