Staged Data For Complex Deal Taxes
In ScopeTechnical: IM_INJECT_COMPLEX_DEAL_TAX | ID: OR-IM-IM_INJECT_COMPLEX_DEAL_TAX-IM_INJECT_COMPLEX_DEAL_TAX
Stores staged data for complex deal 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_COMPLEX_DEAL_TAX
Field Definitions(5)
Rules & Considerations(26)
validation
constraint
Sample Load Data(4)
| _scenario | SEQ_NOR | TAX_CODER | TAX_RATER | ITEM | INJECT_ID | TAX_BASIS | CREATED_BY | TAX_AMOUNT | CREATION_DATE | INJECT_DOC_ID | 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 | SAMPLE | 1.0000000000 | SAMPLE | 1 | 1.0000 | SAMPLE | 1.0000 | 2026-01-01 | 1 | S | SAMPLE | S | 2026-01-01 | 1 | 1 |
| default | 4 | ALT-IM | 12.5000000000 | IM Inject Complex Deal Ta | 1000000003 | 12.5000 | IM Inject Complex Deal Tax-002-ALT | 12.5000 | 2026-01-03 | 1000000003 | P | 2026-01-02-ALT | N | 2026-01-03 | 1000000003 | 1000000003 |
| default | 6 | EDGE-I | 14.0000000000 | IM Inject Complex Deal Ta | 1000000005 | 14.0000 | IM Inject Complex Deal Tax-003-EDGE | 14.0000 | 2026-01-05 | 1000000005 | P | 2026-01-03-EDGE | Y | 2026-01-05 | 1000000005 | 1000000005 |
Example values from field definitions
- SEQ_NOR
- 1
- TAX_CODER
- SAMPLE
- TAX_RATER
- 1.0000000000
- ITEM
- SAMPLE
- INJECT_ID
- 1
- TAX_BASIS
- 1.0000
- CREATED_BY
- SAMPLE
- TAX_AMOUNT
- 1.0000
- CREATION_DATE
- 2026-01-01
- INJECT_DOC_ID
- 1
- 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
- SEQ_NOR
- 4
- TAX_CODER
- ALT-IM
- TAX_RATER
- 12.5000000000
- ITEM
- IM Inject Complex Deal Ta
- INJECT_ID
- 1000000003
- TAX_BASIS
- 12.5000
- CREATED_BY
- IM Inject Complex Deal Tax-002-ALT
- TAX_AMOUNT
- 12.5000
- CREATION_DATE
- 2026-01-03
- INJECT_DOC_ID
- 1000000003
- TAX_CALC_TYPE
- P
- LAST_UPDATED_BY
- 2026-01-02-ALT
- REVERSE_VAT_IND
- N
- LAST_UPDATE_DATE
- 2026-01-03
- OBJECT_VERSION_ID
- 1000000003
- REF_OBJECT_VERSION_ID
- 1000000003
default
- SEQ_NOR
- 6
- TAX_CODER
- EDGE-I
- TAX_RATER
- 14.0000000000
- ITEM
- IM Inject Complex Deal Ta
- INJECT_ID
- 1000000005
- TAX_BASIS
- 14.0000
- CREATED_BY
- IM Inject Complex Deal Tax-003-EDGE
- TAX_AMOUNT
- 14.0000
- CREATION_DATE
- 2026-01-05
- INJECT_DOC_ID
- 1000000005
- TAX_CALC_TYPE
- P
- LAST_UPDATED_BY
- 2026-01-03-EDGE
- REVERSE_VAT_IND
- Y
- 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
- 26
