[Home] [Help] [Dependency Information]
Object Name: | CE_CP_WORKSHEET_LINES |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_CP_WORKSHEET_LINES |
Subobject Name: | |
Status: | VALID |
This table stores the Cash Position worksheet details
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_CP_WORKSHEET_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | WORKSHEET_LINE_ID |
CE_CP_WORKSHEET_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
WORKSHEET_HEADER_ID
SOURCE_TYPE |
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 |
SOURCE_TYPE | VARCHAR2 | (15) | Yes | Transaction source type |
INCLUDE_FLAG | VARCHAR2 | (1) | Yes | Flag to show if the line should be included in the Cash Position result |
DESCRIPTION | VARCHAR2 | (80) | Yes | Description |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier | |
BANK_NAME | VARCHAR2 | (60) | Bank name | |
BANK_ACCOUNT_ID | NUMBER | (15) | Bank account identifier | |
BALANCE_TYPE | VARCHAR2 | (15) | Balance type, CE lookup type BANK_ACC_BAL_TYPE | |
FLOAT_TYPE | VARCHAR2 | (15) | Float type, CE lookup type FLOAT_TYPE | |
TRX_TYPE | VARCHAR2 | (30) | Transaction type | |
PAYMENT_METHOD | VARCHAR2 | (25) | Payment method for APP and PAY | |
RECEIPT_METHOD_ID | NUMBER | (15) | Payment method for ARR | |
CLEARED_TRX_FLAG | VARCHAR2 | (1) | Include cleared transactions? (Y/N) | |
OVERDUE_TRX_FLAG | VARCHAR2 | (1) | Include overdue transactions? (Y/N) | |
CUT_OFF_DAYS | NUMBER | Cut off days | ||
EXT_SOURCE_TYPE | VARCHAR2 | (30) | External source type for open interface | |
AMOUNT | NUMBER | Amount for user-defined transactions | ||
PAYROLL_ID | NUMBER | (15) | Payroll identifier | |
INDICATIVE_FLAG | VARCHAR2 | (1) | Include indicative exposures for XTR? (Y/N) | |
CRITERIA_CATEGORY | VARCHAR2 | (30) | External source type descriptive flexfield structure definition column | |
CRITERIA1 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA2 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA3 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA4 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA5 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA6 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA7 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA8 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA9 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA10 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA11 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA12 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA13 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA14 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
CRITERIA15 | VARCHAR2 | (150) | External source type descriptive flexfield segment | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CASHPOOL_ID | NUMBER | (15) | Cash pool identifier | |
TRXN_SUBTYPE_CODE_ID | NUMBER | (15) | Transaction subtype for Cash Management infows and outflows |
Cut, paste (and edit) the following text to query this object:
SELECT WORKSHEET_HEADER_ID
, WORKSHEET_LINE_ID
, SOURCE_TYPE
, INCLUDE_FLAG
, DESCRIPTION
, LEGAL_ENTITY_ID
, BANK_NAME
, BANK_ACCOUNT_ID
, BALANCE_TYPE
, FLOAT_TYPE
, TRX_TYPE
, PAYMENT_METHOD
, RECEIPT_METHOD_ID
, CLEARED_TRX_FLAG
, OVERDUE_TRX_FLAG
, CUT_OFF_DAYS
, EXT_SOURCE_TYPE
, AMOUNT
, PAYROLL_ID
, INDICATIVE_FLAG
, CRITERIA_CATEGORY
, CRITERIA1
, CRITERIA2
, CRITERIA3
, CRITERIA4
, CRITERIA5
, CRITERIA6
, CRITERIA7
, CRITERIA8
, CRITERIA9
, CRITERIA10
, CRITERIA11
, CRITERIA12
, CRITERIA13
, CRITERIA14
, CRITERIA15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CASHPOOL_ID
, TRXN_SUBTYPE_CODE_ID
FROM CE.CE_CP_WORKSHEET_LINES;
CE.CE_CP_WORKSHEET_LINES does not reference any database object
CE.CE_CP_WORKSHEET_LINES is referenced by following:
|
|
|