Store Item Stock History
In ScopeTechnical: STORE_ITEM_STOCK_HISTORY | ID: OR-SIOCS-STORE_ITEM_STOCK_HISTORY
Stores the store item stock transction history.
See how this object fits into Store Operations
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- STORE_ITEM_STOCK_HISTORY
Field Definitions(10)
Rules & Considerations(31)
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | REASON_CODER | TRANSACTION_IDR | TRANSACTION_USERR | TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPER | QUANTITY_TOTAL_DELTA | TRANSACTION_DESCRIPTION | QUANTITY_NON_SELLABLE_DELTA |
|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | STD-STORE_ITEM-001 | 1000000001 | 0001 | STD-STORE_ITEM-001 | Store Item Stock History-001 | 01 | 11.0000 | Store Item Stock History: Baseline migration row | 11.0000 |
default
- IDRPK
- 1
- ITEM_IDR
- STD-STORE_ITEM-001
- STORE_IDR
- 1000000001
- REASON_CODER
- 0001
- TRANSACTION_IDR
- STD-STORE_ITEM-001
- TRANSACTION_USERR
- Store Item Stock History-001
- TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPER
- 01
- QUANTITY_TOTAL_DELTA
- 11.0000
- TRANSACTION_DESCRIPTION
- Store Item Stock History: Baseline migration row
- QUANTITY_NON_SELLABLE_DELTA
- 11.0000