project QadFinancials > class BProjectReport > business logic query DebtorBalanceByFilter
Parameters
| iiCompanyId | integer | Company id |
| iiDebtorId | integer | |
| iiCurrencyId | integer | |
| icFromDebtorCode | character | |
| icToDebtorCode | character | |
| icCanDoDebtorCode | character | |
query condition
each DBalance where
DBalance.Company_Id = iiCompanyId AND
DBalance.Debtor_ID = iiDebtorId AND
DBalance.Currency_ID = iiCurrencyId
first Debtor (inner-join) where
Debtor.SharedSet_Id = vi_DEBTOR_sharedset(iiCompanyId) AND
Debtor.Debtor_ID = DBalance.Debtor_ID AND
Debtor.DebtorCode can-do icCanDoDebtorCode AND
Debtor.DebtorCode >= icFromDebtorCode AND
Debtor.DebtorCode <= icToDebtorCode
query resultset tqDebtorBalanceByFilter
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | DBalance.Company_ID | Link to Company |
| tiCurrency_ID | integer | DBalance.Currency_ID | Link to Currency |
| tiDBalance_ID | integer | DBalance.DBalance_ID | Record ID |
| tdDBalanceCC | decimal | DBalance.DBalanceCC | SC Balance |
| tdDBalanceLC | decimal | DBalance.DBalanceLC | BC Balance |
| tdDBalanceTC | decimal | DBalance.DBalanceTC | TC Balance |
| tiDebtor_ID | integer | DBalance.Debtor_ID | Link to Debtor |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(DBalance),rowid(Debtor) |
Internal usage
QadFinancials