One Row For Each Contract Placed

In Scope

Technical: CONTRACT_HEADER | ID: OR-PUR-CONTRACT_HEADER-CONTRACT_HEADER

Stores one row for each contract placed within Oracle Retail. A contract is defined as a legally binding agreement with a supplier to supply stated SKUs at a particular price.

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_HEADER

Field Definitions(5)

Rules & Considerations(54)

constraint

validation

Sample Load Data(4)

_scenario	DEPTR	TERMSR	SUPPLIERR	CONTRACT_NORPK	CONTRACT_TYPER	STATUS	END_DATE	EST_DUTY	CANCEL_ID	CREATE_ID	REVIEW_ID	COUNTRY_ID	START_DATE	TOTAL_COST	APPROVAL_ID	CANCEL_DATE	CREATE_DATE	DISTRIBUTOR	REVIEW_DATE	SHIP_METHOD	STATUS_DATE	COMMENT_DESC	EDI_SENT_IND	EST_EXPENSES	SUBMITTED_ID	APPROVAL_DATE	COMPLETE_DATE	CURRENCY_CODE	CUR_REPL_COST	ORDERABLE_IND	OUTSTAND_COST	SUBMITTED_DATE	EDI_CONTRACT_IND	IMPORT_COUNTRY_ID	LAST_ORDERED_DATE	CONTRACT_APPROVAL_IND
Example values from field definitions	1	SAMPLE	1	1	S	S	2026-01-01	1.0000	SAMPLE	SAMPLE	SAMPLE	SAM	2026-01-01	1.0000	SAMPLE	2026-01-01	2026-01-01	SAMPLE	2026-01-01	SA	2026-01-01	SAMPLE	S	1.0000	SAMPLE	2026-01-01	2026-01-01	SAM	1.0000	S	1.0000	2026-01-01	S	SAM	2026-01-01	S
default	1003	Contract Header	3	4	B	P	2026-01-03	12.5000	ALT-CONTRACT_H-002	MDM_USER	ALT-CONTRACT_H-002	ALT	2026-01-03	12.5000	ALT-CONTRACT_H-002	2026-01-03	2026-01-03	Contract H	2026-01-03	RD	2026-01-03	Contract Header-002-ALT	C	12.5000	ALT-CONTRACT_H-002	2026-01-03	2026-01-03	ALT	12.5000	C	12.5000	2026-01-03	N	US	2026-01-03	N
default	1005	Contract Header	5	6	C	A	2026-01-05	14.0000	EDGE-CONTRACT_H-003	BATCH_USER	EDGE-CONTRACT_H-003	EDG	2026-01-05	14.0000	EDGE-CONTRACT_H-003	2026-01-05	2026-01-05	Contract H	2026-01-05	SA	2026-01-05	Contract Header-003-EDGE	C	14.0000	EDGE-CONTRACT_H-003	2026-01-05	2026-01-05	EDG	14.0000	C	14.0000	2026-01-05	S	US	2026-01-05	Y

Example values from field definitions

DEPTR: 1
TERMSR: SAMPLE
SUPPLIERR: 1
CONTRACT_NORPK: 1
CONTRACT_TYPER: S
STATUS: S
END_DATE: 2026-01-01
EST_DUTY: 1.0000
CANCEL_ID: SAMPLE
CREATE_ID: SAMPLE
REVIEW_ID: SAMPLE
COUNTRY_ID: SAM
START_DATE: 2026-01-01
TOTAL_COST: 1.0000
APPROVAL_ID: SAMPLE
CANCEL_DATE: 2026-01-01
CREATE_DATE: 2026-01-01
DISTRIBUTOR: SAMPLE
REVIEW_DATE: 2026-01-01
SHIP_METHOD: SA
STATUS_DATE: 2026-01-01
COMMENT_DESC: SAMPLE
EDI_SENT_IND: S
EST_EXPENSES: 1.0000
SUBMITTED_ID: SAMPLE
APPROVAL_DATE: 2026-01-01
COMPLETE_DATE: 2026-01-01
CURRENCY_CODE: SAM
CUR_REPL_COST: 1.0000
ORDERABLE_IND: S
OUTSTAND_COST: 1.0000
SUBMITTED_DATE: 2026-01-01
EDI_CONTRACT_IND: S
IMPORT_COUNTRY_ID: SAM
LAST_ORDERED_DATE: 2026-01-01
CONTRACT_APPROVAL_IND: S

default

DEPTR: 1003
TERMSR: Contract Header
SUPPLIERR: 3
CONTRACT_NORPK: 4
CONTRACT_TYPER: B
STATUS: P
END_DATE: 2026-01-03
EST_DUTY: 12.5000
CANCEL_ID: ALT-CONTRACT_H-002
CREATE_ID: MDM_USER
REVIEW_ID: ALT-CONTRACT_H-002
COUNTRY_ID: ALT
START_DATE: 2026-01-03
TOTAL_COST: 12.5000
APPROVAL_ID: ALT-CONTRACT_H-002
CANCEL_DATE: 2026-01-03
CREATE_DATE: 2026-01-03
DISTRIBUTOR: Contract H
REVIEW_DATE: 2026-01-03
SHIP_METHOD: RD
STATUS_DATE: 2026-01-03
COMMENT_DESC: Contract Header-002-ALT
EDI_SENT_IND: C
EST_EXPENSES: 12.5000
SUBMITTED_ID: ALT-CONTRACT_H-002
APPROVAL_DATE: 2026-01-03
COMPLETE_DATE: 2026-01-03
CURRENCY_CODE: ALT
CUR_REPL_COST: 12.5000
ORDERABLE_IND: C
OUTSTAND_COST: 12.5000
SUBMITTED_DATE: 2026-01-03
EDI_CONTRACT_IND: N
IMPORT_COUNTRY_ID: US
LAST_ORDERED_DATE: 2026-01-03
CONTRACT_APPROVAL_IND: N