[Home] [Help]
[Dependency Information]
Object Name: | XTR_BOND_COUPON_DATES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
XTR_BOND_COUPON_DATES contains the coupon dates for bond issues. Each row contains a coupon date and the bond issue for which the date was generated. Oracle Treasury uses these dates to calculate bond prices or yields.
This table corresponds to the Coupon Dates tabbed region of the Bond Issues window.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_BOND_COUPON_DATES_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOND_ISSUE_CODE | VARCHAR2 | (7) | Yes | Reference to a bond issue |
COUPON_DATE | DATE | Yes | Date that a coupon is paid or received | |
RATE_FIXING_DATE | DATE | Rate fixing date | ||
RATE | NUMBER | Coupon rate | ||
DUE_DATE | DATE | Coupon due date | ||
START_DATE | DATE | Coupon start date | ||
RATE_UPDATE_ON | DATE | The last date on which coupon rate is updated |
Cut, paste (and edit) the following text to query this object:
SELECT BOND_ISSUE_CODE
, COUPON_DATE
, RATE_FIXING_DATE
, RATE
, DUE_DATE
, START_DATE
, RATE_UPDATE_ON
FROM XTR.XTR_BOND_COUPON_DATES;
XTR.XTR_BOND_COUPON_DATES does not reference any database object
XTR.XTR_BOND_COUPON_DATES is referenced by following:
|
|
|