Powered by InfoCaptor


Previous Page   Next Page

Cash Forecasts
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.CEFG_CASH_FORECASTSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Amount ThresholdInclude only source transactions with amounts over the amount Threshold when Currency Type is Entered or Functional.Cash Forecasts.Amount ThresholdAMOUNT_THRESHOLDAMOUNT_THRESHOLD115912
Business CalendarBusiness calendar used to ensure that cash activity dates are business days.Cash Forecasts.Business CalendarBUSINESS_CALENDARBUSINESS_CALENDAR120541
Calendar NameAccounting calendar name used to determine forecast periods.Cash Forecasts.Calendar NameCALENDAR_NAMECALENDAR_NAME121357
Created ByStandard WHO column.Cash Forecasts.Created ByCREATED_BYCREATED_BY124571
Created DateStandard WHO column.Cash Forecasts.Created DateCREATED_DATECREATED_DATE125370
Currency TypeThe type of currency.Cash Forecasts.Currency TypeCURRENCY_TYPECURRENCY_TYPE127239
DescriptionThe accounting period description.Cash Forecasts.DescriptionDESCRIPTIONDESCRIPTION129522
Error StatusIdentifies whether any errors or warnings occurred when the forecastwas generated.Cash Forecasts.Error StatusERROR_STATUSERROR_STATUS133542
Exchange DateCurrency exchange date for determining the currency exchange rate tobe used for converting the source transaction amount to the forecastcurrency amount.Cash Forecasts.Exchange DateEXCHANGE_DATEEXCHANGE_DATE133779
Exchange RateCurrency exchange rate used for converting the source transactionamount to the forecast currency amount for the 'User' exchange ratetype.Cash Forecasts.Exchange RateEXCHANGE_RATEEXCHANGE_RATE133787
Exchange Rate TypeCurrency exchange rate type used for converting the sourcetransaction amount to the forecast currency amount.Cash Forecasts.Exchange Rate TypeEXCHANGE_RATE_TYPEEXCHANGE_RATE_TYPE133803
Forecast CurrencyCurrency in which the forecast is represented.Cash Forecasts.Forecast CurrencyFORECAST_CURRENCYFORECAST_CURRENCY134483
Forecast IdAn id which uniquely identifies the forecast to which this 'cell'belongs.Cash Forecasts.Forecast IdFORECAST_IDFORECAST_ID134504
Last Updated ByStandard WHO column.Cash Forecasts.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139197
Last Updated DateStandard WHO column.Cash Forecasts.Last Updated DateLAST_UPDATED_DATELAST_UPDATED_DATE139947
NameName of the resource.Cash Forecasts.NameNAMENAME147718
Overdue Transaction Cutoff PeriodCut off period of overdue transactions included in the forecast.Cash Forecasts.Overdue Transaction Cutoff PeriodOVERDUE_TXN_CUTOFF_PERIODOVERDUE_TXN_CUTOFF_PERIOD151686
Overdue Transaction OptionIndicates whether overdue transactions are included or excluded in theforecast.Cash Forecasts.Overdue Transaction OptionOVERDUE_TRANSACTION_OPTIONOVERDUE_TRANSACTION_OPTION151685
Project IdIdentifier of the project from which the costs are collected, summarized, and transferred from Oracle Projects.Cash Forecasts.Project IdPROJECT_IDPROJECT_ID156422
Project Number Cash Forecasts.Project NumberPROJECT_NUMBERPROJECT_NUMBER156603
Source CurrencyInclude only source transactions that match this currency when Currency Type is Entered or Functional.Cash Forecasts.Source CurrencySOURCE_CURRENCYSOURCE_CURRENCY162349
Start DateStart Effective date for accounting cost.Cash Forecasts.Start DateSTART_DATESTART_DATE162908
Start Date - Day Cash Forecasts.Start Date START_DATE_DAY190951
Start Date - Month Cash Forecasts.Start Date START_DATE_MONTH190981
Start Date - Quarter Cash Forecasts.Start Date START_DATE_QUARTER191015
Start Date - Year Cash Forecasts.Start Date START_DATE_YEAR191049
Start PeriodAccounting period used as a starting point to determine forecastperiods.Cash Forecasts.Start PeriodSTART_PERIODSTART_PERIOD163328
Template DescriptionDescription of the forecast template.Cash Forecasts.Template DescriptionTEMPLATE_DESCRIPTIONTEMPLATE_DESCRIPTION164928
Template NameAPI Template Name (Required for Multi-Lingual support).Cash Forecasts.Template NameTEMPLATE_NAMETEMPLATE_NAME164932
TypeForecast period type. Indicates whether the forecast period ranges are GL Period or date ranges.Cash Forecasts.TypeTYPETYPE166130
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Cash Forecasts -> Cash Forecast CellsCash Forecasts.Forecast Id = Cash Forecast Cells.Forecast IdAlways exist in master folderNoneNo