business logic query CDocumentStatusByTypeStatusGL

Parameters

iiCompanyId	integer	Company id
icCDocumentStatusDocumentType	character
icCDocumentStatusStatus	character
iiBankGLId	integer
icBankGLCode	character

query condition

each CDocumentStatus where

CDocumentStatus.Company_Id = iiCompanyId AND
CDocumentStatus.CDocumentStatusDocType = icCDocumentStatusDocumentType AND
CDocumentStatus.CDocumentStatusStatus = icCDocumentStatusStatus AND
CDocumentStatus.BankGL_ID = iiBankGLId

first GL1 (outer-join) where

GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = CDocumentStatus.GL_ID AND

first GL2 (inner-join) where

GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = CDocumentStatus.BankGL_ID AND
GL2.GLCode = icBankGLCode

first Journal (outer-join) where

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

query resultset tqCDocumentStatusByTypeStatusGL

field name	data type	db field	description
tiBankGL_ID	integer	CDocumentStatus.BankGL_ID	Bank Account Code
tcBankGLCode	character	GL2.GLCode	A code identifying the GL account.
tiCDocumentStatusDefValDays	integer	CDocumentStatus.CDocumentStatusDefValDays	Default Value Days
tcCDocumentStatusDocType	character	CDocumentStatus.CDocumentStatusDocType	Payment Instrument
tcCDocumentStatusStatus	character	CDocumentStatus.CDocumentStatusStatus	Status
tiGL_ID	integer	GL1.GL_ID	Record ID
tcGLCode	character	GL1.GLCode	A code identifying the GL account.
tcGLDescription	character	GL1.GLDescription	A description of the GL account.
tlGLIsDivisionAccount	logical	GL1.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 BCDocument.AdditionalUpdates
method BCDocument.AdditionalUpdatesGetStatusInfo
method BCDocument.DefaultValuesCDocumentTypeStatus
method BCDocument.GetListExistingDocStatus
method BCDocument.InitialValues
method BCDocumentStatus.CreateDocumentStatusForBankGL
method BCDocumentStatus.ValidateComponent
method BPaymentSelection.DefaultValuesDocumentType