IM Item Tax Audit
In ScopeTechnical: 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(15)
Rules & Considerations(21)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | DOC_IDR | ORDER_NOR | CREATED_BYR | CREATION_DATER | LAST_UPDATED_BYR | LAST_UPDATE_DATER | OBJECT_VERSION_IDR | TAX_CODE | DOC_TAX_RATE | SYS_TAX_RATE | DOC_TAX_AMOUNT | SYS_TAX_AMOUNT | DOC_TAX_CALC_TYPE | SYS_TAX_CALC_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 1 | SAMPLE | 1.0000000000 | 1.0000000000 | 1.0000 | 1.0000 | S | S |
Example values from field definitions
- ITEMR
- SAMPLE
- DOC_IDR
- 1
- ORDER_NOR
- 1
- CREATED_BYR
- SAMPLE
- CREATION_DATER
- 2026-01-01
- LAST_UPDATED_BYR
- SAMPLE
- LAST_UPDATE_DATER
- 2026-01-01
- OBJECT_VERSION_IDR
- 1
- TAX_CODE
- SAMPLE
- DOC_TAX_RATE
- 1.0000000000
- SYS_TAX_RATE
- 1.0000000000
- DOC_TAX_AMOUNT
- 1.0000
- SYS_TAX_AMOUNT
- 1.0000
- DOC_TAX_CALC_TYPE
- S
- SYS_TAX_CALC_TYPE
- S
Rule Validation Summary
- Source Rule Count
- 45
- Governed Rule Count
- 21