project QadFinancials > class BProjectReport > business logic query CreditorBalanceByFilter
Parameters
| iiCompanyId | integer | Company id |
| iiCreditorId | integer | |
| iiCurrencyId | integer | |
| icCandoCreditor | character | |
| icFromCreditor | character | |
| icToCreditor | character | |
query condition
each CBalance where
CBalance.Company_Id = iiCompanyId AND
CBalance.Creditor_ID = iiCreditorId AND
CBalance.Currency_ID = iiCurrencyId
first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CBalance.Creditor_ID AND
Creditor.CreditorCode can-do icCandoCreditor AND
Creditor.CreditorCode >= icFromCreditor AND
Creditor.CreditorCode <= icToCreditor
query resultset tqCreditorBalanceByFilter
| field name | data type | db field | description |
|---|
| tiCBalance_ID | integer | CBalance.CBalance_ID | Record ID |
| tdCBalanceCC | decimal | CBalance.CBalanceCC | SC Balance |
| tdCBalanceLC | decimal | CBalance.CBalanceLC | BC Balance |
| tdCBalanceTC | decimal | CBalance.CBalanceTC | TC Balance |
| tiCompany_ID | integer | CBalance.Company_ID | Link to Company |
| tiCreditor_ID | integer | CBalance.Creditor_ID | Link to Creditor |
| tiCurrency_ID | integer | CBalance.Currency_ID | Link to Currency |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(CBalance),rowid(Creditor) |
Internal usage
QadFinancials