project QadFinancials > class BDDocumentStatus > business logic query DDocumentStatusPrim
Description
Primary query for debtor document status
Parameters
| iiDDocumentStatusID | integer | Parameter for DDocumentStatus_ID |
| icDDocumentStatusStatus | character | Parameter for DocumentStatusStatus |
| icDDocumentStatusDocumentType | character | |
| icBankGLCode | character | |
| iiCompanyId | integer | Company id |
query condition
each DDocumentStatus where
DDocumentStatus.Company_Id = iiCompanyId AND
DDocumentStatus.DDocumentStatus_ID = iiDDocumentStatusID AND
DDocumentStatus.DDocumentStatusStatus = icDDocumentStatusStatus AND
DDocumentStatus.DDocumentStatusDocType = icDDocumentStatusDocumentType
first GL (inner-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = DDocumentStatus.BankGL_ID AND
GL.GLCode = icBankGLCode
query resultset tqDDocumentStatusPrim
| field name | data type | db field | description |
|---|
| tiDDocumentStatus_ID | integer | DDocumentStatus.DDocumentStatus_ID | Record ID |
| tcDDocumentStatusDocType | character | DDocumentStatus.DDocumentStatusDocType | Payment Instrument |
| tcDDocumentStatusStatus | character | DDocumentStatus.DDocumentStatusStatus | Status |
| tcGLCode | character | GL.GLCode | A code identifying the GL account. |
Internal usage
QadFinancials