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