Historical balances
In ScopeTechnical: historical_balances | ID: RELEX-RA-HISTORICAL_BALANCES
To correct historical sales for out-of-stocks. To calculate availability from history.
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