[Home] [Help]
[Dependency Information]
| Object Name: | XTR_STOCK_CASH_DIVIDENDS |
|---|---|
| Object Type: | TABLE |
| Owner: | XTR |
| FND Design Data: | XTR.XTR_STOCK_CASH_DIVIDENDS
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: | APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| XTR_STOCK_CASH_DIVIDENDS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
CASH_DIVIDEND_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CASH_DIVIDEND_ID | NUMBER | Yes | Unique identifier for each row of the table | |
| STOCK_ISSUE_CODE | VARCHAR2 | (30) | Yes | Stock issue code |
| DECLARE_DATE | DATE | Yes | The announcement date of the cash dividend | |
| RECORD_DATE | DATE | Yes | The date or record for cash dividend | |
| PAYMENT_DATE | DATE | The payment date of cash dividend | ||
| DIVIDEND_PER_SHARE | NUMBER | Yes | Cash dividend per stock share | |
| CURRENCY | VARCHAR2 | (15) | Yes | Currency of the stock issue |
| GENERATED_FLAG | VARCHAR2 | (1) | To specify whether the cash dividend | |
| CREATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who colum | ||
| LAST_UPDATED_BY | NUMBER | Standard Who colum | ||
| LAST_UPDATE_DATE | DATE | Standard Who colum | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who colum |
Cut, paste (and edit) the following text to query this object:
SELECT CASH_DIVIDEND_ID
, STOCK_ISSUE_CODE
, DECLARE_DATE
, RECORD_DATE
, PAYMENT_DATE
, DIVIDEND_PER_SHARE
, CURRENCY
, GENERATED_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM XTR.XTR_STOCK_CASH_DIVIDENDS;
XTR.XTR_STOCK_CASH_DIVIDENDS does not reference any database object
XTR.XTR_STOCK_CASH_DIVIDENDS is referenced by following:
XTR
XTR_STOCK_CASH_DIVIDENDS#
|
|
|
|