project QadFinancials > class BCreditorBalance > business logic query CBalanceByCyCreditorCurrID
Description
Prim-Query on CBalance
Parameters
| iiCompanyId | integer | Company id |
| iiCreditor_ID | integer | Creditor_ID |
| iiCurrency_ID | integer | Currency ID |
| iiCBalance_ID | integer | CBalance_ID |
query condition
each CBalance where
CBalance.Company_Id = iiCompanyId AND
CBalance.Creditor_ID = iiCreditor_ID AND
CBalance.Currency_ID = iiCurrency_ID AND
CBalance.CBalance_ID = iiCBalance_ID
query resultset tqCBalanceByCyCreditorCurrID
| field name | data type | db field | description |
|---|
| tiCBalance_ID | integer | CBalance.CBalance_ID | Record ID |
| 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 |
Internal usage
QadFinancials