Description: Returns the item-site service level detail grid from the Service Level screen in the Inventory module
Resource: ItemSiteServiceLevelDetail/
Verb: GET
Query String Arguments
- interval (required):
- 2 = Weekly
- 4 = Monthly
- 8 = Quarterly
- 16 = Yearly
- startDate (optional) - Limit result set to a particular date
Returns: JSON Array containing records matching item-site service level details
Example Response JSON:
[{
"AlertKeyId": 3,
"AlertType": 4,
"PrimaryId": 3,
"PrimaryIdProperty": 1,
"FillRate": 1.0,
"OnTimeFillRate": 1.0,
"ServiceLevel": 1.0,
"ServiceLevelVariance": 0.050000,
"QuantityUnFilled": 0,
"PeriodDate": "2023/06/01",
"StartDate": "2023/06/01",
"EndDate": "2023/06/30",
"ItemSiteId": 3,
"ItemId": 18,
"SiteId": 15,
"BuyerId": 9,
"PrimarySupplierId": 28,
"ShipperId": 3,
"ItemCode": "0101003",
"SiteCode": "271",
"ItemDescription": "Contoso 1G MP3 Player E100 White",
"BuyerName": "Alberto Ascari",
"AbcClass": "C",
"XyzClass": "X",
"TargetServiceLevel": 0.950000,
"ActiveOrderPolicy": 2,
"ResolvedItemStatus": 1,
"ItemSiteCategory1Id": 2,
"ItemSiteCategory2Id": 8,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ItemSiteCategory6Id": 1,
"ItemSiteCategory7Id": 1,
"ItemSiteCategory8Id": 1,
"ItemSiteCategory1Name": "Audio",
"ItemSiteCategory2Name": "MP4&MP3",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemSiteCategory6Name": "Unassigned",
"ItemSiteCategory7Name": "Unassigned",
"ItemSiteCategory8Name": "Unassigned",
"PrimarySupplierName": "Tyrell Corp. ",
"NumberOfOrderLines": 83,
"QuantityOrdered": 92,
"QuantityFilled": 92,
"QuantityFilledOnTime": 92,
"NumberOfCompleteOrderLines": 83,
"NumberOfOnTimeCompleteOrderLines": 83,
"SupplierItemCode": "0101003",
"AlertSummaryId": 1150,
"AMsg": "Achieved service level of 80.32% is under target 95.00% by -14.68%.",
"DateCreated": "2024/06/17",
"DateUpdated": "2024-06-17T00:00:00-05:00",
"ASt": 1,
"APri": 4,
"Rank": 171,
"AlertTypeName": "ItemSiteServiceLevel"
}
,
... ]