Cost Component Upd Stg

In Scope

Technical: COST_COMP_UPD_STG | ID: OR-ITM-COST_COMP_UPD_STG-COST_COMPONENT_UPD_STG

This is a new staging table that will hold cost component changes made on the expense, assessment and upcharge screens, that have to be defaulted to other entities.

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: COST_COMP_UPD_STG

Field Definitions(5)

Rules & Considerations(54)

constraint

validation

Sample Load Data(4)

_scenario	SEQ_NORPK	COMP_IDR	COMP_TYPER	DEFAULTING_LEVELR	HTS	DEPT	ITEM	ACTION	TO_LOC	ZONE_ID	FROM_LOC	SUPPLIER	EFFECT_TO	EFFECT_FROM	LADING_PORT	EXPENSE_TYPE	EXP_PROF_KEY	ITEM_EXP_SEQ	EXCHANGE_RATE	ITEM_EXP_TYPE	NEW_COMP_RATE	NEW_PER_COUNT	OLD_COMP_RATE	OLD_PER_COUNT	ZONE_GROUP_ID	DISCHARGE_PORT	EFFECTIVE_DATE	DEPT_DEFAULT_IND	ITEM_DEFAULT_IND	PTNR_DEFAULT_IND	SUPP_DEFAULT_IND	CNTRY_DEFAULT_IND	IMPORT_COUNTRY_ID	NEW_COMP_CURRENCY	NEW_PER_COUNT_UOM	OLD_COMP_CURRENCY	OLD_PER_COUNT_UOM	ORDER_DEFAULT_IND	ORIGIN_COUNTRY_ID	TSF_ALLOC_DEFAULT_IND	PROF_UPD_BASED_ON_DEFAULT_IND
Example values from field definitions	1	SAMPLE	S	S	SAMPLE	1	SAMPLE	SAM	1	1	1	1	2026-01-01	2026-01-01	SAMPL	SAMPLE	1	1	1.0000000000	S	1.0000	1.0000	1.0000	1.0000	1	SAMPL	2026-01-01	S	S	S	S	S	SAM	SAM	SAMP	SAM	SAMP	S	SAM	S	S
default	4	ALT-COST_C	C	C	Cost Comp Upd Stg-002-ALT	1003	Cost Comp Upd Stg-002-ALT	Cos	3	1000000003	3	3	2026-02-09	2026-02-09	Cost	Cost C	3	3	12.5000000000	C	12.5000	12.5000	12.5000	12.5000	100003	Cost	2026-01-03	N	N	N	N	N	ALT	Cos	Cost	Cos	Cost	N	ALT	N	N
default	6	EDGE-COST_	C	S	Cost Comp Upd Stg-003-EDG	1005	Cost Comp Upd Stg-003-EDG	Cos	5	1000000005	5	5	2026-03-12	2026-03-12	Cost	Cost C	5	5	14.0000000000	C	14.0000	14.0000	14.0000	14.0000	100005	Cost	2026-01-05	N	N	N	N	N	EDG	Cos	Cost	Cos	Cost	N	EDG	N	u

Example values from field definitions

SEQ_NORPK: 1
COMP_IDR: SAMPLE
COMP_TYPER: S
DEFAULTING_LEVELR: S
HTS: SAMPLE
DEPT: 1
ITEM: SAMPLE
ACTION: SAM
TO_LOC: 1
ZONE_ID: 1
FROM_LOC: 1
SUPPLIER: 1
EFFECT_TO: 2026-01-01
EFFECT_FROM: 2026-01-01
LADING_PORT: SAMPL
EXPENSE_TYPE: SAMPLE
EXP_PROF_KEY: 1
ITEM_EXP_SEQ: 1
EXCHANGE_RATE: 1.0000000000
ITEM_EXP_TYPE: S
NEW_COMP_RATE: 1.0000
NEW_PER_COUNT: 1.0000
OLD_COMP_RATE: 1.0000
OLD_PER_COUNT: 1.0000
ZONE_GROUP_ID: 1
DISCHARGE_PORT: SAMPL
EFFECTIVE_DATE: 2026-01-01
DEPT_DEFAULT_IND: S
ITEM_DEFAULT_IND: S
PTNR_DEFAULT_IND: S
SUPP_DEFAULT_IND: S
CNTRY_DEFAULT_IND: S
IMPORT_COUNTRY_ID: SAM
NEW_COMP_CURRENCY: SAM
NEW_PER_COUNT_UOM: SAMP
OLD_COMP_CURRENCY: SAM
OLD_PER_COUNT_UOM: SAMP
ORDER_DEFAULT_IND: S
ORIGIN_COUNTRY_ID: SAM
TSF_ALLOC_DEFAULT_IND: S
PROF_UPD_BASED_ON_DEFAULT_IND: S

default

SEQ_NORPK: 4
COMP_IDR: ALT-COST_C
COMP_TYPER: C
DEFAULTING_LEVELR: C
HTS: Cost Comp Upd Stg-002-ALT
DEPT: 1003
ITEM: Cost Comp Upd Stg-002-ALT
ACTION: Cos
TO_LOC: 3
ZONE_ID: 1000000003
FROM_LOC: 3
SUPPLIER: 3
EFFECT_TO: 2026-02-09
EFFECT_FROM: 2026-02-09
LADING_PORT: Cost
EXPENSE_TYPE: Cost C
EXP_PROF_KEY: 3
ITEM_EXP_SEQ: 3
EXCHANGE_RATE: 12.5000000000
ITEM_EXP_TYPE: C
NEW_COMP_RATE: 12.5000
NEW_PER_COUNT: 12.5000
OLD_COMP_RATE: 12.5000
OLD_PER_COUNT: 12.5000
ZONE_GROUP_ID: 100003
DISCHARGE_PORT: Cost
EFFECTIVE_DATE: 2026-01-03
DEPT_DEFAULT_IND: N
ITEM_DEFAULT_IND: N
PTNR_DEFAULT_IND: N
SUPP_DEFAULT_IND: N
CNTRY_DEFAULT_IND: N
IMPORT_COUNTRY_ID: ALT
NEW_COMP_CURRENCY: Cos
NEW_PER_COUNT_UOM: Cost
OLD_COMP_CURRENCY: Cos
OLD_PER_COUNT_UOM: Cost
ORDER_DEFAULT_IND: N
ORIGIN_COUNTRY_ID: ALT
TSF_ALLOC_DEFAULT_IND: N
PROF_UPD_BASED_ON_DEFAULT_IND: N