[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_FORECASTS |
|---|---|
| Object Type: | TABLE |
| Owner: | CE |
| FND Design Data: |  CE.CE_FORECASTS
|
| Subobject Name: | |
| Status: | VALID |
The CE_FORECASTS table stores information about cash forecasts you generate. Each row includes the forecast ID, template ID, name, description, and all the parameters you have entered when the forecast run was submitted.
If an error has occurred while running a forecast, ERROR_STATUS is updated with E, and no records are created in the CE_FORECAST_CELLS table. ERROR_STATUS is updated to W when certain warning conditions are detected during the forecast run. An example of a warning can be a situation where certain currency exchange rates are not being defined. ERROR_STATUS is updated with S for a successful forecast run.
A record is generated for each forecast run, or it can be generated from the Cash Forecast window of the Cash Forecasts form.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CE_FORECASTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FORECAST_ID
|
| CE_FORECASTS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| CE_FORECASTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
FORECAST_HEADER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORECAST_ID | NUMBER | (15) | Yes | System-assigned forecast identifier |
| NAME | VARCHAR2 | (100) | Yes | User-assigned unique name for the forecast |
| FORECAST_CURRENCY | VARCHAR2 | (15) | Yes | Currency in which the forecast is generated |
| CURRENCY_TYPE | VARCHAR2 | (1) | Yes | Type of currency code to select transactions by, lookup type FORECAST_CURRENCY_TYPE |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Currency exchange rate type to be used for translating forecast amount | |
| EXCHANGE_DATE | DATE | Date to determine exchange rate for translating forecast amounts | ||
| EXCHANGE_RATE | NUMBER | Exchange rate for 'User' rate type | ||
| 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 template identifier | |
| DESCRIPTION | VARCHAR2 | (255) | Description of the forecast | |
| START_DATE | DATE | Forecast start date, only applicable when AGING_TYPE in the corresponding CE_FORECAST_HEADERS record is D | ||
| START_PERIOD | VARCHAR2 | (15) | Starting GL account period of the forecast, only applicable when AGING_TYPE in the corresponding CE_FORECAST_HEADER record is A | |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Calendar name of the starting period | |
| SOURCE_CURRENCY | VARCHAR2 | (15) | Currency code of the source transactions to select for forecasting | |
| ERROR_STATUS | VARCHAR2 | (1) | Status of forecast run (S for successful run, W for warning, and E for error) | |
| AMOUNT_THRESHOLD | NUMBER | (15) | A forecast submission option used to select transactions that have amounts greater than this threshold amount | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| PROJECT_ID | NUMBER | (15) | Project number for Project-Related source types | |
| DRILLDOWN_FLAG | VARCHAR2 | (1) | Flag to indicate whether this forecast supports drill-down functionality or not | |
| BANK_BALANCE_TYPE | VARCHAR2 | (3) | Lookup type BANK_ACC_BAL_TYPEL: Ledger Balance;C: Cash Flow Balance;I: Interest Calculated Balance | |
| FLOAT_TYPE | VARCHAR2 | (4) | Lookup type FLOAT_TYPENONE: None;ADD1: Add 1 Day FloatADD2: Add 2 Day Float SUB1: Subtract 1 Day Float SUB2: Subtract 2 Day Float | |
| VIEW_BY | VARCHAR2 | (4) | Lookup type OPENING_BAL_TYPE BANK or GLCP | |
| INCLUDE_SUB_ACCOUNT | VARCHAR2 | (1) | Flag to indicate whether to include subsidiary bank account balance in the forecast results | |
| FACTOR | NUMBER | Factor used for forecast results | ||
| REQUEST_ID | NUMBER | Concurrent program request id |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ID
, NAME
, FORECAST_CURRENCY
, CURRENCY_TYPE
, EXCHANGE_RATE_TYPE
, EXCHANGE_DATE
, EXCHANGE_RATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, FORECAST_HEADER_ID
, DESCRIPTION
, START_DATE
, START_PERIOD
, PERIOD_SET_NAME
, SOURCE_CURRENCY
, ERROR_STATUS
, AMOUNT_THRESHOLD
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PROJECT_ID
, DRILLDOWN_FLAG
, BANK_BALANCE_TYPE
, FLOAT_TYPE
, VIEW_BY
, INCLUDE_SUB_ACCOUNT
, FACTOR
, REQUEST_ID
FROM CE.CE_FORECASTS;
CE.CE_FORECASTS does not reference any database object
CE.CE_FORECASTS is referenced by following:
CE
CE_FORECASTS#
|
|
|
|