IM Document Tax

In Scope

Technical: IM_DOC_TAX | ID: OR-IM-IM_DOC_TAX-IM_DOCUMENT_TAX

Stores tax detail associated with IM doc tax 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_DOC_TAX

Field Definitions(5)

Rules & Considerations(19)

validation

constraint

Sample Load Data(4)

_scenario	DOC_IDRPK	TAX_CODERPK	TAX_AMOUNTR	TAX_RATE	TAX_BASIS	CREATED_BY	CREATION_DATE	TAX_CALC_TYPE	LAST_UPDATED_BY	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	1	SAMPLE	1.0000	1.0000000000	1.0000	SAMPLE	2026-01-01	S	SAMPLE	2026-01-01	1
default	1000000003	ALT-IM	12.5000	12.5000000000	12.5000	APP_USER_ID	2026-01-03	I	APP_USER_ID	2026-01-03	1000000003
default	1000000005	EDGE-I	14.0000	14.0000000000	14.0000	USERENV	2026-01-05	I	USERENV	2026-01-05	1000000005

Example values from field definitions

DOC_IDRPK: 1
TAX_CODERPK: SAMPLE
TAX_AMOUNTR: 1.0000
TAX_RATE: 1.0000000000
TAX_BASIS: 1.0000
CREATED_BY: SAMPLE
CREATION_DATE: 2026-01-01
TAX_CALC_TYPE: S
LAST_UPDATED_BY: SAMPLE
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

DOC_IDRPK: 1000000003
TAX_CODERPK: ALT-IM
TAX_AMOUNTR: 12.5000
TAX_RATE: 12.5000000000
TAX_BASIS: 12.5000
CREATED_BY: APP_USER_ID
CREATION_DATE: 2026-01-03
TAX_CALC_TYPE: I
LAST_UPDATED_BY: APP_USER_ID
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003