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