Staged Document Detail Taxes
In ScopeTechnical: IM_INJECT_DOC_DETAIL_TAX | ID: OR-IM-IM_INJECT_DOC_DETAIL_TAX-IM_INJECT_DOCUMENT_DETAIL_TAX
Stores staged document detail taxes.
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_INJECT_DOC_DETAIL_TAX
Field Definitions(5)
Rules & Considerations(22)
validation
constraint
Sample Load Data(4)
| _scenario | DETAIL_IDR | SEQ_ID | TAX_CODE | TAX_RATE | TAX_BASIS | CREATED_BY | TAX_AMOUNT | CREATION_DATE | TAX_CALC_TYPE | LAST_UPDATED_BY | REVERSE_VAT_IND | LAST_UPDATE_DATE | OBJECT_VERSION_ID | REF_OBJECT_VERSION_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | SAMPLE | 1.0000000000 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | S | SAMPLE | S | 2026-01-01 | 1 | 1 |
| default | 1000000003 | 1000000003 | ALT-IM | 12.5000000000 | 12.5000 | APP_USER_ID | 12.5000 | 2026-01-03 | P | APP_USER_ID | N | 2026-01-03 | 1000000003 | 1000000003 |
| default | 1000000005 | 1000000005 | EDGE-I | 14.0000000000 | 14.0000 | USERENV | 14.0000 | 2026-01-05 | P | USERENV | N | 2026-01-05 | 1000000005 | 1000000005 |
Example values from field definitions
- DETAIL_IDR
- 1
- SEQ_ID
- 1
- TAX_CODE
- SAMPLE
- TAX_RATE
- 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
- REF_OBJECT_VERSION_ID
- 1
default
- DETAIL_IDR
- 1000000003
- SEQ_ID
- 1000000003
- TAX_CODE
- ALT-IM
- TAX_RATE
- 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
- N
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
- REF_OBJECT_VERSION_ID
- 1000000003
default
- DETAIL_IDR
- 1000000005
- SEQ_ID
- 1000000005
- TAX_CODE
- EDGE-I
- TAX_RATE
- 14.0000000000
- TAX_BASIS
- 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
- REF_OBJECT_VERSION_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 22