Expense Profile Detail Information

In Scope

Technical: EXP_PROF_DETAIL | ID: OR-TRD-EXP_PROF_DETAIL-EXPENSE_PROF_DETAIL

Stores Expense Profile 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 Trade 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: EXP_PROF_DETAIL

Field Definitions(5)

Rules & Considerations(31)

constraint

validation

Sample Load Data(4)

_scenario	COMP_IDRPK	COMP_RATER	EXP_PROF_KEYRPK	COMP_CURRENCYR	CVB_CODE	PER_COUNT	NOM_FLAG_1	NOM_FLAG_2	NOM_FLAG_3	NOM_FLAG_4	NOM_FLAG_5	PER_COUNT_UOM
Example values from field definitions	SAMPLE	1.0000	1	SAM	SAMPLE	1.0000	S	S	S	S	S	SAMP
default	ALT-EXP_PR	12.5000	3	Exp	ALT-EXP_PR	12.5000	E	E	E	E	E	Exp
default	EDGE-EXP_P	14.0000	5	Exp	EDGE-EXP_P	14.0000	E	E	E	E	E	Exp

Example values from field definitions

COMP_IDRPK: SAMPLE
COMP_RATER: 1.0000
EXP_PROF_KEYRPK: 1
COMP_CURRENCYR: SAM
CVB_CODE: SAMPLE
PER_COUNT: 1.0000
NOM_FLAG_1: S
NOM_FLAG_2: S
NOM_FLAG_3: S
NOM_FLAG_4: S
NOM_FLAG_5: S
PER_COUNT_UOM: SAMP

default

COMP_IDRPK: ALT-EXP_PR
COMP_RATER: 12.5000
EXP_PROF_KEYRPK: 3
COMP_CURRENCYR: Exp
CVB_CODE: ALT-EXP_PR
PER_COUNT: 12.5000
NOM_FLAG_1: E
NOM_FLAG_2: E
NOM_FLAG_3: E
NOM_FLAG_4: E
NOM_FLAG_5: E
PER_COUNT_UOM: Exp