project QadFinancials > class BCInvoice > business logic query CInvoiceVatForDelTax

Description

retrieve the tax records with delayed taxes


Parameters


iiCompanyIdintegerCompany id
iiCInvoiceIdintegerID of the supplier invoice
ilCInvoiceVatIsSuspDellogicalDelayed flag


query condition


  each CInvoice where
CInvoice.Company_Id = iiCompanyId AND
CInvoice.CInvoice_ID = iiCInvoiceId

      each CInvoiceVat (inner-join) where
CInvoiceVat.CInvoice_ID = CInvoice.CInvoice_ID AND
CInvoiceVat.CInvoiceVatIsSuspDel = ilCInvoiceVatIsSuspDel

          first Division1 (outer-join) where
Division1.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division1.Division_ID = CInvoiceVat.NormalTaxDivision_ID AND

          first GL (conditional-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = CInvoiceVat.NormalTaxGL_ID AND

      first CostCentre (outer-join) where
CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = CInvoice.CostCentre_ID AND

      first Division2 (conditional-join) where
Division2.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division2.Division_ID = CInvoice.Division_ID AND

      first Project (outer-join) where
Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = CInvoice.Project_ID AND


query resultset tqCInvoiceVatForDelTax


field namedata typedb fielddescription
tdCInvoiceVatBaseCreditTCdecimalCInvoice.CInvoiceVatBaseCreditTCTC 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.
tdCInvoiceVatBaseDebitTCdecimalCInvoice.CInvoiceVatBaseDebitTCTC 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.
tdCInvoiceVatCreditTCdecimalCInvoice.CInvoiceVatCreditTCTC 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.
tdCInvoiceVatDebitTCdecimalCInvoice.CInvoiceVatDebitTCTC 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.
tdCInvoiceVatSuspDelTaxAmtTCdecimalCInvoiceVat.CInvoiceVatSuspDelTaxAmtTCTax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency.
tdCInvoiceVatVatCreditTCdecimalCInvoiceVat.CInvoiceVatVatCreditTCTC 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.
tdCInvoiceVatVatDebitTCdecimalCInvoiceVat.CInvoiceVatVatDebitTCTC 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.
tcCostCentreCodecharacterCostCentre.CostCentreCodeCost Center: A code that identifies the cost center.
tcNormalTaxDivisionCodecharacterDivision1.DivisionCodeSub-Account
tcNormalTaxGLCodecharacterGL.GLCodeA code identifying the GL account.
tiPostingVat_IDintegerCInvoiceVat.PostingVat_IDLink to PostingVat
tcProjectCodecharacterProject.ProjectCodeProject
tiCompany_IDintegerCInvoice.Company_IDLink to Company
tiCInvoice_IDintegerCInvoice.CInvoice_IDRecord ID
tcCInvoiceTypecharacterCInvoice.CInvoiceTypeInvoice Type. This field identifies the invoice type.
The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined.
ttCInvoiceDatedateCInvoice.CInvoiceDateInvoice Date. This field indicates the invoice creation date.
The system uses this field with the credit terms to calculate due date and discount date.
api annotation:This field defaults from the system date.
tdCInvoiceBalanceCreditTCdecimalCInvoice.CInvoiceBalanceCreditTCTC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
tdCInvoiceBalanceDebitTCdecimalCInvoice.CInvoiceBalanceDebitTCTC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
tdCInvoiceOriginalCreditTCdecimalCInvoice.CInvoiceOriginalCreditTCTC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
tdCInvoiceOriginalDebitTCdecimalCInvoice.CInvoiceOriginalDebitTCTC AP Amount. This field displays the debit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same.
tcDivisionCodecharacterDivision2.DivisionCodeSub-Account
tiCInvoiceVat_IDintegerCInvoiceVat.CInvoiceVat_IDRecord ID
tlCInvoiceVatIsSuspDellogicalCInvoiceVat.CInvoiceVatIsSuspDelCInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM.
tlCInvoiceVatIsTaxablelogicalCInvoiceVat.CInvoiceVatIsTaxableTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.


Internal usage


QadFinancials
method BBankEntry.AdditionalUpdatesInvDiscountCurrDiffTax
method BCDocument.AdditionalUpdatesPostingXrefCI