IM Complex Deal Detail Tax

In Scope

Technical: IM_COMPLEX_DEAL_DETAIL_TAX | ID: OR-IM-IM_COMPLEX_DEAL_DETAIL_TAX-IM_COMPLEX_DEAL_DETAIL_TAX

Stores tax detail associated with IM complex deal detail tax 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_COMPLEX_DEAL_DETAIL_TAX

Field Definitions(5)

Rules & Considerations(29)

validation

constraint

Sample Load Data(4)

_scenario	ITEMR	DOC_IDRPK	SEQ_NOR	TAX_CODER	TAX_RATER	TAX_BASIS	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	1	SAMPLE	1.0000000000	1.0000	SAMPLE	1.0000	2026-01-01	S	SAMPLE	S	2026-01-01	1
default	IM Complex Deal Detail Ta	1000000003	4	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 Complex Deal Detail Ta	1000000005	6	EDGE-I	14.0000000000	14.0000	USERENV	14.0000	2026-01-05	P	USERENV	N	2026-01-05	1000000005

Example values from field definitions

ITEMR: SAMPLE
DOC_IDRPK: 1
SEQ_NOR: 1
TAX_CODER: SAMPLE
TAX_RATER: 1.0000000000
TAX_BASIS: 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

ITEMR: IM Complex Deal Detail Ta
DOC_IDRPK: 1000000003
SEQ_NOR: 4
TAX_CODER: ALT-IM
TAX_RATER: 12.5000000000
TAX_BASIS: 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