[Home] [Help] [Dependency Information]
Object Name: | XTR_REVALUATION_RATES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_REVALUATION_RATES |
Subobject Name: | |
Status: | VALID |
XTR_REVALUATION_RATES contains general information about revaluation rates for a particular company in an end-of-period date. Each row contains the company code, currency, end-of-period date, and the revaluation contents, which includes the type, subtype, product type, rate, time frame, and rate type (rate/volatility). The primary key UNIQUE_REF_NUM is generated by Oracle Treasury. You may use this table to review and adjust revaluation rates. You can run the revaluation process to calculate your financial instruments' profits and losses. If you wish to adjust those results, you can then adjust your revaluation rates and recalculate your revaluations. This process continues until you are happy with the results at which time you can transfer the revaluation to General Ledger. The REVAL_TYPE column is derived from the RIC_CODE column in the XTR_MARKET_PRICES table for all deal types except for foreign exchange deals, bond options, interest rate options, and interest rate swaptions. For those deal types, the REVAL_TYPE column is pre-defined and is based on deal type and deal subtype.
This table corresponds to the Revaluations window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_REVALUATION_RATES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BATCH_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
COMPANY_CODE | VARCHAR2 | (7) | Yes | Company code |
CURRENCYA | VARCHAR2 | (15) | Yes | Base currency |
CURRENCYB | VARCHAR2 | (15) | Contra currency | |
DAY_MTH | VARCHAR2 | (13) | Period frequency type (days or months) | |
ENTERED_BY | VARCHAR2 | (30) | Yes | User who entered the revaluation details |
ENTERED_ON | DATE | Yes | Date the revaluation details was entered | |
NUMBER_OF_DAYS | NUMBER | Period frequency length converted to days | ||
PERIOD_FROM | DATE | Yes | Previous revaluation date | |
PERIOD_REF1 | NUMBER | Period length | ||
PERIOD_REF2 | NUMBER | Not currently used | ||
PERIOD_TO | DATE | Yes | Current revaluation date | |
RATE_DATE | DATE | Yes | Date the rate is set | |
REVAL_PRODUCT_TYPE | VARCHAR2 | (10) | No longer used. | |
REVAL_RATE | NUMBER | No longer used. | ||
REVAL_SUBTYPE | VARCHAR2 | (7) | No longer used. | |
REVAL_TYPE | VARCHAR2 | (20) | Yes | Revaluation type |
UNIQUE_REF_NUM | NUMBER | Yes | Unique reference number for revaluation rates | |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
VOLATILITY_OR_RATE | VARCHAR2 | (4) | Yes | Not currently used |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
BATCH_ID | NUMBER | (15) | Yes | Identifier that groups events into one process flow. |
BID | NUMBER | The bid rate. | ||
BID_OVERWRITE | NUMBER | The overwrite bid rate. | ||
ASK | NUMBER | The ask rate. | ||
ASK_OVERWRITE | NUMBER | The overwrite ask rate. | ||
DAY_COUNT_BASIS | VARCHAR2 | (30) | The day count basis. |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, COMPANY_CODE
, CURRENCYA
, CURRENCYB
, DAY_MTH
, ENTERED_BY
, ENTERED_ON
, NUMBER_OF_DAYS
, PERIOD_FROM
, PERIOD_REF1
, PERIOD_REF2
, PERIOD_TO
, RATE_DATE
, REVAL_PRODUCT_TYPE
, REVAL_RATE
, REVAL_SUBTYPE
, REVAL_TYPE
, UNIQUE_REF_NUM
, UPDATED_BY
, UPDATED_ON
, VOLATILITY_OR_RATE
, CREATED_BY
, CREATED_ON
, BATCH_ID
, BID
, BID_OVERWRITE
, ASK
, ASK_OVERWRITE
, DAY_COUNT_BASIS
FROM XTR.XTR_REVALUATION_RATES;
XTR.XTR_REVALUATION_RATES does not reference any database object
XTR.XTR_REVALUATION_RATES is referenced by following:
|
|
|