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(41)
Rules & Considerations(51)
Sample Load Data(4)
| _scenario | ITEM_IDRPK | SELLABLER | ITEM_TYPER | ORDERABLER | CREATE_DATER | UPDATE_DATER | DEPARTMENT_IDRPK | INVENTORIABLER | UNIT_OF_MEASURER | ESTIMATE_SOH_FOR_PACKR | BRAND | STATUS | CLASS_ID | CASE_SIZE | IS_PRIMARY | ITEM_LEVEL | SHIP_ALONE | WASTE_TYPE | SUBCLASS_ID | PACKAGE_SIZE | ORDER_AS_TYPE | THUMBNAIL_URL | WASTE_PERCENT | BARCODE_FORMAT | BARCODE_PREFIX | PARENT_ITEM_ID | RETAIL_ZONE_ID | DIFFERENTIATOR_1 | DIFFERENTIATOR_2 | DIFFERENTIATOR_3 | DIFFERENTIATOR_4 | LONG_DESCRIPTION | TICKET_TYPE_CODE | BRAND_DESCRIPTION | SHORT_DESCRIPTION | TRANSACTION_LEVEL | EACH_TO_UOM_FACTOR | WASTE_PERCENT_DEFAULT | PACKAGE_UNIT_OF_MEASURE | MANU_SUGGESTED_RETAIL_PRICE | MANU_SUGGESTED_RETAIL_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | S | 1 | S | 2026-01-01 | 2026-01-01 | 1 | S | SAMP | Y | SAMPLE | S | 1 | 1.0000 | Y | 1 | S | SAMPLE | 1 | 1.0000 | S | SAMPLE | 1.0000 | SAMP | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000000000 | 1.0000 | SAMP | 1.0000 | SAM |
Example values from field definitions
- ITEM_IDRPK
- SAMPLE
- SELLABLER
- S
- ITEM_TYPER
- 1
- ORDERABLER
- S
- CREATE_DATER
- 2026-01-01
- UPDATE_DATER
- 2026-01-01
- DEPARTMENT_IDRPK
- 1
- INVENTORIABLER
- S
- UNIT_OF_MEASURER
- SAMP
- ESTIMATE_SOH_FOR_PACKR
- Y
- BRAND
- SAMPLE
- STATUS
- S
- CLASS_ID
- 1
- CASE_SIZE
- 1.0000
- IS_PRIMARY
- Y
- ITEM_LEVEL
- 1
- SHIP_ALONE
- S
- WASTE_TYPE
- SAMPLE
- SUBCLASS_ID
- 1
- PACKAGE_SIZE
- 1.0000
- 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
- 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
- WASTE_PERCENT_DEFAULT
- 1.0000
- PACKAGE_UNIT_OF_MEASURE
- SAMP
- MANU_SUGGESTED_RETAIL_PRICE
- 1.0000
- MANU_SUGGESTED_RETAIL_CURRENCY
- SAM
Rule Validation Summary
- Source Rule Count
- 59
- Governed Rule Count
- 51