Store Item
In ScopeTechnical: STORE_ITEM | ID: OR-SIOCS-STORE_ITEM
table was altered to include the uin_required column. y indicates that the item requires uins.
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
Field Definitions(21)
Rules & Considerations(57)
Sample Load Data(4)
| _scenario | RFIDR | ITEM_IDRPK | STORE_IDR | ITEM_TYPER | TOLERANCE_TYPER | DEFAULT_CURRENCYR | PRIMARY_SUPPLIER_IDPK | STATUS | STATUS_DATE | UIN_REQUIRED | UNIT_TOLERANCE | CONSIGNMENT_TYPE | LONG_DESCRIPTION | PERCENT_TOLERANCE | SHORT_DESCRIPTION | STORE_REORDERABLE | NEXT_DELIVERY_DATE | REJECT_STORE_ORDER | REPLENISHMENT_TYPE | STORE_CONTROL_PRICING | MULTIPLE_DELIVERY_PER_DAY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | N | STD-STORE_ITEM-001 | 1000000001 | 01 | 1 | Store Item-001 | 1000000001 | A | 2026-01-01 | Store Item-001 | 11.0000 | 01 | Store Item: Baseline migration row | 11.0000 | Store Item: Baseline migration row | Store Item-001 | 2026-01-01 | Store Item-001 | so | 1 | Store Item-001 |
default
- RFIDR
- N
- ITEM_IDRPK
- STD-STORE_ITEM-001
- STORE_IDR
- 1000000001
- ITEM_TYPER
- 01
- TOLERANCE_TYPER
- 1
- DEFAULT_CURRENCYR
- Store Item-001
- PRIMARY_SUPPLIER_IDPK
- 1000000001
- STATUS
- A
- STATUS_DATE
- 2026-01-01
- UIN_REQUIRED
- Store Item-001
- UNIT_TOLERANCE
- 11.0000
- CONSIGNMENT_TYPE
- 01
- LONG_DESCRIPTION
- Store Item: Baseline migration row
- PERCENT_TOLERANCE
- 11.0000
- SHORT_DESCRIPTION
- Store Item: Baseline migration row
- STORE_REORDERABLE
- Store Item-001
- NEXT_DELIVERY_DATE
- 2026-01-01
- REJECT_STORE_ORDER
- Store Item-001
- REPLENISHMENT_TYPE
- so
- STORE_CONTROL_PRICING
- 1
- MULTIPLE_DELIVERY_PER_DAY
- Store Item-001