project QadFinancials > class BDebtorBalance > business logic query DHistByDebtorFromTill
Parameters
| iiCompanyId | integer | Company id |
| iiDebtorId | integer | |
| iiDHistYearPeriodFrom | integer | |
| iiDHistYearPeriodTill | integer | |
query condition
each DHist where
DHist.Company_Id = iiCompanyId AND
DHist.Debtor_ID = iiDebtorId AND
DHist.DHistYearPeriodFrom >= iiDHistYearPeriodFrom AND
DHist.DHistYearPeriodFrom < iiDHistYearPeriodTill
first Currency (inner-join) where
Currency.Currency_ID = DHist.Currency_ID AND
query resultset tqDHistByDebtorFromTill
| field name | data type | db field | description |
|---|
| tcCurrencyCode | character | Currency.CurrencyCode | Currency Code |
| tiDebtor_ID | integer | DHist.Debtor_ID | Link to Debtor |
| tdDHistGrossCredNoteTC | decimal | DHist.DHistGrossCredNoteTC | TC Gross Credit Note |
| tdDHistGrossInvoiceTC | decimal | DHist.DHistGrossInvoiceTC | TC Gross Invoice |
| tiDHistYearPeriodFrom | integer | DHist.DHistYearPeriodFrom | From Year GL Period |
| tiDHistYearPeriodTill | integer | DHist.DHistYearPeriodTill | To Year GL Period |
Internal usage
QadFinancials