Parameters
| icTaxRegCode | character | |
| iiCompanyId | integer | |
query condition
each TaxReg where
TaxReg.TaxRegCode = icTaxRegCode
each TaxRegCompany (inner-join) where
TaxRegCompany.Company_Id = iiCompanyId AND
TaxRegCompany.TaxReg_ID = TaxReg.TaxReg_ID AND
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = TaxRegCompany.Company_ID AND
query resultset tqTaxRegisterByCompany
| field name | data type | db field | description |
|---|
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcTaxRegCode | character | TaxReg.TaxRegCode | Tax Register Code |
Internal usage
QadFinancials