project QadFinancials > class BMfgTaxType > business logic query MfgTaxTypeByTaxTypeV01
Description
Query to fetch description of the Tax Type using Tax Type Code.
Parameters
icTaxTypeCode | character | Code for Tax Type |
ilTaxTypeIsWHT | logical | Is 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 name | data type | db field | description |
tclbl_lang | character | lbl_mstr.lbl_lang | Language |
tclbl_long | character | lbl_mstr.lbl_long | Long Label |
tctxty_tax_desc | character | txty_mstr.txty_tax_desc | Description |
tctxty_tax_type | character | txty_mstr.txty_tax_type | Code |
tltxty_wt_type | logical | txty_mstr.txty_wt_type | Withholding Tax Type |
Internal usage
QadFinancials