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 | |