Store Item Stock Publish
In ScopeTechnical: STORE_ITEM_STOCK_PUBLISH | ID: OR-SIOCS-STORE_ITEM_STOCK_PUBLISH
Table to hold stock adjustment information for external messaging. Records are deleted when processed.
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_PUBLISH
Field Definitions(8)
Rules & Considerations(28)
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | QUANTITYR | STORE_IDR | REASON_CODER | TRANSACTION_IDR | TRANSACTION_USERR | TRANSACTION_TIMESTAMPR |
|---|---|---|---|---|---|---|---|---|
| default | 1 | STD-STORE_ITEM-001 | 11.0000 | 1000000001 | 1 | STD-STORE_ITEM-001 | Store Item Stock Publish-001 | 2026-01-06 |
default
- IDRPK
- 1
- ITEM_IDR
- STD-STORE_ITEM-001
- QUANTITYR
- 11.0000
- STORE_IDR
- 1000000001
- REASON_CODER
- 1
- TRANSACTION_IDR
- STD-STORE_ITEM-001
- TRANSACTION_USERR
- Store Item Stock Publish-001
- TRANSACTION_TIMESTAMPR
- 2026-01-06