IM Invoice Detail Tax

In Scope

Technical: IM_INVOICE_DETAIL_TAX | ID: OR-IM-IM_INVOICE_DETAIL_TAX-IM_INVOICE_DETAIL_TAX

Stores tax detail associated with IM invoice detail tax 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_INVOICE_DETAIL_TAX

Field Definitions(5)

Rules & Considerations(28)

validation

constraint

Sample Load Data(4)

_scenario	ITEMRPK	DOC_IDRPK	TAX_CODERPK	TAX_RATER	TAX_BASISR	CREATED_BY	TAX_AMOUNT	CREATION_DATE	TAX_CALC_TYPE	LAST_UPDATED_BY	REVERSE_VAT_IND	LAST_UPDATE_DATE	OBJECT_VERSION_ID
Example values from field definitions	SAMPLE	1	SAMPLE	1.0000000000	1.0000	SAMPLE	1.0000	2026-01-01	S	SAMPLE	S	2026-01-01	1
default	IM Invoice Detail Tax-002	1000000003	ALT-IM	12.5000000000	12.5000	APP_USER_ID	12.5000	2026-01-03	P	APP_USER_ID	Y	2026-01-03	1000000003
default	IM Invoice Detail Tax-003	1000000005	EDGE-I	14.0000000000	14.0000	USERENV	14.0000	2026-01-05	P	USERENV	N	2026-01-05	1000000005

Example values from field definitions

ITEMRPK: SAMPLE
DOC_IDRPK: 1
TAX_CODERPK: SAMPLE
TAX_RATER: 1.0000000000
TAX_BASISR: 1.0000
CREATED_BY: SAMPLE
TAX_AMOUNT: 1.0000
CREATION_DATE: 2026-01-01
TAX_CALC_TYPE: S
LAST_UPDATED_BY: SAMPLE
REVERSE_VAT_IND: S
LAST_UPDATE_DATE: 2026-01-01
OBJECT_VERSION_ID: 1

default

ITEMRPK: IM Invoice Detail Tax-002
DOC_IDRPK: 1000000003
TAX_CODERPK: ALT-IM
TAX_RATER: 12.5000000000
TAX_BASISR: 12.5000
CREATED_BY: APP_USER_ID
TAX_AMOUNT: 12.5000
CREATION_DATE: 2026-01-03
TAX_CALC_TYPE: P
LAST_UPDATED_BY: APP_USER_ID
REVERSE_VAT_IND: Y
LAST_UPDATE_DATE: 2026-01-03
OBJECT_VERSION_ID: 1000000003