Contract Cost

In Scope

Technical: CONTRACT_COST | ID: OR-PUR-CONTRACT_COST-CONTRACT_COST

This table will hold contract cost information for parent items(for all contract types). Contract types C and D will only ever have records on the CONTRACT_COST table.

See how this object fits into Purchasing

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: CONTRACT_COST

Field Definitions(5)

Rules & Considerations(21)

constraint

validation

Sample Load Data(4)

_scenario	SEQ_NORPK	CONTRACT_NORPK	ITEM	DIFF_1	DIFF_2	DIFF_3	DIFF_4	UNIT_COST	ITEM_PARENT	ITEM_GRANDPARENT	ITEM_LEVEL_INDEX
Example values from field definitions	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1.0000	SAMPLE	SAMPLE	1
default	4	4	Contract Cost-002-ALT	Contract C	Contract C	Contract C	Contract C	12.5000	Contract Cost-002-ALT	Contract Cost-002-ALT	3
default	6	6	Contract Cost-003-EDGE	Contract C	Contract C	Contract C	Contract C	14.0000	Contract Cost-003-EDGE	Contract Cost-003-EDGE	5

Example values from field definitions

SEQ_NORPK: 1
CONTRACT_NORPK: 1
ITEM: SAMPLE
DIFF_1: SAMPLE
DIFF_2: SAMPLE
DIFF_3: SAMPLE
DIFF_4: SAMPLE
UNIT_COST: 1.0000
ITEM_PARENT: SAMPLE
ITEM_GRANDPARENT: SAMPLE
ITEM_LEVEL_INDEX: 1

default

SEQ_NORPK: 4
CONTRACT_NORPK: 4
ITEM: Contract Cost-002-ALT
DIFF_1: Contract C
DIFF_2: Contract C
DIFF_3: Contract C
DIFF_4: Contract C
UNIT_COST: 12.5000
ITEM_PARENT: Contract Cost-002-ALT
ITEM_GRANDPARENT: Contract Cost-002-ALT
ITEM_LEVEL_INDEX: 3