Future Cost

In Scope

Technical: FUTURE_COST | ID: OR-CST-FUTURE_COST-FUTURE_COST

Stores estimated costs of items on future dates. Applicable deals, pending price changes, and pending reclassifications are considered when calculating the future costs.

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

Field Definitions(5)

Rules & Considerations(69)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	LOCATIONRPK	SUPPLIERRPK	ORIGIN_COUNTRY_IDRPK	AREA	DEPT	CHAIN	CLASS	DIFF_1	DIFF_2	DIFF_3	DIFF_4	REGION	ELC_AMT	WAC_TAX	DISTRICT	DIVISION	GROUP_NO	LOC_TYPE	NET_COST	SUBCLASS	TEMPL_ID	BASE_COST	CALC_DATE	START_IND	RECLASS_NO	STORE_TYPE	ACTIVE_DATE	COSTING_LOC	COST_CHANGE	ITEM_PARENT	NET_NET_COST	PASSTHRU_PCT	PRICING_COST	CURRENCY_CODE	SIMPLE_PACK_IND	SUPP_HIER_LVL_1	SUPP_HIER_LVL_2	SUPP_HIER_LVL_3	ACQUISITION_COST	ITEM_GRANDPARENT	DEAD_NET_NET_COST	PRIMARY_COST_PACK	EXTENDED_BASE_COST	OWNERSHIP_CHANGE_ID	DEFAULT_COSTING_TYPE	NEGOTIATED_ITEM_COST	PRIMARY_COST_PACK_QTY	PRIMARY_SUPP_COUNTRY_IND
Example values from field definitions	SAMPLE	1	1	SAM	1	1	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	1.0000	1.0000	1	1	1	S	1.0000	1	1	1.0000	2026-01-01	S	1	S	2026-01-01	1	1	SAMPLE	1.0000	1.0000	1.0000	SAM	S	SAMPLE	SAMPLE	SAMPLE	1.0000	SAMPLE	1.0000	SAMPLE	1.0000	1	SAMPLE	1.0000	1.0000	S
default	Future Cost-002-ALT	3	3	ALT	103	1003	13	1103	Future Cos	Future Cos	Future Cos	Future Cos	203	12.5000	12.5000	303	103	4	F	12.5000	1113	1000000003	12.5000	2026-01-03	F	4	C	2026-01-03	3	3	Future Cost-002-ALT	12.5000	12.5000	12.5000	ALT	N	Future Cos	Future Cos	Future Cos	12.5000	Future Cost-002-ALT	12.5000	Future Cost-002-ALT	12.5000	1000000003	NIC	12.5000	12.5000	N
default	Future Cost-003-EDGE	5	5	EDG	105	1005	15	1105	Future Cos	Future Cos	Future Cos	Future Cos	205	14.0000	14.0000	305	105	6	F	14.0000	1115	1000000005	14.0000	2026-01-05	F	6	F	2026-01-05	5	5	Future Cost-003-EDGE	14.0000	14.0000	14.0000	EDG	Y	Future Cos	Future Cos	Future Cos	14.0000	Future Cost-003-EDGE	14.0000	Future Cost-003-EDGE	14.0000	1000000005	BC	14.0000	14.0000	N

Example values from field definitions

ITEMRPK: SAMPLE
LOCATIONRPK: 1
SUPPLIERRPK: 1
ORIGIN_COUNTRY_IDRPK: SAM
AREA: 1
DEPT: 1
CHAIN: 1
CLASS: 1
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
REGION: 1
ELC_AMT: 1.0000
WAC_TAX: 1.0000
DISTRICT: 1
DIVISION: 1
GROUP_NO: 1
LOC_TYPE: S
NET_COST: 1.0000
SUBCLASS: 1
TEMPL_ID: 1
BASE_COST: 1.0000
CALC_DATE: 2026-01-01
START_IND: S
RECLASS_NO: 1
STORE_TYPE: S
ACTIVE_DATE: 2026-01-01
COSTING_LOC: 1
COST_CHANGE: 1
ITEM_PARENT: SAMPLE
NET_NET_COST: 1.0000
PASSTHRU_PCT: 1.0000
PRICING_COST: 1.0000
CURRENCY_CODE: SAM
SIMPLE_PACK_IND: S
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_COST_PACK: SAMPLE
EXTENDED_BASE_COST: 1.0000
OWNERSHIP_CHANGE_ID: 1
DEFAULT_COSTING_TYPE: SAMPLE
NEGOTIATED_ITEM_COST: 1.0000
PRIMARY_COST_PACK_QTY: 1.0000
PRIMARY_SUPP_COUNTRY_IND: S

default

ITEMRPK: Future Cost-002-ALT
LOCATIONRPK: 3
SUPPLIERRPK: 3
ORIGIN_COUNTRY_IDRPK: ALT
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
ELC_AMT: 12.5000
WAC_TAX: 12.5000
DISTRICT: 303
DIVISION: 103
GROUP_NO: 4
LOC_TYPE: F
NET_COST: 12.5000
SUBCLASS: 1113
TEMPL_ID: 1000000003
BASE_COST: 12.5000
CALC_DATE: 2026-01-03
START_IND: F
RECLASS_NO: 4
STORE_TYPE: C
ACTIVE_DATE: 2026-01-03
COSTING_LOC: 3
COST_CHANGE: 3
ITEM_PARENT: Future Cost-002-ALT
NET_NET_COST: 12.5000
PASSTHRU_PCT: 12.5000
PRICING_COST: 12.5000
CURRENCY_CODE: ALT
SIMPLE_PACK_IND: N
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-002-ALT
DEAD_NET_NET_COST: 12.5000
PRIMARY_COST_PACK: Future Cost-002-ALT
EXTENDED_BASE_COST: 12.5000
OWNERSHIP_CHANGE_ID: 1000000003
DEFAULT_COSTING_TYPE: NIC
NEGOTIATED_ITEM_COST: 12.5000
PRIMARY_COST_PACK_QTY: 12.5000
PRIMARY_SUPP_COUNTRY_IND: N