Cost Comp Upd Stg
In ScopeTechnical: COST_COMP_UPD_STG | ID: OR-MFCS-COST_COMP_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
Target Structure
- Load Approach
- Table
- Target Objects
- COST_COMP_UPD_STG
Field Definitions(41)
Rules & Considerations(56)
Sample Load Data(4)
| _scenario | SEQ_NORPK | COMP_IDR | COMP_TYPER | NEW_COMP_RATER | OLD_COMP_RATER | EFFECTIVE_DATER | DEFAULTING_LEVELR | DEPT_DEFAULT_INDR | ITEM_DEFAULT_INDR | PTNR_DEFAULT_INDR | SUPP_DEFAULT_INDR | CNTRY_DEFAULT_INDR | ORDER_DEFAULT_INDR | TSF_ALLOC_DEFAULT_INDR | PROF_UPD_BASED_ON_DEFAULT_INDR | 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_PER_COUNT | OLD_PER_COUNT | ZONE_GROUP_ID | DISCHARGE_PORT | IMPORT_COUNTRY_ID | NEW_COMP_CURRENCY | NEW_PER_COUNT_UOM | OLD_COMP_CURRENCY | OLD_PER_COUNT_UOM | ORIGIN_COUNTRY_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2 | STD-COST_COMP-001 | Cost Comp Upd Stg-001 | 11.0000 | 11.0000 | 2026-01-01 | E | N | N | N | N | N | N | N | Y | Cost Comp Upd Stg-001 | 1001 | Cost Comp Upd Stg-001 | Cost Comp Upd Stg-001 | 1 | 1000000001 | 1 | 1 | 2026-01-06 | 2026-01-06 | Cost Comp Upd Stg-001 | Cost Comp Upd Stg-001 | 000001 | 000001 | 11.0000 | Cost Comp Upd Stg-001 | 11.0000 | 11.0000 | 100001 | Cost Comp Upd Stg-001 | STD-COST_COMP-001 | Cost Comp Upd Stg-001 | Cost Comp Upd Stg-001 | Cost Comp Upd Stg-001 | Cost Comp Upd Stg-001 | STD-COST_COMP-001 |
default
- SEQ_NORPK
- 2
- COMP_IDR
- STD-COST_COMP-001
- COMP_TYPER
- Cost Comp Upd Stg-001
- NEW_COMP_RATER
- 11.0000
- OLD_COMP_RATER
- 11.0000
- EFFECTIVE_DATER
- 2026-01-01
- DEFAULTING_LEVELR
- E
- DEPT_DEFAULT_INDR
- N
- ITEM_DEFAULT_INDR
- N
- PTNR_DEFAULT_INDR
- N
- SUPP_DEFAULT_INDR
- N
- CNTRY_DEFAULT_INDR
- N
- ORDER_DEFAULT_INDR
- N
- TSF_ALLOC_DEFAULT_INDR
- N
- PROF_UPD_BASED_ON_DEFAULT_INDR
- Y
- HTS
- Cost Comp Upd Stg-001
- DEPT
- 1001
- ITEM
- Cost Comp Upd Stg-001
- ACTION
- Cost Comp Upd Stg-001
- TO_LOC
- 1
- ZONE_ID
- 1000000001
- FROM_LOC
- 1
- SUPPLIER
- 1
- EFFECT_TO
- 2026-01-06
- EFFECT_FROM
- 2026-01-06
- LADING_PORT
- Cost Comp Upd Stg-001
- EXPENSE_TYPE
- Cost Comp Upd Stg-001
- EXP_PROF_KEY
- 000001
- ITEM_EXP_SEQ
- 000001
- EXCHANGE_RATE
- 11.0000
- ITEM_EXP_TYPE
- Cost Comp Upd Stg-001
- NEW_PER_COUNT
- 11.0000
- OLD_PER_COUNT
- 11.0000
- ZONE_GROUP_ID
- 100001
- DISCHARGE_PORT
- Cost Comp Upd Stg-001
- IMPORT_COUNTRY_ID
- STD-COST_COMP-001
- NEW_COMP_CURRENCY
- Cost Comp Upd Stg-001
- NEW_PER_COUNT_UOM
- Cost Comp Upd Stg-001
- OLD_COMP_CURRENCY
- Cost Comp Upd Stg-001
- OLD_PER_COUNT_UOM
- Cost Comp Upd Stg-001
- ORIGIN_COUNTRY_ID
- STD-COST_COMP-001