GL_DAILY_RATES_INTERFACE
GL_DAILY_RATES_INTERFACE is used to create, update, and delete daily conversion rates. You can use this table to load rates into the GL_DAILY_RATES table. To use this table to insert/update rates into GL_DAILY_RATES, insert rows into it with a FROM_CURRENCY, a TO_CURRENCY, a FROM_CONVERSION_DATE, a TO_CONVERSION_DATE, a USER_CONVERSION_TYPE, a CONVERSION_RATE, a MODE of 'I', and optionally, an INVERSE_CONVERSION_RATE. Oracle General Ledger will automatically create rows in GL_DAILY_RATES for each date between the FROM_CONVERSION_DATE and the TO_CONVERSION_DATE, using the specified FROM_CURRENCY, TO_CURRENCY, USER_CONVERSION_TYPE, and CONVERSION_RATE. It will also automatically insert the inverse rows, switching the FROM_CURRENCY and TO_CURRENCY and using the INVERSE_CONVERSION_RATE, if provided, or otherwise, taking the inverse of the CONVERSION_RATE provided. If these rows already exist, it will update these rows with the new rates instead. For example, if you specified a FROM_CURRENCY of USD, a TO_CURRENCY of CND, a FROM_CONVERSION_DATE of January 1, 1997, a TO_CONVERSION_DATE of January 3, 1997, a USER_CONVERSION_TYPE of Spot, a CONVERSION_RATE of 1.377, an INVERSION_CONVERSION_RATE of NULL, and a MODE of 'I', Oracle General Ledger will automatically create three rows in GL_DAILY_RATES with a FROM_CURRENCY of USD, a TO_CURRENCY of CND, a CONVERSION_TYPE of Spot, a CONVERSION_RATE of 1.377, and with CONVERSION_DATEs of January 1, 1997, January 2, 1997, and January 3, 1997. It would also automatically create the three inverse rows in GL_DAILY_RATES with a FROM_CURRENCY of CND, a TO_CURRENCY of USD, a CONVERSION_TYPE of Spot, a CONVERSION_RATE of 0.7262, and with CONVERSION_DATEs of January 1, 1997, January 2, 1997, and January 3, 1997. To use this table to delete rows from GL_DAILY_RATES, insert rows into it with a FROM_CURRENCY, a TO_CURRENCY, a FROM_CONVERSION_DATE, a TO_CONVERSION_DATE, a USER_CONVERSION_TYPE, a dummy CONVERSION_RATE, and a MODE of 'D'. Any rates in GL_DAILY_RATES with a date between the FROM_CONVERSION_DATE and TO_CONVERSION_DATE and with that FROM_CURRENCY, TO_CURRENCY, and USER_CONVERSION_TYPE will be deleted automatically. The corresponding inverse rows will also be deleted. The insert/update/delete is all done automatically by database triggers on GL_DAILY_RATES_INTERFACE. No import programs need to be run. Note that when inserting into this table, you must specify the USER_CONVERSION_TYPE, not the CONVERSION_TYPE. Oracle General Ledger will automatically convert the USER_CONVERSION_TYPE to the CONVERSION_TYPE when it maintains GL_DAILY_RATES. Scope: public Product: GL Lifecycle: active Display Name: GL Daily Rate Interface Category: BUSINESS_ENTITY GL_DAILY_RATE @rep:ihelp GL/@t_drt_auto#t_drt_auto Loading Daily Rates Automatically Using the GL_DAILY_RATES_INTERFACE table, Oracle General Ledger Help
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
Name | Columns |
---|---|
GL_DAILY_RATES_INTERFACE_PK |
FROM_CURRENCY, TO_CURRENCY, FROM_CONVERSION_DATE, TO_CONVERSION_DATE, USER_CONVERSION_TYPE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
FROM_CURRENCY | VARCHAR2 | 15 | Yes | From currency code of daily rate. | |
TO_CURRENCY | VARCHAR2 | 15 | Yes | To currency code of daily rate. | |
FROM_CONVERSION_DATE | DATE | Yes | Start of date range for which this rate is valid. | ||
TO_CONVERSION_DATE | DATE | Yes | End of date range for which this rate is valid. | ||
USER_CONVERSION_TYPE | VARCHAR2 | 30 | Yes | User entered currency conversion type. | |
CONVERSION_RATE | NUMBER | Yes | User entered currency conversion rate. | ||
MODE_FLAG | VARCHAR2 | 1 | Yes | Import mode ('D' - delete any matching rows from gl_daily_rates, 'I' - insert or update rows in gl_daily_rates, and 'X' - invalid row). | |
INVERSE_CONVERSION_RATE | NUMBER | Inverse of the currency conversion rate. | |||
USER_ID | NUMBER | 18 | Identifier of the user who is adding the rows. | ||
LAUNCH_RATE_CHANGE | VARCHAR2 | 1 | Automatically launch rate change program flag. | ||
ERROR_CODE | VARCHAR2 | 30 | Error code for unsuccessful rows. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
USED_FOR_AB_TRANSLATION | VARCHAR2 | 1 | Used for internal processing. Do not put a value into this column. | ||
LOAD_REQUEST_ID | NUMBER | Oracle Enterprise Scheduler: request identifier of the job that created the row. | |||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
ENTERPRISE_ID | NUMBER | 18 | Enterprise or business group identifier. | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
GL_DAILY_RATES_INTERFACE_N1 | Non Unique | Default | FROM_CURRENCY, TO_CURRENCY, USER_CONVERSION_TYPE |