Item Master

In Scope

Technical: 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(5)

Rules & Considerations(144)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	ITEM_NUMBER_TYPER	DEPT	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	PREFIX	STATUS	DESC_UP	COMMENTS	PACK_IND	SUBCLASS	CREATE_ID	FORMAT_ID	ITEM_DESC	LONG_DESC	PACK_TYPE	SALE_TYPE	WASTE_PCT	BRAND_NAME	ITEM_LEVEL	ORDER_TYPE	SHORT_DESC	TRAN_LEVEL	WASTE_TYPE	ITEM_PARENT	PACKAGE_UOM	FORECAST_IND	PACKAGE_SIZE	SELLABLE_IND	STANDARD_UOM	AIP_CASE_TYPE	ALC_ITEM_TYPE	CHECK_UDA_IND	GIFT_WRAP_IND	HANDLING_TEMP	INVENTORY_IND	ORDERABLE_IND	ORDER_AS_TYPE	CONTAINER_ITEM	ITEM_XFORM_IND	LAST_UPDATE_ID	MFG_REC_RETAIL	PERISHABLE_IND	SHIP_ALONE_IND	STORE_ORD_MULT	CONST_DIMEN_IND	CREATE_DATETIME	MERCHANDISE_IND	ORIGINAL_RETAIL	SIMPLE_PACK_IND	UOM_CONV_FACTOR	CATCH_WEIGHT_IND	CATCH_WEIGHT_UOM	CURR_SELLING_UOM	ITEM_GRANDPARENT	REINSTATE_STATUS	CATCH_WEIGHT_TYPE	DEFAULT_WASTE_PCT	DEPOSIT_ITEM_TYPE	NOTIONAL_PACK_IND	RETAIL_LABEL_TYPE	CONTAINS_INNER_IND	COST_ZONE_GROUP_ID	ITEM_AGGREGATE_IND	ITEM_SERVICE_LEVEL	RETAIL_LABEL_VALUE	ITEM_DESC_SECONDARY	DIFF_1_AGGREGATE_IND	DIFF_2_AGGREGATE_IND	DIFF_3_AGGREGATE_IND	DIFF_4_AGGREGATE_IND	HANDLING_SENSITIVITY	LAST_UPDATE_DATETIME	PRIMARY_REF_ITEM_IND	PRODUCT_CLASSIFICATION	SOH_INQUIRY_AT_PACK_IND	CURR_SELLING_UNIT_RETAIL	DEPOSIT_IN_PRICE_PER_UOM	TSF_ALLOC_UP_CHRG_SOURCE_TYPE
Example values from field definitions	SAMPLE	SAMPLE	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	S	SAMPLE	SAMPLE	S	1	SAMPLE	S	SAMPLE	SAMPLE	S	SAMPLE	1.0000	SAMPLE	1	SAMPLE	SAMPLE	1	SAMPLE	SAMPLE	SAMP	S	1.0000	S	SAMP	SAMPLE	SAMPLE	S	S	SAMPLE	S	S	S	SAMPLE	S	SAMPLE	1.0000	S	S	S	S	2026-01-01	S	1.0000	S	1.0000000000	S	SAMP	SAMP	SAMPLE	S	S	1.0000	SAMPLE	S	SAMPLE	S	1	S	SAMPLE	1.0000	SAMPLE	S	S	S	S	SAMPLE	2026-01-01	S	SAMPLE	S	1.0000	SAMPLE	SAMPLE
default	Item Master-002-ALT	Item M	1003	1103	Item Maste	Item Maste	Item Maste	Item Maste	3	S	Item Master-002-ALT	Item Master-002-ALT	I	1113	C LIENT_INFO	A	Item Master-002-ALT	Item Master-002-ALT	V	V	12.5000	Item Master Secondary	3	F	Item Master-002-ALT	3	SP	Item Master-002-ALT	Item	I	12.5000	N	Item	Item M	Item Master-002	N	I	Item M	N	N	P	Item Master-002-ALT	I	MDM_USER	12.5000	N	I	C	I	2026-01-03	I	12.5000	N	12.5000000000	N	Item	Item	Item Master-002-ALT	P	I	12.5000	Item M	N	Item M	N	100003	I	Item M	12.5000	Item Master-002-ALT	I	I	I	I	Item M	2026-01-03	I	Item M	N	12.5000	I	Item M
default	Item Master-003-EDGE	Item M	1005	1105	Item Maste	Item Maste	Item Maste	Item Maste	5	A	Item Master-003-EDGE	Item Master-003-EDGE	I	1115	USE RENV	E	Item Master-003-EDGE	Item Master-003-EDGE	V	V	14.0000	Item Master Core	5	F	Item Master-003-EDGE	5	SP	Item Master-003-EDGE	Item	I	14.0000	Y	Item	Item M	Item Master-003	N	I	Item M	Y	Y	E	Item Master-003-EDGE	I	BATCH_USER	14.0000	N	I	C	I	2026-01-05	I	14.0000	Y	14.0000000000	Y	Item	Item	Item Master-003-EDGE	A	I	14.0000	Item M	N	Item M	Y	100005	I	Item M	14.0000	Item Master-003-EDGE	I	I	I	I	Item M	2026-01-05	I	Item M	N	14.0000	I	Item M

