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