Contract Detail
In ScopeTechnical: CONTRACT_DETAIL | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- CONTRACT_DETAIL
Field Definitions(18)
Rules & Considerations(45)
Sample Load Data(4)
| _scenario | ITEMPK | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Contract Detail-001 | 0002 | 000002 | 11.0000 | 1 | Contract Detail-001 | Contract Detail-001 | Contract Detail-001 | Contract Detail-001 | 1 | Contract Detail-001 | Contract Detail-001 | 2026-01-01 | Contract Detail-001 | 11.0000 | 11.0000 | 11.0000 | Contract Detail-001 |
default
- ITEMPK
- Contract Detail-001
- SEQ_NOR
- 0002
- CONTRACT_NORPK
- 000002
- QTY_CONTRACTEDR
- 11.0000
- ITEM_LEVEL_INDEXR
- 1
- DIFF_1
- Contract Detail-001
- DIFF_2
- Contract Detail-001
- DIFF_3
- Contract Detail-001
- DIFF_4
- Contract Detail-001
- LOCATION
- 1
- LOC_TYPE
- Contract Detail-001
- REF_ITEM
- Contract Detail-001
- READY_DATE
- 2026-01-01
- ITEM_PARENT
- Contract Detail-001
- QTY_ORDERED
- 11.0000
- CUR_REPL_QTY
- 11.0000
- QTY_RECEIVED
- 11.0000
- ITEM_GRANDPARENT
- Contract Detail-001