WRKSHT_RULES_V2 (SQL View)	Index Back
Worksheet Rules View View over Worksheet Rules.

WRKSHT_RULES_V2

(SQL View)

Worksheet Rules View

View over Worksheet Rules.

SELECT W.SETID ,W.WORKSHEET_ID ,W.EFFDT ,W.CSH_FCST_RULE_ID ,R.FCST_RULE_TYPE FROM PS_WORKSHEET_RULES W , PS_CSH_FCST_RULES R WHERE W.SETID = R.SETID AND W.CSH_FCST_RULE_ID = R.CSH_FCST_RULE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

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

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 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.
Prompt Table: CSH_FCST_RULES

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	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. Prompt Table: CSH_FCST_RULES
5	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