Contract Detail
In ScopeTechnical: 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(18)
Rules & Considerations(24)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | SEQ_NOR | CONTRACT_NORPK | QTY_CONTRACTEDR | ITEM_LEVEL_INDEXR | DIFF_1 | DIFF_2 | DIFF_3 | DIFF_4 | LOCATION | LOC_TYPE | REF_ITEM | READY_DATE | ITEM_PARENT | QTY_ORDERED | CUR_REPL_QTY | QTY_RECEIVED | ITEM_GRANDPARENT |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1.0000 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | S | SAMPLE | 2026-01-01 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | SAMPLE |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SEQ_NOR
- 1
- CONTRACT_NORPK
- 1
- QTY_CONTRACTEDR
- 1.0000
- ITEM_LEVEL_INDEXR
- 1
- 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
- ITEM_GRANDPARENT
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 32
- Governed Rule Count
- 24