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(10)
Rules & Considerations(17)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMR | SEQ_NOR | INVC_IDRPK | SHIPMENTRPK | INVC_UNIT_COSTR | 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 |
Example values from field definitions
- ITEMR
- SAMPLE
- SEQ_NOR
- 1
- INVC_IDRPK
- 1
- SHIPMENTRPK
- 1
- INVC_UNIT_COSTR
- 1.0000
- CARTON
- SAMPLE
- MATCH_TO_QTY
- 1.0000
- MATCH_TO_COST
- 1.0000
- INVC_MATCH_QTY
- 1.0000
- MATCH_TO_SEQ_NO
- 1
Rule Validation Summary
- Source Rule Count
- 23
- Governed Rule Count
- 17