project QadFinancials > class BDebtorBalance > business logic query DBalanceByCyDebtorCurrID

Description

Prim-Query on DBalance


Parameters


iiCompanyIdintegerCompany id
iiDBalance_IDintegerDBalance_ID
iiDebtor_IDintegerCustomer ID
iiCurrency_IDintegerCurrency 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 namedata typedb fielddescription
tdDBalanceCCdecimalDBalance.DBalanceCCSC Balance
tdDBalanceLCdecimalDBalance.DBalanceLCBC Balance
tdDBalanceTCdecimalDBalance.DBalanceTCTC Balance
tiDBalance_IDintegerDBalance.DBalance_IDRecord ID
tiCompany_IDintegerDBalance.Company_IDLink to Company
tiDebtor_IDintegerDBalance.Debtor_IDLink to Debtor
tiCurrency_IDintegerDBalance.Currency_IDLink to Currency


Internal usage


QadFinancials
method BDebtorBalance.UpdateDBalanceAndDHist
method BDebtorBalance.UpdateDBalanceAndDHistDebtorHighCredit