project QadFinancials > class BDebtorBalance > business logic query DHistByDebtorFromTill


Parameters


iiCompanyIdintegerCompany id
iiDebtorIdinteger
iiDHistYearPeriodFrominteger
iiDHistYearPeriodTillinteger


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 namedata typedb fielddescription
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code
tiDebtor_IDintegerDHist.Debtor_IDLink to Debtor
tdDHistGrossCredNoteTCdecimalDHist.DHistGrossCredNoteTCTC Gross Credit Note
tdDHistGrossInvoiceTCdecimalDHist.DHistGrossInvoiceTCTC Gross Invoice
tiDHistYearPeriodFromintegerDHist.DHistYearPeriodFromFrom Year GL Period
tiDHistYearPeriodTillintegerDHist.DHistYearPeriodTillTo Year GL Period


Internal usage


QadFinancials
method BDebtor.CalculateCreditOnTurnover