Item
In ScopeTechnical: ITEM | ID: OR-STO-ITEM-ITEM
Stores one record for each item defined for the company. it contains the base information for an item that is consistent across all locations.
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
- ITEM
Field Definitions(5)
Rules & Considerations(54)
Sample Load Data(4)
| _scenario | ITEM_IDRPK | ITEM_TYPER | BRAND | STATUS | CLASS_ID | SELLABLE | CASE_SIZE | ORDERABLE | IS_PRIMARY | ITEM_LEVEL | SHIP_ALONE | WASTE_TYPE | CREATE_DATE | SUBCLASS_ID | UPDATE_DATE | PACKAGE_SIZE | DEPARTMENT_ID | INVENTORIABLE | ORDER_AS_TYPE | THUMBNAIL_URL | WASTE_PERCENT | BARCODE_FORMAT | BARCODE_PREFIX | PARENT_ITEM_ID | RETAIL_ZONE_ID | UNIT_OF_MEASURE | DIFFERENTIATOR_1 | DIFFERENTIATOR_2 | DIFFERENTIATOR_3 | DIFFERENTIATOR_4 | LONG_DESCRIPTION | TICKET_TYPE_CODE | BRAND_DESCRIPTION | SHORT_DESCRIPTION | TRANSACTION_LEVEL | EACH_TO_UOM_FACTOR | ESTIMATE_SOH_FOR_PACK | WASTE_PERCENT_DEFAULT | PACKAGE_UNIT_OF_MEASURE | MANU_SUGGESTED_RETAIL_PRICE | MANU_SUGGESTED_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | S | 1 | S | 1.0000 | S | Y | 1 | S | SAMPLE | 2026-01-01 | 1 | 2026-01-01 | 1.0000 | 1 | S | S | SAMPLE | 1.0000 | SAMP | 1 | SAMPLE | SAMPLE | SAMP | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000000000 | Y | 1.0000 | SAMP | 1.0000 | SAM |
| default | ALT-ITEM-002 | 3 | Item-002-ALT | P | 1000000003 | N | 12.5000 | N | N | 3 | N | Item-0 | 2026-01-03 | 1000000003 | 2026-01-03 | 12.5000 | 1000000003 | Y | I | Item-002-ALT | 12.5000 | Item | 3 | ALT-ITEM-002 | ALT-ITEM-002 | Item | Item-002-A | Item-002-A | Item-002-A | Item-002-A | Item: Alternate source profile | ALT-IT | Item: Alternate source profile | Item: Alternate source profile | 3 | 12.5000000000 | N | 12.5000 | Item | 12.5000 | Ite |
| default | EDGE-ITEM-003 | 5 | Item-003-EDGE | A | 1000000005 | Y | 14.0000 | Y | Y | 5 | Y | Item-0 | 2026-01-05 | 1000000005 | 2026-01-05 | 14.0000 | 1000000005 | Y | I | Item-003-EDGE | 14.0000 | Item | 5 | EDGE-ITEM-003 | EDGE-ITEM-003 | Item | Item-003-E | Item-003-E | Item-003-E | Item-003-E | — | EDGE-I | — | — | 5 | 14.0000000000 | N | 14.0000 | Item | 14.0000 | Ite |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- ITEM_TYPER
- 1
- BRAND
- SAMPLE
- STATUS
- S
- CLASS_ID
- 1
- SELLABLE
- S
- CASE_SIZE
- 1.0000
- ORDERABLE
- S
- IS_PRIMARY
- Y
- ITEM_LEVEL
- 1
- SHIP_ALONE
- S
- WASTE_TYPE
- SAMPLE
- CREATE_DATE
- 2026-01-01
- SUBCLASS_ID
- 1
- UPDATE_DATE
- 2026-01-01
- PACKAGE_SIZE
- 1.0000
- DEPARTMENT_ID
- 1
- INVENTORIABLE
- S
- ORDER_AS_TYPE
- S
- THUMBNAIL_URL
- SAMPLE
- WASTE_PERCENT
- 1.0000
- BARCODE_FORMAT
- SAMP
- BARCODE_PREFIX
- 1
- PARENT_ITEM_ID
- SAMPLE
- RETAIL_ZONE_ID
- SAMPLE
- UNIT_OF_MEASURE
- SAMP
- DIFFERENTIATOR_1
- SAMPLE
- DIFFERENTIATOR_2
- SAMPLE
- DIFFERENTIATOR_3
- SAMPLE
- DIFFERENTIATOR_4
- SAMPLE
- LONG_DESCRIPTION
- SAMPLE
- TICKET_TYPE_CODE
- SAMPLE
- BRAND_DESCRIPTION
- SAMPLE
- SHORT_DESCRIPTION
- SAMPLE
- TRANSACTION_LEVEL
- 1
- EACH_TO_UOM_FACTOR
- 1.0000000000
- ESTIMATE_SOH_FOR_PACK
- Y
- WASTE_PERCENT_DEFAULT
- 1.0000
- PACKAGE_UNIT_OF_MEASURE
- SAMP
- MANU_SUGGESTED_RETAIL_PRICE
- 1.0000
- MANU_SUGGESTED_RETAIL_CURRENCY
- SAM
default
- ITEM_IDRPK
- ALT-ITEM-002
- ITEM_TYPER
- 3
- BRAND
- Item-002-ALT
- STATUS
- P
- CLASS_ID
- 1000000003
- SELLABLE
- N
- CASE_SIZE
- 12.5000
- ORDERABLE
- N
- IS_PRIMARY
- N
- ITEM_LEVEL
- 3
- SHIP_ALONE
- N
- WASTE_TYPE
- Item-0
- CREATE_DATE
- 2026-01-03
- SUBCLASS_ID
- 1000000003
- UPDATE_DATE
- 2026-01-03
- PACKAGE_SIZE
- 12.5000
- DEPARTMENT_ID
- 1000000003
- INVENTORIABLE
- Y
- ORDER_AS_TYPE
- I
- THUMBNAIL_URL
- Item-002-ALT
- WASTE_PERCENT
- 12.5000
- BARCODE_FORMAT
- Item
- BARCODE_PREFIX
- 3
- PARENT_ITEM_ID
- ALT-ITEM-002
- RETAIL_ZONE_ID
- ALT-ITEM-002
- UNIT_OF_MEASURE
- Item
- DIFFERENTIATOR_1
- Item-002-A
- DIFFERENTIATOR_2
- Item-002-A
- DIFFERENTIATOR_3
- Item-002-A
- DIFFERENTIATOR_4
- Item-002-A
- LONG_DESCRIPTION
- Item: Alternate source profile
- TICKET_TYPE_CODE
- ALT-IT
- BRAND_DESCRIPTION
- Item: Alternate source profile
- SHORT_DESCRIPTION
- Item: Alternate source profile
- TRANSACTION_LEVEL
- 3
- EACH_TO_UOM_FACTOR
- 12.5000000000
- ESTIMATE_SOH_FOR_PACK
- N
- WASTE_PERCENT_DEFAULT
- 12.5000
- PACKAGE_UNIT_OF_MEASURE
- Item
- MANU_SUGGESTED_RETAIL_PRICE
- 12.5000
- MANU_SUGGESTED_RETAIL_CURRENCY
- Ite
default
- ITEM_IDRPK
- EDGE-ITEM-003
- ITEM_TYPER
- 5
- BRAND
- Item-003-EDGE
- STATUS
- A
- CLASS_ID
- 1000000005
- SELLABLE
- Y
- CASE_SIZE
- 14.0000
- ORDERABLE
- Y
- IS_PRIMARY
- Y
- ITEM_LEVEL
- 5
- SHIP_ALONE
- Y
- WASTE_TYPE
- Item-0
- CREATE_DATE
- 2026-01-05
- SUBCLASS_ID
- 1000000005
- UPDATE_DATE
- 2026-01-05
- PACKAGE_SIZE
- 14.0000
- DEPARTMENT_ID
- 1000000005
- INVENTORIABLE
- Y
- ORDER_AS_TYPE
- I
- THUMBNAIL_URL
- Item-003-EDGE
- WASTE_PERCENT
- 14.0000
- BARCODE_FORMAT
- Item
- BARCODE_PREFIX
- 5
- PARENT_ITEM_ID
- EDGE-ITEM-003
- RETAIL_ZONE_ID
- EDGE-ITEM-003
- UNIT_OF_MEASURE
- Item
- DIFFERENTIATOR_1
- Item-003-E
- DIFFERENTIATOR_2
- Item-003-E
- DIFFERENTIATOR_3
- Item-003-E
- DIFFERENTIATOR_4
- Item-003-E
- LONG_DESCRIPTION
- —
- TICKET_TYPE_CODE
- EDGE-I
- BRAND_DESCRIPTION
- —
- SHORT_DESCRIPTION
- —
- TRANSACTION_LEVEL
- 5
- EACH_TO_UOM_FACTOR
- 14.0000000000
- ESTIMATE_SOH_FOR_PACK
- N
- WASTE_PERCENT_DEFAULT
- 14.0000
- PACKAGE_UNIT_OF_MEASURE
- Item
- MANU_SUGGESTED_RETAIL_PRICE
- 14.0000
- MANU_SUGGESTED_RETAIL_CURRENCY
- Ite
Rule Validation Summary
- Source Rule Count
- 62
- Governed Rule Count
- 54