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