business logic query DDocumentStatusByTypeStatusGL

Parameters

iiCompanyId	integer	Company id
icDDocumentStatusDocumentType	character
icDDocumentStatusStatus	character
iiBankGLId	integer
icBankGLCode	character

query condition

each DDocumentStatus where

DDocumentStatus.Company_Id = iiCompanyId AND
DDocumentStatus.BankGL_ID = iiBankGLId AND
DDocumentStatus.DDocumentStatusDocType = icDDocumentStatusDocumentType AND
DDocumentStatus.DDocumentStatusStatus = icDDocumentStatusStatus

first GL1 (inner-join) where

GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = DDocumentStatus.BankGL_ID AND
GL1.GLCode = icBankGLCode

first GL2 (outer-join) where

GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = DDocumentStatus.GL_ID AND

first Journal (outer-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = DDocumentStatus.Journal_ID AND

query resultset tqDDocumentStatusByTypeStatusGL

field name	data type	db field	description
tiBankGL_ID	integer	DDocumentStatus.BankGL_ID	Bank Account Code
tcBankGLCode	character	GL1.GLCode	A code identifying the GL account.
tiDDocumentStatusDefValDays	integer	DDocumentStatus.DDocumentStatusDefValDays	Default Value Days
tcDDocumentStatusDocType	character	DDocumentStatus.DDocumentStatusDocType	Payment Instrument
tcDDocumentStatusStatus	character	DDocumentStatus.DDocumentStatusStatus	Status
tcGLCode	character	GL2.GLCode	A code identifying the GL account.
tlGLIsDivisionAccount	logical	GL2.GLIsDivisionAccount	Set to true if the account has a sub-account. Its value is calculated by the system and is determined by the value of tcDivisionProfileCode.
	api annotation:		This field can be left blank as it will be calculated by the system.
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).

Internal usage

QadFinancials

method BDCollection.RetrievePaySelInitial
method BDDocument.AdditionalUpdatesGetStatusInfo
method BDDocument.AdditionalUpdatesPosting
method BDDocument.DefaultValuesDDocumentTypeStatus
method BDDocument.GetListExistingDocStatus
method BDDocument.InitialValues
method BDDocumentStatus.ValidateComponent
method BDPaymentSelection.GetListAllowedDocStatus
method BDPaymentSelection.InitialValues