Contract Ordloc
In ScopeTechnical: CONTRACT_ORDLOC | ID: OR-PUR-CONTRACT_ORDLOC-CONTRACT_ORDLOC
This table is a temporary table used in the manual creation of orders against contracts on-line dialogue.
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_ORDLOC
Field Definitions(5)
Rules & Considerations(19)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONRPK | LOC_TYPER | CONTRACT_NORPK | CONTRACT_ORDHEAD_SEQRPK | ORDER_NO | QTY_ORDERED | UNIT_RETAIL |
|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | S | 1 | 1 | 1 | 1.0000 | 1.0000 |
| default | Contract Ordloc-002-ALT | 3 | C | 4 | 3 | 4 | 12.5000 | 12.5000 |
| default | Contract Ordloc-003-EDGE | 5 | C | 6 | 5 | 6 | 14.0000 | 14.0000 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LOCATIONRPK
- 1
- LOC_TYPER
- S
- CONTRACT_NORPK
- 1
- CONTRACT_ORDHEAD_SEQRPK
- 1
- ORDER_NO
- 1
- QTY_ORDERED
- 1.0000
- UNIT_RETAIL
- 1.0000
default
- ITEMRPK
- Contract Ordloc-002-ALT
- LOCATIONRPK
- 3
- LOC_TYPER
- C
- CONTRACT_NORPK
- 4
- CONTRACT_ORDHEAD_SEQRPK
- 3
- ORDER_NO
- 4
- QTY_ORDERED
- 12.5000
- UNIT_RETAIL
- 12.5000
default
- ITEMRPK
- Contract Ordloc-003-EDGE
- LOCATIONRPK
- 5
- LOC_TYPER
- C
- CONTRACT_NORPK
- 6
- CONTRACT_ORDHEAD_SEQRPK
- 5
- ORDER_NO
- 6
- QTY_ORDERED
- 14.0000
- UNIT_RETAIL
- 14.0000
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 19