project QadFinancials > class BVAT > dataset BVAT

class dataset

object identification

primary key
Vat_ID
object identity
Vat_ID

table tVat


field namedata typemnd.description
Vat_IDintegeryesRecord ID
Domain_IDintegeryesDomain
VatCodecharacter(20)yesTax Code
VatDescriptioncharacter(40)yesDescription
VatInOutcharacter(20)yesTax In/Out
value list:{&VATINOUT-OUTPUTS}
VatTransactionTypecharacter(20)yesTransaction Type
value list:{&VATTRANSACTIONTYPES}
VatAVRTypecharacter(20)noAVR Code
VatIsActivelogicalyesActive
VatIsRetainedlogicalyesRetained
VatIsAbsorbedlogicalyesAbsorbed
VatPercentageLevelcharacter(20)yesTax Percentage Level
value list:{&VATPERCENTAGELEVELS}
VatIsGlobalTaxlogicalyesGlobal Tax
VatInvoiceTextcharacter(2000)noTax Text on Invoice
VatIsDelaylogicalnoDelay
TxuTaxUsagecharacter(8)noTax Usage
tcDomainCodecharacter(8)yesDomain
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tVatRule

Description

Tax Rule

field namedata typemnd.description
VatRule_IDintegeryesRecord ID
VatRuleBaseFullcharacter(20)yesBase/Full
value list:{&VATRULEBASES}
VatRuleSequenceintegeryesSequence
VatRuleDescriptioncharacter(40)noDescription
VatRuleIsPostinglogicalyesPosting
VatRuleRef1character(20)yesReference 1
value list:{&VATRULEREF-INITIAL-TR} + chr(2) + {&VATRULEREF-INITIAL} + chr(2) + {&VATRULEREF-DISCOUNT-TR} + chr(2) + {&VATRULEREF-DISCOUNT} + chr(2) + {&VATRULEREF-QUANTITY-TR} + chr(2) + {&VATRULEREF-QUANTITY} + chr(2) + "1":U + chr(2) + "1":U + chr(2) + "2":U + chr(2) + "2":U + chr(2) + "3":U + chr(2) + "3":U + chr(2) + "4":U + chr(2) + "4":U + chr(2) + "5":U + chr(2) + "5":U + chr(2) + "6":U + chr(2) + "6":U + chr(2) + "7":U + chr(2) + "7":U + chr(2) + "8":U + chr(2) + "8":U + chr(2) + "9":U + chr(2) + "9":U + chr(2) + "10":U + chr(2) + "10":U + chr(2) + "11":U + chr(2) + "11":U + chr(2) + "12":U + chr(2) + "12":U + chr(2) + "13":U + chr(2) + "13":U + chr(2) + "14":U + chr(2) + "14":U + chr(2) + "15":U + chr(2) + "15":U
VatRuleOperatorcharacter(1)yesOperator
value list:"+":U + chr(2) + "+":U + chr(2) + "-":U + chr(2) + "-":U + chr(2) + "*":U + chr(2) + "*":U + chr(2) + "/":U + chr(2) + "/":U + chr(2) + "=":U + chr(2) + "=":U
VatRuleRef2character(20)noReference 2
value list:"":U + chr(2) + "":U + chr(2) + {&VATRULEREF-NONE-TR} + chr(2) + {&VATRULEREF-NONE} + chr(2) + {&VATRULEREF-INITIAL-TR} + chr(2) + {&VATRULEREF-INITIAL} + chr(2) + {&VATRULEREF-DISCOUNT-TR} + chr(2) + {&VATRULEREF-DISCOUNT} + chr(2) + {&VATRULEREF-QUANTITY-TR} + chr(2) + {&VATRULEREF-QUANTITY} + chr(2) + "1":U + chr(2) + "1":U + chr(2) + "2":U + chr(2) + "2":U + chr(2) + "3":U + chr(2) + "3":U + chr(2) + "4":U + chr(2) + "4":U + chr(2) + "5":U + chr(2) + "5":U + chr(2) + "6":U + chr(2) + "6":U + chr(2) + "7":U + chr(2) + "7":U + chr(2) + "8":U + chr(2) + "8":U + chr(2) + "9":U + chr(2) + "9":U + chr(2) + "10":U + chr(2) + "10":U + chr(2) + "11":U + chr(2) + "11":U + chr(2) + "12":U + chr(2) + "12":U + chr(2) + "13":U + chr(2) + "13":U + chr(2) + "14":U + chr(2) + "14":U + chr(2) + "15":U + chr(2) + "15":U
VatRuleValuedecimal(4)noValue
VatRuleUsagecharacter(20)yesUsage
value list:{&VATRULEUSAGES}
VatRuleRoundingcharacter(20)yesRounding
value list:{&VATRULEROUNDINGS}
VatRuleMovementTypecharacter(20)noActivity Type
value list:"":U + chr(2) + "":U + chr(2) + {&VATRULEMOVS}
VatRuleIsPassBaseValuelogicalyesBase Value
VatRuleIsDelayedlogicalnoDelayed
VatRuleDelayCorrectionintegernoDelay Correction
Vat_IDintegeryesLink to Vat
InvoiceGLProfile_IDintegernoInvoice GL Profile
CreditNoteGLProfile_IDintegernoCN GL Profile
InvoiceVatGroup_IDintegernoInvoice Tax Group
CreditNoteVatGroup_IDintegernoCredit Note Tax Group
VoucherVatGroup_IDintegernoTax Group Code
CreditVoucherVatGroup_IDintegernoTax Group Code
AbsorbedInvoiceVatGroup_IDintegernoTax Group Code
AbsorbedCreditNVatGroup_IDintegernoTax Group Code
RetainVoucherVatGroup_IDintegernoTax Group Code
RetainCVoucherVatGroup_IDintegernoTax Group Code
DelayedGLProfile_IDintegernoDelayed GL Profile
VatPercent_IDintegernoTax Percentage
tcVatPercentCodecharacter(20)noTax Percentage
tcInvoiceVatGroupCodecharacter(20)noivgc
tcCreditNoteVatGroupCodecharacter(20)nocnvgc
tcInvoiceGLProfileCodecharacter(20)noInvoice GL Profile
tcDelayedGLProfileCodecharacter(20)noDelayed GL Profile
tcPercentageFormulacharacter(20)noPercentage Formula
tdBaseCreditTCdecimal(4)noBase
tdBaseDebitTCdecimal(4)noBase
tcGLDescriptioncharacternoGL Description
tcGLCodecharacternoGL Account
tcVoucherVatGroupCodecharacter(20)noTax Group Code
tdVATCreditTCdecimal(4)noTax
tcCreditVoucherVatGroupCodecharacter(20)noTax Group Code
tdVATDebitTCdecimal(4)noTax
tcCreditNoteGLProfileCodecharacter(20)noCreditNoteGLProfileCode
tcAbsorbedInvVatGroupCodecharacter(20)noTax Group Code
tcRetainedCVoucherVatGroupCodecharacter(20)noTax Group Code
tcRetainedVoucherVatGroupcharacter(20)noTax Group Code
tcAbsorbedCreditNVatGroupCodecharacter(20)noTax Group Code
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tVat.tc_Rowid
tc_Statuscharacternoupdate status

table tTransString

Description

Table for keeping translations of end-user data.
The application defines what columns can be translated, and the end-user maintains the translations itself.

field namedata typedescription
tiParentObject_IDinteger
tcLngCodecharacter
tcTranslationStringTextcharacter
tc_ParentRowidcharacter
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_Statuscharacter

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter