Description: Returns a list of supply order lines
Resource: SupplyOrderLineDetail/
Verb: GET
Returns: JSON Array of SupplyOrderLineDetail objects for the requested filters
Query String Arguments: (all optional)
- startDate- allows you to specify earliest order creation date you want to see
- endDate- allows you to specify latest order creation date you want to see
- createdBySystem - Whether or not the order was placed in SIQ for not. specify 'true' to get only SIQ-created orders
- erpLineStatuses - List of ERP Line Statuses that you want included. This argument can be specified multiple times if you have multiple values, e.g. ...erpLineStatus=1&erpLineStatus=2...
- 1 = Open
- 2 = Closed
- 4 - Canceled
- 8 = On Hold
- 16 = Released
- stockIqStatuses - List of StockIQ order line statuses you want included. This argument can be specified multiple times if you have multiple values, e.g. ...stockIqStatuses=1&stockIqStatuses=2...
- 1 = Review
- 2 = Confirmed
- 4 = Hold For Merge
- 8 = Merged
- 16 = Approved
- 32 = Accepted
- 64 = Canceled
- hasBuyerEditedQuantity - Filter on whether the buyer has edited any line quantity in this order or not. "true" for yes, "false" for no. Omit this if you don't care either way.
Example JSON:
[{
"ErrorMessages": [],
"SubstituteOrderLines": [],
"Guid": "337a8812-72f5-4b49-b3e7-cdf4501a7de2",
"AlertKeyId": 77,
"DaysUntilDue": 7,
"SiteWorkDaysPerYear": 260,
"IsInOrder": true,
"IsFromSubstitute": false,
"IsEditingAllowed": false,
"HasHigherMultiples": false,
"IsUnderMinOrderQuantity": false,
"IsOverMaxOrderQuantity": false,
"ViolatesOrderMultipleQuantity": false,
"SubstitutesCount": 0,
"RecommendedSubstitutesCount": 0,
"IsOverWarehouseProjectedAvailableToTransfer": false,
"IsOverWarehouseAvailableToTransfer": false,
"IsOverWarehouseOnHandToTransfer": false,
"IsOverWarehouseExcessToTransfer": false,
"HasTransferQuantityProblem": false,
"HasSupplierQuantityProblem": false,
"OverWarehouseCapacityByOnHand": false,
"OverWarehouseCapacityByAvailableQuantity": false,
"OverWarehouseCapacityByProjectedAvailable": false,
"HasWarehouseCapacityProblem": false,
"IsPlanAtRisk": false,
"HasPlannedReceiptDateProblem": false,
"HasExpectedShipDateProblem": false,
"IsCoverageBuy": false,
"OrderedToday": 0.0,
"AllWarehousesOnOrderQuantity": 0.0,
"PurchaseQuantity": 138.0,
"PurchaseQuantityCost": 57.5800000000,
"PercentOfReleaseReceived": 0.0,
"OrderDaysOfSupply": 40.22,
"ProjectedDaysOfSupplyOnArrival": 0.58,
"ProjectedOnHandQuantity": 2.00000,
"ProjectedDaysOfSupply": -39.64,
"ProjectedDaysOfCycleStock": -39.931508906225052643782193226,
"ExpectedReceiptDate": "0001/01/01",
"LineSupplierCost": 7946.0400000000,
"LinePurchaseCost": 7946.0400000000,
"LineWeight": 1.38000000000000000,
"LineCubes": 17.94000000000000000,
"TotalOnDemandQuantity": 0.00000,
"PlanState": 0,
"InventoryPositionAtLeadTime": 1,
"UnitCubes": 0.130000000000,
"HistoricalMonthlyUsage": 72.558139534883722,
"ForecastedMonthlyUsage": 74.325916705318491,
"MonthlyUsageAtLeadTime": 74.325916649488065,
"QuantityReceived": 0.000000000,
"UnconsumedAvailableAndOrderQuantity": 0.00000,
"UnconsumedDaysOfSupply": 40.228229059057264841942665161,
"MoqRatio": 1.0,
"StockIqOrderNumber": "MRG1000",
"SupplyType": 1,
"ShipperId": 1,
"ItemId": 37,
"SiteId": 9,
"ItemSiteSupplierId": 77,
"SupplierId": 48,
"ItemSiteCategory1Id": 7,
"ItemSiteCategory2Id": 30,
"ItemSiteCategory3Id": 1,
"ItemSiteCategory4Id": 1,
"ItemSiteCategory5Id": 1,
"ShipperCode": "ABB",
"ItemCode": "0104020",
"SiteCode": "44",
"SupplierCode": "V0055",
"SupplierName": "Vendor V0055",
"ItemSiteCategory1Name": "Audio",
"ItemSiteCategory2Name": "Recording Pen",
"ItemSiteCategory3Name": "Unassigned",
"ItemSiteCategory4Name": "Unassigned",
"ItemSiteCategory5Name": "Unassigned",
"ItemDescription": "WWI 2GB Spy Video Recorder Pen M300 Purple",
"SupplierItemCode": "0104020",
"ActiveSupplierLevel": 1,
"ProjectedOutOfStockDate": "2020/06/01",
"CreatedByUserId": 2,
"IsStockIqOrder": true,
"DateCreated": "2020-06-01T13:16:33-07:00",
"SupplyOrderSetId": 53,
"SupplyOrderLineId": 158,
"SupplyOrderId": 53,
"ReleaseNumber": 1,
"StockIqLineNumber": 1.00000,
"ItemSiteId": 66,
"StockIqStatus": 8,
"ErpLineStatus": 0,
"ReleaseQuantity": 138.00000,
"RemainingReleaseQuantity": 138.00000,
"PurchaseCost": 57.58000,
"ExpectedShipDate": "2020/06/08",
"ExpectedDockDate": "2020/06/08",
"PlannedReceiptDate": "2020/06/08",
"InternalLineComment": "",
"ExternalLineComment": "",
"ReceiptQuantity": 138.000000000,
"RemainingReceiptQuantity": 138.000000000,
"StockIqSuggestedReleaseQuantity": 138.00000,
"RawReleaseQuantity": 137.00000,
"SupplierCost": 57.58000,
"StandardPrice": 0.85000,
"OriginalReleaseQuantity": 138.00000,
"OriginalReceiptQuantity": 138.000000000,
"OriginalExpectedShipDate": "2020/06/08",
"OriginalExpectedDockDate": "2020/06/08",
"OriginalExpectedReceiptDate": "2020/06/08",
"OriginalPlannedReceiptDate": "2020/06/08",
"AbcClass": "D",
"XyzClass": "X",
"UnitOfMeasure": "PR",
"StockingUnitsPerPurchaseUnits": 1.00000,
"MinimumOrderQuantity": 1,
"OrderMultipleQuantity": 1,
"TotalOnHandQuantity": 0.00000,
"TotalOnOrderQuantity": 0.00000,
"TotalInTransitQuantity": 0.00000,
"TotalOnDemandOrderQuantity": 0.00000,
"TotalAvailableQuantity": 0.00000,
"TotalAvailableQuantityAtLeadTime": 0.00000,
"HistoricalDailyUsage": 3.3488372093023258,
"ForecastedDailyUsage": 3.4304269248608534,
"DailyUsageAtLeadTime": 3.4304269222840649,
"ProjectedActualAvailableAtLeadTime": -136.00000,
"Eoq": 137.93996760282687,
"PercentHoldingCost": 0.25,
"HoldingCost": 307.36068941569243755769815362,
"EstimatedCostOfOrdering": 12287.00000,
"EstimatedReceivingCost": 12282.00000,
"ActiveOrderCycle": 1,
"ActivePanicPoint": 0.50000,
"ActiveSafetyStock": 1.00000,
"ActiveTargetStock": 71.0000000,
"ActiveMaxStock": 141.00000,
"ActiveOrderPolicy": 2,
"TotalOnHandToTransfer": 14.00000,
"TotalAvailableToTransfer": 14.00000,
"TotalProjectedAvailableToTransfer": 0.00000,
"TotalExcessToTransfer": 0.00000,
"AlternatesFlags": 0,
"CurrentExcess": 0.00000,
"InventoryPosition": 1,
"UsagePattern": 2,
"YieldPercentage": 1.00000,
"ActivePlanningLeadTime": 7,
"ActiveAdminLeadTime": 0,
"ActiveShippingLeadTime": 0,
"ActivePutawayLeadTime": 0,
"SubtractPlanningPadFromErpDate": true,
"SubtractPutawayTimeFromErpDate": false,
"UserEditedReleaseQuantity": false,
"UserEditedReceiptDate": false,
"UserEditedShipDate": false,
"PurchaseCostStatus": 0,
"HasOrderSchedule": false,
"HasDeliverySchedule": false,
"HasShipmentSchedule": false,
"DateUpdated": "2022-02-04T13:16:33.5457687-07:00",
"MergedByUserId": 2,
"OrderCreationDate": "2020/06/01",
"ExpectedReleaseDate": "2020/06/01",
"UnitWeight": 0.010000000000,
"UnitHeight": 0.130000000000,
"OutOfStockQuantity": 0.00000,
"SalesOrderLineNumber": 0.0,
"CreatedByUserName": "SiqSupport",
"PrimarySupplierId": 48,
"BoMPosition": 1,
"Removed": false,
"IsActive": true,
"APri": 0,
"AT": 524288,
"ATN": "LaunchOrder"
},
....
]