project QadFinancials > class BDebtorReport > business logic query DInvoiceReminderLevelSortDesc


Parameters


iiCompanyIdintegerCompany id
iiDebtorIdinteger
icCompanyCodecharacter


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 namedata typedb fielddescription
tiDebtor_IDintegerDInvoice.Debtor_IDLink to Debtor
tiDInvoice_IDintegerDInvoice.DInvoice_IDRecord ID
tiDInvoiceReminderCountintegerDInvoice.DInvoiceReminderCountReminder Counter. This field displays the reminder level that applies to this invoice.


Internal usage


QadFinancials
method BDebtorReport.CustomerCreditOverview