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(5)
Rules & Considerations(17)
Row Count
Field Mapping
Data Accuracy
Sample Load Data(4)
| _scenario | dateR | typeR | productR | locationR | quantityR | value | order_row | reference | order_type | partner_code | estimated_date | expiration_date | transaction_uid | order_requested_date | estimated_delivery_time | order_proposal_reference |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2021-05-11 | ORDER | 58974 | D100 | 100 | 100 | 4 | PO5442 | SPECIAL | STD-OPEN_PURCH-001 | 2021-05-18 | 2021-05-21 | TID12345 | 2021-05-17 | 12:00:00 | 5314130 |
| default | 2021-05-12 | ORDER-ALT | 58974-ALT | D100-ALT | 101 | 101 | 4-ALT | PO5442-ALT | SPECIAL-ALT | ALT-OPEN_PURCH-002 | 2021-05-19 | 2021-05-22 | TID12345-ALT | 2021-05-18 | 12:00:00-ALT | 5314130-ALT |
| default | 2021-05-13 | ORDER-EDGE | 58974-EDGE | D100-EDGE | 102 | 102 | 4-EDGE | — | SPECIAL-EDGE | EDGE-OPEN_PURCH-003 | 2021-05-20 | 2021-05-23 | TID12345-EDGE | 2021-05-19 | 12:00:00-EDGE | — |
default
- dateR
- 2021-05-11
- typeR
- ORDER
- productR
- 58974
- locationR
- D100
- quantityR
- 100
- value
- 100
- order_row
- 4
- reference
- PO5442
- order_type
- SPECIAL
- partner_code
- STD-OPEN_PURCH-001
- estimated_date
- 2021-05-18
- expiration_date
- 2021-05-21
- transaction_uid
- TID12345
- order_requested_date
- 2021-05-17
- estimated_delivery_time
- 12:00:00
- order_proposal_reference
- 5314130
default
- dateR
- 2021-05-12
- typeR
- ORDER-ALT
- productR
- 58974-ALT
- locationR
- D100-ALT
- quantityR
- 101
- value
- 101
- order_row
- 4-ALT
- reference
- PO5442-ALT
- order_type
- SPECIAL-ALT
- partner_code
- ALT-OPEN_PURCH-002
- estimated_date
- 2021-05-19
- expiration_date
- 2021-05-22
- transaction_uid
- TID12345-ALT
- order_requested_date
- 2021-05-18
- estimated_delivery_time
- 12:00:00-ALT
- order_proposal_reference
- 5314130-ALT
default
- dateR
- 2021-05-13
- typeR
- ORDER-EDGE
- productR
- 58974-EDGE
- locationR
- D100-EDGE
- quantityR
- 102
- value
- 102
- order_row
- 4-EDGE
- reference
- —
- order_type
- SPECIAL-EDGE
- partner_code
- EDGE-OPEN_PURCH-003
- estimated_date
- 2021-05-20
- expiration_date
- 2021-05-23
- transaction_uid
- TID12345-EDGE
- order_requested_date
- 2021-05-19
- estimated_delivery_time
- 12:00:00-EDGE
- order_proposal_reference
- —