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

VIEW: XTR.XTR_FUTURES#

Object Details
Object Name: XTR_FUTURES#
Object Type: VIEW
Owner: XTR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APR_YN VARCHAR2 (1)
AUDIT_INDICATOR VARCHAR2 (1)
AUG_YN VARCHAR2 (1)
AUTHORISED VARCHAR2 (1) Yes
CALCULATION_TYPE VARCHAR2 (7)
CONTRACT_CODE VARCHAR2 (7) Yes
CONTRACT_CONFO VARCHAR2 (1)
CONTRACT_DAYS NUMBER

CONTRACT_DESCRIPTION VARCHAR2 (50) Yes
CONTRACT_YEARS NUMBER

CONTRA_CURRENCY VARCHAR2 (15)
COUPONS_PER_YEAR NUMBER

COUPON_RATE NUMBER

CREATED_BY VARCHAR2 (30) Yes
CREATED_ON DATE
Yes
CURRENCY VARCHAR2 (15)
DEC_YN VARCHAR2 (1)
DELIVERABLE VARCHAR2 (1) Yes
EX_CODE VARCHAR2 (7) Yes
FEB_YN VARCHAR2 (1)
FINANCIAL_CONTRACT VARCHAR2 (1) Yes
JAN_YN VARCHAR2 (1)
JUL_YN VARCHAR2 (1)
JUN_YN VARCHAR2 (1)
MAR_YN VARCHAR2 (1)
MAY_YN VARCHAR2 (1)
NOV_YN VARCHAR2 (1)
OCT_YN VARCHAR2 (1)
PRICING_BASIS VARCHAR2 (7) Yes
ROUNDING_FACTOR NUMBER
Yes
SEP_YN VARCHAR2 (1)
SETTLEMENT_ADJUSTMENT NUMBER
Yes
TERMINATION_DATE NUMBER

TERMINATION_DAY VARCHAR2 (3)
TERMINATION_WEEK NUMBER

TICK_VALUE NUMBER

TOTAL_COUPONS NUMBER

UNIT_SIZE NUMBER
Yes
UPDATED_BY VARCHAR2 (30)
UPDATED_ON DATE

YEAR_BASIS NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT APR_YN
,      AUDIT_INDICATOR
,      AUG_YN
,      AUTHORISED
,      CALCULATION_TYPE
,      CONTRACT_CODE
,      CONTRACT_CONFO
,      CONTRACT_DAYS
,      CONTRACT_DESCRIPTION
,      CONTRACT_YEARS
,      CONTRA_CURRENCY
,      COUPONS_PER_YEAR
,      COUPON_RATE
,      CREATED_BY
,      CREATED_ON
,      CURRENCY
,      DEC_YN
,      DELIVERABLE
,      EX_CODE
,      FEB_YN
,      FINANCIAL_CONTRACT
,      JAN_YN
,      JUL_YN
,      JUN_YN
,      MAR_YN
,      MAY_YN
,      NOV_YN
,      OCT_YN
,      PRICING_BASIS
,      ROUNDING_FACTOR
,      SEP_YN
,      SETTLEMENT_ADJUSTMENT
,      TERMINATION_DATE
,      TERMINATION_DAY
,      TERMINATION_WEEK
,      TICK_VALUE
,      TOTAL_COUPONS
,      UNIT_SIZE
,      UPDATED_BY
,      UPDATED_ON
,      YEAR_BASIS
FROM XTR.XTR_FUTURES#;

Dependencies

[top of page]

XTR.XTR_FUTURES# references the following:

SchemaXTR
TableXTR_FUTURES
XTR.XTR_FUTURES# is referenced by following:

SchemaAPPS
SynonymXTR_FUTURES