Contract Detail

In Scope

Technical: CONTRACT_DETAIL | ID: OR-PUR-CONTRACT_DETAIL-CONTRACT_DETAIL

This table will hold item-level contract information for contract type A and B. The cost details for these items will be held in 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_DETAIL

Field Definitions(5)

Rules & Considerations(27)

constraint

validation

Sample Load Data(4)

_scenario	SEQ_NORPK	CONTRACT_NORPK	ITEM	DIFF_1	DIFF_2	DIFF_3	DIFF_4	LOCATION	LOC_TYPE	REF_ITEM	READY_DATE	ITEM_PARENT	QTY_ORDERED	CUR_REPL_QTY	QTY_RECEIVED	QTY_CONTRACTED	ITEM_GRANDPARENT	ITEM_LEVEL_INDEX
Example values from field definitions	1	1	SAMPLE	SAMPLE	SAMPLE	SAMPLE	SAMPLE	1	S	SAMPLE	2026-01-01	SAMPLE	1.0000	1.0000	1.0000	1.0000	SAMPLE	1
default	4	4	Contract Detail-002-ALT	Contract D	Contract D	Contract D	Contract D	3	C	Contract Detail-002-ALT	2026-01-03	Contract Detail-002-ALT	12.5000	12.5000	12.5000	12.5000	Contract Detail-002-ALT	3
default	6	6	Contract Detail-003-EDGE	Contract D	Contract D	Contract D	Contract D	5	C	Contract Detail-003-EDGE	2026-01-05	Contract Detail-003-EDGE	14.0000	14.0000	14.0000	14.0000	Contract Detail-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
LOCATION: 1
LOC_TYPE: S
REF_ITEM: SAMPLE
READY_DATE: 2026-01-01
ITEM_PARENT: SAMPLE
QTY_ORDERED: 1.0000
CUR_REPL_QTY: 1.0000
QTY_RECEIVED: 1.0000
QTY_CONTRACTED: 1.0000
ITEM_GRANDPARENT: SAMPLE
ITEM_LEVEL_INDEX: 1

default

SEQ_NORPK: 4
CONTRACT_NORPK: 4
ITEM: Contract Detail-002-ALT
DIFF_1: Contract D
DIFF_2: Contract D
DIFF_3: Contract D
DIFF_4: Contract D
LOCATION: 3
LOC_TYPE: C
REF_ITEM: Contract Detail-002-ALT
READY_DATE: 2026-01-03
ITEM_PARENT: Contract Detail-002-ALT
QTY_ORDERED: 12.5000
CUR_REPL_QTY: 12.5000
QTY_RECEIVED: 12.5000
QTY_CONTRACTED: 12.5000
ITEM_GRANDPARENT: Contract Detail-002-ALT
ITEM_LEVEL_INDEX: 3