IM Match Group Cn (GTT)
Out of ScopeTechnical: IM_MATCH_GROUP_CN_GTT | ID: OR-IM-IM_MATCH_GROUP_CN_GTT-IM_MATCH_GROUP_CN_GTT
Temporary table to group CN and CNR groups for matching.
See how this object fits into Invoice Matching
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- gtt
Target Structure
- Load Approach
- Table
- Target Objects
- IM_MATCH_GROUP_CN_GTT
Field Definitions(5)
Rules & Considerations(20)
Sample Load Data(4)
| _scenario | ERROR_CODE | CN_GROUP_QTY | MATCH_STATUS | QTY_VARIANCE | TOLERANCE_ID | WORKSPACE_ID | CNR_GROUP_QTY | CN_GROUP_COST | COST_VARIANCE | ERROR_CONTEXT | CNR_GROUP_COST | MATCH_GROUP_ID | QTY_DISCREPANT | COST_DISCREPANT | MATCH_AVAILABLE | MATCH_CN_GROUP_ID | MATCH_CNR_GROUP_ID | QTY_MATCH_REQUIRED | TOLERANCE_CURRENCY_CODE | TOLERANCE_EXCHANGE_RATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1.0000 | SAMPLE | 1.0000 | 1 | 1 | 1.0000 | 1.0000 | 1.0000 | SAMPLE | 1.0000 | 1 | S | S | S | 1 | 1 | S | SAM | 1.0000000000 |
| default | ALT-IM_MATCH-002 | 12.5000 | PENDIN | 12.5000 | 1000000003 | 1000000003 | 12.5000 | 12.5000 | 12.5000 | IM Match Group Cn Gtt-002-ALT | 12.5000 | 1000000003 | I | I | I | 1000000003 | 1000000003 | I | ALT | 12.5000000000 |
| default | EDGE-IM_MATCH-003 | 14.0000 | ACTIVE | 14.0000 | 1000000005 | 1000000005 | 14.0000 | 14.0000 | 14.0000 | IM Match Group Cn Gtt-003-EDGE | 14.0000 | 1000000005 | I | I | I | 1000000005 | 1000000005 | I | EDG | 14.0000000000 |
Example values from field definitions
- ERROR_CODE
- SAMPLE
- CN_GROUP_QTY
- 1.0000
- MATCH_STATUS
- SAMPLE
- QTY_VARIANCE
- 1.0000
- TOLERANCE_ID
- 1
- WORKSPACE_ID
- 1
- CNR_GROUP_QTY
- 1.0000
- CN_GROUP_COST
- 1.0000
- COST_VARIANCE
- 1.0000
- ERROR_CONTEXT
- SAMPLE
- CNR_GROUP_COST
- 1.0000
- MATCH_GROUP_ID
- 1
- QTY_DISCREPANT
- S
- COST_DISCREPANT
- S
- MATCH_AVAILABLE
- S
- MATCH_CN_GROUP_ID
- 1
- MATCH_CNR_GROUP_ID
- 1
- QTY_MATCH_REQUIRED
- S
- TOLERANCE_CURRENCY_CODE
- SAM
- TOLERANCE_EXCHANGE_RATE
- 1.0000000000
default
- ERROR_CODE
- ALT-IM_MATCH-002
- CN_GROUP_QTY
- 12.5000
- MATCH_STATUS
- PENDIN
- QTY_VARIANCE
- 12.5000
- TOLERANCE_ID
- 1000000003
- WORKSPACE_ID
- 1000000003
- CNR_GROUP_QTY
- 12.5000
- CN_GROUP_COST
- 12.5000
- COST_VARIANCE
- 12.5000
- ERROR_CONTEXT
- IM Match Group Cn Gtt-002-ALT
- CNR_GROUP_COST
- 12.5000
- MATCH_GROUP_ID
- 1000000003
- QTY_DISCREPANT
- I
- COST_DISCREPANT
- I
- MATCH_AVAILABLE
- I
- MATCH_CN_GROUP_ID
- 1000000003
- MATCH_CNR_GROUP_ID
- 1000000003
- QTY_MATCH_REQUIRED
- I
- TOLERANCE_CURRENCY_CODE
- ALT
- TOLERANCE_EXCHANGE_RATE
- 12.5000000000
default
- ERROR_CODE
- EDGE-IM_MATCH-003
- CN_GROUP_QTY
- 14.0000
- MATCH_STATUS
- ACTIVE
- QTY_VARIANCE
- 14.0000
- TOLERANCE_ID
- 1000000005
- WORKSPACE_ID
- 1000000005
- CNR_GROUP_QTY
- 14.0000
- CN_GROUP_COST
- 14.0000
- COST_VARIANCE
- 14.0000
- ERROR_CONTEXT
- IM Match Group Cn Gtt-003-EDGE
- CNR_GROUP_COST
- 14.0000
- MATCH_GROUP_ID
- 1000000005
- QTY_DISCREPANT
- I
- COST_DISCREPANT
- I
- MATCH_AVAILABLE
- I
- MATCH_CN_GROUP_ID
- 1000000005
- MATCH_CNR_GROUP_ID
- 1000000005
- QTY_MATCH_REQUIRED
- I
- TOLERANCE_CURRENCY_CODE
- EDG
- TOLERANCE_EXCHANGE_RATE
- 14.0000000000
Rule Validation Summary
- Source Rule Count
- 26
- Governed Rule Count
- 20