IM Tax Discrepancy
In ScopeTechnical: IM_TAX_DISCREPANCY | ID: OR-IM-IM_TAX_DISCREPANCY-IM_TAX_DISCREPANCY
Stores tax detail associated with IM tax discrepancy in Oracle Retail Invoice Matching, such as tax codes, jurisdictions, rates, amounts, or tax-only adjustments. Used to support accurate calculation, matching, reporting,...
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
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- IM_TAX_DISCREPANCY
Field Definitions(5)
Rules & Considerations(28)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | DOC_IDR | ORDER_NOR | ID | TAX_CODE | CREATED_BY | DOC_TAX_RATE | CREATION_DATE | DOC_TAX_AMOUNT | VERIFY_TAX_SRC | LAST_UPDATED_BY | VERIFY_TAX_CODE | VERIFY_TAX_RATE | LAST_UPDATE_DATE | DOC_TAX_CALC_TYPE | OBJECT_VERSION_ID | VERIFY_TAX_AMOUNT | VERIFY_TAX_CALC_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | 1 | SAMPLE | SAMPLE | 1.0000000000 | 2026-01-01 | 1.0000 | SA | SAMPLE | SAMPLE | 1.0000000000 | 2026-01-01 | S | 1 | 1.0000 | S |
| default | IM Tax Discrepancy-002-AL | 1000000003 | 4 | 3 | ALT-IM | APP_USER_ID | 12.5000000000 | 2026-01-03 | 12.5000 | IM | APP_USER_ID | ALT-IM | 12.5000000000 | 2026-01-03 | I | 1000000003 | 12.5000 | I |
| default | IM Tax Discrepancy-003-ED | 1000000005 | 6 | 5 | EDGE-I | USERENV | 14.0000000000 | 2026-01-05 | 14.0000 | IM | USERENV | EDGE-I | 14.0000000000 | 2026-01-05 | I | 1000000005 | 14.0000 | I |
Example values from field definitions
- ITEMR
- SAMPLE
- DOC_IDR
- 1
- ORDER_NOR
- 1
- ID
- 1
- TAX_CODE
- SAMPLE
- CREATED_BY
- SAMPLE
- DOC_TAX_RATE
- 1.0000000000
- CREATION_DATE
- 2026-01-01
- DOC_TAX_AMOUNT
- 1.0000
- VERIFY_TAX_SRC
- SA
- LAST_UPDATED_BY
- SAMPLE
- VERIFY_TAX_CODE
- SAMPLE
- VERIFY_TAX_RATE
- 1.0000000000
- LAST_UPDATE_DATE
- 2026-01-01
- DOC_TAX_CALC_TYPE
- S
- OBJECT_VERSION_ID
- 1
- VERIFY_TAX_AMOUNT
- 1.0000
- VERIFY_TAX_CALC_TYPE
- S
default
- ITEMR
- IM Tax Discrepancy-002-AL
- DOC_IDR
- 1000000003
- ORDER_NOR
- 4
- ID
- 3
- TAX_CODE
- ALT-IM
- CREATED_BY
- APP_USER_ID
- DOC_TAX_RATE
- 12.5000000000
- CREATION_DATE
- 2026-01-03
- DOC_TAX_AMOUNT
- 12.5000
- VERIFY_TAX_SRC
- IM
- LAST_UPDATED_BY
- APP_USER_ID
- VERIFY_TAX_CODE
- ALT-IM
- VERIFY_TAX_RATE
- 12.5000000000
- LAST_UPDATE_DATE
- 2026-01-03
- DOC_TAX_CALC_TYPE
- I
- OBJECT_VERSION_ID
- 1000000003
- VERIFY_TAX_AMOUNT
- 12.5000
- VERIFY_TAX_CALC_TYPE
- I
default
- ITEMR
- IM Tax Discrepancy-003-ED
- DOC_IDR
- 1000000005
- ORDER_NOR
- 6
- ID
- 5
- TAX_CODE
- EDGE-I
- CREATED_BY
- USERENV
- DOC_TAX_RATE
- 14.0000000000
- CREATION_DATE
- 2026-01-05
- DOC_TAX_AMOUNT
- 14.0000
- VERIFY_TAX_SRC
- IM
- LAST_UPDATED_BY
- USERENV
- VERIFY_TAX_CODE
- EDGE-I
- VERIFY_TAX_RATE
- 14.0000000000
- LAST_UPDATE_DATE
- 2026-01-05
- DOC_TAX_CALC_TYPE
- I
- OBJECT_VERSION_ID
- 1000000005
- VERIFY_TAX_AMOUNT
- 14.0000
- VERIFY_TAX_CALC_TYPE
- I
Rule Validation Summary
- Source Rule Count
- 56
- Governed Rule Count
- 28