Store Item Stock Publish
In ScopeTechnical: STORE_ITEM_STOCK_PUBLISH | ID: OR-STO-STORE_ITEM_STOCK_PUBLISH-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STORE_ITEM_STOCK_PUBLISH
Field Definitions(5)
Rules & Considerations(16)
validation
constraint
Sample Load Data(4)
| _scenario | ITEM_IDR | QUANTITYR | STORE_IDR | REASON_CODER | TRANSACTION_IDR | ID | TRANSACTION_USER | TRANSACTION_TIMESTAMP |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1.0000 | 1 | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 |
| default | ALT-STORE_ITEM-002 | 12.5000 | 1000000003 | 3 | ALT-STORE_ITEM-002 | 3 | Store Item Stock Publish-002-ALT | 2026-02-09 |
| default | EDGE-STORE_ITEM-003 | 14.0000 | 1000000005 | 5 | EDGE-STORE_ITEM-003 | 5 | Store Item Stock Publish-003-EDGE | 2026-03-12 |
Example values from field definitions
- ITEM_IDR
- SAMPLE
- QUANTITYR
- 1.0000
- STORE_IDR
- 1
- REASON_CODER
- 1
- TRANSACTION_IDR
- SAMPLE
- ID
- 1
- TRANSACTION_USER
- SAMPLE
- TRANSACTION_TIMESTAMP
- 2026-01-01
default
- ITEM_IDR
- ALT-STORE_ITEM-002
- QUANTITYR
- 12.5000
- STORE_IDR
- 1000000003
- REASON_CODER
- 3
- TRANSACTION_IDR
- ALT-STORE_ITEM-002
- ID
- 3
- TRANSACTION_USER
- Store Item Stock Publish-002-ALT
- TRANSACTION_TIMESTAMP
- 2026-02-09
default
- ITEM_IDR
- EDGE-STORE_ITEM-003
- QUANTITYR
- 14.0000
- STORE_IDR
- 1000000005
- REASON_CODER
- 5
- TRANSACTION_IDR
- EDGE-STORE_ITEM-003
- ID
- 5
- TRANSACTION_USER
- Store Item Stock Publish-003-EDGE
- TRANSACTION_TIMESTAMP
- 2026-03-12
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 16