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


iiCInvoiceIdintegerID of the Creditor Invoice
iiCompanyIdintegerCompany id
icDomainCodecharacter


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 namedata typedb fielddescription
tiCInvoice_IDintegerCInvoiceVat.CInvoice_IDLink to CInvoice
tiCompany_IDintegerCompany.Company_IDRecord ID
tiDomain_IDintegerCompany.Domain_IDDomain
tcDomainCodecharacterDomains.DomainCodeDomain
tltx2_by_linelogicaltx2_mstr.tx2_by_lineTax-By-Line
tctx2_domaincharactertx2_mstr.tx2_domainDomain
tctx2_tax_codecharactertx2_mstr.tx2_tax_codeTax Code
tiVat_IDintegerVat.Vat_IDRecord ID


Internal usage


QadFinancials
method BCInvoice.AllocateCInvoices