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