project QadFinancials > class BVAT > business logic query VatRuleByVatIDCode

Description

VatRuleByVatIDCode.


Parameters


icVatCodecharacterVatCode
iiVatIDintegerVatID
icVatRuleBaseFullcharacterVatRuleBaseFull
icVatInOutcharacterVat In/Out
icDomainCodecharacterdomain


query condition


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

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

      each VatRule (inner-join) where
VatRule.Vat_ID = Vat.Vat_ID AND
VatRule.VatRuleBaseFull = icVatRuleBaseFull


query sort order


Vat.Vat_ID (ascending)
VatRule.VatRuleSequence (ascending)


query resultset tqVatRuleByVatIDCode


field namedata typedb fielddescription
tiAbsorbedCreditNVatGroup_IDintegerVatRule.AbsorbedCreditNVatGroup_IDTax Group Code
tiAbsorbedInvoiceVatGroup_IDintegerVatRule.AbsorbedInvoiceVatGroup_IDTax Group Code
tiCreditNoteGLProfile_IDintegerVatRule.CreditNoteGLProfile_IDCN GL Profile
tiCreditNoteVatGroup_IDintegerVatRule.CreditNoteVatGroup_IDCredit Note Tax Group
tiDelayedGLProfile_IDintegerVatRule.DelayedGLProfile_IDDelayed GL Profile
tcDomainCodecharacterDomains.DomainCodeDomain
tiInvoiceGLProfile_IDintegerVatRule.InvoiceGLProfile_IDInvoice GL Profile
tiInvoiceVatGroup_IDintegerVatRule.InvoiceVatGroup_IDInvoice Tax Group
tiRetainCVoucherVatGroup_IDintegerVatRule.RetainCVoucherVatGroup_IDTax Group Code
tiRetainVoucherVatGroup_IDintegerVatRule.RetainVoucherVatGroup_IDTax Group Code
tiVat_IDintegerVat.Vat_IDRecord ID
tcVatAVRTypecharacterVat.VatAVRTypeAVR Code
tcVatCodecharacterVat.VatCodeTax Code
tcVatDescriptioncharacterVat.VatDescriptionDescription
tcVatInOutcharacterVat.VatInOutTax In/Out
tlVatIsActivelogicalVat.VatIsActiveActive
tiVatPercent_IDintegerVatRule.VatPercent_IDTax Percentage
tcVatPercentageLevelcharacterVat.VatPercentageLevelTax Percentage Level
tiVatRule_IDintegerVatRule.VatRule_IDRecord ID
tcVatRuleBaseFullcharacterVatRule.VatRuleBaseFullBase/Full
tiVatRuleDelayCorrectionintegerVatRule.VatRuleDelayCorrectionDelay Correction
tcVatRuleDescriptioncharacterVatRule.VatRuleDescriptionDescription
tlVatRuleIsDelayedlogicalVatRule.VatRuleIsDelayedDelayed
tlVatRuleIsPassBaseValuelogicalVatRule.VatRuleIsPassBaseValueBase Value
tlVatRuleIsPostinglogicalVatRule.VatRuleIsPostingPosting
tcVatRuleMovementTypecharacterVatRule.VatRuleMovementTypeActivity Type
tcVatRuleOperatorcharacterVatRule.VatRuleOperatorOperator
tcVatRuleRef1characterVatRule.VatRuleRef1Reference 1
tcVatRuleRef2characterVatRule.VatRuleRef2Reference 2
tcVatRuleRoundingcharacterVatRule.VatRuleRoundingRounding
tiVatRuleSequenceintegerVatRule.VatRuleSequenceSequence
tcVatRuleUsagecharacterVatRule.VatRuleUsageUsage
tdVatRuleValuedecimalVatRule.VatRuleValueValue
tcVatTransactionTypecharacterVat.VatTransactionTypeTransaction Type


Internal usage


QadFinancials
method BPosting.AddPostingLineTax
method BPosting.AddTaxPosting
method BPosting.AddTaxPostingDetail
method BPosting.AddTaxPostingPartTwo
method BPosting.ApiStdMaintainMultiTT
method BPosting.ApiStdMaintainTT
method BPosting.ApiStdMaintainTTSub1
method BPosting.DataLoadByInputVatRule
method BPosting.StdMaintainTT
method BPosting.StdMaintainTTSub1
method BPosting.ValidateComponentPreAssignVatGroup