project QadFinancials > class BDomain > business logic query DomainForCDocumentByStatus
Description
Query returns cdocuments by status and for the selected domain
Parameters
| icDomainCode | character | Domain Code |
| icDocumentStatus | character | Document Status |
| iiCompanyId | integer | Company id |
query condition
each Domains where
Domains.DomainCode = icDomainCode
each Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Domain_ID = Domains.Domain_ID AND
each CDocument (inner-join) where
CDocument.Company_Id = iiCompanyId AND
CDocument.Company_ID = Company.Company_ID AND
CDocument.CDocumentStatus = icDocumentStatus
query resultset tqDomainForCDocumentByStatus
| field name | data type | db field | description |
|---|
| tcCDocumentStatus | character | CDocument.CDocumentStatus | Status. The payment status. The default value for a new record is Initial. |
| tcDomainCode | character | Domains.DomainCode | Domain |
Internal usage
QadFinancials