project QadFinancials > class BDDocument > business logic query DocumentByDpaySelID
Parameters
| iiCompanyId | integer | Company id |
| iiDPaySelID | integer | |
query condition
each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.DPaySel_ID = iiDPaySelID
first DPaySel (inner-join) where
DPaySel.Company_Id = iiCompanyId AND
DPaySel.DPaySel_ID = DDocument.DPaySel_ID AND
query resultset tqDocumentByDPaySelID
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DPaySel.Company_ID | Link to Company |
| tiDPaySel_ID | integer | DDocument.DPaySel_ID | Link to DPaySel |
| tiDPaySel_ID1 | integer | DPaySel.DPaySel_ID | Record ID |
| tcDPaySelCode | character | DPaySel.DPaySelCode | Payment Selection |
| tcDPaySelStatus | character | DPaySel.DPaySelStatus | Status |
Internal usage
QadFinancials