Item Expense Header

In Scope

Technical: ITEM_EXP_HEAD | ID: OR-PRC-ITEM_EXP_HEAD-ITEM_EXPENSE_HEADER

This table will hold one record for each Expense. If the Item Expense Type is Country, the expense will be associated with a given Item/Supplier/Origin Country/Lading Port/Discharge Port.

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

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: ITEM_EXP_HEAD

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	SUPPLIERRPK	ITEM_EXP_SEQRPK	ITEM_EXP_TYPERPK	ZONE_ID	CREATE_ID	LADING_PORT	BASE_EXP_IND	ZONE_GROUP_ID	DISCHARGE_PORT	LAST_UPDATE_ID	CREATE_DATETIME	ORIGIN_COUNTRY_ID	LAST_UPDATE_DATETIME
Example values from field definitions	SAMPLE	1	1	S	1	SAMPLE	SAMPL	S	1	SAMPL	SAMPLE	2026-01-01	SAM	2026-01-01
default	Item Exp Head-002-ALT	3	3	C	1000000003	C LIENT_INFO	Item	N	100003	Item	MDM_USER	2026-01-03	ALT	2026-01-03
default	Item Exp Head-003-EDGE	5	5	Z	1000000005	USE RENV	Item	Y	100005	Item	BATCH_USER	2026-01-05	EDG	2026-01-05

Example values from field definitions

ITEMRPK: SAMPLE
SUPPLIERRPK: 1
ITEM_EXP_SEQRPK: 1
ITEM_EXP_TYPERPK: S
ZONE_ID: 1
CREATE_ID: SAMPLE
LADING_PORT: SAMPL
BASE_EXP_IND: S
ZONE_GROUP_ID: 1
DISCHARGE_PORT: SAMPL
LAST_UPDATE_ID: SAMPLE
CREATE_DATETIME: 2026-01-01
ORIGIN_COUNTRY_ID: SAM
LAST_UPDATE_DATETIME: 2026-01-01

default

ITEMRPK: Item Exp Head-002-ALT
SUPPLIERRPK: 3
ITEM_EXP_SEQRPK: 3
ITEM_EXP_TYPERPK: C
ZONE_ID: 1000000003
CREATE_ID: C LIENT_INFO
LADING_PORT: Item
BASE_EXP_IND: N
ZONE_GROUP_ID: 100003
DISCHARGE_PORT: Item
LAST_UPDATE_ID: MDM_USER
CREATE_DATETIME: 2026-01-03
ORIGIN_COUNTRY_ID: ALT
LAST_UPDATE_DATETIME: 2026-01-03