Store Item Stock Transction History
In ScopeTechnical: STORE_ITEM_STOCK_HISTORY | ID: OR-STO-STORE_ITEM_STOCK_HISTORY-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STORE_ITEM_STOCK_HISTORY
Field Definitions(10)
Rules & Considerations(18)
validation
constraint
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | 1.0000 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- REASON_CODER
- 1
- TRANSACTION_IDR
- SAMPLE
- TRANSACTION_USERR
- SAMPLE
- TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPER
- 1
- QUANTITY_TOTAL_DELTA
- 1.0000
- TRANSACTION_DESCRIPTION
- SAMPLE
- QUANTITY_NON_SELLABLE_DELTA
- 1.0000
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 18