project QadFinancials > class BVAT > business logic query VatByCodeDomainForCInvoiceWHT
Parameters
| icVatCode | character | |
| icDomainCode | character | |
query condition
each Vat where
Vat.VatCode = icVatCode
each CInvoiceWHT (inner-join) where
CInvoiceWHT.Vat_ID = Vat.Vat_ID AND
first Domains (inner-join) where
Domains.Domain_ID = Vat.Domain_ID AND
Domains.DomainCode = icDomainCode
query resultset tqVatByCodeDomainForCInvoiceWHT
| field name | data type | db field | description |
|---|
| tiCInvoiceWHT_ID | integer | CInvoiceWHT.CInvoiceWHT_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcVatCode | character | Vat.VatCode | Tax Code |
Internal usage
QadFinancials