project QadFinancials > class BVAT > business logic query VatForVatCodeTaxType

Description

VatForVatCodeTaxType: query that read the Vat record and the associated tx2_mstr record


Parameters


icVatCodecharacter
iiVatIDinteger
icVatInOutcharacter
icDomainCodecharacter
iiDomainIDinteger


query condition


  each Vat where
Vat.Vat_ID = iiVatID AND
Vat.VatInOut = icVatInOut AND
Vat.VatCode = icVatCode AND
Vat.Domain_ID = iiDomainID

      first Domains (inner-join) where
Domains.Domain_ID = Vat.Domain_ID AND
Domains.DomainCode = icDomainCode

      first tx2_mstr (conditional-join) where
tx2_mstr.tx2_tax_code = Vat.VatCode AND


query resultset tqVatForVatCodeTaxType


field namedata typedb fielddescription
tiDomain_IDintegerVat.Domain_IDDomain
tcDomainCodecharacterDomains.DomainCodeDomain
tctx2_domaincharactertx2_mstr.tx2_domainDomain
tctx2_tax_codecharactertx2_mstr.tx2_tax_codeTax Code
tdtx2_tax_pctdecimaltx2_mstr.tx2_tax_pctTax Rate
tctx2_tax_typecharactertx2_mstr.tx2_tax_typeTax Type
tctx2_tax_usagecharactertx2_mstr.tx2_tax_usageTax Usage
tiVat_IDintegerVat.Vat_IDRecord ID
tcVatCodecharacterVat.VatCodeTax Code
tcVatInOutcharacterVat.VatInOutTax In/Out
tlVatIsActivelogicalVat.VatIsActiveActive
tcVatTransactionTypecharacterVat.VatTransactionTypeTransaction Type


Internal usage


QadFinancials
method BWithholdingTax.ValidateComponentPost