Item Expense Detail Information
In ScopeTechnical: ITEM_EXP_DETAIL | ID: OR-PRC-ITEM_EXP_DETAIL-ITEM_EXPENSE_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_EXP_DETAIL
Field Definitions(24)
Rules & Considerations(47)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | COMP_IDRPK | CVB_CODERPK | 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_UOMRPK | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | PER_COUNT | KEY_VALUE_1 | KEY_VALUE_2 | DEFAULTED_FROM |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | SAMPLE | 1 | 1.0000 | SAMPLE | S | S | S | S | S | 1 | SAM | 1 | 1.0000000000 | S | SAMP | SAMPLE | 2026-01-01 | 2026-01-01 | 1.0000 | SAMPLE | SAMPLE | S |
Example values from field definitions
- ITEMRPK
- SAMPLE
- COMP_IDRPK
- SAMPLE
- CVB_CODERPK
- SAMPLE
- SUPPLIERR
- 1
- COMP_RATER
- 1.0000
- CREATE_IDR
- SAMPLE
- NOM_FLAG_1R
- S
- NOM_FLAG_2R
- S
- NOM_FLAG_3R
- S
- NOM_FLAG_4R
- S
- NOM_FLAG_5R
- S
- ITEM_EXP_SEQR
- 1
- COMP_CURRENCYRPK
- SAM
- DISPLAY_ORDERR
- 1
- EST_EXP_VALUER
- 1.0000000000
- ITEM_EXP_TYPER
- S
- PER_COUNT_UOMRPK
- SAMP
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- PER_COUNT
- 1.0000
- KEY_VALUE_1
- SAMPLE
- KEY_VALUE_2
- SAMPLE
- DEFAULTED_FROM
- S
Rule Validation Summary
- Source Rule Count
- 77
- Governed Rule Count
- 47