Parameters
| iiCompanyId | integer | Company id |
| icTaxRegCode | character | |
query condition
each TaxReg where
TaxReg.TaxRegCode = icTaxRegCode
each TaxRegJournal (inner-join) where
TaxRegJournal.TaxReg_ID = TaxReg.TaxReg_ID AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = TaxRegJournal.Journal_ID AND
query resultset tqTaxRegisterByJournal
| field name | data type | db field | description |
|---|
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tcTaxRegCode | character | TaxReg.TaxRegCode | Tax Register Code |
Internal usage
QadFinancials