Balances
In ScopeTechnical: balances | ID: RELEX-RA-BALANCES
Snapshot of balances 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(20)
Row Count
Field Mapping
Data Accuracy
Daily Balance Value
Daily Balance Quantity
Sample Load Data(4)
| _scenario | dateR | typeR | balanceR | productR | locationR | time | value |
|---|---|---|---|---|---|---|---|
| default | 2021-05-31 | BALANCE | 10 | 58974 | 100 | 12:00:00 | 10 |
| default | 2021-06-01 | BALANCE-ALT | 11 | 58974-ALT | 100-ALT | 12:00:00-ALT | 11 |
| default | 2021-06-02 | BALANCE-EDGE | 12 | 58974-EDGE | 100-EDGE | 12:00:00-EDGE | 12 |
default
- dateR
- 2021-05-31
- typeR
- BALANCE
- balanceR
- 10
- productR
- 58974
- locationR
- 100
- time
- 12:00:00
- value
- 10
default
- dateR
- 2021-06-01
- typeR
- BALANCE-ALT
- balanceR
- 11
- productR
- 58974-ALT
- locationR
- 100-ALT
- time
- 12:00:00-ALT
- value
- 11
default
- dateR
- 2021-06-02
- typeR
- BALANCE-EDGE
- balanceR
- 12
- productR
- 58974-EDGE
- locationR
- 100-EDGE
- time
- 12:00:00-EDGE
- value
- 12