project QadFinancials > class BDInvoice > business logic query DInvoiceByDebtorForReminderLvl


Parameters


iiCompanyIdintegerCompany id
iiDebtorIDinteger


query condition


  each DInvoice where
DInvoice.Debtor_ID = iiDebtorID AND
DInvoice.DInvoiceIsOpen = true AND
DInvoice.Company_ID = iiCompanyId


query sort order


DInvoice.DInvoiceReminderCount (descending)


query resultset tqDInvoiceByDebtorForReminderLvl


field namedata typedb fielddescription
tiCompany_IDintegerDInvoice.Company_IDLink to Company
tiDebtor_IDintegerDInvoice.Debtor_IDLink to Debtor
tiDInvoiceReminderCountintegerDInvoice.DInvoiceReminderCountReminder Counter. This field displays the reminder level that applies to this invoice.


Internal usage


QadFinancials
method BDebtor.GetHighestReminderLeverl