project QadFinancials > class BCInvoice > business logic query CInvoiceVatForTaxByLine
Description
query that reads all tax-lines of an invoice and joins to the tax-definition to know the tax by line property
Parameters
iiCInvoiceId | integer | ID of the Creditor Invoice |
iiCompanyId | integer | Company id |
icDomainCode | character | |
query condition
each CInvoiceVat where
CInvoiceVat.CInvoice_ID = iiCInvoiceId
first Vat (inner-join) where
Vat.Vat_ID = CInvoiceVat.Vat_ID AND
first tx2_mstr (inner-join) where
tx2_mstr.tx2_tax_code = Vat.VatCode AND
tx2_mstr.tx2_domain = icDomainCode
first Domains (inner-join) where
Domains.DomainCode = tx2_mstr.tx2_domain AND
each Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Domain_ID = Domains.Domain_ID AND
query resultset tqCInvoiceVatForTaxByLine
field name | data type | db field | description |
tiCInvoice_ID | integer | CInvoiceVat.CInvoice_ID | Link to CInvoice |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tiDomain_ID | integer | Company.Domain_ID | Domain |
tcDomainCode | character | Domains.DomainCode | Domain |
tltx2_by_line | logical | tx2_mstr.tx2_by_line | Tax-By-Line |
tctx2_domain | character | tx2_mstr.tx2_domain | Domain |
tctx2_tax_code | character | tx2_mstr.tx2_tax_code | Tax Code |
tiVat_ID | integer | Vat.Vat_ID | Record ID |
Internal usage
QadFinancials