project QadFinancials > class BDCollection > business logic query DCollectionByIDBalanceTC

Description

DCollectionByIDBalanceTC; query that only works on table DCollection and that has a condition on DCollectionID and on Balance. The check on balance is true if the balance is either credit, either debit. The check on BalanceTC is done on the ABSOLUTE() function of the db-field.
Please do not add fields or joins to this query: is should stay as simple as possible.

Parameters


iiCompanyIdintegerCompany id
iiDCollectionIDintegerDCollectionID
idDCollectionBalanceTCdecimalDCollectionBalanceTC

query condition


  each DCollection where
DCollection.Company_Id = iiCompanyId AND
DCollection.DCollection_ID = iiDCollectionID AND
ABSOLUTE(DCollection.DCollectionBalanceTC) = idDCollectionBalanceTC

query resultset tqDCollectionByIDBalanceTC


field namedata typedb fielddescription
tiCompany_IDintegerDCollection.Company_IDLink to Company
tiDCollection_IDintegerDCollection.DCollection_IDRecord ID
tcDCollectionNamecharacterDCollection.DCollectionNameName
tiDCollectionNumberintegerDCollection.DCollectionNumberNumber
tdDCollectionBalanceTCdecimalDCollection.DCollectionBalanceTCTC Balance

Internal usage


QadFinancials
method BBankEntry.AdditionalUpdatesInvOptimisticLock