CASH_FCST_AET

(SQL Table)
Index Back

Cash Forecast Integration

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 FCST_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of loaded forecast data. The forecast data source provides a means of selectively tracking, reporting, and inquiring on these entries.
4 VALUE_DT Date(10) DATE Equivalent to a deal transaction's settlement date.
5 REFERENCE Character(30) VARCHAR2(30) NOT NULL Field to show when a variable is a reference variable.
6 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number