[Home] [Help] [Dependency Information]
Object Name: | CEBV_CASH_FORECAST_CELLS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CEBV_CASH_FORECAST_CELLS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
A cash forecast cell is a projected cashflow amount for each transaction source and forecast period, along with information applicable to that amount.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FORECAST_CELL_ID | NUMBER | System-assigned forecast cell identifier | ||
SOURCE_TYPE | VARCHAR2 | (80) | Lookup meaning, the value shown on screen as code | |
START_PERIOD_DATE | DATE | |||
END_PERIOD_DATE | DATE | |||
AMOUNT | NUMBER | |||
SOURCE_DESCRIPTION | VARCHAR2 | (255) | ||
LEAD_TIME | NUMBER | (15) | ||
SET_OF_BOOKS_NAME | VARCHAR2 | (30) | ||
FORECAST_METHOD | VARCHAR2 | (80) | ||
BANK_ACCOUNT_ID | NUMBER | (15) | ||
BANK_ACCOUNT_NAME | VARCHAR2 | (100) | ||
BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
_KF:PAYROLL_BANK_ACCOUNT | CHAR | (15) | ||
RECEIPT_METHOD | VARCHAR2 | (30) | ||
CUSTOMER_PROFILE_CLASS | VARCHAR2 | (30) | ||
PAYMENT_METHOD | VARCHAR2 | (80) | ||
DISPUTE_OPTION | VARCHAR2 | (80) | ||
PAY_GROUP | VARCHAR2 | (25) | ||
SUPPLIER_TYPE | VARCHAR2 | (25) | ||
PAYMENT_PRIORITY | NUMBER | (15) | ||
DISCOUNT_OPTION | VARCHAR2 | (80) | ||
PO_AUTHORIZATION_STATUS | VARCHAR2 | (240) | ||
ROLL_FORWARD_TYPE | VARCHAR2 | (80) | ||
ROLL_FORWARD_PERIOD | NUMBER | (15) | ||
ORDER_STATUS | VARCHAR2 | (80) | ||
ORDER_DATE_TYPE | VARCHAR2 | (80) | ||
PAYROLL_NAME | VARCHAR2 | (80) | ||
PAYROLL_LEGISLATION | VARCHAR2 | (150) | ||
CODE_COMBINATION_ID | NUMBER | (15) | ||
_KF:GL_ACCOUNT_NUMBER | CHAR | (16) | ||
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | ||
BUDGET_NAME | VARCHAR2 | (15) | ||
EXTERNAL_SOURCE_TYPE | VARCHAR2 | (30) | ||
EXTERNAL_SOURCE_CRITERIA1 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA2 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA3 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA4 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA5 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA6 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA7 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA8 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA9 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA10 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA11 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA12 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA13 | VARCHAR2 | (150) | ||
EXTERNAL_SOURCE_CRITERIA14 | VARCHAR2 | (150) | ||
FORECAST_ID | NUMBER | (15) | ||
CREATED_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATED_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT FORECAST_CELL_ID
, SOURCE_TYPE
, START_PERIOD_DATE
, END_PERIOD_DATE
, AMOUNT
, SOURCE_DESCRIPTION
, LEAD_TIME
, SET_OF_BOOKS_NAME
, FORECAST_METHOD
, BANK_ACCOUNT_ID
, BANK_ACCOUNT_NAME
, BANK_ACCOUNT_NUMBER
, _KF:PAYROLL_BANK_ACCOUNT
, RECEIPT_METHOD
, CUSTOMER_PROFILE_CLASS
, PAYMENT_METHOD
, DISPUTE_OPTION
, PAY_GROUP
, SUPPLIER_TYPE
, PAYMENT_PRIORITY
, DISCOUNT_OPTION
, PO_AUTHORIZATION_STATUS
, ROLL_FORWARD_TYPE
, ROLL_FORWARD_PERIOD
, ORDER_STATUS
, ORDER_DATE_TYPE
, PAYROLL_NAME
, PAYROLL_LEGISLATION
, CODE_COMBINATION_ID
, _KF:GL_ACCOUNT_NUMBER
, ENCUMBRANCE_TYPE
, BUDGET_NAME
, EXTERNAL_SOURCE_TYPE
, EXTERNAL_SOURCE_CRITERIA1
, EXTERNAL_SOURCE_CRITERIA2
, EXTERNAL_SOURCE_CRITERIA3
, EXTERNAL_SOURCE_CRITERIA4
, EXTERNAL_SOURCE_CRITERIA5
, EXTERNAL_SOURCE_CRITERIA6
, EXTERNAL_SOURCE_CRITERIA7
, EXTERNAL_SOURCE_CRITERIA8
, EXTERNAL_SOURCE_CRITERIA9
, EXTERNAL_SOURCE_CRITERIA10
, EXTERNAL_SOURCE_CRITERIA11
, EXTERNAL_SOURCE_CRITERIA12
, EXTERNAL_SOURCE_CRITERIA13
, EXTERNAL_SOURCE_CRITERIA14
, FORECAST_ID
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
FROM APPS.CEBV_CASH_FORECAST_CELLS;
APPS.CEBV_CASH_FORECAST_CELLS is not referenced by any database object
|
|
|