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(5)
Rules & Considerations(18)
validation
constraint
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | STORE_IDR | REASON_CODE | TRANSACTION_ID | TRANSACTION_USER | QUANTITY_TOTAL_DELTA | TRANSACTION_DESCRIPTION | QUANTITY_NON_SELLABLE_DELTA | TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1 |
| default | 3 | ALT-STORE_ITEM-002 | 1000000003 | 3 | ALT-STORE_ITEM-002 | Store Item Stock History-002-ALT | 12.5000 | Store Item Stock History: Alternate source profile | 12.5000 | 3 |
| default | 5 | EDGE-STORE_ITEM-003 | 1000000005 | 5 | EDGE-STORE_ITEM-003 | Store Item Stock History-003-EDGE | 14.0000 | — | 14.0000 | 5 |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- STORE_IDR
- 1
- REASON_CODE
- 1
- TRANSACTION_ID
- SAMPLE
- TRANSACTION_USER
- SAMPLE
- QUANTITY_TOTAL_DELTA
- 1.0000
- TRANSACTION_DESCRIPTION
- SAMPLE
- QUANTITY_NON_SELLABLE_DELTA
- 1.0000
- TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPE
- 1
default
- IDRPK
- 3
- ITEM_IDR
- ALT-STORE_ITEM-002
- STORE_IDR
- 1000000003
- REASON_CODE
- 3
- TRANSACTION_ID
- ALT-STORE_ITEM-002
- TRANSACTION_USER
- Store Item Stock History-002-ALT
- QUANTITY_TOTAL_DELTA
- 12.5000
- TRANSACTION_DESCRIPTION
- Store Item Stock History: Alternate source profile
- QUANTITY_NON_SELLABLE_DELTA
- 12.5000
- TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPE
- 3
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-STORE_ITEM-003
- STORE_IDR
- 1000000005
- REASON_CODE
- 5
- TRANSACTION_ID
- EDGE-STORE_ITEM-003
- TRANSACTION_USER
- Store Item Stock History-003-EDGE
- QUANTITY_TOTAL_DELTA
- 14.0000
- TRANSACTION_DESCRIPTION
- —
- QUANTITY_NON_SELLABLE_DELTA
- 14.0000
- TRANSACTION_TIMEYTIMESTAMP(0)78TRANSACTION_TYPE
- 5
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 18