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