project QadFinancials > class BDebtorBalance > business logic query DBalanceByCyDebtorCurrID
Description
Prim-Query on DBalance
Parameters
| iiCompanyId | integer | Company id |
| iiDBalance_ID | integer | DBalance_ID |
| iiDebtor_ID | integer | Customer ID |
| iiCurrency_ID | integer | Currency ID |
query condition
each DBalance where
DBalance.Company_Id = iiCompanyId AND
DBalance.Debtor_ID = iiDebtor_ID AND
DBalance.Currency_ID = iiCurrency_ID AND
DBalance.DBalance_ID = iiDBalance_ID
query resultset tqDBalanceByCyDebtorCurrID
| field name | data type | db field | description |
|---|
| tdDBalanceCC | decimal | DBalance.DBalanceCC | SC Balance |
| tdDBalanceLC | decimal | DBalance.DBalanceLC | BC Balance |
| tdDBalanceTC | decimal | DBalance.DBalanceTC | TC Balance |
| tiDBalance_ID | integer | DBalance.DBalance_ID | Record ID |
| tiCompany_ID | integer | DBalance.Company_ID | Link to Company |
| tiDebtor_ID | integer | DBalance.Debtor_ID | Link to Debtor |
| tiCurrency_ID | integer | DBalance.Currency_ID | Link to Currency |
Internal usage
QadFinancials