Item
In ScopeTechnical: ITEM | ID: OR-SIOCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM
Field Definitions(41)
Rules & Considerations(102)
Sample Load Data(4)
| _scenario | ITEM_IDRPK | SELLABLER | ITEM_TYPER | ORDERABLER | CREATE_DATER | UPDATE_DATER | DEPARTMENT_IDPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | STD-ITEM-001 | Y | 01 | Y | 2026-01-01 | 2026-01-01 | 1000000001 | Y | Item-001 | N | Item-001 | ACTIVE | 1000000001 | 11.0000 | Y | 1 | Y | Item-001 | 1000000001 | 11.0000 | Item-001 | Item-001 | 11.0000 | Item-001 | 1 | STD-ITEM-001 | STD-ITEM-001 | Item-001 | Item-001 | Item-001 | Item-001 | Item: Baseline migration row | STD-ITEM-001 | Item: Baseline migration row | Item: Baseline migration row | 1 | 11.0000 | 11.0000 | Item-001 | 11.0000 | Item-001 |
default
- ITEM_IDRPK
- STD-ITEM-001
- SELLABLER
- Y
- ITEM_TYPER
- 01
- ORDERABLER
- Y
- CREATE_DATER
- 2026-01-01
- UPDATE_DATER
- 2026-01-01
- DEPARTMENT_IDPK
- 1000000001
- INVENTORIABLER
- Y
- UNIT_OF_MEASURER
- Item-001
- ESTIMATE_SOH_FOR_PACKR
- N
- BRAND
- Item-001
- STATUS
- ACTIVE
- CLASS_ID
- 1000000001
- CASE_SIZE
- 11.0000
- IS_PRIMARY
- Y
- ITEM_LEVEL
- 1
- SHIP_ALONE
- Y
- WASTE_TYPE
- Item-001
- SUBCLASS_ID
- 1000000001
- PACKAGE_SIZE
- 11.0000
- ORDER_AS_TYPE
- Item-001
- THUMBNAIL_URL
- Item-001
- WASTE_PERCENT
- 11.0000
- BARCODE_FORMAT
- Item-001
- BARCODE_PREFIX
- 1
- PARENT_ITEM_ID
- STD-ITEM-001
- RETAIL_ZONE_ID
- STD-ITEM-001
- DIFFERENTIATOR_1
- Item-001
- DIFFERENTIATOR_2
- Item-001
- DIFFERENTIATOR_3
- Item-001
- DIFFERENTIATOR_4
- Item-001
- LONG_DESCRIPTION
- Item: Baseline migration row
- TICKET_TYPE_CODE
- STD-ITEM-001
- BRAND_DESCRIPTION
- Item: Baseline migration row
- SHORT_DESCRIPTION
- Item: Baseline migration row
- TRANSACTION_LEVEL
- 1
- EACH_TO_UOM_FACTOR
- 11.0000
- WASTE_PERCENT_DEFAULT
- 11.0000
- PACKAGE_UNIT_OF_MEASURE
- Item-001
- MANU_SUGGESTED_RETAIL_PRICE
- 11.0000
- MANU_SUGGESTED_RETAIL_CURRENCY
- Item-001