One Row For Each Contract Placed
In ScopeTechnical: 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(36)
Rules & Considerations(49)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | S | 2026-01-01 | 1 | SAMPLE | SAM | 2026-01-01 | 1 | 2026-01-01 | 2026-01-01 | S | SAM | S | S | SAM | S | 1.0000 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | SA | SAMPLE | S | 1.0000 | SAMPLE | 2026-01-01 | 2026-01-01 | 1.0000 | 1.0000 | 2026-01-01 | 2026-01-01 |
Example values from field definitions
- DEPTRPK
- 1
- TERMSRPK
- SAMPLE
- STATUSR
- S
- END_DATER
- 2026-01-01
- SUPPLIERRPK
- 1
- CREATE_IDR
- SAMPLE
- COUNTRY_IDRPK
- SAM
- START_DATER
- 2026-01-01
- CONTRACT_NORPK
- 1
- CREATE_DATER
- 2026-01-01
- STATUS_DATER
- 2026-01-01
- CONTRACT_TYPER
- S
- CURRENCY_CODERPK
- SAM
- ORDERABLE_INDR
- S
- EDI_CONTRACT_INDR
- S
- IMPORT_COUNTRY_IDR
- SAM
- CONTRACT_APPROVAL_INDR
- S
- EST_DUTY
- 1.0000
- CANCEL_ID
- SAMPLE
- REVIEW_ID
- SAMPLE
- TOTAL_COST
- 1.0000
- APPROVAL_ID
- SAMPLE
- CANCEL_DATE
- 2026-01-01
- DISTRIBUTOR
- SAMPLE
- REVIEW_DATE
- 2026-01-01
- SHIP_METHOD
- SA
- COMMENT_DESC
- SAMPLE
- EDI_SENT_IND
- S
- EST_EXPENSES
- 1.0000
- SUBMITTED_ID
- SAMPLE
- APPROVAL_DATE
- 2026-01-01
- COMPLETE_DATE
- 2026-01-01
- CUR_REPL_COST
- 1.0000
- OUTSTAND_COST
- 1.0000
- SUBMITTED_DATE
- 2026-01-01
- LAST_ORDERED_DATE
- 2026-01-01
Rule Validation Summary
- Source Rule Count
- 69
- Governed Rule Count
- 49