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