TR_FCST_AET (SQL Table)	Index Back
Cash Forecast default state The following state record is used in the Cash Forecast Process (TR_CASH_FCST). This is the default state record for the process.

TR_FCST_AET

(SQL Table)

Cash Forecast default state

The following state record is used in the Cash Forecast Process (TR_CASH_FCST). This is the default state record for the process.

# 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 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

4 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

6 WORKSHEET_ID Character(20) VARCHAR2(20) NOT NULL Cash Flows Worksheet ID

7 SELECT_DT_OPTN Character(1) VARCHAR2(1) NOT NULL Date Type
1=Specific Dates
2=Relative Dates

8 SRCH_DAYS_FROM Number(5,0) INTEGER NOT NULL Days Back

9 SRCH_DAYS_TO Number(5,0) INTEGER NOT NULL Days Ahead

10 EFFDT Date(10) DATE Effective Date

11 LINE_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals.
1=Cash
2=Non-Cash

12 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

13 WRKSHEET_LINE_ITEM Character(30) VARCHAR2(30) NOT NULL Cash Forecast Worksheet Line item

14 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

15 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

16 SEL_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Cash Forecast Selection SQL statement.

17 CSH_FCST_RULE_ID Character(20) VARCHAR2(20) NOT NULL Uniquely identifies a Cash Forecasting Rule. The identifier is manually entered by the user and not automatically generated by the system.

18 WEIGHTING Signed Number(10,5) DECIMAL(8,5) NOT NULL Used for applying a weighting to totals. e.g. Limit Utilisation totals

19 POS_DEF_SRC_SET Character(1) VARCHAR2(1) NOT NULL a checkbox that identifies the default position source set.

20 START_DT Date(10) DATE Start Date

21 END_DT Date(10) DATE End Date

22 AMOUNT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL An internal work field utilized for calculating forecast amounts for a given category in cash wor

23 CURRENCY_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Currency Field Name

24 DATE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL "(Generic field that crosses multiple products; in Treasury

25 REFR_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Reference Field Name

26 PYMNTMTH_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Payment Method Field Name

27 PER_UNIT_FIELDNAME Character(18) VARCHAR2(18) NOT NULL Per Unit Field Name

28 RECNAME_SOURCE Character(15) VARCHAR2(15) NOT NULL Source Recname

29 REV_AMOUNT_SIGN Character(1) VARCHAR2(1) NOT NULL Position source indicator that specifies that the amount sign is to be reveresed.

