IM Tax Discrepancy History

In Scope

Technical: IM_TAX_DISCREPANCY_HISTORY | ID: OR-IM-IM_TAX_DISCREPANCY_HISTORY-IM_TAX_DISCREPANCY_HISTORY

Stores historical records for IM tax discrepancy history in Oracle Retail Invoice Matching, preserving prior states, events, or transaction outcomes over time. Used for auditability, reporting, reconciliation, and traceability of...

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_HISTORY

Field Definitions(5)

Rules & Considerations(28)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDRPK	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 Histor	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 Histor	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_IDRPK: 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 Histor
DOC_IDRPK: 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