project QadFinancials > class BDebtorReport > business logic query DInvoiceReminderLevelSortDesc
Parameters
| iiCompanyId | integer | Company id |
| iiDebtorId | integer | |
| icCompanyCode | character | |
query condition
each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.Debtor_ID = iiDebtorId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = DInvoice.Company_ID AND
Company.CompanyCode can-do icCompanyCode
query sort order
DInvoice.DInvoiceReminderCount (descending)
query resultset tqDInvoiceReminderLevelSortDesc
| field name | data type | db field | description |
|---|
| tiDebtor_ID | integer | DInvoice.Debtor_ID | Link to Debtor |
| tiDInvoice_ID | integer | DInvoice.DInvoice_ID | Record ID |
| tiDInvoiceReminderCount | integer | DInvoice.DInvoiceReminderCount | Reminder Counter. This field displays the reminder level that applies to this invoice. |
Internal usage
QadFinancials