eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CE.CE_FORECAST_ROWS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

CE.CE_FORECAST_ROWS does not reference any database object

CE.CE_FORECAST_ROWS is referenced by following:

APPS: CE_FORECAST_ROWS