[Home] [Help] [Dependency Information]
Object Name: | CE_CASHPOOLS |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_CASHPOOLS |
Subobject Name: | |
Status: | VALID |
This table stores header information about the cash pool
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_CASHPOOLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | CASHPOOL_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CASHPOOL_ID | NUMBER | (15) | Yes | System-assigned cash pool identifier |
NAME | VARCHAR2 | (100) | Yes | Cash Pool name |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Cash Pool currency |
TYPE | VARCHAR2 | (15) | Yes | Cash Pool type: NOTIONAL or PHYSICAL |
CONC_ACCOUNT_ID | NUMBER | (15) | Concentration bank account identifier | |
INV_CONC_ACCOUNT_ID | NUMBER | (15) | Investment concentration bank account identifier | |
FUND_CONC_ACCOUNT_ID | NUMBER | (15) | Funding concentration bank account identifier | |
SINGLE_CONC_ACCOUNT_FLAG | VARCHAR2 | (1) | Flag to indicate whether the cash pool has only one concentration account | |
PARTY_CODE | VARCHAR2 | (7) | Cash Pool company party code | |
EFFECTIVE_DATE_FROM | DATE | Cash Pool effective date from | ||
EFFECTIVE_DATE_TO | DATE | Cash Pool effective date to | ||
SWEEPS_FLAG | VARCHAR2 | (1) | Flag to indicate whether the cash pool is set up for bank-initiated sweeps | |
PARENT_CASHPOOL_ID | NUMBER | (15) | Parent cash pool identifier | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier | |
TRXN_SUBTYPE_CODE_ID | NUMBER | (15) | Transaction Subtype Code identifier | |
AUTHORIZATION_BAT | VARCHAR2 | (30) | Flag to indicate whether Bank Account Transfer Authorization is required or not |
Cut, paste (and edit) the following text to query this object:
SELECT CASHPOOL_ID
, NAME
, CURRENCY_CODE
, TYPE
, CONC_ACCOUNT_ID
, INV_CONC_ACCOUNT_ID
, FUND_CONC_ACCOUNT_ID
, SINGLE_CONC_ACCOUNT_FLAG
, PARTY_CODE
, EFFECTIVE_DATE_FROM
, EFFECTIVE_DATE_TO
, SWEEPS_FLAG
, PARENT_CASHPOOL_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LEGAL_ENTITY_ID
, TRXN_SUBTYPE_CODE_ID
, AUTHORIZATION_BAT
FROM CE.CE_CASHPOOLS;
CE.CE_CASHPOOLS does not reference any database object
CE.CE_CASHPOOLS is referenced by following:
|
|
|