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 Projected Excess Detail grid from the Projected Excess screen in the Purchase module
Resource: ProjectedExcessDetail/
Verb: GET
Returns: JSON Array of projected excess objects
Example JSON:
[{
"AlertKeyId": 3345,
"AlertType": 23,
"PrimaryId": 3345,
"PrimaryIdProperty": 2,
"MostProjectedExcessQuantity": 2.00000,
"MostProjectedExcessValue": 25.7000000000,
"ItemSiteSupplierId": 3345,
"ItemSiteId": 4,
"OutOfStockQuantity": 0.00000,
"StandardCost": 12.85000,
"ShipperId": 3,
"ItemId": 28,
"SiteId": 2,
"PrimarySupplierId": 47,
"ItemCode": "0101008",
"SiteCode": "95",
"BuyerName": "Sebastien Loeb",
"ItemDescription": "Contoso 4G MP3 Player E400 Silver",
"ActiveOrderPolicy": 2,
"ResolvedItemStatus": 1,
"ActiveSafetyStock": 0.00000,
"AbcClass": "X",
"XyzClass": "Z",
"PrimarySupplierCode": "V0045",
"PrimarySupplierName": "Contoso Regional Hub",
"TargetServiceLevel": 0.500000,
"ActivePlanningLeadTime": 7,
"TotalOnHandQuantity": 2.00000,
"TotalAvailableQuantity": 2.00000,
"TotalAvailableQuantityAtLeadTime": 2.00000,
"TotalOnOrderQuantity": 0.00000,
"TotalHistoricalDailyUsage": 0.0,
"InventoryPosition": 32,
"LostRevenuePerDay": 0.0,
"TotalOnDemandOrderQuantity": 0.00000,
"TotalOnDemandValue": 0.00000,
"ItemSiteCategory1Name": "Audio",
"ItemSiteCategory2Name": "MP4&MP3",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"ReplacementFlags": 0,
"IsOnHandCopied": false,
"ItemSiteCategory1Id": 7,
"ItemSiteCategory2Id": 24,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ItemSiteCategory6Id": 1,
"ItemSiteCategory7Id": 1,
"ItemSiteCategory8Id": 1,
"BuyerId": 7,
"BoMPosition": 4,
"ProjectedExcessStockDate": "2024/06/17",
"HighestQuantityAfterExcess": 2.00000,
"ExcessThresholdOnTestDate": 0.00000,
"TotalForecastedDailyUsage": 0.0,
"AlertSummaryId": 0,
"DateCreated": "0001/01/01",
"DateUpdated": "0001-01-01T00:00:00+00:00",
"ASt": 0,
"APri": 0,
"AlertTypeName": "ProjectedExcess"
},
...
]