project QadFinancials > class BMfgTaxZone > business logic query TaxZoneByTaxZone
Description
tax zone by tax zone
Parameters
| icTxzTaxZone | character | Tax Zone |
query condition
each txz_mstr where
txz_mstr.txz_tax_zone = icTxzTaxZone
first ctry_mstr (inner-join) where
ctry_mstr.ctry_ctry_code = txz_mstr.txz_ctry_code AND
query resultset tqTaxZoneByTaxZone
| field name | data type | db field | description |
|---|
| tlctry_ec_flag | logical | ctry_mstr.ctry_ec_flag | EC Country |
| tctxz_ctry_code | character | txz_mstr.txz_ctry_code | Country Code |
| tctxz_tax_zone | character | txz_mstr.txz_tax_zone | Tax Zone |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(txz_mstr),rowid(ctry_mstr) |
Internal usage
QadFinancials