Item Expense Header
In ScopeTechnical: 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(14)
Rules & Considerations(23)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | SUPPLIERR | CREATE_IDR | BASE_EXP_INDR | ITEM_EXP_SEQR | ITEM_EXP_TYPER | DISCHARGE_PORTR | LAST_UPDATE_IDR | CREATE_DATETIMER | LAST_UPDATE_DATETIMER | ZONE_ID | LADING_PORT | ZONE_GROUP_ID | ORIGIN_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | SAMPLE | S | 1 | S | SAMPL | SAMPLE | 2026-01-01 | 2026-01-01 | 1 | SAMPL | 1 | SAM |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SUPPLIERR
- 1
- CREATE_IDR
- SAMPLE
- BASE_EXP_INDR
- S
- ITEM_EXP_SEQR
- 1
- ITEM_EXP_TYPER
- S
- DISCHARGE_PORTR
- SAMPL
- LAST_UPDATE_IDR
- SAMPLE
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- ZONE_ID
- 1
- LADING_PORT
- SAMPL
- ZONE_GROUP_ID
- 1
- ORIGIN_COUNTRY_ID
- SAM
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 23