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