Open purchase orders
In ScopeTechnical: open_purchase_orders | ID: RELEX-RA-OPEN_PURCHASE_ORDERS
Snapshot of open purchase orders at the end of yesterday used for order proposal calculation.
See how this object fits into Inventory
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2 - Demand Signals
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- transactions
Field Definitions(16)
Rules & Considerations(17)
Row Count
Field Mapping
Sample Load Data(4)
| _scenario | dateR | typeR | productR | locationR | quantityR | estimated_dateR | value | order_row | reference | order_type | partner_code | expiration_date | transaction_uid | order_requested_date | estimated_delivery_time | order_proposal_reference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2021-05-11 | ORDER | 58974 | D100 | 100 | 2021-05-18 | 100 | 4 | PO5442 | SPECIAL | STD-OPEN_PURCH-001 | 2021-05-21 | TID12345 | 2021-05-17 | 12:00:00 | 5314130 |
default
- dateR
- 2021-05-11
- typeR
- ORDER
- productR
- 58974
- locationR
- D100
- quantityR
- 100
- estimated_dateR
- 2021-05-18
- value
- 100
- order_row
- 4
- reference
- PO5442
- order_type
- SPECIAL
- partner_code
- STD-OPEN_PURCH-001
- expiration_date
- 2021-05-21
- transaction_uid
- TID12345
- order_requested_date
- 2021-05-17
- estimated_delivery_time
- 12:00:00
- order_proposal_reference
- 5314130
