project QadFinancials > class BVAT > business logic query VatByAllFields
Description
Give vat code back based on all parameters of vat table
Parameters
iiVatId | integer | |
icVatCode | character | |
icVatDeliveryType | character | |
icVatPercentageLevel | character | |
icVatInOut | character | |
icTransactionType | character | |
icVatAVRCode | character | VatAVRCode; if you realy want to have a condition with a test on empty for this field then you have to pass string "EMPTYAVRCODE":U |
ilVatIsActive | logical | Is this vat code active ? |
query condition
each Vat where
Vat.Vat_ID = iiVatId AND
Vat.VatCode matches icVatCode AND
Vat.VatDeliveryType matches icVatDeliveryType AND
Vat.VatPercentageLevel matches icVatPercentageLevel AND
Vat.VatInOut matches icVatInOut AND
Vat.VatAVRType matches (if icVatAVRCode = 'EMPTYAVRCODE' then '' else icVatAVRCode) AND
Vat.VatTransactionType matches icTransactionType AND
Vat.VatIsActive = ilVatIsActive
query resultset tqVatByAllFields
field name | data type | db field | description |
tiVat_ID | integer | Vat.Vat_ID | Record ID |
tcVatAVRType | character | Vat.VatAVRType | AVR Code |
tcVatCode | character | Vat.VatCode | Tax Code |
tcVatDescription | character | Vat.VatDescription | Description |
tcVatInOut | character | Vat.VatInOut | Tax In/Out |
tlVatIsActive | logical | Vat.VatIsActive | Active |
tcVatPercentageLevel | character | Vat.VatPercentageLevel | Tax Percentage Level |
tcVatTransactionType | character | Vat.VatTransactionType | Transaction Type |
Internal usage
QadFinancials