Vat Item
In ScopeTechnical: VAT_ITEM | ID: OR-ITM-VAT_ITEM-VAT_ITEM
This table will hold VAT information for Items. It will not be used for SYSTEM_OPTIONS.DEFAULT_TAX_TYPE 'GTS'.
See how this object fits into Item Management
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
- VAT_ITEM
Field Definitions(5)
Rules & Considerations(28)
constraint
validation
Sample Load Data(4)
| _scenario | ITEMRPK | VAT_CODER | VAT_TYPERPK | VAT_REGIONRPK | ACTIVE_DATERPK | VAT_RATE | CREATE_ID | CREATE_DATE | LAST_UPDATE_ID | CREATE_DATETIME | REVERSE_VAT_IND | LAST_UPDATE_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | S | 1 | 2026-01-01 | 1.0000000000 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | S | 2026-01-01 |
| default | Vat Item-002-ALT | ALT-VA | V | 203 | 2026-01-03 | 12.5000000000 | MDM_USER | 2026-01-03 | MDM_USER | 2026-01-03 | Y | 2026-01-03 |
| default | Vat Item-003-EDGE | EDGE-V | V | 205 | 2026-01-05 | 14.0000000000 | BATCH_USER | 2026-01-05 | BATCH_USER | 2026-01-05 | N | 2026-01-05 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- VAT_CODER
- SAMPLE
- VAT_TYPERPK
- S
- VAT_REGIONRPK
- 1
- ACTIVE_DATERPK
- 2026-01-01
- VAT_RATE
- 1.0000000000
- CREATE_ID
- SAMPLE
- CREATE_DATE
- 2026-01-01
- LAST_UPDATE_ID
- SAMPLE
- CREATE_DATETIME
- 2026-01-01
- REVERSE_VAT_IND
- S
- LAST_UPDATE_DATETIME
- 2026-01-01
default
- ITEMRPK
- Vat Item-002-ALT
- VAT_CODER
- ALT-VA
- VAT_TYPERPK
- V
- VAT_REGIONRPK
- 203
- ACTIVE_DATERPK
- 2026-01-03
- VAT_RATE
- 12.5000000000
- CREATE_ID
- MDM_USER
- CREATE_DATE
- 2026-01-03
- LAST_UPDATE_ID
- MDM_USER
- CREATE_DATETIME
- 2026-01-03
- REVERSE_VAT_IND
- Y
- LAST_UPDATE_DATETIME
- 2026-01-03
default
- ITEMRPK
- Vat Item-003-EDGE
- VAT_CODER
- EDGE-V
- VAT_TYPERPK
- V
- VAT_REGIONRPK
- 205
- ACTIVE_DATERPK
- 2026-01-05
- VAT_RATE
- 14.0000000000
- CREATE_ID
- BATCH_USER
- CREATE_DATE
- 2026-01-05
- LAST_UPDATE_ID
- BATCH_USER
- CREATE_DATETIME
- 2026-01-05
- REVERSE_VAT_IND
- N
- LAST_UPDATE_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 62
- Governed Rule Count
- 28