[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_MASTER_CURRENCIES |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: |  XTR.XTR_MASTER_CURRENCIES
|
| Subobject Name: | |
| Status: | VALID |
XTR_MASTER_CURRENCIES contains currency characteristics information which includes net maximum exposure, quotation basis, and year basis. Each row corresponds to a currency. All currencies in this table are derived from FND_CURRENCIES. All other currency columns in Treasury tables derive their currency values from this table, including the following tables: XTR_INTEREST_RATE_BANDS, XTR_INTEREST_RATE_POLICY, XTR_BUY_SELL_COMBINATION, XTR_HOLIDAY_RULES, and XTR_BANK_ACCOUNTS.
This table corresponds to the Currency Authorization region of the Currency Details and Add / Maintain Currency Details windows.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_MASTER_CURRENCIES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CURRENCY
ZD_EDITION_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
| AUTHORISED | VARCHAR2 | (1) | Yes | Flag to indicate if the currency is authorized for use (Y), or not (N) |
| CALCULATE_HOLS_YEARS | NUMBER | Number of years forward to calculate holiday dates | ||
| CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
| CREATED_ON | DATE | Yes | Date this record was created | |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
| CURRENT_SPOT_RATE | NUMBER | Current spot rate | ||
| DIVIDE_OR_MULTIPLY | VARCHAR2 | (1) | Yes | Flag that determines whether the spot rate calculation of a forward foreign exchange rate should be division (/) or multiplication (*) |
| FX_SEQ_NO | NUMBER | Sequence number that determines the currency ordering in the LOV's of foreign exchange forms | ||
| HCE_RATE | NUMBER | Conversion rate to the reporting currency | ||
| IR_SEQ_NO | NUMBER | Sequence number that determines the currency ordering in the LOVs of money market forms | ||
| LAST_TRANSACTION_CHANGED | DATE | Date on which a currency combination monitor status is changed | ||
| MAXIMUM_BAND | NUMBER | Maximum foreign exchange coverage percentage | ||
| MAX_DAYS_CONTRACT | NUMBER | Not currently used | ||
| MINIMUM_BAND | NUMBER | Minimum foreign exchange coverage percentage | ||
| NAME | VARCHAR2 | (20) | Yes | Currency description |
| NET_FX_EXPOSURE | NUMBER | Foreign exchange exposure limit | ||
| RATE_DATE | DATE | Date the rate is based on | ||
| ROUNDING_FACTOR | NUMBER | Rounding factor used in revaluation of foreign exchange forward agreements | ||
| SPOT_DATE | DATE | Date the conversion rate to reporting currency was last updated | ||
| UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
| UPDATED_ON | DATE | Date this record was last updated | ||
| USD_BASE_CURR_BID_RATE | NUMBER | Foreign exchange rate bid price against the US dollar | ||
| USD_BASE_CURR_OFFER_RATE | NUMBER | Foreign exchange rate offer price against the US dollar | ||
| USD_QUOTED_SPOT | NUMBER | Spot rate against the US dollar | ||
| UTILISED_AMOUNT | NUMBER | Total amount that deal transactions have applied to the limit | ||
| YEAR_BASIS | NUMBER | Yes | Number of days in a year used in calculations (for example, 360 and 365) | |
| IG_YEAR_BASIS | VARCHAR2 | (15) | Currency year basis | |
| GL_CALENDAR_NAME | VARCHAR2 | (25) | Specifies the GL calendar for determining weekends | |
| GL_NO_UPLOAD | VARCHAR2 | (1) | Indicates that the spot rate is not to be uploaded to GL | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, CALCULATE_HOLS_YEARS
, CREATED_BY
, CREATED_ON
, CURRENCY
, CURRENT_SPOT_RATE
, DIVIDE_OR_MULTIPLY
, FX_SEQ_NO
, HCE_RATE
, IR_SEQ_NO
, LAST_TRANSACTION_CHANGED
, MAXIMUM_BAND
, MAX_DAYS_CONTRACT
, MINIMUM_BAND
, NAME
, NET_FX_EXPOSURE
, RATE_DATE
, ROUNDING_FACTOR
, SPOT_DATE
, UPDATED_BY
, UPDATED_ON
, USD_BASE_CURR_BID_RATE
, USD_BASE_CURR_OFFER_RATE
, USD_QUOTED_SPOT
, UTILISED_AMOUNT
, YEAR_BASIS
, IG_YEAR_BASIS
, GL_CALENDAR_NAME
, GL_NO_UPLOAD
, ZD_EDITION_NAME
FROM XTR.XTR_MASTER_CURRENCIES;
XTR.XTR_MASTER_CURRENCIES does not reference any database object
XTR.XTR_MASTER_CURRENCIES is referenced by following:
XTR
XTR_MASTER_CURRENCIES#
|
|
|
|