business logic query CurrencyByCurrRoundingMethod

Description

Simple query on tables Currency and RoundingMethod that only returns the main properties of both tables - not the translatable descriptions on both tables!
Keep this query as simple as possible as this is used by some ancestor-classes and by classes that are called or used frequently!!!!!!

Parameters

iiCurrencyID	integer
icCurrencyCode	character
icRoundingMethodCode	character

query condition

each Currency where

Currency.Currency_ID = iiCurrencyID AND
Currency.CurrencyCode = icCurrencyCode

first RoundingMethod (inner-join) where

RoundingMethod.RoundingMethod_ID = Currency.RoundingMethod_ID AND
RoundingMethod.RoundingMethodCode = icRoundingMethodCode

query sort order

Currency.CurrencyCode (ascending)

query resultset tqCurrencyByCurrRoundingMethod

field name	data type	db field	description
tiCurrencyNumberOfDecimals	integer	Currency.CurrencyNumberOfDecimals	Number of Decimals
tiCurrency_ID	integer	Currency.Currency_ID	Record ID
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiRoundingMethod_ID	integer	RoundingMethod.RoundingMethod_ID	Record ID
tcRoundingMethodCode	character	RoundingMethod.RoundingMethodCode	Code
tdRoundingMethodUnit	decimal	RoundingMethod.RoundingMethodUnit	Unit
tdRoundingMethodThreshold	decimal	RoundingMethod.RoundingMethodThreshold	Threshold
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Currency),rowid(RoundingMethod)

Internal usage

QadFinancials

method business.RoundAmount
method BCDocument.AdditionalUpdatesPostingRounding
method BCInvoice.CreateCIPostingValidate
method BDDocument.AdditionalUpdatesPostingRounding
method BDInvoice.CreateDIPostingValidate
method BPosting.AdditionalUpdatesPostFallBack
method BPosting.CreateRoundingPosting
method BPosting.ValidateComponentPreBalancePosting
method BMfgDomain.AdditionalUpdatesCopyDomainCtrlTables
method BMfgSystemAccountControl.PerformMfgUpdate
method BMfgSystemAccountControl.UpdateMfgData
method BMfgSystemAccountControl.UpdateRndMthd
method BRoundingMethod.ValidateComponent
method Session.GetDecimalSettings