[Home] [Help] [Dependency Information]
Object Name: | BIL_BI_CURRENCY_RATE |
---|---|
Object Type: | TABLE |
Owner: | BIL |
FND Design Data: | BIL.BIL_BI_CURRENCY_RATE |
Subobject Name: | |
Status: | VALID |
Interface table to store the currency conversion rate from transaction currency to BIS Primary Global Currency. Currency rates are obtained from FII and GL APIs. The interface table is used in base summary concurrent program for better performance.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIL_BI_CURRENCY_RATE_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
CURRENCY_CODE
EXCHANGE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Transaction Currency code |
EXCHANGE_DATE | DATE | Yes | Date of the currency conversion | |
EXCHANGE_RATE | NUMBER | Currency conversion rate from transaction currency to BIS Primary Global Currency | ||
EXCHANGE_RATE_S | NUMBER | Currency conversion rate from transaction currency to BIS Secondary Global Currency |
Cut, paste (and edit) the following text to query this object:
SELECT CURRENCY_CODE
, EXCHANGE_DATE
, EXCHANGE_RATE
, EXCHANGE_RATE_S
FROM BIL.BIL_BI_CURRENCY_RATE;
BIL.BIL_BI_CURRENCY_RATE does not reference any database object
BIL.BIL_BI_CURRENCY_RATE is referenced by following:
|
|
|