IM Invoice Detail Rev Tax
In ScopeTechnical: IM_INVOICE_DETAIL_REV_TAX | ID: OR-IM-IM_INVOICE_DETAIL_REV_TAX-IM_INVOICE_DETAIL_REV_TAX
Stores document detail taxes from the GTS Tax Engine where reverse_vat_ind in the engine is set to Y.
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_REV_TAX
Field Definitions(5)
Rules & Considerations(25)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMR | DOC_IDRPK | TAX_CODER | 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 Rev Tax | 1000000003 | ALT-IM | 12.5000000000 | 12.5000 | APP_USER_ID | 12.5000 | 2026-01-03 | P | APP_USER_ID | N | 2026-01-03 | 1000000003 |
| default | IM Invoice Detail Rev Tax | 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
- ITEMR
- SAMPLE
- DOC_IDRPK
- 1
- TAX_CODER
- 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
- ITEMR
- IM Invoice Detail Rev Tax
- DOC_IDRPK
- 1000000003
- TAX_CODER
- 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
- N
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
default
- ITEMR
- IM Invoice Detail Rev Tax
- DOC_IDRPK
- 1000000005
- TAX_CODER
- EDGE-I
- TAX_RATER
- 14.0000000000
- TAX_BASISR
- 14.0000
- CREATED_BY
- USERENV
- TAX_AMOUNT
- 14.0000
- CREATION_DATE
- 2026-01-05
- TAX_CALC_TYPE
- P
- LAST_UPDATED_BY
- USERENV
- REVERSE_VAT_IND
- N
- LAST_UPDATE_DATE
- 2026-01-05
- OBJECT_VERSION_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 39
- Governed Rule Count
- 25