[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CE_FORECAST_ROWS |
|---|---|
| Object Type: | TABLE |
| Owner: | CE |
| FND Design Data: |  CE.CE_FORECAST_ROWS
|
| Subobject Name: | |
| Status: | VALID |
The CE_FORECAST_ROWS table stores the source transaction information of your cash forecast templates. Each row includes the forecast template row ID, row number, source transaction type, and transaction selection criteria.
This table corresponds to the Forecast Template Rows window of the Forecast Templates form.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CE_FORECAST_ROWS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FORECAST_ROW_ID
|
| CE_FORECAST_ROWS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
FORECAST_HEADER_ID
ROW_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FORECAST_ROW_ID | NUMBER | (15) | Yes | System-assigned forecast template row identifier |
| FORECAST_HEADER_ID | NUMBER | (15) | Yes | Template header identifier |
| ROW_NUMBER | NUMBER | (15) | Yes | User-assigned number to specify the sequence of template rows |
| TRX_TYPE | VARCHAR2 | (30) | Yes | Type of source transactions, lookup type FORECAST_TRX_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 | |
| DESCRIPTION | VARCHAR2 | (255) | Description of the template row | |
| LEAD_TIME | NUMBER | (15) | Amount of time added to the transaction date to project cash date | |
| FORECAST_METHOD | VARCHAR2 | (1) | Method of forecast (P for selecting historical transactions and C for selecting current transactions), only applicable when TRX_TYPE is APP or ARR, always P for TRX_TYPE of PAY | |
| RECEIPT_METHOD_ID | NUMBER | (15) | AR's receipt class payment method, only applicable when TRX_TYPE is ARR | |
| BANK_ACCOUNT_ID | NUMBER | (15) | Bank account ID, only applicable when TRX_ID is APP, ARR, or PAY | |
| PAYMENT_METHOD | VARCHAR2 | (25) | Payment method of AP payments, only applicable when TRX_TYPE is APP | |
| PAY_GROUP | VARCHAR2 | (25) | Payment group of AP payments, only applicable when TRX_TYPE is APP | |
| VENDOR_TYPE | VARCHAR2 | (25) | Vendor type of AP invoices or purchase orders, only applicable when TRX_TYPE is API or POP | |
| PAYMENT_PRIORITY | NUMBER | (15) | Priority of generating AP payments, only applicable when TRX_TYPE is API or POP | |
| ROLL_FORWARD_TYPE | VARCHAR2 | (1) | Type of periods to roll forward when forecasting, only applicable when FORECAST_METHOD is P and TRX_TYPE is APP, ARR, or PAY, lookup type FORECAST_ROLL_FORWARD_TYPE | |
| ROLL_FORWARD_PERIOD | NUMBER | (15) | Number of periods to roll forward, only applicable when FORECAST_METHOD is P and TRX_TYPE is APP, ARR, or PAY | |
| DISCOUNT_OPTION | VARCHAR2 | (1) | Option to include or exclude discount amounts for AP invoices and purchase orders, only applicable when TRX_TYPE is API or POP (X for largest discount, M for minimum discount, and N for no discount) | |
| INCLUDE_FLOAT_FLAG | VARCHAR2 | (1) | Flag to indicate whether to include any AR receipts in transit, only applicable when TRX_TYPE is ARR | |
| INCLUDE_DISPUTE_FLAG | VARCHAR2 | (1) | Flag to indicate whether to include any dispute amounts, only applicable when TRX_TYPE is ARI | |
| CUSTOMER_PROFILE_CLASS_ID | NUMBER | (15) | Customer profile class identifier for AR invoices, only applicable when TRX_TYPE is ARI | |
| ORDER_STATUS | VARCHAR2 | (1) | Status of sales orders, only applicable when TRX_TYPE is OEO, lookup type FORECAST_ORDER_STATUS | |
| ORDER_DATE_TYPE | VARCHAR2 | (1) | Date type of sales orders to base the projection of cash receipt date. Only applicable when TRX_TYPE is OEO, lookup type FORECAST_ORDER_DATE_TYPE | |
| SALES_STAGE_ID | NUMBER | (15) | Sales stage identifier. Only applicable when TRX_TYPE is ASF | |
| CHANNEL_CODE | VARCHAR2 | (15) | Sales channel for the lead item. Only applicable when TRX_TYPE is ASF | |
| WIN_PROBABILITY | NUMBER | (15) | Probability that this item will be sold. Only applicable when TRX_TYPE is ASF. A probability of 10 will select all sales leads with a probability of 10% or more | |
| SALES_FORECAST_STATUS | VARCHAR2 | (30) | Sales lead status. Only applicable when TRX_TYPE is ASF | |
| CODE_COMBINATION_ID | NUMBER | (15) | GL account code for GL transactions, only applicable when TRX_TYPE is GLB, GLC, or GLE | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Set of books identifier for source transaction | |
| ORG_ID | NUMBER | (15) | Organization identifier of the source transaction, -1 for all organizations | |
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) | Chart of accounts identifier of the source transaction, only applicable when TRX_TYPE is GLB, GLC, or GLE | |
| BUDGET_NAME | VARCHAR2 | (15) | Name of the GL budgets, only applicable when TRX_TYPE is GLB | |
| BUDGET_VERSION_ID | NUMBER | (15) | Version identifier of the budgets, only applicable when TRX_TYPE is GLB | |
| ENCUMBRANCE_TYPE_ID | NUMBER | (15) | Encumbrance type identifier of encumbrances, only applicable when TRX_TYPE is GLE | |
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status of purchase orders or requisitions, only applicable when TRX_TYPE is POP or POR | |
| ORG_PAYMENT_METHOD_ID | NUMBER | (9) | Payment method identifier for TRX_TYPE of PAY | |
| 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 | |
| PAYROLL_ID | NUMBER | (9) | Payroll identifier for TRX_TYPE of PAY | |
| EXTERNAL_SOURCE_TYPE | VARCHAR2 | (30) | External source type name for TRX_TYPE of OII or OIO | |
| CRITERIA_CATEGORY | VARCHAR2 | (30) | Structure defining column for the external source type flexfields, only applicable when TRX_TYPE is OII or OIO | |
| 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 | |
| TYPE | VARCHAR2 | (30) | Project Transaction Type | |
| BUDGET_TYPE | VARCHAR2 | (30) | The status of the budget | |
| BUDGET_VERSION | VARCHAR2 | (30) | The version of the budget type selected | |
| INCLUDE_HOLD_FLAG | VARCHAR2 | (1) | The flag that determines whether the expense reports on hold should be included in the forecast | |
| INCLUDE_NET_CASH_FLAG | VARCHAR2 | (1) | The flag that determines whether the budget amounts should be included in the net cash calculation | |
| COMPANY_CODE | VARCHAR2 | (7) | Applicable when TRX_TYPE is XTR | |
| EXCLUDE_INDIC_EXP | VARCHAR2 | (1) | Flag to indicate whether to include indicative transactions. Only applicable when TRX_TYPE is XTR and TYPE is Exposure. | |
| XTR_BANK_ACCOUNT | VARCHAR2 | (20) | Bank Account. Only applicable when TRX_TYPE is XTR. | |
| USE_AVERAGE_PAYMENT_DAYS | VARCHAR2 | (1) | Flag to indicate whether to use average payment days to decide the cash activity date. | |
| PERIOD | NUMBER | (15) | Number of periods to use for calculating average payment days. | |
| USE_PAYMENT_TERMS | VARCHAR2 | (1) | Yes | Flag to indicate whether to use payment terms to decide the cash activity date for sales orders and purchase orders. |
| ORDER_TYPE_ID | NUMBER | (15) | Order type identifier for a sales order | |
| LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier | |
| INCLUDE_TEMP_LABOR_FLAG | VARCHAR2 | (1) | Include temporary labor identifier |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_ROW_ID
, FORECAST_HEADER_ID
, ROW_NUMBER
, TRX_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, DESCRIPTION
, LEAD_TIME
, FORECAST_METHOD
, RECEIPT_METHOD_ID
, BANK_ACCOUNT_ID
, PAYMENT_METHOD
, PAY_GROUP
, VENDOR_TYPE
, PAYMENT_PRIORITY
, ROLL_FORWARD_TYPE
, ROLL_FORWARD_PERIOD
, DISCOUNT_OPTION
, INCLUDE_FLOAT_FLAG
, INCLUDE_DISPUTE_FLAG
, CUSTOMER_PROFILE_CLASS_ID
, ORDER_STATUS
, ORDER_DATE_TYPE
, SALES_STAGE_ID
, CHANNEL_CODE
, WIN_PROBABILITY
, SALES_FORECAST_STATUS
, CODE_COMBINATION_ID
, SET_OF_BOOKS_ID
, ORG_ID
, CHART_OF_ACCOUNTS_ID
, BUDGET_NAME
, BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID
, AUTHORIZATION_STATUS
, ORG_PAYMENT_METHOD_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, PAYROLL_ID
, EXTERNAL_SOURCE_TYPE
, CRITERIA_CATEGORY
, CRITERIA1
, CRITERIA2
, CRITERIA3
, CRITERIA4
, CRITERIA5
, CRITERIA6
, CRITERIA7
, CRITERIA8
, CRITERIA9
, CRITERIA10
, CRITERIA11
, CRITERIA12
, CRITERIA13
, CRITERIA14
, CRITERIA15
, TYPE
, BUDGET_TYPE
, BUDGET_VERSION
, INCLUDE_HOLD_FLAG
, INCLUDE_NET_CASH_FLAG
, COMPANY_CODE
, EXCLUDE_INDIC_EXP
, XTR_BANK_ACCOUNT
, USE_AVERAGE_PAYMENT_DAYS
, PERIOD
, USE_PAYMENT_TERMS
, ORDER_TYPE_ID
, LEGAL_ENTITY_ID
, INCLUDE_TEMP_LABOR_FLAG
FROM CE.CE_FORECAST_ROWS;
CE.CE_FORECAST_ROWS does not reference any database object
CE.CE_FORECAST_ROWS is referenced by following:
CE
CE_FORECAST_ROWS#
|
|
|
|