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