Ordloc Invc Cost
In ScopeTechnical: ORDLOC_INVC_COST | ID: OR-PUR-ORDLOC_INVC_COST-ORDLOC_INVC_COST
This table will hold the actual (to be invoiced) costs of items on a PO. It will also hold invoice matching information, identifying which cost and quantity of each order...
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
- ORDLOC_INVC_COST
Field Definitions(5)
Rules & Considerations(20)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | SEQ_NORPK | LOCATIONRPK | ORDER_NORPK | UNIT_COSTRPK | QTY | CARTON | SHIPMENT | MATCH_INVC_ID |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 1.0000 | 1.0000 | SAMPLE | 1 | 1 |
| default | Ordloc Invc Cost-002-ALT | 4 | 3 | 4 | 12.5000 | 12.5000 | Ordloc Invc Cost-002-ALT | 3 | 1000000003 |
| default | Ordloc Invc Cost-003-EDGE | 6 | 5 | 6 | 14.0000 | 14.0000 | Ordloc Invc Cost-003-EDGE | 5 | 1000000005 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SEQ_NORPK
- 1
- LOCATIONRPK
- 1
- ORDER_NORPK
- 1
- UNIT_COSTRPK
- 1.0000
- QTY
- 1.0000
- CARTON
- SAMPLE
- SHIPMENT
- 1
- MATCH_INVC_ID
- 1
default
- ITEMRPK
- Ordloc Invc Cost-002-ALT
- SEQ_NORPK
- 4
- LOCATIONRPK
- 3
- ORDER_NORPK
- 4
- UNIT_COSTRPK
- 12.5000
- QTY
- 12.5000
- CARTON
- Ordloc Invc Cost-002-ALT
- SHIPMENT
- 3
- MATCH_INVC_ID
- 1000000003
default
- ITEMRPK
- Ordloc Invc Cost-003-EDGE
- SEQ_NORPK
- 6
- LOCATIONRPK
- 5
- ORDER_NORPK
- 6
- UNIT_COSTRPK
- 14.0000
- QTY
- 14.0000
- CARTON
- Ordloc Invc Cost-003-EDGE
- SHIPMENT
- 5
- MATCH_INVC_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 20