project QadFinancials > class BCDocumentStatus > business logic query CDocumentStatusPrim

Description

Primary query for CDocument Status


Parameters


icCDocumentStatusIDcharacterParameter for CDocumentStatus_ID
icCDocumentStatusStatuscharacterCDocumentStatus Status
icCDocumentStatusDocumentTypecharacter
iiCompanyIdinteger
icBankGLCodecharacter


query condition


  each CDocumentStatus where
CDocumentStatus.Company_Id = iiCompanyId AND
CDocumentStatus.CDocumentStatus_ID = icCDocumentStatusID AND
CDocumentStatus.CDocumentStatusStatus = icCDocumentStatusStatus AND
CDocumentStatus.CDocumentStatusDocType = icCDocumentStatusDocumentType

      first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = CDocumentStatus.BankGL_ID AND
GL.GLCode = icBankGLCode


query resultset tqCDocumentStatusPrim


field namedata typedb fielddescription
tiCDocumentStatus_IDintegerCDocumentStatus.CDocumentStatus_IDRecord ID
tcCDocumentStatusDocTypecharacterCDocumentStatus.CDocumentStatusDocTypePayment Instrument
tcCDocumentStatusStatuscharacterCDocumentStatus.CDocumentStatusStatusStatus
tcGLCodecharacterGL.GLCodeA code identifying the GL account.


Internal usage


QadFinancials
method BCDocument.CreateVoidedDocument
method BCDocument.ValidateComponentPost
method BCompany.ValidateComponentSSChange
method BDomain.ValidateComponentSharedSetChange