[Home] [Help] [Dependency Information]
Object Name: | CEFV_CASH_FORECAST_CELLS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CE.CEFV_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 | Cash forecast cell identifier. | ||
SOURCE_TYPE | VARCHAR2 | (80) | Identifies what type of source transactions this forecast cell amount was generated from. | |
START_PERIOD_DATE | DATE | Start date of forecast period. | ||
END_PERIOD_DATE | DATE | End date of forecast period. | ||
AMOUNT | NUMBER | Forecast amount for given source transaction type and forecast period. | ||
SOURCE_DESCRIPTION | VARCHAR2 | (255) | A brief description of the transaction source. | |
LEAD_TIME | NUMBER | (15) | Amount of time added to the transaction date to project cash activity date. | |
SET_OF_BOOKS_NAME | VARCHAR2 | (30) | Indicates the set of books the forecast amount represents. | |
FORECAST_METHOD | VARCHAR2 | (80) | Indicates the method of the forecast being generated for AP payment, AR receipt, or Payroll expense source types, either by selecting Historical transactions or Future transactions. | |
BANK_ACCOUNT_ID | NUMBER | (15) | The bank account id which uniquely identifiers the bank the forecast amount represents for AP payment, AR receipt, or Payroll expense source type. | |
BANK_ACCOUNT_NAME | VARCHAR2 | (100) | Indicates the bank account name the forecast amount represents for AP payment or AR receipt source types. | |
BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | Bank account selection criterion for Supplier Payments and Customer Receipts. | |
_KF:PAYROLL_BANK_ACCOUNT | CHAR | (15) | Bank account selection criterion for Payroll Expenses. | |
RECEIPT_METHOD | VARCHAR2 | (30) | Receipt class payment method for Customer Receipts. | |
CUSTOMER_PROFILE_CLASS | VARCHAR2 | (30) | Customer Profile Class selection criterion for Customer Invoices. | |
PAYMENT_METHOD | VARCHAR2 | (80) | Payment Method selection criterion. | |
DISPUTE_OPTION | VARCHAR2 | (80) | Indicates whether disputed amounts are included or excluded when the forecast amount is generated from AR invoices. | |
PAY_GROUP | VARCHAR2 | (25) | Payment Group selection criterion for Supplier Invoices and Purchase Orders. | |
SUPPLIER_TYPE | VARCHAR2 | (25) | Supplier Type selection criterion for Supplier Invoices and Purchase Orders. | |
PAYMENT_PRIORITY | NUMBER | (15) | Indicates the lowest payment priority the forecast amount represents for AP invoice or Purchase order source type. | |
DISCOUNT_OPTION | VARCHAR2 | (80) | Indicates whether discounted amounts are included or excluded when the forecast amount is generated from AP invoices. | |
PO_AUTHORIZATION_STATUS | VARCHAR2 | (240) | Authorization Status selection criterion for Oracle Purchasing source types. | |
ROLL_FORWARD_TYPE | VARCHAR2 | (80) | The type of periods to roll forward when forecasting from historical transactions: by days, by months, or by accounting periods. | |
ROLL_FORWARD_PERIOD | NUMBER | (15) | The number of periods to roll forward when forecasting from historical transactions. | |
ORDER_STATUS | VARCHAR2 | (80) | Order Status selection criterion for Sales Orders. | |
ORDER_DATE_TYPE | VARCHAR2 | (80) | Date Type selection criterion for Sales Orders. | |
PAYROLL_NAME | VARCHAR2 | (80) | Payroll name selection criterion for Payroll expense source type. | |
PAYROLL_LEGISLATION | VARCHAR2 | (150) | Indicates the legislation the forecast amount represents for Payroll expense source type. | |
CODE_COMBINATION_ID | NUMBER | (15) | GL Account selection criterion for GL source types. | |
_KF:GL_ACCOUNT_NUMBER | CHAR | (16) | Indicates the GL account number the forecast amount represents for GL source types. | |
ENCUMBRANCE_TYPE | VARCHAR2 | (30) | Encumbrance type selection criterion for GL Encumbrances. | |
BUDGET_NAME | VARCHAR2 | (15) | Budget Name selection criterion for GL Budgets. | |
EXTERNAL_SOURCE_TYPE | VARCHAR2 | (30) | Indicates the external source type the forecast amount represents for Open Interface Inflow or Outflow source type. | |
EXTERNAL_SOURCE_CRITERIA1 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA2 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA3 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA4 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA5 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA6 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA7 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA8 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA9 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA10 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA11 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA12 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA13 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA14 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
EXTERNAL_SOURCE_CRITERIA15 | VARCHAR2 | (150) | Selection criterion for Open Interface Inflow or Outflow source types. | |
FORECAST_ID | NUMBER | (15) | An id which uniquely identifies the forecast to which this 'cell' belongs. | |
FORECAST_NAME | VARCHAR2 | (100) | The name of the forecast to which this 'cell' belongs. | |
FORECAST_TYPE | VARCHAR2 | (80) | The type of forecast, by days or GL periods, to which this 'cell' belongs. | |
FORECAST_DESCRIPTION | VARCHAR2 | (255) | A brief description of the forecast to which this 'cell' belongs. | |
CREATED_DATE | DATE | Standard WHO column. | ||
CREATED_BY | NUMBER | Standard WHO column. | ||
LAST_UPDATED_DATE | DATE | Standard WHO column. | ||
LAST_UPDATED_BY | NUMBER | Standard WHO column. |
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
, EXTERNAL_SOURCE_CRITERIA15
, FORECAST_ID
, FORECAST_NAME
, FORECAST_TYPE
, FORECAST_DESCRIPTION
, CREATED_DATE
, CREATED_BY
, LAST_UPDATED_DATE
, LAST_UPDATED_BY
FROM APPS.CEFV_CASH_FORECAST_CELLS;
APPS.CEFV_CASH_FORECAST_CELLS is not referenced by any database object
|
|
|