Open sales orders
In ScopeTechnical: open_sales_orders | ID: RELEX-RA-OPEN_SALES_ORDERS
Snapshot of open sales orders at the end of yesterday used for order proposal calculation.
See how this object fits into Sales Demand
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
- Transactionstransactions
Field Definitions(5)
Rules & Considerations(12)
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 | transaction_uid | order_requested_date | estimated_delivery_time |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2021-05-11 | SALES_ORDER | 58974 | D100 | -100 | 50 | 4 | SO5432 | NORMAL | STD-OPEN_SALES-001 | 2021-05-18 | TID12345 | 2021-05-17 | 12:00:00 |
| default | 2021-05-12 | SALES_ORDER-ALT | 58974-ALT | D100-ALT | -99 | 51 | 4-ALT | SO5432-ALT | NORMAL-ALT | ALT-OPEN_SALES-002 | 2021-05-19 | TID12345-ALT | 2021-05-18 | 12:00:00-ALT |
| default | 2021-05-13 | SALES_ORDER-EDGE | 58974-EDGE | D100-EDGE | -98 | 52 | 4-EDGE | — | NORMAL-EDGE | EDGE-OPEN_SALES-003 | 2021-05-20 | TID12345-EDGE | 2021-05-19 | 12:00:00-EDGE |
default
- dateR
- 2021-05-11
- typeR
- SALES_ORDER
- productR
- 58974
- locationR
- D100
- quantityR
- -100
- value
- 50
- order_row
- 4
- reference
- SO5432
- order_type
- NORMAL
- partner_code
- STD-OPEN_SALES-001
- estimated_date
- 2021-05-18
- transaction_uid
- TID12345
- order_requested_date
- 2021-05-17
- estimated_delivery_time
- 12:00:00
default
- dateR
- 2021-05-12
- typeR
- SALES_ORDER-ALT
- productR
- 58974-ALT
- locationR
- D100-ALT
- quantityR
- -99
- value
- 51
- order_row
- 4-ALT
- reference
- SO5432-ALT
- order_type
- NORMAL-ALT
- partner_code
- ALT-OPEN_SALES-002
- estimated_date
- 2021-05-19
- transaction_uid
- TID12345-ALT
- order_requested_date
- 2021-05-18
- estimated_delivery_time
- 12:00:00-ALT
default
- dateR
- 2021-05-13
- typeR
- SALES_ORDER-EDGE
- productR
- 58974-EDGE
- locationR
- D100-EDGE
- quantityR
- -98
- value
- 52
- order_row
- 4-EDGE
- reference
- —
- order_type
- NORMAL-EDGE
- partner_code
- EDGE-OPEN_SALES-003
- estimated_date
- 2021-05-20
- transaction_uid
- TID12345-EDGE
- order_requested_date
- 2021-05-19
- estimated_delivery_time
- 12:00:00-EDGE