Item Exp Detail

In Scope

Technical: ITEM_EXP_DETAIL | ID: OR-MFCS-ITEM_EXP_DETAIL

Stores Item Expense Detail information. This information indicates the expenses incurred when moving goods from a particular origin country/lading port to a discharge port in another country, or from a…

See how this object fits into Pricing & Promotions

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_EXP_DETAIL

Field Definitions(24)

Rules & Considerations(80)

Sample Load Data(4)

_scenario	ITEMRPK	COMP_IDRPK	CVB_CODEPK	SUPPLIERR	COMP_RATER	CREATE_IDR	NOM_FLAG_1R	NOM_FLAG_2R	NOM_FLAG_3R	NOM_FLAG_4R	NOM_FLAG_5R	ITEM_EXP_SEQR	COMP_CURRENCYRPK	DISPLAY_ORDERR	EST_EXP_VALUER	ITEM_EXP_TYPER	PER_COUNT_UOMPK	LAST_UPDATE_IDR	CREATE_DATETIMER	LAST_UPDATE_DATETIMER	PER_COUNT	KEY_VALUE_1	KEY_VALUE_2	DEFAULTED_FROM
default	Item Exp Detail-001	STD-ITEM_EXP-001	STD-ITEM_EXP-001	1	11.0000	USERENV	Item Exp Detail-001	used	Item Exp Detail-001	used	used	000001	Item Exp Detail-001	01	11.0000	Zone	Item Exp Detail-001	MIG_USER	2026-01-01	2026-01-01	11.0000	Item Exp Detail-001	Item Exp Detail-001	P

default

ITEMRPK: Item Exp Detail-001
COMP_IDRPK: STD-ITEM_EXP-001
CVB_CODEPK: STD-ITEM_EXP-001
SUPPLIERR: 1
COMP_RATER: 11.0000
CREATE_IDR: USERENV
NOM_FLAG_1R: Item Exp Detail-001
NOM_FLAG_2R: used
NOM_FLAG_3R: Item Exp Detail-001
NOM_FLAG_4R: used
NOM_FLAG_5R: used
ITEM_EXP_SEQR: 000001
COMP_CURRENCYRPK: Item Exp Detail-001
DISPLAY_ORDERR: 01
EST_EXP_VALUER: 11.0000
ITEM_EXP_TYPER: Zone
PER_COUNT_UOMPK: Item Exp Detail-001
LAST_UPDATE_IDR: MIG_USER
CREATE_DATETIMER: 2026-01-01
LAST_UPDATE_DATETIMER: 2026-01-01
PER_COUNT: 11.0000
KEY_VALUE_1: Item Exp Detail-001
KEY_VALUE_2: Item Exp Detail-001
DEFAULTED_FROM: P

All objects