IM Order Item Tax Audit

In Scope

Technical: IM_ORDER_ITEM_TAX_AUDIT | ID: OR-IM-IM_ORDER_ITEM_TAX_AUDIT-IM_ORDER_ITEM_TAX_AUDIT

Stores tax detail associated with IM order item tax audit in Oracle Retail Invoice Matching, such as tax codes, jurisdictions, rates, amounts, or tax-only adjustments. Used to support accurate calculation,...

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_ORDER_ITEM_TAX_AUDIT

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDR	ORDER_NOR	TAX_CODER	CREATED_BY	DOC_TAX_RATE	ORD_TAX_RATE	CREATION_DATE	DOC_TAX_AMOUNT	ORD_TAX_AMOUNT	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
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	1
default	IM Order Item Tax Audit-0	1000000003	4	ALT-IM	APP_USER_ID	12.5000000000	12.5000000000	2026-01-03	12.5000	12.5000	APP_USER_ID	2026-01-03	1000000003
default	IM Order Item Tax Audit-0	1000000005	6	EDGE-I	USERENV	14.0000000000	14.0000000000	2026-01-05	14.0000	14.0000	USERENV	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
DOC_IDR: 1
ORDER_NOR: 1
TAX_CODER: SAMPLE
CREATED_BY: SAMPLE
DOC_TAX_RATE: 1.0000000000
ORD_TAX_RATE: 1.0000000000
CREATION_DATE: 2026-01-01
DOC_TAX_AMOUNT: 1.0000
ORD_TAX_AMOUNT: 1.0000
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMR: IM Order Item Tax Audit-0
DOC_IDR: 1000000003
ORDER_NOR: 4
TAX_CODER: ALT-IM
CREATED_BY: APP_USER_ID
DOC_TAX_RATE: 12.5000000000
ORD_TAX_RATE: 12.5000000000
CREATION_DATE: 2026-01-03
DOC_TAX_AMOUNT: 12.5000
ORD_TAX_AMOUNT: 12.5000
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003