project QadFinancials > class BVAT > business logic query VATPrim

Description

Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.


Parameters


iiVatIdintegerVatId = primary key
icVatCodecharacterVatCode = logical key
iiDomainIdintegerdomain ID
icDomainCodecharacterdomain Code
icVatInOutcharacterVatInOut


query condition


  each Vat where
Vat.Vat_ID = iiVatId AND
Vat.VatCode = icVatCode AND
Vat.Domain_ID = iiDomainId AND
Vat.VatInOut = icVatInOut

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


query resultset tqVATPrim


field namedata typedb fielddescription
tiDomain_IDintegerVat.Domain_IDDomain
tcDomainCodecharacterDomains.DomainCodeDomain
tcVatDescriptioncharacterVat.VatDescriptionDescription
tcVatInOutcharacterVat.VatInOutTax In/Out
tcVatCodecharacterVat.VatCodeTax Code
tiVat_IDintegerVat.Vat_IDRecord ID


Internal usage


QadFinancials
method BAPMatching.CreateAPMatchingLNTaxFromGTM
method BAPMatching.GetPendingVouchersLogChargesTaxWHT
method BAPMatching.GetPendingVouchersNoLogChargesTaxFiscalWHT
method BAPMatching.GetPendingVouchersNoLogChargesTaxWHT
method BAPMatching.GetPendingVouchersPOShipperTaxWHT
method BCInvoice.CreateCInvoices
method BCInvoice.GetWHTDescriptionAndCCExch
method BCreditor.DataLoadByInput
method BCreditor.PreValidateComponent
method BDInvoice.CreateDInvoices
method BJournalEntry.AutoUpdatePostingVatVatGroups
method BVAT.ApiDeleteOfTaxRate
method BVAT.ApiStdMaintainTT
read related business field(s) on tAPMatchingLnTax.Vat_ID
read related business field(s) on tAPMatchingLnWHT.Vat_ID
read related business field(s) on tCInvoiceVat.Vat_ID
read related business field(s) on tCInvoiceWHT.Vat_ID
read related business field(s) on tCreditorVat.Vat_ID
read related business field(s) on tDInvoiceVat.Vat_ID
read related business field(s) on tPostingVat.Vat_ID
read related business field(s) on tPostingVatDelay.Vat_ID
read related business field(s) on tPostingWHT.Vat_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAPMatchingLnTax.Vat_ID
validate related business field(s) on tAPMatchingLnWHT.Vat_ID
validate related business field(s) on tCInvoiceVat.Vat_ID
validate related business field(s) on tCInvoiceWHT.Vat_ID
validate related business field(s) on tCreditorVat.Vat_ID
validate related business field(s) on tDInvoiceVat.Vat_ID
validate related business field(s) on tPostingVat.Vat_ID
validate related business field(s) on tPostingVatDelay.Vat_ID
validate related business field(s) on tPostingWHT.Vat_ID