30 INTERCOMPANY_FLG Character(1) VARCHAR2(1) NOT NULL /* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/

31 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

32 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

33 FIELDNAME_SOURCE Character(18) VARCHAR2(18) NOT NULL Source Fieldname

34 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym

35 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

36 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

37 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number

38 DEFAULT_VALUE Character(40) VARCHAR2(40) NOT NULL Default Value

39 INPUT_VALUE Character(40) VARCHAR2(40) NOT NULL Input Value

40 OUTPUT_VALUE Character(40) VARCHAR2(40) NOT NULL Output Value

41 GROUP_BY_FIELD Character(3) VARCHAR2(3) NOT NULL Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account
BNK=Bank
BU=Business Unit
CUR=Currency
GP1=Group By Field 1
GP2=Group By Field 2
GP3=Group By Field 3
GP4=Group By Field 4
GP5=Group By Field 5
GP6=Group By Field 6
GP7=Group By Field 7
WKS=Worksheet

42 SQLID Character(30) VARCHAR2(30) NOT NULL SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE
SQLTYPE = 0: SQL object name
SQLTYPE = 1: Application Engine Step Identifier
SQLTYPE = 2: RECNAME
SQLTYPE = 6: Application Engine XSLT (XML definition)

43 RATE_INDEX Character(10) VARCHAR2(10) NOT NULL Rate index

44 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

45 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

46 PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success

47 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler

48 SYSTEM_DATE Date(10) DATE System Date

49 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

50 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

51 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status

52 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

53 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

54 MESSAGE_PARM1 Character(30) VARCHAR2(30) NOT NULL Message Parameter 1

55 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2

56 SELECT_FLAG Character(1) VARCHAR2(1) NOT NULL Selection Flag
N=No
Y=Yes

57 FIRST_PASS_SW Character(1) VARCHAR2(1) NOT NULL First Pass Switch

58 SQLROWS_TAO Number(12,0) DECIMAL(12) NOT NULL Total Rows

59 EXIST Character(1) VARCHAR2(1) NOT NULL Exist

60 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

61 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

62 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

63 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

64 POSITION_CURRENCY Character(3) VARCHAR2(3) NOT NULL The transaction currency of a given position or exposure.

65 DFLT_POSN_CURRENCY Character(3) VARCHAR2(3) NOT NULL The default position currency of a given worksheet.

66 FCST_RULE_TYPE Character(2) VARCHAR2(2) NOT NULL Categorizes the cash forecasting rule according to the field the rule processes (e.g. amount or date) or by worksheet offset for the Copy function.
01=Amount
02=Date
03=Payment Method
04=Worksheet Offset
05=Replacement

67 BUSINESS_DT_RULE Character(1) VARCHAR2(1) NOT NULL How to change a date when it isn't a Business Day (when its a holiday), either: Following, Modified Following, Previous, Modified Previous
F=Following
M=Modified Following
N=Modified Previous
P=Previous

68 POS_SHIFT_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Represents the number of days by which a cash position worksheet may be copied forward.

69 POS_SHIFT_MONTHS Signed Number(4,0) DECIMAL(3) NOT NULL Represents the number of months by which a cash position worksheet may be copied forward.

70 POS_SHIFT_YEARS Signed Number(4,0) DECIMAL(3) NOT NULL Represents the number of years by which a cash position worksheet may be copied forward.

71 VALUE_DATE Date(10) DATE VALUE DATE

72 CALC_DT Date(10) DATE The calculation date for a given data set within the Position tools.

73 FIELDLIST Character(254) VARCHAR2(254) NOT NULL Used to store a list of FieldNames

74 WHERE_SOURCE_SET Character(254) VARCHAR2(254) NOT NULL Where Clause for Worksheet Source Set criteria

75 SQL_STMT Long Character(8192) CLOB An internal work field that contains SQL text that is to be utilized in treasury application processing.

#	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	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
4	REQUEST_NBR	Number(4,0)	SMALLINT NOT NULL	Request Number
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
6	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
7	SELECT_DT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Date Type 1=Specific Dates 2=Relative Dates
8	SRCH_DAYS_FROM	Number(5,0)	INTEGER NOT NULL	Days Back
9	SRCH_DAYS_TO	Number(5,0)	INTEGER NOT NULL	Days Ahead
10	EFFDT	Date(10)	DATE	Effective Date
11	LINE_ITEM_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals. 1=Cash 2=Non-Cash
12	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
13	WRKSHEET_LINE_ITEM	Character(30)	VARCHAR2(30) NOT NULL	Cash Forecast Worksheet Line item
14	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
15	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
16	SEL_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Cash Forecast Selection SQL statement.
17	CSH_FCST_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Uniquely identifies a Cash Forecasting Rule. The identifier is manually entered by the user and not automatically generated by the system.
18	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
19	POS_DEF_SRC_SET	Character(1)	VARCHAR2(1) NOT NULL	a checkbox that identifies the default position source set.
20	START_DT	Date(10)	DATE	Start Date
21	END_DT	Date(10)	DATE	End Date
22	AMOUNT_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	An internal work field utilized for calculating forecast amounts for a given category in cash wor
23	CURRENCY_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Currency Field Name
24	DATE_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	"(Generic field that crosses multiple products; in Treasury
25	REFR_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Reference Field Name
26	PYMNTMTH_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Payment Method Field Name
27	PER_UNIT_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Per Unit Field Name
28	RECNAME_SOURCE	Character(15)	VARCHAR2(15) NOT NULL	Source Recname
29	REV_AMOUNT_SIGN	Character(1)	VARCHAR2(1) NOT NULL	Position source indicator that specifies that the amount sign is to be reveresed.
30	INTERCOMPANY_FLG	Character(1)	VARCHAR2(1) NOT NULL	/* GMG 02/1999 R-CJOHNS-0E8DU InterCompany transfer enhancement*/
31	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
32	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
33	FIELDNAME_SOURCE	Character(18)	VARCHAR2(18) NOT NULL	Source Fieldname
34	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym
35	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
36	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
37	SEQNUM	Number(3,0)	SMALLINT NOT NULL	Sequence Number
38	DEFAULT_VALUE	Character(40)	VARCHAR2(40) NOT NULL	Default Value
39	INPUT_VALUE	Character(40)	VARCHAR2(40) NOT NULL	Input Value
40	OUTPUT_VALUE	Character(40)	VARCHAR2(40) NOT NULL	Output Value
41	GROUP_BY_FIELD	Character(3)	VARCHAR2(3) NOT NULL	Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values. BAC=Bank Account BNK=Bank BU=Business Unit CUR=Currency GP1=Group By Field 1 GP2=Group By Field 2 GP3=Group By Field 3 GP4=Group By Field 4 GP5=Group By Field 5 GP6=Group By Field 6 GP7=Group By Field 7 WKS=Worksheet
42	SQLID	Character(30)	VARCHAR2(30) NOT NULL	SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE SQLTYPE = 0: SQL object name SQLTYPE = 1: Application Engine Step Identifier SQLTYPE = 2: RECNAME SQLTYPE = 6: Application Engine XSLT (XML definition)
43	RATE_INDEX	Character(10)	VARCHAR2(10) NOT NULL	Rate index
44	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
45	PROCESS_FREQUENCY	Character(1)	VARCHAR2(1) NOT NULL	Process Frequency A=Always Process N=Don't Run O=Process Once
46	PROCESS_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Process Status A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success
47	PROCESS_ORIG	Character(1)	VARCHAR2(1) NOT NULL	Process Origin N=Other Source P=Process Scheduler
48	SYSTEM_DATE	Date(10)	DATE	System Date
49	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
50	STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status Indicator A=Active I=Inactive
51	AE_APPSTATUS	Number(1,0)	SMALLINT NOT NULL	AE Application Warning Status
52	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
53	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
54	MESSAGE_PARM1	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 1
55	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
56	SELECT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Selection Flag N=No Y=Yes
57	FIRST_PASS_SW	Character(1)	VARCHAR2(1) NOT NULL	First Pass Switch
58	SQLROWS_TAO	Number(12,0)	DECIMAL(12) NOT NULL	Total Rows
59	EXIST	Character(1)	VARCHAR2(1) NOT NULL	Exist
60	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
61	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
62	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
63	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
64	POSITION_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The transaction currency of a given position or exposure.
65	DFLT_POSN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The default position currency of a given worksheet.
66	FCST_RULE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Categorizes the cash forecasting rule according to the field the rule processes (e.g. amount or date) or by worksheet offset for the Copy function. 01=Amount 02=Date 03=Payment Method 04=Worksheet Offset 05=Replacement
67	BUSINESS_DT_RULE	Character(1)	VARCHAR2(1) NOT NULL	How to change a date when it isn't a Business Day (when its a holiday), either: Following, Modified Following, Previous, Modified Previous F=Following M=Modified Following N=Modified Previous P=Previous
68	POS_SHIFT_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Represents the number of days by which a cash position worksheet may be copied forward.
69	POS_SHIFT_MONTHS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Represents the number of months by which a cash position worksheet may be copied forward.
70	POS_SHIFT_YEARS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Represents the number of years by which a cash position worksheet may be copied forward.
71	VALUE_DATE	Date(10)	DATE	VALUE DATE
72	CALC_DT	Date(10)	DATE	The calculation date for a given data set within the Position tools.
73	FIELDLIST	Character(254)	VARCHAR2(254) NOT NULL	Used to store a list of FieldNames
74	WHERE_SOURCE_SET	Character(254)	VARCHAR2(254) NOT NULL	Where Clause for Worksheet Source Set criteria
75	SQL_STMT	Long Character(8192)	CLOB	An internal work field that contains SQL text that is to be utilized in treasury application processing.