Svc Item Master

In Scope

Technical: SVC_ITEM_MASTER | ID: OR-MFCS-SVC_ITEM_MASTER

This is the staging table for Item Induction module. It is used to temporarily hold data before it is uploaded/updated in ITEM_MASTER.

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

Target Structure

Load Approach: Table
Target Objects: SVC_ITEM_MASTER

Field Definitions(83)

Rules & Considerations(26)

Sample Load Data(4)

_scenario	ROW_SEQR	CHUNK_IDR	PROCESS_IDRPK	DIFF_FINALIZED_INDR	DEPT	ITEM	CLASS	ACTION	DIFF_1	DIFF_2	DIFF_3	DIFF_4	PREFIX	STATUS	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	LAST_UPD_ID	NEXT_UPD_ID	ORIG_REF_NO	PACKAGE_UOM	FORECAST_IND	PACKAGE_SIZE	SELLABLE_IND	STANDARD_UOM	AIP_CASE_TYPE	GIFT_WRAP_IND	HANDLING_TEMP	INVENTORY_IND	ORDERABLE_IND	ORDER_AS_TYPE	CONTAINER_ITEM	ITEM_XFORM_IND	MFG_REC_RETAIL	PERISHABLE_IND	PROCESS$STATUS	SHIP_ALONE_IND	STORE_ORD_MULT	CONST_DIMEN_IND	CREATE_DATETIME	MERCHANDISE_IND	ORIGINAL_RETAIL	SIMPLE_PACK_IND	UOM_CONV_FACTOR	CATCH_WEIGHT_IND	ITEM_GRANDPARENT	ITEM_NUMBER_TYPE	PRE_RESERVED_IND	DEFAULT_WASTE_PCT	DEPOSIT_ITEM_TYPE	LAST_UPD_DATETIME	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	PRIMARY_REF_ITEM_IND	PRODUCT_CLASSIFICATION	SOH_INQUIRY_AT_PACK_IND	DEPOSIT_IN_PRICE_PER_UOM	TSF_ALLOC_UP_CHRG_SOURCE_TYPE
default	1	1000000001	1000000001	N	1001	Svc Item Master-001	1101	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	01	ACTIVE	Svc Item Master-001	Svc Item Master-001	1111	USERENV	STD-SVC_ITEM-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	11.0000	Svc Item Master Primary	1	Svc Item Master-001	Svc Item Master-001	1	Svc Item Master-001	Svc Item Master-001	USERENV	USERENV	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	11.0000	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	11.0000	Svc Item Master-001	N	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	2026-01-01	Svc Item Master-001	11.0000	Svc Item Master-001	11.0000	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	11.0000	Svc Item Master-001	2026-01-01	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	100001	Svc Item Master-001	Svc Item Master-001	11.0000	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001	Svc Item Master-001

default

ROW_SEQR: 1
CHUNK_IDR: 1000000001
PROCESS_IDRPK: 1000000001
DIFF_FINALIZED_INDR: N
DEPT: 1001
ITEM: Svc Item Master-001
CLASS: 1101
ACTION: Svc Item Master-001
DIFF_1: Svc Item Master-001
DIFF_2: Svc Item Master-001
DIFF_3: Svc Item Master-001
DIFF_4: Svc Item Master-001
PREFIX: 01
STATUS: ACTIVE
COMMENTS: Svc Item Master-001
PACK_IND: Svc Item Master-001
SUBCLASS: 1111
CREATE_ID: USERENV
FORMAT_ID: STD-SVC_ITEM-001
ITEM_DESC: Svc Item Master-001
LONG_DESC: Svc Item Master-001
PACK_TYPE: Svc Item Master-001
SALE_TYPE: Svc Item Master-001
WASTE_PCT: 11.0000
BRAND_NAME: Svc Item Master Primary
ITEM_LEVEL: 1
ORDER_TYPE: Svc Item Master-001
SHORT_DESC: Svc Item Master-001
TRAN_LEVEL: 1
WASTE_TYPE: Svc Item Master-001
ITEM_PARENT: Svc Item Master-001
LAST_UPD_ID: USERENV
NEXT_UPD_ID: USERENV
ORIG_REF_NO: Svc Item Master-001
PACKAGE_UOM: Svc Item Master-001
FORECAST_IND: Svc Item Master-001
PACKAGE_SIZE: 11.0000
SELLABLE_IND: Svc Item Master-001
STANDARD_UOM: Svc Item Master-001
AIP_CASE_TYPE: Svc Item Master-001
GIFT_WRAP_IND: Svc Item Master-001
HANDLING_TEMP: Svc Item Master-001
INVENTORY_IND: Svc Item Master-001
ORDERABLE_IND: Svc Item Master-001
ORDER_AS_TYPE: Svc Item Master-001
CONTAINER_ITEM: Svc Item Master-001
ITEM_XFORM_IND: Svc Item Master-001
MFG_REC_RETAIL: 11.0000
PERISHABLE_IND: Svc Item Master-001
PROCESS$STATUS: N
SHIP_ALONE_IND: Svc Item Master-001
STORE_ORD_MULT: Svc Item Master-001
CONST_DIMEN_IND: Svc Item Master-001
CREATE_DATETIME: 2026-01-01
MERCHANDISE_IND: Svc Item Master-001
ORIGINAL_RETAIL: 11.0000
SIMPLE_PACK_IND: Svc Item Master-001
UOM_CONV_FACTOR: 11.0000
CATCH_WEIGHT_IND: Svc Item Master-001
ITEM_GRANDPARENT: Svc Item Master-001
ITEM_NUMBER_TYPE: Svc Item Master-001
PRE_RESERVED_IND: Svc Item Master-001
DEFAULT_WASTE_PCT: 11.0000
DEPOSIT_ITEM_TYPE: Svc Item Master-001
LAST_UPD_DATETIME: 2026-01-01
NOTIONAL_PACK_IND: Svc Item Master-001
RETAIL_LABEL_TYPE: Svc Item Master-001
CONTAINS_INNER_IND: Svc Item Master-001
COST_ZONE_GROUP_ID: 100001
ITEM_AGGREGATE_IND: Svc Item Master-001
ITEM_SERVICE_LEVEL: Svc Item Master-001
RETAIL_LABEL_VALUE: 11.0000
ITEM_DESC_SECONDARY: Svc Item Master-001
DIFF_1_AGGREGATE_IND: Svc Item Master-001
DIFF_2_AGGREGATE_IND: Svc Item Master-001
DIFF_3_AGGREGATE_IND: Svc Item Master-001
DIFF_4_AGGREGATE_IND: Svc Item Master-001
HANDLING_SENSITIVITY: Svc Item Master-001
PRIMARY_REF_ITEM_IND: Svc Item Master-001
PRODUCT_CLASSIFICATION: Svc Item Master-001
SOH_INQUIRY_AT_PACK_IND: Svc Item Master-001
DEPOSIT_IN_PRICE_PER_UOM: Svc Item Master-001
TSF_ALLOC_UP_CHRG_SOURCE_TYPE: Svc Item Master-001

All objects