Item Master
In ScopeTechnical: ITEM_MASTER | ID: OR-ITM-ITEM_MASTER-ITEM_MASTER
Stores all the main attributes and records for all items and pack items in RMS. Additionally this table has referential integrity on itself which hold the links between grandparent, parent…
See how this object fits into Item Management
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_MASTER
Field Definitions(82)
Rules & Considerations(263)
Sample Load Data(4)
| _scenario | DEPTRPK | ITEMRPK | CLASSR | STATUSR | DESC_UPR | PACK_INDR | SUBCLASSR | CREATE_IDR | ITEM_DESCR | BRAND_NAMERPK | ITEM_LEVELR | SHORT_DESCR | TRAN_LEVELR | ITEM_PARENTRPK | PACKAGE_UOMRPK | FORECAST_INDR | SELLABLE_INDR | STANDARD_UOMRPK | GIFT_WRAP_INDR | INVENTORY_INDR | ORDERABLE_INDR | CONTAINER_ITEMRPK | ITEM_XFORM_INDR | LAST_UPDATE_IDR | PERISHABLE_INDR | SHIP_ALONE_INDR | STORE_ORD_MULTR | CONST_DIMEN_INDR | CREATE_DATETIMER | MERCHANDISE_INDR | SIMPLE_PACK_INDR | CATCH_WEIGHT_INDR | CATCH_WEIGHT_UOMRPK | ITEM_GRANDPARENTRPK | ITEM_NUMBER_TYPER | NOTIONAL_PACK_INDR | CONTAINS_INNER_INDR | COST_ZONE_GROUP_IDRPK | ITEM_AGGREGATE_INDR | DIFF_1_AGGREGATE_INDR | DIFF_2_AGGREGATE_INDR | DIFF_3_AGGREGATE_INDR | DIFF_4_AGGREGATE_INDR | LAST_UPDATE_DATETIMER | PRIMARY_REF_ITEM_INDR | SOH_INQUIRY_AT_PACK_INDR | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | PREFIX | COMMENTS | FORMAT_ID | LONG_DESC | PACK_TYPE | SALE_TYPE | WASTE_PCT | ORDER_TYPE | WASTE_TYPE | PACKAGE_SIZE | AIP_CASE_TYPE | ALC_ITEM_TYPE | CHECK_UDA_IND | HANDLING_TEMP | ORDER_AS_TYPE | MFG_REC_RETAIL | ORIGINAL_RETAIL | UOM_CONV_FACTOR | CURR_SELLING_UOM | REINSTATE_STATUS | CATCH_WEIGHT_TYPE | DEFAULT_WASTE_PCT | DEPOSIT_ITEM_TYPE | RETAIL_LABEL_TYPE | ITEM_SERVICE_LEVEL | RETAIL_LABEL_VALUE | ITEM_DESC_SECONDARY | HANDLING_SENSITIVITY | PRODUCT_CLASSIFICATION | CURR_SELLING_UNIT_RETAIL | DEPOSIT_IN_PRICE_PER_UOM | TSF_ALLOC_UP_CHRG_SOURCE_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | S | SAMPLE | S | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | SAMP | S | S | SAMP | S | S | S | SAMPLE | S | SAMPLE | S | S | S | S | 2026-01-01 | S | S | S | SAMP | SAMPLE | SAMPLE | S | S | 1 | S | S | S | S | S | 2026-01-01 | S | S | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | S | SAMPLE | S | SAMPLE | 1 | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | S | SAMPLE | S | 1 | 1 | 1 | SAMP | S | S | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE |
Example values from field definitions
- DEPTRPK
- 1
- ITEMRPK
- SAMPLE
- CLASSR
- 1
- STATUSR
- S
- DESC_UPR
- SAMPLE
- PACK_INDR
- S
- SUBCLASSR
- 1
- CREATE_IDR
- SAMPLE
- ITEM_DESCR
- SAMPLE
- BRAND_NAMERPK
- SAMPLE
- ITEM_LEVELR
- 1
- SHORT_DESCR
- SAMPLE
- TRAN_LEVELR
- 1
- ITEM_PARENTRPK
- SAMPLE
- PACKAGE_UOMRPK
- SAMP
- FORECAST_INDR
- S
- SELLABLE_INDR
- S
- STANDARD_UOMRPK
- SAMP
- GIFT_WRAP_INDR
- S
- INVENTORY_INDR
- S
- ORDERABLE_INDR
- S
- CONTAINER_ITEMRPK
- SAMPLE
- ITEM_XFORM_INDR
- S
- LAST_UPDATE_IDR
- SAMPLE
- PERISHABLE_INDR
- S
- SHIP_ALONE_INDR
- S
- STORE_ORD_MULTR
- S
- CONST_DIMEN_INDR
- S
- CREATE_DATETIMER
- 2026-01-01
- MERCHANDISE_INDR
- S
- SIMPLE_PACK_INDR
- S
- CATCH_WEIGHT_INDR
- S
- CATCH_WEIGHT_UOMRPK
- SAMP
- ITEM_GRANDPARENTRPK
- SAMPLE
- ITEM_NUMBER_TYPER
- SAMPLE
- NOTIONAL_PACK_INDR
- S
- CONTAINS_INNER_INDR
- S
- COST_ZONE_GROUP_IDRPK
- 1
- ITEM_AGGREGATE_INDR
- S
- DIFF_1_AGGREGATE_INDR
- S
- DIFF_2_AGGREGATE_INDR
- S
- DIFF_3_AGGREGATE_INDR
- S
- DIFF_4_AGGREGATE_INDR
- S
- LAST_UPDATE_DATETIMER
- 2026-01-01
- PRIMARY_REF_ITEM_INDR
- S
- SOH_INQUIRY_AT_PACK_INDR
- S
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- PREFIX
- 1
- COMMENTS
- SAMPLE
- FORMAT_ID
- S
- LONG_DESC
- SAMPLE
- PACK_TYPE
- S
- SALE_TYPE
- SAMPLE
- WASTE_PCT
- 1
- ORDER_TYPE
- SAMPLE
- WASTE_TYPE
- SAMPLE
- PACKAGE_SIZE
- 1
- AIP_CASE_TYPE
- SAMPLE
- ALC_ITEM_TYPE
- SAMPLE
- CHECK_UDA_IND
- S
- HANDLING_TEMP
- SAMPLE
- ORDER_AS_TYPE
- S
- MFG_REC_RETAIL
- 1
- ORIGINAL_RETAIL
- 1
- UOM_CONV_FACTOR
- 1
- CURR_SELLING_UOM
- SAMP
- REINSTATE_STATUS
- S
- CATCH_WEIGHT_TYPE
- S
- DEFAULT_WASTE_PCT
- 1
- DEPOSIT_ITEM_TYPE
- SAMPLE
- RETAIL_LABEL_TYPE
- SAMPLE
- ITEM_SERVICE_LEVEL
- SAMPLE
- RETAIL_LABEL_VALUE
- 1
- ITEM_DESC_SECONDARY
- SAMPLE
- HANDLING_SENSITIVITY
- SAMPLE
- PRODUCT_CLASSIFICATION
- SAMPLE
- CURR_SELLING_UNIT_RETAIL
- 1
- DEPOSIT_IN_PRICE_PER_UOM
- SAMPLE
- TSF_ALLOC_UP_CHRG_SOURCE_TYPE
- SAMPLE