project QadFinancials > class BDInvoice > business logic query DInvoiceVatByDInvoiceId

Description

DInvoiceVatByDInvoiceId


Parameters


iiDInvoiceIdintegerDInvoice Id


query condition


  each DInvoiceVat where
DInvoiceVat.DInvoice_ID = iiDInvoiceId

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

          first Domains (inner-join) where
Domains.Domain_ID = Vat.Domain_ID AND


query resultset tqDInvoiceVatByDInvoiceId


field namedata typedb fielddescription
tiDInvoice_IDintegerDInvoiceVat.DInvoice_IDLink to DInvoice
tlDInvoiceVatIsAbsRetlogicalDInvoiceVat.DInvoiceVatIsAbsRetRetained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government.
tlDInvoiceVatIsTaxablelogicalDInvoiceVat.DInvoiceVatIsTaxableTaxable. This field indicates if the invoice is taxable.
api annotation:This field defaults to true if the customer is taxable.
tdDInvoiceVatVatBaseCreditCCdecimalDInvoiceVat.DInvoiceVatVatBaseCreditCCSC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
tdDInvoiceVatVatBaseCreditLCdecimalDInvoiceVat.DInvoiceVatVatBaseCreditLCBC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
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.
tdDInvoiceVatVatBaseDebitCCdecimalDInvoiceVat.DInvoiceVatVatBaseDebitCCSC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
tdDInvoiceVatVatBaseDebitLCdecimalDInvoiceVat.DInvoiceVatVatBaseDebitLCBC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
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.
tdDInvoiceVatVatCreditCCdecimalDInvoiceVat.DInvoiceVatVatCreditCCSC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
tdDInvoiceVatVatCreditLCdecimalDInvoiceVat.DInvoiceVatVatCreditLCBC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
tdDInvoiceVatVatCreditTCdecimalDInvoiceVat.DInvoiceVatVatCreditTCTC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tdDInvoiceVatVatDebitCCdecimalDInvoiceVat.DInvoiceVatVatDebitCCSC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
tdDInvoiceVatVatDebitLCdecimalDInvoiceVat.DInvoiceVatVatDebitLCBC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
tdDInvoiceVatVatDebitTCdecimalDInvoiceVat.DInvoiceVatVatDebitTCTC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
tcDomainCodecharacterDomains.DomainCodeDomain
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.
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
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(DInvoiceVat),rowid(Vat),rowid(Domains)


Internal usage


QadFinancials
method BBankEntry.CalculateBankStateAlloc
method BBankEntry.GetPossibleAllocationsDInvoice
method BDDocument.Calculate
method BPaymentSelection.AdditionalUpdatesRegister