project QadFinancials > class BMfgTaxType > business logic query MfgTaxTypeByTaxTypeV01

Description

Query to fetch description of the Tax Type using Tax Type Code.


Parameters


icTaxTypeCodecharacterCode for Tax Type
ilTaxTypeIsWHTlogicalIs the tax type a withholding tax type


query condition


  each txty_mstr where
txty_mstr.txty_tax_type = icTaxTypeCode AND
txty_mstr.txty_wt_type = ilTaxTypeIsWHT

      first lbl_mstr (outer-join) where
lbl_mstr.lbl_term = txty_mstr.txty_tax_desc AND
lbl_mstr.lbl_lang = current-language


query resultset tqMfgTaxTypeByTaxTypeV01


field namedata typedb fielddescription
tclbl_langcharacterlbl_mstr.lbl_langLanguage
tclbl_longcharacterlbl_mstr.lbl_longLong Label
tctxty_tax_desccharactertxty_mstr.txty_tax_descDescription
tctxty_tax_typecharactertxty_mstr.txty_tax_typeCode
tltxty_wt_typelogicaltxty_mstr.txty_wt_typeWithholding Tax Type


Internal usage


QadFinancials
method BCInvoice.ValidateComponentPostTax
method BCInvoice.ValidateComponentPostWHT
method BCreditor.PostValidateComponent
method BPosting.PreSave
method BPosting.ValidateComponentPost
method BJournalEntry.CheckTaxTypeWithWHT