Store Item
In ScopeTechnical: STORE_ITEM | ID: OR-STO-STORE_ITEM-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- STORE_ITEM
Field Definitions(22)
Rules & Considerations(29)
constraint
validation
Sample Load Data(4)
| _scenario | RFIDR | ITEM_IDRPK | STORE_IDR | ITEM_TYPER | TOLERANCE_TYPER | DEFAULT_CURRENCYR | PRIMARY_SUPPLIER_IDRPK | 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_ORDER_ALLOWED | STORE_CONTROL_PRICING | MULTIPLE_DELIVERY_PER_DAY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | S | SAMPLE | 1 | 1 | 1 | SAM | 1 | SAMPLE | 2026-01-01 | S | 1.0000 | 1 | SAMPLE | 1.0000 | SAMPLE | S | 2026-01-01 | Y | SAMPLE | Y | 1 | S |
Example values from field definitions
- RFIDR
- S
- ITEM_IDRPK
- SAMPLE
- STORE_IDR
- 1
- ITEM_TYPER
- 1
- TOLERANCE_TYPER
- 1
- DEFAULT_CURRENCYR
- SAM
- PRIMARY_SUPPLIER_IDRPK
- 1
- STATUS
- SAMPLE
- STATUS_DATE
- 2026-01-01
- UIN_REQUIRED
- S
- UNIT_TOLERANCE
- 1.0000
- CONSIGNMENT_TYPE
- 1
- LONG_DESCRIPTION
- SAMPLE
- PERCENT_TOLERANCE
- 1.0000
- SHORT_DESCRIPTION
- SAMPLE
- STORE_REORDERABLE
- S
- NEXT_DELIVERY_DATE
- 2026-01-01
- REJECT_STORE_ORDER
- Y
- REPLENISHMENT_TYPE
- SAMPLE
- STORE_ORDER_ALLOWED
- Y
- STORE_CONTROL_PRICING
- 1
- MULTIPLE_DELIVERY_PER_DAY
- S
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 29