DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_REVALUATION_RATES

Object Details
Object Name: XTR_REVALUATION_RATES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_REVALUATION_RATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
Columns
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.
Query Text

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;

Dependencies

[top of page]

XTR.XTR_REVALUATION_RATES does not reference any database object

XTR.XTR_REVALUATION_RATES is referenced by following:

SchemaXTR
ViewXTR_REVALUATION_RATES#