Daily Rates

The daily rates view object is used to perform foreign currency journal conversions. It contains the rate to use when converting between two currencies for a given conversion date and conversion type. Each row in this view object has a corresponding inverse row in which the from and to currencies are switched. The combination of DailyRateConversionDate, DailyRateToCurrency, DailyRateFromCurrency and DailyRateConversionType forms the unique identifier of the Daily Rates view object.

Data Store Key : FscmTopModelAM.FinExtractAM.GlBiccExtractAM.DailyRateExtractPVO

Primary Keys : DailyRateConversionDate, DailyRateConversionType, DailyRateToCurrency, DailyRateFromCurrency

Initial Extract Date : DailyRateCreationDate

Incremental Extract Date : DailyRateLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
DailyRateAttribute1 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute10 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute11 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute12 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute13 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute14 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute15 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute2 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute3 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute4 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute5 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute6 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute7 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute8 A segment for the Daily Rates descriptive flexfield.
DailyRateAttribute9 A segment for the Daily Rates descriptive flexfield.
DailyRateAttributeCategory The descriptive flexfield context name for the Daily Rates descriptive flexfield.
DailyRateAttributeDate1 A date segment for the Daily Rates descriptive flexfield.
DailyRateAttributeDate2 A date segment for the Daily Rates descriptive flexfield.
DailyRateAttributeDate3 A date segment for the Daily Rates descriptive flexfield.
DailyRateAttributeDate4 A date segment for the Daily Rates descriptive flexfield.
DailyRateAttributeDate5 A date segment for the Daily Rates descriptive flexfield.
DailyRateAttributeNumber1 A number segment for the Daily Rates descriptive flexfield.
DailyRateAttributeNumber2 A number segment for the Daily Rates descriptive flexfield.
DailyRateAttributeNumber3 A number segment for the Daily Rates descriptive flexfield.
DailyRateAttributeNumber4 A number segment for the Daily Rates descriptive flexfield.
DailyRateAttributeNumber5 A number segment for the Daily Rates descriptive flexfield.
DailyRateConversionDate The date when the currency conversion takes place. This attribute is a part of the composite key of the Daily Rates view object.
DailyRateConversionRate The rate used for currency conversion between the DailyRateFromCurrency and DailyRateToCurrency attributes.
DailyRateConversionType The rate type used for currency conversion. This is a foreign key to the Daily Conversion Types view object. This attribute is a part of the composite key of the Daily Rates view object.
DailyRateCreatedBy The user who created the daily rate.
DailyRateCreationDate The date and time when the daily rate was created.
DailyRateFromCurrency The source currency applicable to the conversion rate. The amount denominated in the from or source currency multiplied by the conversion rate gives the amount denominated in the to or target currency.
DailyRateLastUpdateDate The date when the daily rate row was last updated.
DailyRateLastUpdateLogin The session login associated with the user who last updated the daily rate.
DailyRateLastUpdatedBy The user who last updated the daily rate.
DailyRateObjectVersionNumber The number of times the daily rate row has been updated.
DailyRateStatusCode Indicates the status of the daily rates. It can have three possible values: C, O, D. C indicates that the daily rate isn't used by any ledger that has average-balances enabled. O indicates that the daily rate is used by at least one ledger that has average balances enabled. D indicates an interim state during the import process and signifies that the daily rate has to be deleted.
DailyRateToCurrency The target currency applicable to the conversion rate. This attribute is a part of the composite key of the Daily Rates view object.