[Home] [Help] [Dependency Information]
Object Name: | FEM_CUST_BOND_PRICES |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Customer Bond Prices
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_CUST_BOND_PRICES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_PERIOD_ID
DATASET_CODE SOURCE_SYSTEM_CODE LEDGER_ID CUSTOMER_ID BOND_ID |
FEM_CUST_BOND_PRICES_01 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CREATED_BY_REQUEST_ID
CREATED_BY_OBJECT_ID CUSTOMER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CAL_PERIOD_ID | NUMBER | Yes | Calendar Period | |
DATASET_CODE | NUMBER | Yes | Dataset Code | |
SOURCE_SYSTEM_CODE | NUMBER | Yes | Source System | |
LEDGER_ID | NUMBER | Yes | Ledger | |
CUSTOMER_ID | NUMBER | Yes | Unique numeric identifier of the Customer | |
BOND_ID | VARCHAR2 | (50) | Yes | Identifier of each bond |
CREATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Object that created the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID |
CREATED_BY_REQUEST_ID | NUMBER | Yes | Request that created the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID | |
LAST_UPDATED_BY_OBJECT_ID | NUMBER | (9) | Yes | Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID |
LAST_UPDATED_BY_REQUEST_ID | NUMBER | Yes | Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID | |
BOND_TYPE_CODE | VARCHAR2 | (30) | Yes | Type of Bond or Fixed Income Instrument |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
BOND_PRICE_DATE | DATE | Bond Pricing Date | ||
BOND_TERM | NUMBER | Original Term of Bond | ||
BOND_TERM_MULT | VARCHAR2 | (30) | Original Term multiplier of Bond | |
COUPON_RATE | NUMBER | Current Coupon Rate | ||
CURRENT_PRICE | NUMBER | Current Price of the Bond (Value) | ||
ISSUE_PRICE | NUMBER | Issue price of the Bond | ||
REDEMPTION_PRICE | NUMBER | Bond Redemption Price (Value) | ||
ALPHANUMERIC_MEASURE01 | VARCHAR2 | (4000) | Alphanumeric Measure1 | |
ALPHANUMERIC_MEASURE02 | VARCHAR2 | (4000) | Alphanumeric Measure2 | |
ALPHANUMERIC_MEASURE03 | VARCHAR2 | (4000) | Alphanumeric Measure3 | |
ALPHANUMERIC_MEASURE04 | VARCHAR2 | (4000) | Alphanumeric Measure4 | |
ALPHANUMERIC_MEASURE05 | VARCHAR2 | (4000) | Alphanumeric Measure5 | |
ALPHANUMERIC_MEASURE06 | VARCHAR2 | (4000) | Alphanumeric Measure6 | |
ALPHANUMERIC_MEASURE07 | VARCHAR2 | (4000) | Alphanumeric Measure7 | |
ALPHANUMERIC_MEASURE08 | VARCHAR2 | (4000) | Alphanumeric Measure8 | |
ALPHANUMERIC_MEASURE09 | VARCHAR2 | (4000) | Alphanumeric Measure9 | |
ALPHANUMERIC_MEASURE10 | VARCHAR2 | (4000) | Alphanumeric Measure10 | |
DATE_MEASURE01 | DATE | Date Measure1 | ||
DATE_MEASURE02 | DATE | Date Measure2 | ||
DATE_MEASURE03 | DATE | Date Measure3 | ||
DATE_MEASURE04 | DATE | Date Measure4 | ||
DATE_MEASURE05 | DATE | Date Measure5 | ||
DATE_MEASURE06 | DATE | Date Measure6 | ||
DATE_MEASURE07 | DATE | Date Measure7 | ||
DATE_MEASURE08 | DATE | Date Measure8 | ||
DATE_MEASURE09 | DATE | Date Measure9 | ||
DATE_MEASURE10 | DATE | Date Measure10 | ||
NUMERIC_MEASURE01 | NUMBER | Numeric Measure1 | ||
NUMERIC_MEASURE02 | NUMBER | Numeric Measure2 | ||
NUMERIC_MEASURE03 | NUMBER | Numeric Measure3 | ||
NUMERIC_MEASURE04 | NUMBER | Numeric Measure4 | ||
NUMERIC_MEASURE05 | NUMBER | Numeric Measure5 | ||
NUMERIC_MEASURE06 | NUMBER | Numeric Measure6 | ||
NUMERIC_MEASURE07 | NUMBER | Numeric Measure7 | ||
NUMERIC_MEASURE08 | NUMBER | Numeric Measure8 | ||
NUMERIC_MEASURE09 | NUMBER | Numeric Measure9 | ||
NUMERIC_MEASURE10 | NUMBER | Numeric Measure10 |
Cut, paste (and edit) the following text to query this object:
SELECT CAL_PERIOD_ID
, DATASET_CODE
, SOURCE_SYSTEM_CODE
, LEDGER_ID
, CUSTOMER_ID
, BOND_ID
, CREATED_BY_OBJECT_ID
, CREATED_BY_REQUEST_ID
, LAST_UPDATED_BY_OBJECT_ID
, LAST_UPDATED_BY_REQUEST_ID
, BOND_TYPE_CODE
, CURRENCY_CODE
, BOND_PRICE_DATE
, BOND_TERM
, BOND_TERM_MULT
, COUPON_RATE
, CURRENT_PRICE
, ISSUE_PRICE
, REDEMPTION_PRICE
, ALPHANUMERIC_MEASURE01
, ALPHANUMERIC_MEASURE02
, ALPHANUMERIC_MEASURE03
, ALPHANUMERIC_MEASURE04
, ALPHANUMERIC_MEASURE05
, ALPHANUMERIC_MEASURE06
, ALPHANUMERIC_MEASURE07
, ALPHANUMERIC_MEASURE08
, ALPHANUMERIC_MEASURE09
, ALPHANUMERIC_MEASURE10
, DATE_MEASURE01
, DATE_MEASURE02
, DATE_MEASURE03
, DATE_MEASURE04
, DATE_MEASURE05
, DATE_MEASURE06
, DATE_MEASURE07
, DATE_MEASURE08
, DATE_MEASURE09
, DATE_MEASURE10
, NUMERIC_MEASURE01
, NUMERIC_MEASURE02
, NUMERIC_MEASURE03
, NUMERIC_MEASURE04
, NUMERIC_MEASURE05
, NUMERIC_MEASURE06
, NUMERIC_MEASURE07
, NUMERIC_MEASURE08
, NUMERIC_MEASURE09
, NUMERIC_MEASURE10
FROM FEM.FEM_CUST_BOND_PRICES;
FEM.FEM_CUST_BOND_PRICES does not reference any database object
FEM.FEM_CUST_BOND_PRICES is referenced by following:
|
|
|