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(5)
Rules & Considerations(32)
constraint
validation
Sample Load Data(4)
| _scenario | ITEM_IDRPK | STORE_IDRPK | ITEM_TYPER | RFID | STATUS | STATUS_DATE | UIN_REQUIRED | TOLERANCE_TYPE | UNIT_TOLERANCE | CONSIGNMENT_TYPE | DEFAULT_CURRENCY | LONG_DESCRIPTION | PERCENT_TOLERANCE | SHORT_DESCRIPTION | STORE_REORDERABLE | NEXT_DELIVERY_DATE | REJECT_STORE_ORDER | REPLENISHMENT_TYPE | PRIMARY_SUPPLIER_ID | STORE_ORDER_ALLOWED | STORE_CONTROL_PRICING | MULTIPLE_DELIVERY_PER_DAY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | S | SAMPLE | 2026-01-01 | S | 1 | 1.0000 | 1 | SAM | SAMPLE | 1.0000 | SAMPLE | S | 2026-01-01 | Y | SAMPLE | 1 | Y | 1 | S |
| default | ALT-STORE_ITEM-002 | 1000000003 | 3 | Y | soldC | 2026-01-03 | S | 1 | 12.5000 | 3 | Sto | Store Item: Alternate source profile | 12.5000 | Store Item: Alternate source profile | S | 2026-01-03 | S | so | 1000000003 | — | 3 | S |
| default | EDGE-STORE_ITEM-003 | 1000000005 | 5 | N | I | 2026-01-05 | S | 1 | 14.0000 | 5 | Sto | — | 14.0000 | — | S | 2026-01-05 | S | so | 1000000005 | — | 5 | S |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- STORE_IDRPK
- 1
- ITEM_TYPER
- 1
- RFID
- S
- STATUS
- SAMPLE
- STATUS_DATE
- 2026-01-01
- UIN_REQUIRED
- S
- TOLERANCE_TYPE
- 1
- UNIT_TOLERANCE
- 1.0000
- CONSIGNMENT_TYPE
- 1
- DEFAULT_CURRENCY
- SAM
- 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
- PRIMARY_SUPPLIER_ID
- 1
- STORE_ORDER_ALLOWED
- Y
- STORE_CONTROL_PRICING
- 1
- MULTIPLE_DELIVERY_PER_DAY
- S
default
- ITEM_IDRPK
- ALT-STORE_ITEM-002
- STORE_IDRPK
- 1000000003
- ITEM_TYPER
- 3
- RFID
- Y
- STATUS
- soldC
- STATUS_DATE
- 2026-01-03
- UIN_REQUIRED
- S
- TOLERANCE_TYPE
- 1
- UNIT_TOLERANCE
- 12.5000
- CONSIGNMENT_TYPE
- 3
- DEFAULT_CURRENCY
- Sto
- LONG_DESCRIPTION
- Store Item: Alternate source profile
- PERCENT_TOLERANCE
- 12.5000
- SHORT_DESCRIPTION
- Store Item: Alternate source profile
- STORE_REORDERABLE
- S
- NEXT_DELIVERY_DATE
- 2026-01-03
- REJECT_STORE_ORDER
- S
- REPLENISHMENT_TYPE
- so
- PRIMARY_SUPPLIER_ID
- 1000000003
- STORE_ORDER_ALLOWED
- —
- STORE_CONTROL_PRICING
- 3
- MULTIPLE_DELIVERY_PER_DAY
- S
default
- ITEM_IDRPK
- EDGE-STORE_ITEM-003
- STORE_IDRPK
- 1000000005
- ITEM_TYPER
- 5
- RFID
- N
- STATUS
- I
- STATUS_DATE
- 2026-01-05
- UIN_REQUIRED
- S
- TOLERANCE_TYPE
- 1
- UNIT_TOLERANCE
- 14.0000
- CONSIGNMENT_TYPE
- 5
- DEFAULT_CURRENCY
- Sto
- LONG_DESCRIPTION
- —
- PERCENT_TOLERANCE
- 14.0000
- SHORT_DESCRIPTION
- —
- STORE_REORDERABLE
- S
- NEXT_DELIVERY_DATE
- 2026-01-05
- REJECT_STORE_ORDER
- S
- REPLENISHMENT_TYPE
- so
- PRIMARY_SUPPLIER_ID
- 1000000005
- STORE_ORDER_ALLOWED
- —
- STORE_CONTROL_PRICING
- 5
- MULTIPLE_DELIVERY_PER_DAY
- S
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 32