[Home] [Help] [Dependency Information]
Object Name: | CE_CP_WORKSHEET_USER_LINES |
---|---|
Object Type: | TABLE |
Owner: | CE |
Subobject Name: | |
Status: | VALID |
This table stores the Cash Position user defined flow information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_CP_WORKSHEET_USER_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
WORKSHEET_HEADER_ID
WORKSHEET_LINE_ID AS_OF_DATE BANK_ACCOUNT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKSHEET_HEADER_ID | NUMBER | (15) | Yes | Cash Position worksheet header identifier |
WORKSHEET_LINE_ID | NUMBER | (15) | Yes | Cash Position worksheet line identifier |
LINE_DESCRIPTION | VARCHAR2 | (80) | Line description | |
SOURCE_TYPE | VARCHAR2 | (15) | Yes | Transaction source type |
BANK_ACCOUNT_ID | NUMBER | (15) | Yes | Bank account identifier |
AS_OF_DATE | DATE | Yes | As of date | |
AMOUNT | NUMBER | Amount for user-defined transactions |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_HEADER_ID
, WORKSHEET_LINE_ID
, LINE_DESCRIPTION
, SOURCE_TYPE
, BANK_ACCOUNT_ID
, AS_OF_DATE
, AMOUNT
FROM CE.CE_CP_WORKSHEET_USER_LINES;
CE.CE_CP_WORKSHEET_USER_LINES does not reference any database object
CE.CE_CP_WORKSHEET_USER_LINES is referenced by following:
|
|
|