Example values from field definitions

ITEMRPK: SAMPLE
ITEM_NUMBER_TYPER: SAMPLE
DEPT: 1
CLASS: 1
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
PREFIX: 1
STATUS: S
DESC_UP: SAMPLE
COMMENTS: SAMPLE
PACK_IND: S
SUBCLASS: 1
CREATE_ID: SAMPLE
FORMAT_ID: S
ITEM_DESC: SAMPLE
LONG_DESC: SAMPLE
PACK_TYPE: S
SALE_TYPE: SAMPLE
WASTE_PCT: 1.0000
BRAND_NAME: SAMPLE
ITEM_LEVEL: 1
ORDER_TYPE: SAMPLE
SHORT_DESC: SAMPLE
TRAN_LEVEL: 1
WASTE_TYPE: SAMPLE
ITEM_PARENT: SAMPLE
PACKAGE_UOM: SAMP
FORECAST_IND: S
PACKAGE_SIZE: 1.0000
SELLABLE_IND: S
STANDARD_UOM: SAMP
AIP_CASE_TYPE: SAMPLE
ALC_ITEM_TYPE: SAMPLE
CHECK_UDA_IND: S
GIFT_WRAP_IND: S
HANDLING_TEMP: SAMPLE
INVENTORY_IND: S
ORDERABLE_IND: S
ORDER_AS_TYPE: S
CONTAINER_ITEM: SAMPLE
ITEM_XFORM_IND: S
LAST_UPDATE_ID: SAMPLE
MFG_REC_RETAIL: 1.0000
PERISHABLE_IND: S
SHIP_ALONE_IND: S
STORE_ORD_MULT: S
CONST_DIMEN_IND: S
CREATE_DATETIME: 2026-01-01
MERCHANDISE_IND: S
ORIGINAL_RETAIL: 1.0000
SIMPLE_PACK_IND: S
UOM_CONV_FACTOR: 1.0000000000
CATCH_WEIGHT_IND: S
CATCH_WEIGHT_UOM: SAMP
CURR_SELLING_UOM: SAMP
ITEM_GRANDPARENT: SAMPLE
REINSTATE_STATUS: S
CATCH_WEIGHT_TYPE: S
DEFAULT_WASTE_PCT: 1.0000
DEPOSIT_ITEM_TYPE: SAMPLE
NOTIONAL_PACK_IND: S
RETAIL_LABEL_TYPE: SAMPLE
CONTAINS_INNER_IND: S
COST_ZONE_GROUP_ID: 1
ITEM_AGGREGATE_IND: S
ITEM_SERVICE_LEVEL: SAMPLE
RETAIL_LABEL_VALUE: 1.0000
ITEM_DESC_SECONDARY: SAMPLE
DIFF_1_AGGREGATE_IND: S
DIFF_2_AGGREGATE_IND: S
DIFF_3_AGGREGATE_IND: S
DIFF_4_AGGREGATE_IND: S
HANDLING_SENSITIVITY: SAMPLE
LAST_UPDATE_DATETIME: 2026-01-01
PRIMARY_REF_ITEM_IND: S
PRODUCT_CLASSIFICATION: SAMPLE
SOH_INQUIRY_AT_PACK_IND: S
CURR_SELLING_UNIT_RETAIL: 1.0000
DEPOSIT_IN_PRICE_PER_UOM: SAMPLE
TSF_ALLOC_UP_CHRG_SOURCE_TYPE: SAMPLE

