Historical deliveries
In ScopeTechnical: historical_deliveries | ID: RELEX-RA-HISTORICAL_DELIVERIES
In addition to be required for mentioned modules, delieveries are useful for KPIs & reporting. To calculate other metrics e.g. delivery rows from history.
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
- transactions
Field Definitions(5)
Rules & Considerations(12)
Row Count
Field Mapping
Data Accuracy
Sample Load Data(4)
| _scenario | dateR | typeR | productR | locationR | quantityR | time | value | order_row | reference | order_type | partner_code | expiration_date | transaction_uid |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2021-05-31 | DELIVERY | 58974 | 100 | 10 | 12:00:00 | 5 | 4 | P4500 | DC | STD-HISTORICAL-001 | 2021-05-21 | TID12345 |
| default | 2021-06-01 | DELIVERY-ALT | 58974-ALT | 100-ALT | 11 | 12:00:00-ALT | 6 | 4-ALT | P4500-ALT | DC-ALT | ALT-HISTORICAL-002 | 2021-05-22 | TID12345-ALT |
| default | 2021-06-02 | DELIVERY-EDGE | 58974-EDGE | 100-EDGE | 12 | 12:00:00-EDGE | 7 | 4-EDGE | — | DC-EDGE | EDGE-HISTORICAL-003 | 2021-05-23 | TID12345-EDGE |
default
- dateR
- 2021-05-31
- typeR
- DELIVERY
- productR
- 58974
- locationR
- 100
- quantityR
- 10
- time
- 12:00:00
- value
- 5
- order_row
- 4
- reference
- P4500
- order_type
- DC
- partner_code
- STD-HISTORICAL-001
- expiration_date
- 2021-05-21
- transaction_uid
- TID12345
default
- dateR
- 2021-06-01
- typeR
- DELIVERY-ALT
- productR
- 58974-ALT
- locationR
- 100-ALT
- quantityR
- 11
- time
- 12:00:00-ALT
- value
- 6
- order_row
- 4-ALT
- reference
- P4500-ALT
- order_type
- DC-ALT
- partner_code
- ALT-HISTORICAL-002
- expiration_date
- 2021-05-22
- transaction_uid
- TID12345-ALT
default
- dateR
- 2021-06-02
- typeR
- DELIVERY-EDGE
- productR
- 58974-EDGE
- locationR
- 100-EDGE
- quantityR
- 12
- time
- 12:00:00-EDGE
- value
- 7
- order_row
- 4-EDGE
- reference
- —
- order_type
- DC-EDGE
- partner_code
- EDGE-HISTORICAL-003
- expiration_date
- 2021-05-23
- transaction_uid
- TID12345-EDGE