project QadFinancials > class BVAT > business logic query VATPrim
Description
Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.
Parameters
| iiVatId | integer | VatId = primary key |
| icVatCode | character | VatCode = logical key |
| iiDomainId | integer | domain ID |
| icDomainCode | character | domain Code |
| icVatInOut | character | VatInOut |
query condition
each Vat where
Vat.Vat_ID = iiVatId AND
Vat.VatCode = icVatCode AND
Vat.Domain_ID = iiDomainId AND
Vat.VatInOut = icVatInOut
first Domains (inner-join) where
Domains.Domain_ID = Vat.Domain_ID AND
Domains.DomainCode = icDomainCode
query resultset tqVATPrim
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | Vat.Domain_ID | Domain |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcVatDescription | character | Vat.VatDescription | Description |
| tcVatInOut | character | Vat.VatInOut | Tax In/Out |
| tcVatCode | character | Vat.VatCode | Tax Code |
| tiVat_ID | integer | Vat.Vat_ID | Record ID |
Internal usage
QadFinancials