Invc Match Worksheet
In ScopeTechnical: INVC_MATCH_WKSHT | ID: OR-ITM-INVC_MATCH_WKSHT-INVC_MATCH_WORKSHEET
This table will contain one row for each invoice/receipt/SKU combination in the system that matches or potentially matches.
See how this object fits into Item Management
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
- INVC_MATCH_WKSHT
Field Definitions(5)
Rules & Considerations(24)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | SEQ_NORPK | INVC_IDRPK | SHIPMENTRPK | INVC_UNIT_COSTRPK | CARTON | MATCH_TO_QTY | MATCH_TO_COST | INVC_MATCH_QTY | MATCH_TO_SEQ_NO |
|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | 1.0000 | SAMPLE | 1.0000 | 1.0000 | 1.0000 | 1 |
| default | Invc Match Wksht-002-ALT | 4 | 1000000003 | 3 | 12.5000 | Invc Match Wksht-002-ALT | 12.5000 | 12.5000 | 12.5000 | 4 |
| default | Invc Match Wksht-003-EDGE | 6 | 1000000005 | 5 | 14.0000 | Invc Match Wksht-003-EDGE | 14.0000 | 14.0000 | 14.0000 | 6 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- SEQ_NORPK
- 1
- INVC_IDRPK
- 1
- SHIPMENTRPK
- 1
- INVC_UNIT_COSTRPK
- 1.0000
- CARTON
- SAMPLE
- MATCH_TO_QTY
- 1.0000
- MATCH_TO_COST
- 1.0000
- INVC_MATCH_QTY
- 1.0000
- MATCH_TO_SEQ_NO
- 1
default
- ITEMRPK
- Invc Match Wksht-002-ALT
- SEQ_NORPK
- 4
- INVC_IDRPK
- 1000000003
- SHIPMENTRPK
- 3
- INVC_UNIT_COSTRPK
- 12.5000
- CARTON
- Invc Match Wksht-002-ALT
- MATCH_TO_QTY
- 12.5000
- MATCH_TO_COST
- 12.5000
- INVC_MATCH_QTY
- 12.5000
- MATCH_TO_SEQ_NO
- 4
default
- ITEMRPK
- Invc Match Wksht-003-EDGE
- SEQ_NORPK
- 6
- INVC_IDRPK
- 1000000005
- SHIPMENTRPK
- 5
- INVC_UNIT_COSTRPK
- 14.0000
- CARTON
- Invc Match Wksht-003-EDGE
- MATCH_TO_QTY
- 14.0000
- MATCH_TO_COST
- 14.0000
- INVC_MATCH_QTY
- 14.0000
- MATCH_TO_SEQ_NO
- 6
Rule Validation Summary
- Source Rule Count
- 30
- Governed Rule Count
- 24