project QadFinancials > class BDDocumentStatus > business logic query DDocumentStatusByTypeStatusGL


Parameters


iiCompanyIdintegerCompany id
icDDocumentStatusDocumentTypecharacter
icDDocumentStatusStatuscharacter
iiBankGLIdinteger
icBankGLCodecharacter


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 namedata typedb fielddescription
tiBankGL_IDintegerDDocumentStatus.BankGL_IDBank Account Code
tcBankGLCodecharacterGL1.GLCodeA code identifying the GL account.
tiDDocumentStatusDefValDaysintegerDDocumentStatus.DDocumentStatusDefValDaysDefault Value Days
tcDDocumentStatusDocTypecharacterDDocumentStatus.DDocumentStatusDocTypePayment Instrument
tcDDocumentStatusStatuscharacterDDocumentStatus.DDocumentStatusStatusStatus
tcGLCodecharacterGL2.GLCodeA code identifying the GL account.
tlGLIsDivisionAccountlogicalGL2.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 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