Future Cost Workspace

In Scope

Technical: 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(5)

Rules & Considerations(53)

constraint

validation

Sample Load Data(4)

_scenario	ITEMR	LOCATIONR	SUPPLIERR	ORIGIN_COUNTRY_IDR	COST_EVENT_PROCESS_IDRPK	AREA	DEPT	CHAIN	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	REGION	DISTRICT	DIVISION	GROUP_NO	LOC_TYPE	NET_COST	SUBCLASS	BASE_COST	CALC_DATE	START_IND	ELC_AMOUNT	RECLASS_NO	ACTIVE_DATE	COST_CHANGE	ITEM_PARENT	NET_NET_COST	PRICING_COST	CURRENCY_CODE	SUPP_HIER_LVL_1	SUPP_HIER_LVL_2	SUPP_HIER_LVL_3	ACQUISITION_COST	ITEM_GRANDPARENT	DEAD_NET_NET_COST	PRIMARY_SUPP_COUNTRY_IND
Example values from field definitions	SAMPLE	1	1	SAM	1	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1	1	1	S	1.0000	1	1.0000	2026-01-01	S	1.0000	1	2026-01-01	1	SAMPLE	1.0000	1.0000	SAM	SAMPLE	SAMPLE	SAMPLE	1.0000	SAMPLE	1.0000	S
default	Future Cost Workspace-002	3	3	ALT	1000000003	103	1003	13	1103	Future Cos	Future Cos	Future Cos	Future Cos	203	303	103	4	F	12.5000	1113	12.5000	2026-01-03	F	12.5000	4	2026-01-03	3	Future Cost Workspace-002	12.5000	12.5000	ALT	Future Cos	Future Cos	Future Cos	12.5000	Future Cost Workspace-002	12.5000	N
default	Future Cost Workspace-003	5	5	EDG	1000000005	105	1005	15	1105	Future Cos	Future Cos	Future Cos	Future Cos	205	305	105	6	F	14.0000	1115	14.0000	2026-01-05	F	14.0000	6	2026-01-05	5	Future Cost Workspace-003	14.0000	14.0000	EDG	Future Cos	Future Cos	Future Cos	14.0000	Future Cost Workspace-003	14.0000	N

Example values from field definitions

ITEMR: SAMPLE
LOCATIONR: 1
SUPPLIERR: 1
ORIGIN_COUNTRY_IDR: SAM
COST_EVENT_PROCESS_IDRPK: 1
AREA: 1
DEPT: 1
CHAIN: 1
CLASS: 1
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
REGION: 1
DISTRICT: 1
DIVISION: 1
GROUP_NO: 1
LOC_TYPE: S
NET_COST: 1.0000
SUBCLASS: 1
BASE_COST: 1.0000
CALC_DATE: 2026-01-01
START_IND: S
ELC_AMOUNT: 1.0000
RECLASS_NO: 1
ACTIVE_DATE: 2026-01-01
COST_CHANGE: 1
ITEM_PARENT: SAMPLE
NET_NET_COST: 1.0000
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
DEAD_NET_NET_COST: 1.0000
PRIMARY_SUPP_COUNTRY_IND: S

default

ITEMR: Future Cost Workspace-002
LOCATIONR: 3
SUPPLIERR: 3
ORIGIN_COUNTRY_IDR: ALT
COST_EVENT_PROCESS_IDRPK: 1000000003
AREA: 103
DEPT: 1003
CHAIN: 13
CLASS: 1103
DIFF_1: Future Cos
DIFF_2: Future Cos
DIFF_3: Future Cos
DIFF_4: Future Cos
REGION: 203
DISTRICT: 303
DIVISION: 103
GROUP_NO: 4
LOC_TYPE: F
NET_COST: 12.5000
SUBCLASS: 1113
BASE_COST: 12.5000
CALC_DATE: 2026-01-03
START_IND: F
ELC_AMOUNT: 12.5000
RECLASS_NO: 4
ACTIVE_DATE: 2026-01-03
COST_CHANGE: 3
ITEM_PARENT: Future Cost Workspace-002
NET_NET_COST: 12.5000
PRICING_COST: 12.5000
CURRENCY_CODE: ALT
SUPP_HIER_LVL_1: Future Cos
SUPP_HIER_LVL_2: Future Cos
SUPP_HIER_LVL_3: Future Cos
ACQUISITION_COST: 12.5000
ITEM_GRANDPARENT: Future Cost Workspace-002
DEAD_NET_NET_COST: 12.5000
PRIMARY_SUPP_COUNTRY_IND: N