Get Pegging Relationships for a Production Schedule
You can use REST API to get pegging information for a particular schedule. The pegging information is a supplier-consumer relationship between two business objects. For example, how to find which work order uses a specific purchase order.
The highlighted line represents the downstream pegging of the purchase order to the specific consuming work order. This information is very useful information for the scheduler. If the purchase order is delayed, the scheduler understands which work orders and other downstream demands are impacted. The entire lineage of downstream pegging can be fetched using this REST service.
The pegging depth indicates the level at which the downstream consumer is. The immediate consumer of the purchase order has a pegging depth of 1. The next consuming work order has a pegging depth of 2. Finally, the sales order is the end of the chain and has a pegging depth of 3.
Conversely, you can peg supply records upstream by a specific demand such as a sales order. The pegging depth is relative to the starting point of the query so immediate supply to the sales order has a pegging depth of 1. Working backwards, the pegging depth increments by 1 for each additional level of the pegging tree.
- Get downstream pegging by inventory on hand.
- Get downstream pegging by inventory on-hold lot.
- Get downstream pegging by purchase order or transfer order.
- Get downstream pegging by work order.
- Get downstream pegging by work order operation.
- Get upstream pegging by sales order.
- Get upstream pegging by work order.
- Get upstream pegging by work order operation.
- Get only immediate downstream consumers of an item on-hand.
- Get only sales orders that consume a specific supply.
Get Downstream Pegging by Inventory On Hand
In this scenario, you can peg all downstream consumers of an inventory item on hand and related consumers at all levels of the supply chain.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H "Content-Type:application/json' -d "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships?finder=findDownstreamByOnHandInventoryItem;ItemCode="SAPS-SiO2-1000"'
Example Request
This request uses the finder findDownstreamByOnHandInventoryItem where ItemCode of the item inventory on-hand is passed as a parameter.
{ "items": [ { "PlanId": 300100543683651, "PeggingId": 3, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 20, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205019034, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205019032, "ConsumeByWorkOrderNumber": "SAMSCSUB101", "ConsumeByOperationCode": "SAPS-MSC-13000-WD1:SAPS-MSC-13000:OP20:20:10", "ConsumeByOperationName": "OP20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-21T10:00:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100543683651,3", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C3", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C3", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 100, "InventoryItemId": 300100204609880, "ItemCode": "SAPS-MSC-13000", "LotNumber": null, "Quantity": 1, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019034, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019032, "SupplyByWorkOrderNumber": "SAMSCSUB101", "SupplyByOperationCode": "SAPS-MSC-13000-WD1:SAPS-MSC-13000:OP20:20:10", "SupplyByOperationName": "OP20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205019025, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205019023, "ConsumeByWorkOrderNumber": "SAMS102", "ConsumeByOperationCode": "SAPS-MS-Chip-WD1:SAPS-MS-Chip:OP20:20:10", "ConsumeByOperationName": "OP20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-02T08:02:05+00:00", "ConsumeDate": "2030-01-21T10:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,100", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C100", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C100", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 119, "InventoryItemId": 300100204609817, "ItemCode": "SAPS-MS-Chip", "LotNumber": null, "Quantity": 36, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019025, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019023, "SupplyByWorkOrderNumber": "SAMS102", "SupplyByOperationCode": "SAPS-MS-Chip-WD1:SAPS-MS-Chip:OP20:20:10", "SupplyByOperationName": "OP20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Sales Order", "ConsumeById": 2, "DemandNumber": "520312", "DemandLineItemNumber": "2:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-21T07:08:45+00:00", "ConsumeDate": "2030-01-21T10:00:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,119", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C119", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C119", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 16, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 5, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018978, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018976, "ConsumeByWorkOrderNumber": "SAHSCSUB103", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100543683651,16", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C16", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C16", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 29, "InventoryItemId": 300100204609821, "ItemCode": "SAPS-HSC-12000", "LotNumber": null, "Quantity": 5, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018978, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018976, "SupplyByWorkOrderNumber": "SAHSCSUB103", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "SupplyByOperationName": "OP2", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018915, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T08:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,29", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C29", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C29", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 36, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018915, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018916, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "ConsumeByOperationName": "Op20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T00:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,36", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 43, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018916, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "SupplyByOperationName": "Op20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018917, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "ConsumeByOperationName": "Op30", "ConsumeByOperationSequenceNumber": 30, "ConsumeByResourceSequenceNumber": 20, "SupplyDate": "2030-01-11T01:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 4, "@context": { "key": "300100543683651,43", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 46, "InventoryItemId": 300100204609815, "ItemCode": "SAPS-HS-Chip", "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018917, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "SupplyByOperationName": "Op30", "SupplyByOperationSequenceNumber": 30, "SupplyByResourceSequenceNumber": 20, "ConsumeByType": "Sales Order", "ConsumeById": 1, "DemandNumber": "520312", "DemandLineItemNumber": "1:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-12T02:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 5, "@context": { "key": "300100543683651,46", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C46", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C46", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 24, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 5, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018960, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018958, "ConsumeByWorkOrderNumber": "SAHSCSUB101", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-07T22:08:45+00:00", "PeggingDepth": 1, "@context": { "key": "300100543683651,24", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C24", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C24", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 30, "InventoryItemId": 300100204609821, "ItemCode": "SAPS-HSC-12000", "LotNumber": null, "Quantity": 40, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018960, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018958, "SupplyByWorkOrderNumber": "SAHSCSUB101", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "SupplyByOperationName": "OP2", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018915, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-08T23:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,30", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C30", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C30", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 25, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 20, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018960, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018958, "ConsumeByWorkOrderNumber": "SAHSCSUB101", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100543683651,25", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C25", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C25", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 28, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 50, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018968, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018966, "ConsumeByWorkOrderNumber": "SAHSCSUB102", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-08T23:08:45+00:00", "PeggingDepth": 1, "@context": { "key": "300100543683651,28", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C28", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C28", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 12, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Downstream Pegging by Inventory On-Hold Lot
In this scenario, you can peg all downstream consumers of an inventory item lot that's on hold and related consumers at all levels of the supply chain.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/latest/ productionSchedulingPlans/300100550006514/child/peggingRelationships?finder=findDownstreamByOnHoldLot;ItemCode="SA-Lot-Comp2",LotNumber="S104033"'
Example Request
This request uses the finder findDownstreamByOnHoldLot where Item Code of the item inventory on-hand is passed as a parameter in addition to the Lot Number that is on hold.
{ "items": [ { "PlanId": 300100550006514, "PeggingId": 66, "InventoryItemId": 300100547232985, "ItemCode": "SA-Lot-Comp2", "LotNumber": "S104033", "Quantity": 11, "SupplyByType": "On Hold Lot", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100547233180, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100547233178, "ConsumeByWorkOrderNumber": "SAHS104", "ConsumeByOperationCode": "HS Chip WD2:SAPS-HS-Chip:20:20:10", "ConsumeByOperationName": "20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-15T11:46:45+00:00", "ConsumeDate": "2030-01-15T11:46:45+00:00", "PeggingDepth": 1, "@context": { "key": "300100550006514,66", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C66", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C66", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100550006514, "PeggingId": 72, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 25, "SupplyByType": "Work Order Operation", "SupplyById": 300100547233180, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100547233178, "SupplyByWorkOrderNumber": "SAHS104", "SupplyByOperationCode": "HS Chip WD2:SAPS-HS-Chip:20:20:10", "SupplyByOperationName": "20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100547233181, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100547233178, "ConsumeByWorkOrderNumber": "SAHS104", "ConsumeByOperationCode": "HS Chip WD2:SAPS-HS-Chip:30:30:10", "ConsumeByOperationName": "30", "ConsumeByOperationSequenceNumber": 30, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-16T12:46:45+00:00", "ConsumeDate": "2030-01-16T12:46:45+00:00", "PeggingDepth": 2, "@context": { "key": "300100550006514,72", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C72", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C72", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 2, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Downstream Pegging by Purchase Order or Transfer Order
In this scenario, you can peg all downstream consumers of a purchase order or a transfer order.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships? finder=findDownstreamBySupply;SupplyNumber="1004781:STANDARD",SupplyLineItemNumber="3"'
Example Request
This request uses the finder findDownstreamBySupply where Supply Number is the purchase order or the transfer order number and Supply Line Item is the line number of the document.
{ "items": [ { "PlanId": 300100550006514, "PeggingId": 54, "InventoryItemId": 300100204609876, "ItemCode": "SAPS-PW-11000", "LotNumber": null, "Quantity": 10, "SupplyByType": "Purchase Order", "SupplyById": 15, "SupplyNumber": "1004781:STANDARD", "SupplyLineItemNumber": "3", "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100543691630, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100543691610, "ConsumeByWorkOrderNumber": "SAHS Non Srd WO1", "ConsumeByOperationCode": "10:10:10", "ConsumeByOperationName": "10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-14T06:13:45+00:00", "PeggingDepth": 1, "@context": { "key": "300100550006514,54", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C54", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C54", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100550006514, "PeggingId": 58, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 10, "SupplyByType": "Work Order Operation", "SupplyById": 300100543691630, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100543691610, "SupplyByWorkOrderNumber": "SAHS Non Srd WO1", "SupplyByOperationCode": "10:10:10", "SupplyByOperationName": "10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100543691630, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100543691610, "ConsumeByWorkOrderNumber": "SAHS Non Srd WO1", "ConsumeByOperationCode": "10:10:20", "ConsumeByOperationName": "10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 20, "SupplyDate": "2030-01-14T11:13:45+00:00", "ConsumeDate": "2030-01-14T11:13:45+00:00", "PeggingDepth": 2, "@context": { "key": "300100550006514,58", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C58", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C58", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100550006514, "PeggingId": 78, "InventoryItemId": 300100204609876, "ItemCode": "SAPS-PW-11000", "LotNumber": null, "Quantity": 90, "SupplyByType": "Purchase Order", "SupplyById": 15, "SupplyNumber": "1004781:STANDARD", "SupplyLineItemNumber": "3", "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205019056, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205019055, "ConsumeByWorkOrderNumber": "SALSCSUB101", "ConsumeByOperationCode": "SAPS-LSC-14000-WD1:SAPS-LSC-14000:Op10:10:10", "ConsumeByOperationName": "Op10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-16T21:08:45+00:00", "PeggingDepth": 1, "@context": { "key": "300100550006514,78", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C78", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C78", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100550006514, "PeggingId": 90, "InventoryItemId": 300100204609882, "ItemCode": "SAPS-LSC-14000", "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019056, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019055, "SupplyByWorkOrderNumber": "SALSCSUB101", "SupplyByOperationCode": "SAPS-LSC-14000-WD1:SAPS-LSC-14000:Op10:10:10", "SupplyByOperationName": "Op10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205019049, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205019048, "ConsumeByWorkOrderNumber": "SALS101", "ConsumeByOperationCode": "SAPS-LS-Chip-WD1:SAPS-LS-Chip:OP1:10:10", "ConsumeByOperationName": "OP1", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-17T04:38:45+00:00", "ConsumeDate": "2030-01-17T04:38:45+00:00", "PeggingDepth": 2, "@context": { "key": "300100550006514,90", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C90", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C90", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100550006514, "PeggingId": 126, "InventoryItemId": 300100204609819, "ItemCode": "SAPS-LS-Chip", "LotNumber": null, "Quantity": 1.67, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019049, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019048, "SupplyByWorkOrderNumber": "SALS101", "SupplyByOperationCode": "SAPS-LS-Chip-WD1:SAPS-LS-Chip:OP1:10:10", "SupplyByOperationName": "OP1", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Sales Order", "ConsumeById": 3, "DemandNumber": "520312", "DemandLineItemNumber": "3:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-23T08:38:45+00:00", "ConsumeDate": "2030-01-23T11:30:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100550006514,126", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C126", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships/300100550006514%2C126", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 5, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100550006514/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Downstream Pegging by Work Order
In this scenario, you can peg all downstream consumers of a work order.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d ‘https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships? finder=findDownstreamByWorkOrder;FromWorkOrderNumber="RBPS-MIXBERRY-JOB1"'
Example Request
This request uses the finder findDownstreamByWorkOrder
from which
work order number is the starting point.
{ "items": [ { "PlanId": 300100542136580, "PeggingId": 43, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 154.67, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173411, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173410, "SupplyByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173432, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173431, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB1", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:30:00+00:00", "ConsumeDate": "2030-01-10T13:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,43", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 60, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 131.33, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173411, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173410, "SupplyByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173438, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173437, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB2", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:30:00+00:00", "ConsumeDate": "2030-01-10T17:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,60", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C60", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C60", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 2, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Downstream Pegging by Work Order Operation
In this scenario, you can peg all downstream consumers of a specific work order operation.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships? finder=findDownstreamByWorkOrderOperation;FromWorkOrderNumber="RBPS-MIXBERRY-JOB1",FromOperationSequenceNumber="10",FromResourceSequenceNumber="10"'
Example Request
This request uses the finder findDownstreamByWorkOrderOperation
where from work order number is the originating work order, from operation sequence
number is the work order operation and from resource sequence number is the specific
operation resource.
{ "items": [ { "PlanId": 300100542136580, "PeggingId": 43, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 154.67, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173411, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173410, "SupplyByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173432, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173431, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB1", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:30:00+00:00", "ConsumeDate": "2030-01-10T13:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,43", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 60, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 131.33, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173411, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173410, "SupplyByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173438, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173437, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB2", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:30:00+00:00", "ConsumeDate": "2030-01-10T17:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,60", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C60", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C60", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 2, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Upstream Pegging by Sales Order
In this scenario, you can peg all upstream suppliers of a specific sales order line item.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships? finder=findUpstreamByDemand;DemandNumber='520312',DemandLineItemNumber="1:1"'
Example Request
This request uses the finder findUpstreamByDemand
where the sales
order number and sales order line are passed as parameters.
{ "items": [ { "PlanId": 300100543683651, "PeggingId": 45, "InventoryItemId": 300100204609815, "ItemCode": "SAPS-HS-Chip", "LotNumber": null, "Quantity": 25, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018917, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "SupplyByOperationName": "Op30", "SupplyByOperationSequenceNumber": 30, "SupplyByResourceSequenceNumber": 20, "ConsumeByType": "Sales Order", "ConsumeById": 1, "DemandNumber": "520312", "DemandLineItemNumber": "1:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-12T02:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100543683651,45", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C45", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C45", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 41, "InventoryItemId": 300100204609874, "ItemCode": "SAPS-PK-1000", "LotNumber": null, "Quantity": 75, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018917, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "ConsumeByOperationName": "Op30", "ConsumeByOperationSequenceNumber": 30, "ConsumeByResourceSequenceNumber": 20, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,41", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C41", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C41", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 42, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 25, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018916, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "SupplyByOperationName": "Op20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018917, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "ConsumeByOperationName": "Op30", "ConsumeByOperationSequenceNumber": 30, "ConsumeByResourceSequenceNumber": 20, "SupplyDate": "2030-01-11T01:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,42", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C42", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C42", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 36, "InventoryItemId": 300100204609863, "ItemCode": "SAPS-LF-1000", "LotNumber": null, "Quantity": 75, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018916, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "ConsumeByOperationName": "Op20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,36", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 37, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 25, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018915, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018916, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "ConsumeByOperationName": "Op20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T00:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,37", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C37", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C37", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 30, "InventoryItemId": 300100204609821, "ItemCode": "SAPS-HSC-12000", "LotNumber": null, "Quantity": 5, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018978, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018976, "SupplyByWorkOrderNumber": "SAHSCSUB103", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "SupplyByOperationName": "OP2", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018915, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T08:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 4, "@context": { "key": "300100543683651,30", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C30", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C30", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 17, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 5, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018978, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018976, "ConsumeByWorkOrderNumber": "SAHSCSUB103", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 5, "@context": { "key": "300100543683651,17", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C17", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C17", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 18, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 5, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018977, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018976, "SupplyByWorkOrderNumber": "SAHSCSUB103", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP1:10:10", "SupplyByOperationName": "OP1", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018978, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018976, "ConsumeByWorkOrderNumber": "SAHSCSUB103", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T02:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 5, "@context": { "key": "300100543683651,18", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C18", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C18", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 12, "InventoryItemId": 300100204609876, "ItemCode": "SAPS-PW-11000", "LotNumber": null, "Quantity": 5, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018977, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018976, "ConsumeByWorkOrderNumber": "SAHSCSUB103", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP1:10:10", "ConsumeByOperationName": "OP1", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 6, "@context": { "key": "300100543683651,12", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C12", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C12", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 31, "InventoryItemId": 300100204609821, "ItemCode": "SAPS-HSC-12000", "LotNumber": null, "Quantity": 20, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018960, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018958, "SupplyByWorkOrderNumber": "SAHSCSUB101", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "SupplyByOperationName": "OP2", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018915, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-08T23:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 4, "@context": { "key": "300100543683651,31", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 26, "InventoryItemId": 300100204609878, "ItemCode": "SAPS-SiO2-1000", "LotNumber": null, "Quantity": 20, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018960, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018958, "ConsumeByWorkOrderNumber": "SAHSCSUB101", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 5, "@context": { "key": "300100543683651,26", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C26", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C26", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 28, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 20, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018959, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018958, "SupplyByWorkOrderNumber": "SAHSCSUB101", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP1:10:10", "SupplyByOperationName": "OP1", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018960, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018958, "ConsumeByWorkOrderNumber": "SAHSCSUB101", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "ConsumeByOperationName": "OP2", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T22:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 5, "@context": { "key": "300100543683651,28", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C28", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C28", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 10, "InventoryItemId": 300100204609876, "ItemCode": "SAPS-PW-11000", "LotNumber": null, "Quantity": 20, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018959, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018958, "ConsumeByWorkOrderNumber": "SAHSCSUB101", "ConsumeByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP1:10:10", "ConsumeByOperationName": "OP1", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-06T21:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 6, "@context": { "key": "300100543683651,10", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C10", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C10", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 13, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Upstream Pegging by Work Order
In this scenario, you can peg all upstream suppliers of a specific work order.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships? finder=findUpstreamByWorkOrder;ToWorkOrderNumber="RBPS-BERRYSHAMPJOB1"'
Example Request
This request uses the finder findUpstreamByWorkOrder
where the
downstream work order number is specified.
{ "items": [ { "PlanId": 300100542136580, "PeggingId": 41, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 95.33, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173418, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173417, "SupplyByWorkOrderNumber": "RBPS-MIXBERRJOB2", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173432, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173431, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB1", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:25:00+00:00", "ConsumeDate": "2030-01-10T13:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,41", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C41", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C41", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 36, "InventoryItemId": 300100541453864, "ItemCode": "RBPS-MIXSOLVENTINO", "LotNumber": null, "Quantity": 26.67, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173418, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173417, "ConsumeByWorkOrderNumber": "RBPS-MIXBERRJOB2", "ConsumeByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T00:00:00+00:00", "ConsumeDate": "2030-01-10T12:45:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100542136580,36", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 43, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 154.67, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173411, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173410, "SupplyByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173432, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173431, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB1", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:30:00+00:00", "ConsumeDate": "2030-01-10T13:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,43", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 31, "InventoryItemId": 300100541453864, "ItemCode": "RBPS-MIXSOLVENTINO", "LotNumber": null, "Quantity": 80, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173411, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173410, "ConsumeByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "ConsumeByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T00:00:00+00:00", "ConsumeDate": "2030-01-10T11:30:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100542136580,31", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 4, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Upstream Pegging by Work Order Operation
In this scenario, you can peg all upstream suppliers of a specific work order operation.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/latest/productionSchedulingPlans/300100542136580/child/peggingRelationships? finder=findUpstreamByWorkOrderOperation;ToWorkOrderNumber="RBPS-BERRYSHAMPJOB1",ToOperationSequenceNumber="10",ToResourceSequenceNumber="10"'
Example Request
This request uses the finder findUpstreamByWorkOrderOperation
where
the consuming work order number, work order operation, and work order operation
resourced sequence is specified.
{ "items": [ { "PlanId": 300100542136580, "PeggingId": 41, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 95.33, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173418, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173417, "SupplyByWorkOrderNumber": "RBPS-MIXBERRJOB2", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173432, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173431, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB1", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:25:00+00:00", "ConsumeDate": "2030-01-10T13:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,41", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C41", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C41", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 36, "InventoryItemId": 300100541453864, "ItemCode": "RBPS-MIXSOLVENTINO", "LotNumber": null, "Quantity": 26.67, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173418, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173417, "ConsumeByWorkOrderNumber": "RBPS-MIXBERRJOB2", "ConsumeByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T00:00:00+00:00", "ConsumeDate": "2030-01-10T12:45:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100542136580,36", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C36", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 43, "InventoryItemId": 300100541453934, "ItemCode": "RBPS-BERRY-MIXTURE", "LotNumber": null, "Quantity": 154.67, "SupplyByType": "Work Order Operation", "SupplyById": 300100546173411, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100546173410, "SupplyByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "SupplyByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173432, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173431, "ConsumeByWorkOrderNumber": "RBPS-BERRYSHAMPJOB1", "ConsumeByOperationCode": "RBPSBERRYSHAMPOO12oz-WDMAP1:RBPS-BERRYSHAMPOO-12oz:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T13:30:00+00:00", "ConsumeDate": "2030-01-10T13:30:00+00:00", "PeggingDepth": 1, "@context": { "key": "300100542136580,43", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C43", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100542136580, "PeggingId": 31, "InventoryItemId": 300100541453864, "ItemCode": "RBPS-MIXSOLVENTINO", "LotNumber": null, "Quantity": 80, "SupplyByType": "On Hand", "SupplyById": null, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": null, "SupplyByWorkOrderNumber": null, "SupplyByOperationCode": null, "SupplyByOperationName": null, "SupplyByOperationSequenceNumber": null, "SupplyByResourceSequenceNumber": null, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100546173411, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100546173410, "ConsumeByWorkOrderNumber": "RBPS-MIXBERRY-JOB1", "ConsumeByOperationCode": "RBPS-MIXBERRY-WDMAP1:RBPS-BERRY-MIXTURE:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T00:00:00+00:00", "ConsumeDate": "2030-01-10T11:30:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100542136580,31", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships/300100542136580%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 4, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100542136580/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Only Immediate Downstream Consumers of an Item On-Hand
In this scenario, you don't want to fetch the entire pegging tree but only the immediate consumers of an on-hand item. The use of Pegging Depth can be used to filter the query. This concept of filtering by pegging depth can be applied to any pegging REST API request.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships?finder=findDownstreamByOnHandInventoryItem;ItemCode="SAPS-SiO2-1000"&q=PeggingDepth=1'
Example Request
This request uses the finder findDownstreamByOnHandInventoryItem
with the additional query parameter filtering the query to only records
where the Pegging Depth only returns immediate consumers.
{ "items": [ { "PlanId": 300100543683651, "PeggingId": 99, "InventoryItemId": 300100204609880, "ItemCode": "SAPS-MSC-13000", "LotNumber": null, "Quantity": 1, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019034, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019032, "SupplyByWorkOrderNumber": "SAMSCSUB101", "SupplyByOperationCode": "SAPS-MSC-13000-WD1:SAPS-MSC-13000:OP20:20:10", "SupplyByOperationName": "OP20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205019025, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205019023, "ConsumeByWorkOrderNumber": "SAMS102", "ConsumeByOperationCode": "SAPS-MS-Chip-WD1:SAPS-MS-Chip:OP20:20:10", "ConsumeByOperationName": "OP20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-02T08:02:05+00:00", "ConsumeDate": "2030-01-21T10:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,99", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C99", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C99", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 118, "InventoryItemId": 300100204609817, "ItemCode": "SAPS-MS-Chip", "LotNumber": null, "Quantity": 36, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019025, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019023, "SupplyByWorkOrderNumber": "SAMS102", "SupplyByOperationCode": "SAPS-MS-Chip-WD1:SAPS-MS-Chip:OP20:20:10", "SupplyByOperationName": "OP20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Sales Order", "ConsumeById": 2, "DemandNumber": "520312", "DemandLineItemNumber": "2:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-21T07:08:45+00:00", "ConsumeDate": "2030-01-21T10:00:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,118", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C118", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C118", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 30, "InventoryItemId": 300100204609821, "ItemCode": "SAPS-HSC-12000", "LotNumber": null, "Quantity": 5, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018978, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018976, "SupplyByWorkOrderNumber": "SAHSCSUB103", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "SupplyByOperationName": "OP2", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018915, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-07T08:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,30", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C30", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C30", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 37, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018915, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "SupplyByOperationName": "OP10", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018916, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "ConsumeByOperationName": "Op20", "ConsumeByOperationSequenceNumber": 20, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-10T00:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,37", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C37", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C37", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 42, "InventoryItemId": null, "ItemCode": null, "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018916, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op20:20:10", "SupplyByOperationName": "Op20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018917, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "ConsumeByOperationName": "Op30", "ConsumeByOperationSequenceNumber": 30, "ConsumeByResourceSequenceNumber": 20, "SupplyDate": "2030-01-11T01:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 4, "@context": { "key": "300100543683651,42", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C42", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C42", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 45, "InventoryItemId": 300100204609815, "ItemCode": "SAPS-HS-Chip", "LotNumber": null, "Quantity": 75, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018917, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "SupplyByOperationName": "Op30", "SupplyByOperationSequenceNumber": 30, "SupplyByResourceSequenceNumber": 20, "ConsumeByType": "Sales Order", "ConsumeById": 1, "DemandNumber": "520312", "DemandLineItemNumber": "1:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-12T02:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 5, "@context": { "key": "300100543683651,45", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C45", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C45", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 31, "InventoryItemId": 300100204609821, "ItemCode": "SAPS-HSC-12000", "LotNumber": null, "Quantity": 40, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018960, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018958, "SupplyByWorkOrderNumber": "SAHSCSUB101", "SupplyByOperationCode": "SAPS-HSC-12000-WD1:SAPS-HSC-12000:OP2:20:10", "SupplyByOperationName": "OP2", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Work Order Operation", "ConsumeById": 300100205018915, "DemandNumber": null, "DemandLineItemNumber": null, "ConsumeByWorkOrderId": 300100205018914, "ConsumeByWorkOrderNumber": "SAHS101", "ConsumeByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:OP10:10:10", "ConsumeByOperationName": "OP10", "ConsumeByOperationSequenceNumber": 10, "ConsumeByResourceSequenceNumber": 10, "SupplyDate": "2030-01-08T23:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 2, "@context": { "key": "300100543683651,31", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C31", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 7, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }
Get Only Sales Orders That Consume a Specific Supply
In this scenario, you can fetch only sales orders that eventually consume any supply by using the query filter where the Demand Number is not null. This only returns records that are only pegged to sales orders.
Example URL
Use this resource URL format:
GET
curl -u username:password -X GET -H 'Content-Type: application/json' -d 'https://servername/fscmRestApi/resources/latest/ productionSchedulingPlans/300100543683651/child/peggingRelationships?finder= findDownstreamByOnHandInventoryItem;ItemCode="SAPS-PW-11000"&q=DemandNumber is not null'
Example Request
{ "items": [ { "PlanId": 300100543683651, "PeggingId": 118, "InventoryItemId": 300100204609817, "ItemCode": "SAPS-MS-Chip", "LotNumber": null, "Quantity": 36, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019025, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019023, "SupplyByWorkOrderNumber": "SAMS102", "SupplyByOperationCode": "SAPS-MS-Chip-WD1:SAPS-MS-Chip:OP20:20:10", "SupplyByOperationName": "OP20", "SupplyByOperationSequenceNumber": 20, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Sales Order", "ConsumeById": 2, "DemandNumber": "520312", "DemandLineItemNumber": "2:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-21T07:08:45+00:00", "ConsumeDate": "2030-01-21T10:00:00+00:00", "PeggingDepth": 4, "@context": { "key": "300100543683651,118", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C118", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C118", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 45, "InventoryItemId": 300100204609815, "ItemCode": "SAPS-HS-Chip", "LotNumber": null, "Quantity": 100, "SupplyByType": "Work Order Operation", "SupplyById": 300100205018917, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205018914, "SupplyByWorkOrderNumber": "SAHS101", "SupplyByOperationCode": "SAPS-HS-Chip-WD1:SAPS-HS-Chip:Op30:30:20", "SupplyByOperationName": "Op30", "SupplyByOperationSequenceNumber": 30, "SupplyByResourceSequenceNumber": 20, "ConsumeByType": "Sales Order", "ConsumeById": 1, "DemandNumber": "520312", "DemandLineItemNumber": "1:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-12T02:08:45+00:00", "ConsumeDate": "2030-01-12T05:00:00+00:00", "PeggingDepth": 6, "@context": { "key": "300100543683651,45", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C45", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C45", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } }, { "PlanId": 300100543683651, "PeggingId": 125, "InventoryItemId": 300100204609819, "ItemCode": "SAPS-LS-Chip", "LotNumber": null, "Quantity": 1.67, "SupplyByType": "Work Order Operation", "SupplyById": 300100205019049, "SupplyNumber": null, "SupplyLineItemNumber": null, "SupplyByWorkOrderId": 300100205019048, "SupplyByWorkOrderNumber": "SALS101", "SupplyByOperationCode": "SAPS-LS-Chip-WD1:SAPS-LS-Chip:OP1:10:10", "SupplyByOperationName": "OP1", "SupplyByOperationSequenceNumber": 10, "SupplyByResourceSequenceNumber": 10, "ConsumeByType": "Sales Order", "ConsumeById": 3, "DemandNumber": "520312", "DemandLineItemNumber": "3:1", "ConsumeByWorkOrderId": null, "ConsumeByWorkOrderNumber": null, "ConsumeByOperationCode": null, "ConsumeByOperationName": null, "ConsumeByOperationSequenceNumber": null, "ConsumeByResourceSequenceNumber": null, "SupplyDate": "2030-01-23T08:38:45+00:00", "ConsumeDate": "2030-01-23T11:30:00+00:00", "PeggingDepth": 3, "@context": { "key": "300100543683651,125", "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C125", "name": "peggingRelationships", "kind": "item" }, { "rel": "canonical", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships/300100543683651%2C125", "name": "peggingRelationships", "kind": "item" }, { "rel": "parent", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651", "name": "productionSchedulingPlans", "kind": "item" } ] } } ], "count": 3, "hasMore": false, "limit": 25, "offset": 0, "links": [ { "rel": "self", "href": "https://servername/fscmRestApi/resources/version/productionSchedulingPlans/300100543683651/child/peggingRelationships", "name": "peggingRelationships", "kind": "collection" } ] }