| field name | data type | db field | description |
|---|
| tiAbsorbedCreditNVatGroup_ID | integer | VatRule.AbsorbedCreditNVatGroup_ID | Tax Group Code |
| tiAbsorbedInvoiceVatGroup_ID | integer | VatRule.AbsorbedInvoiceVatGroup_ID | Tax Group Code |
| tiCreditNoteGLProfile_ID | integer | VatRule.CreditNoteGLProfile_ID | CN GL Profile |
| tiCreditNoteVatGroup_ID | integer | VatRule.CreditNoteVatGroup_ID | Credit Note Tax Group |
| tiDelayedGLProfile_ID | integer | VatRule.DelayedGLProfile_ID | Delayed GL Profile |
| tiDomain_ID | integer | Vat.Domain_ID | Domain |
| tiInvoiceGLProfile_ID | integer | VatRule.InvoiceGLProfile_ID | Invoice GL Profile |
| tiInvoiceVatGroup_ID | integer | VatRule.InvoiceVatGroup_ID | Invoice Tax Group |
| tiRetainCVoucherVatGroup_ID | integer | VatRule.RetainCVoucherVatGroup_ID | Tax Group Code |
| tiRetainVoucherVatGroup_ID | integer | VatRule.RetainVoucherVatGroup_ID | Tax Group Code |
| tiVat_ID | integer | VatRule.Vat_ID | Link to Vat |
| tcVatCode | character | Vat.VatCode | Tax Code |
| tcVatInOut | character | Vat.VatInOut | Tax In/Out |
| tlVatIsAbsorbed | logical | Vat.VatIsAbsorbed | Absorbed |
| tlVatIsActive | logical | Vat.VatIsActive | Active |
| tlVatIsRetained | logical | Vat.VatIsRetained | Retained |
| tiVatRule_ID | integer | VatRule.VatRule_ID | Record ID |
| tcVatRuleBaseFull | character | VatRule.VatRuleBaseFull | Base/Full |
| tiVatRuleDelayCorrection | integer | VatRule.VatRuleDelayCorrection | Delay Correction |
| tcVatRuleDescription | character | VatRule.VatRuleDescription | Description |
| tlVatRuleIsDelayed | logical | VatRule.VatRuleIsDelayed | Delayed |
| tlVatRuleIsPassBaseValue | logical | VatRule.VatRuleIsPassBaseValue | Base Value |
| tlVatRuleIsPosting | logical | VatRule.VatRuleIsPosting | Posting |
| tiVatRuleSequence | integer | VatRule.VatRuleSequence | Sequence |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(VatRule),rowid(Vat) |
each VatRule where