business logic query CompanyPropertyBySuspDelTax

Description

Check the entity( entities) in the system where the Suspended or Delayed tax flag is different from the input value

Parameters

iiCompanyId	integer	Company id
icDelTax	character	flag value of Delayed tax
icSuspTax	character	Flag value of Suspended Tax

query condition

each CompanyProperty where

CompanyProperty.Company_Id = iiCompanyId AND
CompanyProperty.CompanyPropertySuspTax <> icSuspTax AND
CompanyProperty.CompanyPropertyDelTax <> icDelTax

query resultset tqCompanyPropertyBySuspDelTax

field name	data type	db field	description
tiCompany_ID	integer	CompanyProperty.Company_ID	Link to Company
tcCompanyPropertyDelTax	character	CompanyProperty.CompanyPropertyDelTax	Delayed Tax
tcCompanyPropertyDelTaxDateType	character	CompanyProperty.CompanyPropertyDelTaxDateType	Delayed Date Type
tlCompanyPropertyIsDelPaid	logical	CompanyProperty.CompanyPropertyIsDelPaid	Delay Until Paid Status
tlCompanyPropertyIsSuspPaid	logical	CompanyProperty.CompanyPropertyIsSuspPaid	Suspend Until Paid Status
tcCompanyPropertySuspTax	character	CompanyProperty.CompanyPropertySuspTax	Suspended Tax
tcCompanyPropertySusTaxDateType	character	CompanyProperty.CompanyPropertySusTaxDateType	Suspended Date Type

Internal usage

QadFinancials

method BAPMatching.CalculatePost
method BAPMatching.CreateAPMatchingLNTaxFromGTM
method BCDocument.AdditionalUpdatesPostingXrefCIDelTax
method BCDocument.AdditionalUpdatesPostingXrefDI
method BCInvoice.CreateCInvoiceMovementsDelTax
method BCInvoice.DefaultValuesTax
method BCInvoice.UpdateCInvoiceVatDelay
method BCInvoice.ValidateComponentPostTax
method BDDocument.AdditionalUpdatesPostingXrefDI
method BDInvoice.CreateDInvoiceMovementsSuspTax
method BDInvoice.DefaultValuesTax
method BDInvoice.MoveSuspendedTax
method BDInvoice.ValidateComponentAllStopQueries
method BDInvoice.ValidateComponentAllTax