Contract Header
In ScopeTechnical: CONTRACT_HEADER | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- CONTRACT_HEADER
Field Definitions(36)
Rules & Considerations(103)
Sample Load Data(4)
| _scenario | DEPTRPK | TERMSRPK | STATUSR | END_DATER | SUPPLIERRPK | CREATE_IDR | COUNTRY_IDRPK | START_DATER | CONTRACT_NORPK | CREATE_DATER | STATUS_DATER | CONTRACT_TYPER | CURRENCY_CODERPK | ORDERABLE_INDR | EDI_CONTRACT_INDR | IMPORT_COUNTRY_IDR | CONTRACT_APPROVAL_INDR | EST_DUTY | CANCEL_ID | REVIEW_ID | TOTAL_COST | APPROVAL_ID | CANCEL_DATE | DISTRIBUTOR | REVIEW_DATE | SHIP_METHOD | COMMENT_DESC | EDI_SENT_IND | EST_EXPENSES | SUBMITTED_ID | APPROVAL_DATE | COMPLETE_DATE | CUR_REPL_COST | OUTSTAND_COST | SUBMITTED_DATE | LAST_ORDERED_DATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1001 | Contract Header-001 | ACTIVE | 2026-01-01 | 1 | MIG_USER | STD-CONTRACT_H-001 | 2026-01-01 | 000002 | 2026-01-01 | 2026-01-01 | A | STD-CONTRACT_H-001 | Contract Header-001 | Y | US | Y | 11.0000 | STD-CONTRACT_H-001 | STD-CONTRACT_H-001 | 11.0000 | STD-CONTRACT_H-001 | 2026-01-01 | Contract Header-001 | 2026-01-01 | AR | Contract Header-001 | Contract Header-001 | 11.0000 | STD-CONTRACT_H-001 | 2026-01-01 | 2026-01-01 | 11.0000 | 11.0000 | 2026-01-01 | 2026-01-01 |
default
- DEPTRPK
- 1001
- TERMSRPK
- Contract Header-001
- STATUSR
- ACTIVE
- END_DATER
- 2026-01-01
- SUPPLIERRPK
- 1
- CREATE_IDR
- MIG_USER
- COUNTRY_IDRPK
- STD-CONTRACT_H-001
- START_DATER
- 2026-01-01
- CONTRACT_NORPK
- 000002
- CREATE_DATER
- 2026-01-01
- STATUS_DATER
- 2026-01-01
- CONTRACT_TYPER
- A
- CURRENCY_CODERPK
- STD-CONTRACT_H-001
- ORDERABLE_INDR
- Contract Header-001
- EDI_CONTRACT_INDR
- Y
- IMPORT_COUNTRY_IDR
- US
- CONTRACT_APPROVAL_INDR
- Y
- EST_DUTY
- 11.0000
- CANCEL_ID
- STD-CONTRACT_H-001
- REVIEW_ID
- STD-CONTRACT_H-001
- TOTAL_COST
- 11.0000
- APPROVAL_ID
- STD-CONTRACT_H-001
- CANCEL_DATE
- 2026-01-01
- DISTRIBUTOR
- Contract Header-001
- REVIEW_DATE
- 2026-01-01
- SHIP_METHOD
- AR
- COMMENT_DESC
- Contract Header-001
- EDI_SENT_IND
- Contract Header-001
- EST_EXPENSES
- 11.0000
- SUBMITTED_ID
- STD-CONTRACT_H-001
- APPROVAL_DATE
- 2026-01-01
- COMPLETE_DATE
- 2026-01-01
- CUR_REPL_COST
- 11.0000
- OUTSTAND_COST
- 11.0000
- SUBMITTED_DATE
- 2026-01-01
- LAST_ORDERED_DATE
- 2026-01-01