IM Item Tax Audit

In Scope

Technical: IM_ITEM_TAX_AUDIT | ID: OR-IM-IM_ITEM_TAX_AUDIT-IM_ITEM_TAX_AUDIT

Stores tax detail associated with IM item tax audit in Oracle Retail Invoice Matching, such as tax codes, jurisdictions, rates, amounts, or tax-only adjustments. Used to support accurate calculation, 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: dictionary

Target Structure

Load Approach: Table
Target Objects: IM_ITEM_TAX_AUDIT

Field Definitions(5)

Rules & Considerations(21)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDR	ORDER_NOR	TAX_CODE	CREATED_BY	DOC_TAX_RATE	SYS_TAX_RATE	CREATION_DATE	DOC_TAX_AMOUNT	SYS_TAX_AMOUNT	LAST_UPDATED_BY	LAST_UPDATE_DATE	DOC_TAX_CALC_TYPE	OBJECT_VERSION_ID	SYS_TAX_CALC_TYPE
Example values from field definitions	SAMPLE	1	1	SAMPLE	SAMPLE	1.0000000000	1.0000000000	2026-01-01	1.0000	1.0000	SAMPLE	2026-01-01	S	1	S
default	IM Item Tax Audit-002-ALT	1000000003	4	ALT-IM	APP_USER_ID	12.5000000000	12.5000000000	2026-01-03	12.5000	12.5000	APP_USER_ID	2026-01-03	I	1000000003	I
default	IM Item Tax Audit-003-EDG	1000000005	6	EDGE-I	USERENV	14.0000000000	14.0000000000	2026-01-05	14.0000	14.0000	USERENV	2026-01-05	I	1000000005	I

Example values from field definitions

ITEMR: SAMPLE
DOC_IDR: 1
ORDER_NOR: 1
TAX_CODE: SAMPLE
CREATED_BY: SAMPLE
DOC_TAX_RATE: 1.0000000000
SYS_TAX_RATE: 1.0000000000
CREATION_DATE: 2026-01-01
DOC_TAX_AMOUNT: 1.0000
SYS_TAX_AMOUNT: 1.0000
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
DOC_TAX_CALC_TYPE: S
OBJECT_VERSION_ID: 1
SYS_TAX_CALC_TYPE: S

default

ITEMR: IM Item Tax Audit-002-ALT
DOC_IDR: 1000000003
ORDER_NOR: 4
TAX_CODE: ALT-IM
CREATED_BY: APP_USER_ID
DOC_TAX_RATE: 12.5000000000
SYS_TAX_RATE: 12.5000000000
CREATION_DATE: 2026-01-03
DOC_TAX_AMOUNT: 12.5000
SYS_TAX_AMOUNT: 12.5000
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
DOC_TAX_CALC_TYPE: I
OBJECT_VERSION_ID: 1000000003
SYS_TAX_CALC_TYPE: I