project QadFinancials > class BCDocumentStatus > business logic query CDocumentStatusPrim
Description
Primary query for CDocument Status
Parameters
icCDocumentStatusID | character | Parameter for CDocumentStatus_ID |
icCDocumentStatusStatus | character | CDocumentStatus Status |
icCDocumentStatusDocumentType | character | |
iiCompanyId | integer | |
icBankGLCode | character | |
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 name | data type | db field | description |
tiCDocumentStatus_ID | integer | CDocumentStatus.CDocumentStatus_ID | Record ID |
tcCDocumentStatusDocType | character | CDocumentStatus.CDocumentStatusDocType | Payment Instrument |
tcCDocumentStatusStatus | character | CDocumentStatus.CDocumentStatusStatus | Status |
tcGLCode | character | GL.GLCode | A code identifying the GL account. |
Internal usage
QadFinancials