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 |
tcDomainCode | character | Domains.DomainCode | 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 | Vat.Vat_ID | Record ID |
tcVatAVRType | character | Vat.VatAVRType | AVR Code |
tcVatCode | character | Vat.VatCode | Tax Code |
tcVatDescription | character | Vat.VatDescription | Description |
tcVatInOut | character | Vat.VatInOut | Tax In/Out |
tlVatIsActive | logical | Vat.VatIsActive | Active |
tiVatPercent_ID | integer | VatRule.VatPercent_ID | Tax Percentage |
tcVatPercentageLevel | character | Vat.VatPercentageLevel | Tax Percentage Level |
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 |
tcVatRuleMovementType | character | VatRule.VatRuleMovementType | Activity Type |
tcVatRuleOperator | character | VatRule.VatRuleOperator | Operator |
tcVatRuleRef1 | character | VatRule.VatRuleRef1 | Reference 1 |
tcVatRuleRef2 | character | VatRule.VatRuleRef2 | Reference 2 |
tcVatRuleRounding | character | VatRule.VatRuleRounding | Rounding |
tiVatRuleSequence | integer | VatRule.VatRuleSequence | Sequence |
tcVatRuleUsage | character | VatRule.VatRuleUsage | Usage |
tdVatRuleValue | decimal | VatRule.VatRuleValue | Value |
tcVatTransactionType | character | Vat.VatTransactionType | Transaction Type |