Description: Returns the Projected Stockout Detail grid from the Projected Stockout screen in the Purchase module
Resource: ProjectedStockOutDetail/
Verb: GET
Returns: JSON Array of projected stockout objects
Example JSON:
[
{
"AlertKeyId": 37,
"AlertType": 22,
"PrimaryId": 37,
"PrimaryIdProperty": 2,
"MostBalanceBelowPanicPoint": 169.8500000000,
"UnitsBelowPanicPoint": 53.00000,
"ValueBelowPanicPoint": 209.3500000000,
"ProjectedDaysOfSupply": 3.18,
"ItemSiteSupplierId": 37,
"ItemSiteId": 33,
"OutOfStockQuantity": 0.00000,
"StandardCost": 3.95000,
"StandardPrice": 3.95000,
"ShipperId": 1,
"ItemId": 3,
"SiteId": 1,
"PrimarySupplierId": 16,
"ItemCode": "0101026",
"SiteCode": "271",
"SupplierItemCode": "0101026",
"BuyerName": "AJ Foyt",
"ItemDescription": "Contoso 16GB Mp5 Player M1600 Green",
"ActiveOrderPolicy": 2,
"ResolvedItemStatus": 1,
"ActivePanicPoint": 96.00000,
"ActiveSafetyStock": 192.00000,
"AbcClass": "A",
"XyzClass": "X",
"PrimarySupplierCode": "V0027",
"PrimarySupplierName": "Tyrell Corp. ",
"TargetServiceLevel": 0.990000,
"ActivePlanningLeadTime": 3,
"WorstProjectedInventoryPosition": 2,
"InventoryPositionAtLeadTime": 2,
"TotalOnHandQuantity": 43.00000,
"TotalAvailableQuantity": 40.00000,
"TotalAvailableQuantityAtLeadTime": 40.00000,
"TotalOnOrderQuantity": 80.00000,
"TotalHistoricalDailyUsage": 7.558139534883721,
"InventoryPosition": 2,
"LostRevenuePerDay": 30.0,
"TotalOnDemandOrderQuantity": 3.00000,
"TotalOnDemandValue": 11.85000,
"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": 3,
"BoMPosition": 0,
"ProjectedBelowPanicPointDate": "2024/06/17",
"ProjectedAbovePanicPointDate": "2024/06/18",
"LowestQuantityAfterBelowPanicPoint": 43.00000,
"NextExpectedShipDate": "2024/02/12",
"NextExpectedDockDate": "2024/02/14",
"NextErpOrderNumber": "0024",
"NextOrderRemainingReleaseQuantity": 80.00000,
"TotalForecastedDailyUsage": 13.505952380952381,
"AlertSummaryId": 1982,
"AMsg": "Item is projected below panic point on 6/17/2024, eventually reaching 53.00 units below panic point.",
"DateCreated": "2024/06/17",
"DateUpdated": "2024-06-17T00:00:00-05:00",
"ASt": 1,
"APri": 1,
"Rank": 453,
"AlertTypeName": "ProjectedStockOut"
},
...
]