project QadFinancials > class BVAT > business logic query VatForVatCodeTaxType
Description
VatForVatCodeTaxType: query that read the Vat record and the associated tx2_mstr record
Parameters
| icVatCode | character | |
| iiVatID | integer | |
| icVatInOut | character | |
| icDomainCode | character | |
| iiDomainID | integer | |
query condition
each Vat where
Vat.Vat_ID = iiVatID AND
Vat.VatInOut = icVatInOut AND
Vat.VatCode = icVatCode AND
Vat.Domain_ID = iiDomainID
first Domains (inner-join) where
Domains.Domain_ID = Vat.Domain_ID AND
Domains.DomainCode = icDomainCode
first tx2_mstr (conditional-join) where
tx2_mstr.tx2_tax_code = Vat.VatCode AND
query resultset tqVatForVatCodeTaxType
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | Vat.Domain_ID | Domain |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tctx2_domain | character | tx2_mstr.tx2_domain | Domain |
| tctx2_tax_code | character | tx2_mstr.tx2_tax_code | Tax Code |
| tdtx2_tax_pct | decimal | tx2_mstr.tx2_tax_pct | Tax Rate |
| tctx2_tax_type | character | tx2_mstr.tx2_tax_type | Tax Type |
| tctx2_tax_usage | character | tx2_mstr.tx2_tax_usage | Tax Usage |
| tiVat_ID | integer | Vat.Vat_ID | Record ID |
| tcVatCode | character | Vat.VatCode | Tax Code |
| tcVatInOut | character | Vat.VatInOut | Tax In/Out |
| tlVatIsActive | logical | Vat.VatIsActive | Active |
| tcVatTransactionType | character | Vat.VatTransactionType | Transaction Type |
Internal usage
QadFinancials