project QadFinancials > class BMfgTaxCode > business logic query MfgTaxCodeByTaxCode

Description

MfgTaxCodeByTaxCode


Parameters


icTaxCodecharacterTax Code
icDomainCodecharacterDomain
ilDiscountAtPaymentlogicalis there discount at payment ?
ilIsTaxByLinelogicalIs Tax By Line


query condition


  each tx2_mstr where
tx2_mstr.tx2_domain = icDomainCode AND
tx2_mstr.tx2_tax_code = icTaxCode AND
tx2_mstr.tx2_pmt_disc = ilDiscountAtPayment AND
tx2_mstr.tx2_by_line = ilIsTaxByLine


query resultset tqMfgTaxCodeByTaxCode


field namedata typedb fielddescription
tctx2_ap_acctcharactertx2_mstr.tx2_ap_acctAP Tax Account
tctx2_ap_cn_acctcharactertx2_mstr.tx2_ap_cn_acctAP Tax CN Account
tctx2_ap_cn_subcharactertx2_mstr.tx2_ap_cn_subAP Tax CN Sub-Account
tctx2_ap_disc_acctcharactertx2_mstr.tx2_ap_disc_acctAP Discount Account
tctx2_ap_disc_cccharactertx2_mstr.tx2_ap_disc_ccCC
tctx2_ap_disc_subcharactertx2_mstr.tx2_ap_disc_subAP Discount Sub-Account
tctx2_ap_subcharactertx2_mstr.tx2_ap_subAP Tax Sub-Account
tctx2_apr_acctcharactertx2_mstr.tx2_apr_acctAP Retained Tax Account
tctx2_apr_cn_acctcharactertx2_mstr.tx2_apr_cn_acctAP Tax Ret CN Account
tltx2_apr_uselogicaltx2_mstr.tx2_apr_use
tctx2_ar_acctcharactertx2_mstr.tx2_ar_acctAR Sales Tax Account
tctx2_ar_cn_acctcharactertx2_mstr.tx2_ar_cn_acctSales Tax CN Account
tctx2_ar_cn_subcharactertx2_mstr.tx2_ar_cn_subSales Tax CN Sub-Account
tctx2_ar_disc_acctcharactertx2_mstr.tx2_ar_disc_acctAR Discount Account
tctx2_ar_disc_cccharactertx2_mstr.tx2_ar_disc_ccCC
tctx2_ar_disc_subcharactertx2_mstr.tx2_ar_disc_subAR Discount Sub-Account
tctx2_ara_acctcharactertx2_mstr.tx2_ara_acctAR Absorbed Tax Account
tctx2_ara_cn_acctcharactertx2_mstr.tx2_ara_cn_acctSales Tax Abs CN Acct
tltx2_ara_uselogicaltx2_mstr.tx2_ara_use
tctx2_basecharactertx2_mstr.tx2_baseTaxable Base Code
tltx2_by_linelogicaltx2_mstr.tx2_by_lineTax-By-Line
tctx2_desccharactertx2_mstr.tx2_descDescription
tctx2_dltx_cn_acctcharactertx2_mstr.tx2_dltx_cn_acctDelayed Tax CN Account
tctx2_dltx_inv_acctcharactertx2_mstr.tx2_dltx_inv_acctDelayed Tax Invoice Account
tctx2_domaincharactertx2_mstr.tx2_domainDomain
tltx2_inv_disclogicaltx2_mstr.tx2_inv_discDiscount Tax at Invoice
tdtx2_pct_recvdecimaltx2_mstr.tx2_pct_recvPercent Recoverable
tltx2_pmt_disclogicaltx2_mstr.tx2_pmt_discDiscount Tax at Payment
tltx2_rcpt_tax_pointlogicaltx2_mstr.tx2_rcpt_tax_pointAccrue Tax at Receipt
tltx2_reverse_chargelogicaltx2_mstr.tx2_reverse_chargeDomestic Reverse Charge
tctx2_stx_inv_acctcharactertx2_mstr.tx2_stx_inv_acctSuspended Tax Inv Account
tctx2_tax_codecharactertx2_mstr.tx2_tax_codeTax Code
tdtx2_tax_pctdecimaltx2_mstr.tx2_tax_pctTax Rate
tctx2_tax_typecharactertx2_mstr.tx2_tax_typeTax Type
tltx2_update_taxlogicaltx2_mstr.tx2_update_taxUpdate Tax Allowed
tltx2_usage_tax_pointlogicaltx2_mstr.tx2_usage_tax_pointAccrue Tax At Usage
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(tx2_mstr)


Internal usage


QadFinancials
method BAPMatching.CreateAPMatchingLNTaxFromGTM
method BAPMatching.ValidateComponentPreAPMCInvoice
method BBankEntry.AdditionalUpdatesInvDiscountCurrDiff
method BBankEntry.AdditionalUpdatesInvDiscountCurrDiffTax
method BBankEntry.CalculateBankStateAlloc
method BBankEntry.GetPossibleAllocationsCInvoice
method BBankEntry.GetPossibleAllocationsDInvoice
method BCDocument.AdditionalUpdatesPostingXrefCIDiscTax
method BCDocument.AdditionalUpdatesPostingXrefDI
method BCDocument.CalculateAll
method BCInvoice.DefaultValuesTax
method BCInvoice.DefaultValuesWHTCode
method BCInvoice.GetWHTDescriptionAndCCExch
method BCInvoice.UpdateCInvoiceFromAPM
method BCInvoice.ValidateComponentPostTax
method BCInvoice.ValidateComponentPostWHT
method BCreditor.PostValidateComponent
method BDDocument.AdditionalUpdatesPostingXrefDIDisc
method BDDocument.Calculate
method BDDocument.StopAllQueries
method BDInvoice.CalculateDInvoiceVat
method BDInvoice.DefaultValuesTax
method BDInvoice.ValidateComponentAllStopQueries
method BDInvoice.ValidateComponentAllTax
method BPosting.AddTaxPosting
method BPosting.AddTaxPostingDetail
method BJournalEntry.CreateTaxPosting
method BPaymentSelection.AdditionalUpdatesRegister