Future Cost Workspace
In ScopeTechnical: FUTURE_COST_WORKSPACE | ID: OR-CST-FUTURE_COST_WORKSPACE-FUTURE_COST_WORKSPACE
Stores estimated costs of items on future dates. It is used by the margin impact form for cost changes in RMS and serves as a worksheet that provides margin visibility…
See how this object fits into Cost
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
- FUTURE_COST_WORKSPACE
Field Definitions(38)
Rules & Considerations(53)
constraint
validation
Sample Load Data(4)
| _scenario | DEPTR | ITEMR | CLASSR | DIVISIONR | GROUP_NOR | LOCATIONR | NET_COSTR | SUBCLASSR | SUPPLIERR | BASE_COSTR | CALC_DATER | ACTIVE_DATER | NET_NET_COSTR | DEAD_NET_NET_COSTR | ORIGIN_COUNTRY_IDR | COST_EVENT_PROCESS_IDRPK | AREA | CHAIN | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | REGION | DISTRICT | LOC_TYPE | START_IND | ELC_AMOUNT | RECLASS_NO | COST_CHANGE | ITEM_PARENT | PRICING_COST | CURRENCY_CODE | SUPP_HIER_LVL_1 | SUPP_HIER_LVL_2 | SUPP_HIER_LVL_3 | ACQUISITION_COST | ITEM_GRANDPARENT | PRIMARY_SUPP_COUNTRY_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1 | 1 | 1.0000 | 1 | 1 | 1.0000 | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | SAM | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | S | S | 1.0000 | 1 | 1 | SAMPLE | 1.0000 | SAM | SAMPLE | SAMPLE | SAMPLE | 1.0000 | SAMPLE | S |
Example values from field definitions
- DEPTR
- 1
- ITEMR
- SAMPLE
- CLASSR
- 1
- DIVISIONR
- 1
- GROUP_NOR
- 1
- LOCATIONR
- 1
- NET_COSTR
- 1.0000
- SUBCLASSR
- 1
- SUPPLIERR
- 1
- BASE_COSTR
- 1.0000
- CALC_DATER
- 2026-01-01
- ACTIVE_DATER
- 2026-01-01
- NET_NET_COSTR
- 1.0000
- DEAD_NET_NET_COSTR
- 1.0000
- ORIGIN_COUNTRY_IDR
- SAM
- COST_EVENT_PROCESS_IDRPK
- 1
- AREA
- 1
- CHAIN
- 1
- DIFF_1
- SAMPLE
- DIFF_2
- SAMPLE
- DIFF_3
- SAMPLE
- DIFF_4
- SAMPLE
- REGION
- 1
- DISTRICT
- 1
- LOC_TYPE
- S
- START_IND
- S
- ELC_AMOUNT
- 1.0000
- RECLASS_NO
- 1
- COST_CHANGE
- 1
- ITEM_PARENT
- SAMPLE
- PRICING_COST
- 1.0000
- CURRENCY_CODE
- SAM
- SUPP_HIER_LVL_1
- SAMPLE
- SUPP_HIER_LVL_2
- SAMPLE
- SUPP_HIER_LVL_3
- SAMPLE
- ACQUISITION_COST
- 1.0000
- ITEM_GRANDPARENT
- SAMPLE
- PRIMARY_SUPP_COUNTRY_IND
- S
Rule Validation Summary
- Source Rule Count
- 65
- Governed Rule Count
- 53