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