[Home] [Help] [Dependency Information]
Object Name: | FEM_CUST_SHARE_PRICES |
---|---|
Object Type: | TABLE |
Owner: | FEM |
Subobject Name: | |
Status: | VALID |
Customer Share Prices
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FEM_CUST_SHARE_PRICES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CAL_PERIOD_ID
DATASET_CODE SOURCE_SYSTEM_CODE LEDGER_ID CUSTOMER_ID STOCK_IDENTIFIER |
FEM_CUST_SHARE_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 | |
STOCK_IDENTIFIER | VARCHAR2 | (50) | Yes | Unique Committee on Uniform Security value that identifies a security |
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 | |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency Code |
PRICE | NUMBER | Value of Share Price. | ||
SHARE_PRICE_DATE | DATE | Share Price Date | ||
STOCK_TYPE_CODE | VARCHAR2 | (30) | Type of stock: Common, Preferred | |
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
, STOCK_IDENTIFIER
, CREATED_BY_OBJECT_ID
, CREATED_BY_REQUEST_ID
, LAST_UPDATED_BY_OBJECT_ID
, LAST_UPDATED_BY_REQUEST_ID
, CURRENCY_CODE
, PRICE
, SHARE_PRICE_DATE
, STOCK_TYPE_CODE
, 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_SHARE_PRICES;
FEM.FEM_CUST_SHARE_PRICES does not reference any database object
FEM.FEM_CUST_SHARE_PRICES is referenced by following:
|
|
|