project QadFinancials > class BCreditorBalance > business logic query CBalanceByCompanyCreditorCurr

Description

CBalanceByCompanyCreditorCurr: Query on CBalance with filtering-options on the Code and ID for the Company, Currency and Creditor


Parameters


iiCompanyIDintegerCompany id
iiCreditorIDintegerCreditor_ID
iiCurrencyIDintegerCurrency ID
iiCBalanceIDintegerCBalance_ID
icCompanyCodecharacterCompanyCode
icCreditorCodecharacterCreditorCode
icCurrencyCodecharacterCurrencyCode


query condition


  each CBalance where
CBalance.Company_Id = iiCompanyId AND
CBalance.Creditor_ID = iiCreditorID AND
CBalance.Currency_ID = iiCurrencyID AND
CBalance.CBalance_ID = iiCBalanceID

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = CBalance.Company_ID AND
Company.CompanyCode = icCompanyCode

      first Creditor (inner-join) where
Creditor.SharedSet_Id = vi_CREDITOR_sharedset(iiCompanyId) AND
Creditor.Creditor_ID = CBalance.Creditor_ID AND
Creditor.CreditorCode = icCreditorCode

      first Currency (inner-join) where
Currency.Currency_ID = CBalance.Currency_ID AND
Currency.CurrencyCode = icCurrencyCode


query resultset tqCBalanceByCompanyCreditorCurr


field namedata typedb fielddescription
tiCBalance_IDintegerCBalance.CBalance_IDRecord ID
tiCompany_IDintegerCBalance.Company_IDLink to Company
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiCreditor_IDintegerCBalance.Creditor_IDLink to Creditor
tcCreditorCodecharacterCreditor.CreditorCodeSupplier Code
tiCurrency_IDintegerCBalance.Currency_IDLink to Currency
tcCurrencyCodecharacterCurrency.CurrencyCodeCurrency Code


Internal usage


QadFinancials
method BCreditorBalance.RebuildHistory