default

ITEMRPK: Item Master-002-ALT
ITEM_NUMBER_TYPER: Item M
DEPT: 1003
CLASS: 1103
DIFF_1: Item Maste
DIFF_2: Item Maste
DIFF_3: Item Maste
DIFF_4: Item Maste
PREFIX: 3
STATUS: S
DESC_UP: Item Master-002-ALT
COMMENTS: Item Master-002-ALT
PACK_IND: I
SUBCLASS: 1113
CREATE_ID: C LIENT_INFO
FORMAT_ID: A
ITEM_DESC: Item Master-002-ALT
LONG_DESC: Item Master-002-ALT
PACK_TYPE: V
SALE_TYPE: V
WASTE_PCT: 12.5000
BRAND_NAME: Item Master Secondary
ITEM_LEVEL: 3
ORDER_TYPE: F
SHORT_DESC: Item Master-002-ALT
TRAN_LEVEL: 3
WASTE_TYPE: SP
ITEM_PARENT: Item Master-002-ALT
PACKAGE_UOM: Item
FORECAST_IND: I
PACKAGE_SIZE: 12.5000
SELLABLE_IND: N
STANDARD_UOM: Item
AIP_CASE_TYPE: Item M
ALC_ITEM_TYPE: Item Master-002
CHECK_UDA_IND: N
GIFT_WRAP_IND: I
HANDLING_TEMP: Item M
INVENTORY_IND: N
ORDERABLE_IND: N
ORDER_AS_TYPE: P
CONTAINER_ITEM: Item Master-002-ALT
ITEM_XFORM_IND: I
LAST_UPDATE_ID: MDM_USER
MFG_REC_RETAIL: 12.5000
PERISHABLE_IND: N
SHIP_ALONE_IND: I
STORE_ORD_MULT: C
CONST_DIMEN_IND: I
CREATE_DATETIME: 2026-01-03
MERCHANDISE_IND: I
ORIGINAL_RETAIL: 12.5000
SIMPLE_PACK_IND: N
UOM_CONV_FACTOR: 12.5000000000
CATCH_WEIGHT_IND: N
CATCH_WEIGHT_UOM: Item
CURR_SELLING_UOM: Item
ITEM_GRANDPARENT: Item Master-002-ALT
REINSTATE_STATUS: P
CATCH_WEIGHT_TYPE: I
DEFAULT_WASTE_PCT: 12.5000
DEPOSIT_ITEM_TYPE: Item M
NOTIONAL_PACK_IND: N
RETAIL_LABEL_TYPE: Item M
CONTAINS_INNER_IND: N
COST_ZONE_GROUP_ID: 100003
ITEM_AGGREGATE_IND: I
ITEM_SERVICE_LEVEL: Item M
RETAIL_LABEL_VALUE: 12.5000
ITEM_DESC_SECONDARY: Item Master-002-ALT
DIFF_1_AGGREGATE_IND: I
DIFF_2_AGGREGATE_IND: I
DIFF_3_AGGREGATE_IND: I
DIFF_4_AGGREGATE_IND: I
HANDLING_SENSITIVITY: Item M
LAST_UPDATE_DATETIME: 2026-01-03
PRIMARY_REF_ITEM_IND: I
PRODUCT_CLASSIFICATION: Item M
SOH_INQUIRY_AT_PACK_IND: N
CURR_SELLING_UNIT_RETAIL: 12.5000
DEPOSIT_IN_PRICE_PER_UOM: I
TSF_ALLOC_UP_CHRG_SOURCE_TYPE: Item M