project QadFinancials > class BDInvoice > business logic query DInvoiceVatByAllocationInfo

Description

DInvoiceVatByAllocationInfo: query on the taxes of an invoice joined to tx2_mstr


Parameters


iiDInvoiceIDinteger
icDomainCodecharacter
ilDiscountTaxAtPaymentlogical


query condition


  each DInvoiceVat where
DInvoiceVat.DInvoice_ID = iiDInvoiceID

      first Vat (inner-join) where
Vat.Vat_ID = DInvoiceVat.Vat_ID AND

          first tx2_mstr (inner-join) where
tx2_mstr.tx2_tax_code = Vat.VatCode AND
tx2_mstr.tx2_domain = icDomainCode AND
tx2_mstr.tx2_pmt_disc = ilDiscountTaxAtPayment


query resultset tqDInvoiceVatByAllocationInfo


field namedata typedb fielddescription
tiDInvoice_IDintegerDInvoiceVat.DInvoice_IDLink to DInvoice
tiDInvoiceVat_IDintegerDInvoiceVat.DInvoiceVat_IDRecord ID
tlDInvoiceVatIsTaxablelogicalDInvoiceVat.DInvoiceVatIsTaxableTaxable. This field indicates if the invoice is taxable.
api annotation:This field defaults to true if the customer is taxable.
tdDInvoiceVatVatBaseCreditTCdecimalDInvoiceVat.DInvoiceVatVatBaseCreditTCTC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdDInvoiceVatVatBaseDebitTCdecimalDInvoiceVat.DInvoiceVatVatBaseDebitTCTC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tiDomain_IDintegerVat.Domain_IDDomain
tctx2_domaincharactertx2_mstr.tx2_domainDomain
tltx2_pmt_disclogicaltx2_mstr.tx2_pmt_discDiscount Tax at Payment
tctx2_tax_codecharactertx2_mstr.tx2_tax_codeTax Code
tcTxclTaxClscharacterDInvoiceVat.TxclTaxClsTax Class. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax class being applied, if any.
api annotation:This field default from the customer, and can be modified.
tcTxenvTaxEnvcharacterDInvoiceVat.TxenvTaxEnvTax Environment. This field is automatically calculated based on the customer and ship-to address details, and can be modified.
tcTxtyTaxTypecharacterDInvoiceVat.TxtyTaxTypeTax Type. This field displays the tax type, which defaults from the tax environment.
tcTxuTaxUsagecharacterDInvoiceVat.TxuTaxUsageTax Usage. When taxes are defined to accrue at receipt for this receiver, this field indicates the tax usage being applied, if any. Select a different tax class if necessary.
api annotation:This field defaults from the customer,and can be modified.
tiVat_IDintegerDInvoiceVat.Vat_IDDomain
tcVatCodecharacterVat.VatCodeTax Code
tcVatInOutcharacterVat.VatInOutTax In/Out


Internal usage


QadFinancials
method BOpenItemAdjustment.OIAdjApplyFilterDebtor
method BOpenItemAdjustment.OIAdjCommitSubDInvoiceDiscount