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. |