Vat Code Rates
In ScopeTechnical: VAT_CODE_RATES | ID: OR-FND-VAT_CODE_RATES-VAT_CODE_RATES
This table will hold VAT rates and active dates for each VAT code in the system. Each VAT code can only have one rate active at a time.
See how this object fits into Foundation Data
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_CODE_RATES
Field Definitions(5)
Rules & Considerations(11)
constraint
validation
Sample Load Data(4)
| _scenario | VAT_CODERPK | VAT_RATER | CREATE_IDR | ACTIVE_DATERPK | CREATE_DATER |
|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1.0000000000 | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | ALT-VA | 12.5000000000 | MDM_USER | 2026-01-03 | 2026-01-03 |
| default | EDGE-V | 14.0000000000 | BATCH_USER | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- VAT_CODERPK
- SAMPLE
- VAT_RATER
- 1.0000000000
- CREATE_IDR
- SAMPLE
- ACTIVE_DATERPK
- 2026-01-01
- CREATE_DATER
- 2026-01-01
default
- VAT_CODERPK
- ALT-VA
- VAT_RATER
- 12.5000000000
- CREATE_IDR
- MDM_USER
- ACTIVE_DATERPK
- 2026-01-03
- CREATE_DATER
- 2026-01-03
default
- VAT_CODERPK
- EDGE-V
- VAT_RATER
- 14.0000000000
- CREATE_IDR
- BATCH_USER
- ACTIVE_DATERPK
- 2026-01-05
- CREATE_DATER
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 18
- Governed Rule Count
- 11