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