Item Exp Head
In ScopeTechnical: ITEM_EXP_HEAD | ID: OR-MFCS-ITEM_EXP_HEAD
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
Target Structure
- Load Approach
- Table
- Target Objects
- ITEM_EXP_HEAD
Field Definitions(14)
Rules & Considerations(45)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Item Exp Head-001 | 1 | USERENV | Y | 000001 | Zone | Item Exp Head-001 | MIG_USER | 2026-01-01 | 2026-01-01 | 1000000001 | Item Exp Head-001 | 100001 | STD-ITEM_EXP-001 |
default
- ITEMRPK
- Item Exp Head-001
- SUPPLIERR
- 1
- CREATE_IDR
- USERENV
- BASE_EXP_INDR
- Y
- ITEM_EXP_SEQR
- 000001
- ITEM_EXP_TYPER
- Zone
- DISCHARGE_PORTR
- Item Exp Head-001
- LAST_UPDATE_IDR
- MIG_USER
- CREATE_DATETIMER
- 2026-01-01
- LAST_UPDATE_DATETIMER
- 2026-01-01
- ZONE_ID
- 1000000001
- LADING_PORT
- Item Exp Head-001
- ZONE_GROUP_ID
- 100001
- ORIGIN_COUNTRY_ID
- STD-ITEM_EXP-001