[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_FORECAST_HEADERS |
|---|---|
| Object Type: | TABLE |
| Owner: | CE |
| FND Design Data: |  CE.CE_FORECAST_HEADERS
|
| Subobject Name: | |
| Status: | VALID |
The CE_FORECAST_HEADERS table stores the header information of your cash forecast templates. Each row includes the template header ID, name, description, and an indicator to specify whether you are forecasting by GL accounting periods or simply by a range of dates. You must first create a template in order to generate a forecast.
This table corresponds to the Forecast Template window of the Forecast Templates form.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CE_FORECAST_HEADERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FORECAST_HEADER_ID
|
| CE_FORECAST_HEADERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORECAST_HEADER_ID | NUMBER | (15) | Yes | System-assigned forecast template identifier |
| NAME | VARCHAR2 | (30) | Yes | User-assigned forecast template name |
| AGING_TYPE | VARCHAR2 | (1) | Yes | Specifies forecast periods, lookup type FORECAST_AGING_TYPE |
| OVERDUE_TRANSACTIONS | VARCHAR2 | (30) | Yes | A flag to indicate whether to include or exclude overdue transactions, lookup type FORECAST_OVERDUE_TRX |
| CUTOFF_PERIOD | NUMBER | (15) | Number of days or accounting periods for cutoff periods for including overdue transactions | |
| TRANSACTION_CALENDAR_ID | NUMBER | (15) | Transaction or Business Calendar 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 | |
| DESCRIPTION | VARCHAR2 | (255) | Forecast template description | |
| 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 | |
| START_PROJECT_ID | NUMBER | (15) | Start Project Number for Project-Related source types | |
| END_PROJECT_ID | NUMBER | (15) | End Project Number for Project-Related source types | |
| TREASURY_TEMPLATE | VARCHAR2 | (1) | The flag to indicate treasury forecast template | |
| COLUMN_SETUP | VARCHAR2 | (1) | Flag to indicate whether the column setup for this forecast template is Automatic ('A') or Manual ('M') |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_HEADER_ID
, NAME
, AGING_TYPE
, OVERDUE_TRANSACTIONS
, CUTOFF_PERIOD
, TRANSACTION_CALENDAR_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, START_PROJECT_ID
, END_PROJECT_ID
, TREASURY_TEMPLATE
, COLUMN_SETUP
FROM CE.CE_FORECAST_HEADERS;
CE.CE_FORECAST_HEADERS does not reference any database object
CE.CE_FORECAST_HEADERS is referenced by following:
CE
CE_FORECAST_HEADERS#
|
|
|
|