project QadFinancials > class BCDocumentStatus > business logic query CDocumentStatusByTypeStatusGL


Parameters


iiCompanyIdintegerCompany id
icCDocumentStatusDocumentTypecharacter
icCDocumentStatusStatuscharacter
iiBankGLIdinteger
icBankGLCodecharacter


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 namedata typedb fielddescription
tiBankGL_IDintegerCDocumentStatus.BankGL_IDBank Account Code
tcBankGLCodecharacterGL2.GLCodeA code identifying the GL account.
tiCDocumentStatusDefValDaysintegerCDocumentStatus.CDocumentStatusDefValDaysDefault Value Days
tcCDocumentStatusDocTypecharacterCDocumentStatus.CDocumentStatusDocTypePayment Instrument
tcCDocumentStatusStatuscharacterCDocumentStatus.CDocumentStatusStatusStatus
tiGL_IDintegerGL1.GL_IDRecord ID
tcGLCodecharacterGL1.GLCodeA code identifying the GL account.
tcGLDescriptioncharacterGL1.GLDescriptionA description of the GL account.
tlGLIsDivisionAccountlogicalGL1.GLIsDivisionAccountSet 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.
tcJournalCodecharacterJournal.JournalCodeA 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