Cost Component Upd Stg
In ScopeTechnical: COST_COMP_UPD_STG | ID: OR-ITM-COST_COMP_UPD_STG-COST_COMPONENT_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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- COST_COMP_UPD_STG
Field Definitions(41)
Rules & Considerations(54)
constraint
validation
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 1.0000 | 1.0000 | 2026-01-01 | S | S | S | S | S | S | S | S | S | SAMPLE | 1 | SAMPLE | SAM | 1 | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 | SAMPL | SAMPLE | 1 | 1 | 1.0000000000 | S | 1.0000 | 1.0000 | 1 | SAMPL | SAM | SAM | SAMP | SAM | SAMP | SAM |
Example values from field definitions
- SEQ_NORPK
- 1
- COMP_IDR
- SAMPLE
- COMP_TYPER
- S
- NEW_COMP_RATER
- 1.0000
- OLD_COMP_RATER
- 1.0000
- EFFECTIVE_DATER
- 2026-01-01
- DEFAULTING_LEVELR
- S
- DEPT_DEFAULT_INDR
- S
- ITEM_DEFAULT_INDR
- S
- PTNR_DEFAULT_INDR
- S
- SUPP_DEFAULT_INDR
- S
- CNTRY_DEFAULT_INDR
- S
- ORDER_DEFAULT_INDR
- S
- TSF_ALLOC_DEFAULT_INDR
- S
- PROF_UPD_BASED_ON_DEFAULT_INDR
- S
- HTS
- SAMPLE
- DEPT
- 1
- ITEM
- SAMPLE
- ACTION
- SAM
- TO_LOC
- 1
- ZONE_ID
- 1
- FROM_LOC
- 1
- SUPPLIER
- 1
- EFFECT_TO
- 2026-01-01
- EFFECT_FROM
- 2026-01-01
- LADING_PORT
- SAMPL
- EXPENSE_TYPE
- SAMPLE
- EXP_PROF_KEY
- 1
- ITEM_EXP_SEQ
- 1
- EXCHANGE_RATE
- 1.0000000000
- ITEM_EXP_TYPE
- S
- NEW_PER_COUNT
- 1.0000
- OLD_PER_COUNT
- 1.0000
- ZONE_GROUP_ID
- 1
- DISCHARGE_PORT
- SAMPL
- IMPORT_COUNTRY_ID
- SAM
- NEW_COMP_CURRENCY
- SAM
- NEW_PER_COUNT_UOM
- SAMP
- OLD_COMP_CURRENCY
- SAM
- OLD_PER_COUNT_UOM
- SAMP
- ORIGIN_COUNTRY_ID
- SAM
Rule Validation Summary
- Source Rule Count
- 82
- Governed Rule Count
- 54