[Home] [Help] [Dependency Information]
Object Name: | CE_FORECAST_TRX_CELLS |
---|---|
Object Type: | TABLE |
Owner: | CE |
FND Design Data: | CE.CE_FORECAST_TRX_CELLS |
Subobject Name: | |
Status: | VALID |
This table stores transaction level forecast data
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CE_FORECAST_TRX_CELLS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | FORECAST_CELL_ID |
CE_FORECAST_TRX_CELLS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
FORECAST_ROW_ID
FORECAST_COLUMN_ID |
CE_FORECAST_TRX_CELLS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | FORECAST_ID |
CE_FORECAST_TRX_CELLS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BANK_ACCOUNT_ID |
CE_FORECAST_TRX_CELLS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CODE_COMBINATION_ID |
CE_FORECAST_TRX_CELLS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFERENCE_ID |
CE_FORECAST_TRX_CELLS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_CELL_ID | NUMBER | (15) | Yes | System-assigned forecast cell identifier |
FORECAST_ID | NUMBER | (15) | Yes | Forecast identifier |
AMOUNT | NUMBER | Yes | Forecast Amount per individual transaction | |
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 | |
FORECAST_HEADER_ID | NUMBER | (15) | Forecast header identifier | |
FORECAST_ROW_ID | NUMBER | (15) | Forecast template row identifier | |
FORECAST_COLUMN_ID | NUMBER | (15) | Forecast template column identifier | |
REFERENCE_ID | VARCHAR2 | (200) | Unique transaction identifier | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
ORG_ID | NUMBER | (15) | Organization identifier, Legal Entity identifier | |
INCLUDE_FLAG | VARCHAR2 | (1) | This is N if this row has been manually excluded from the forecast results | |
TRX_DATE | DATE | Cash Activity Date | ||
BANK_ACCOUNT_ID | NUMBER | (15) | Bank Account identifier | |
CODE_COMBINATION_ID | NUMBER | (15) | Accounting Flexfield identifier for GL Cash Account associated with bank account | |
TRX_AMOUNT | NUMBER | Forecast Amount in Transaction Currency |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_CELL_ID
, FORECAST_ID
, AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FORECAST_HEADER_ID
, FORECAST_ROW_ID
, FORECAST_COLUMN_ID
, REFERENCE_ID
, CURRENCY_CODE
, ORG_ID
, INCLUDE_FLAG
, TRX_DATE
, BANK_ACCOUNT_ID
, CODE_COMBINATION_ID
, TRX_AMOUNT
FROM CE.CE_FORECAST_TRX_CELLS;
CE.CE_FORECAST_TRX_CELLS does not reference any database object
CE.CE_FORECAST_TRX_CELLS is referenced by following:
|
|
|