project QadFinancials > class BExchangeRateType > business logic query ExchangeRateTypePrim

Description

Query on Exchange Rate Type to convert ID from and to logical prim key


Parameters


iiExchangeRateTypeIdintegerthe Exchange Rate Type ID
icExchangeRateTypeCodecharacterthe exchange rate type code


query condition


  each ExchangeRateType where
ExchangeRateType.ExchangeRateType_ID = iiExchangeRateTypeId AND
ExchangeRateType.ExchangeRateTypeCode = icExchangeRateTypeCode


query sort order


ExchangeRateType.ExchangeRateTypeCode (ascending)


query resultset tqExchangeRateTypePrim


field namedata typedb fielddescription
tcExchangeRateTypeCodecharacterExchangeRateType.ExchangeRateTypeCodeA code identifying an exchange rate type. A number of types are predefined and required by the system.
tiExchangeRateType_IDintegerExchangeRateType.ExchangeRateType_IDRecord ID


Internal usage


QadFinancials
method BExchangeRate.ApiGetAverageExchangeRate
method BExchangeRate.ApiSaveDerivedExchangeRates
method BExchangeRate.DataLoadByInput
method BExchangeRate.InitialValues
method BExchangeRate.PreValidateComponent
method BExchangeRateType.DataLoadByInput
method BGL.ApiLoadGL
method BGL.ApiLoadGLCalcExchangeRateTypeCode
method BProject.ApiLoadProject
method BProject.ApiLoadProjectCalcExchangeRateTypeCode
method TExchangeRate.ApiGetExchangeRate
read related business field(s) on tExchangeRate.ExchangeRateType_ID
read related business field(s) on tGL.UsrDefExchangeRateType_ID
read related business field(s) on tGLConsolidCy.ExchangeRateType_ID
read related business field(s) on tProject.ExchangeRateType_ID
read related business field(s) on tRevalGL.TCExchangeRateType_ID
read related business field(s) on tRevalGL.CCExchangeRateType_ID
read related business field(s) on tRevalRate.ExchangeRateType_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tGL.UsrDefExchangeRateType_ID
validate related business field(s) on tGLConsolidCy.ExchangeRateType_ID
validate related business field(s) on tProject.ExchangeRateType_ID
validate related business field(s) on tRevalGL.TCExchangeRateType_ID
validate related business field(s) on tRevalGL.CCExchangeRateType_ID
validate related business field(s) on tRevalRate.ExchangeRateType_ID