| field name | data type | description |
|---|
| VatRule_ID | integer | |
| VatRuleBaseFull | character | |
| VatRuleSequence | integer | |
| VatRuleDescription | character | |
| VatRuleIsPosting | logical | |
| VatRuleRef1 | character | |
| VatRuleOperator | character | |
| VatRuleRef2 | character | |
| VatRuleValue | decimal(4) | |
| VatRuleUsage | character | |
| VatRuleRounding | character | |
| VatRuleMovementType | character | |
| VatRuleIsPassBaseValue | logical | |
| VatRuleIsDelayed | logical | |
| VatRuleDelayCorrection | integer | |
| Vat_ID | integer | |
| InvoiceGLProfile_ID | integer | |
| CreditNoteGLProfile_ID | integer | |
| InvoiceVatGroup_ID | integer | |
| CreditNoteVatGroup_ID | integer | |
| VoucherVatGroup_ID | integer | |
| CreditVoucherVatGroup_ID | integer | |
| AbsorbedInvoiceVatGroup_ID | integer | |
| AbsorbedCreditNVatGroup_ID | integer | |
| RetainVoucherVatGroup_ID | integer | |
| RetainCVoucherVatGroup_ID | integer | |
| DelayedGLProfile_ID | integer | |
| VatPercent_ID | integer | |
| tcVatPercentCode | character | |
| tcInvoiceVatGroupCode | character | ivgc |
| tcCreditNoteVatGroupCode | character | cnvgc |
| tcInvoiceGLProfileCode | character | |
| tcDelayedGLProfileCode | character | |
| tcPercentageFormula | character | |
| tdBaseCreditTC | decimal(4) | |
| tdBaseDebitTC | decimal(4) | |
| tcGLDescription | character | |
| tcGLCode | character | |
| tcVoucherVatGroupCode | character | |
| tdVATCreditTC | decimal(4) | |
| tcCreditVoucherVatGroupCode | character | |
| tdVATDebitTC | decimal(4) | |
| tcCreditNoteGLProfileCode | character | CreditNoteGLProfileCode |
| tcAbsorbedInvVatGroupCode | character | |
| tcRetainedCVoucherVatGroupCode | character | |
| tcRetainedVoucherVatGroup | character | |
| tcAbsorbedCreditNVatGroupCode | character | |
| CustomShort0 | character | |
| CustomShort1 | character | |
| CustomShort2 | character | |
| CustomShort3 | character | |
| CustomShort4 | character | |
| CustomShort5 | character | |
| CustomShort6 | character | |
| CustomShort7 | character | |
| CustomShort8 | character | |
| CustomShort9 | character | |
| CustomCombo0 | character | |
| CustomCombo1 | character | |
| CustomCombo2 | character | |
| CustomCombo3 | character | |
| CustomCombo4 | character | |
| CustomCombo5 | character | |
| CustomCombo6 | character | |
| CustomCombo7 | character | |
| CustomCombo8 | character | |
| CustomCombo9 | character | |
| CustomLong0 | character | |
| CustomLong1 | character | |
| CustomNote | character | |
| CustomDate0 | date | |
| CustomDate1 | date | |
| CustomDate2 | date | |
| CustomDate3 | date | |
| CustomDate4 | date | |
| CustomInteger0 | integer | |
| CustomInteger1 | integer | |
| CustomInteger2 | integer | |
| CustomInteger3 | integer | |
| CustomInteger4 | integer | |
| CustomDecimal0 | decimal(4) | |
| CustomDecimal1 | decimal(4) | |
| CustomDecimal2 | decimal(4) | |
| CustomDecimal3 | decimal(4) | |
| CustomDecimal4 | decimal(4) | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character | |
QadFinancials