CSH_FCST_RULES (SQL Table)	Index Back
Cash Forecast Rules Cash Forecast Rules for amount, date, payment method and worksheet offset (i.e. historical).

CSH_FCST_RULES

(SQL Table)

Cash Forecast Rules

Cash Forecast Rules for amount, date, payment method and worksheet offset (i.e. historical).

Related Language Record: CSH_FCST_RUL_LN

Parent Record Of PMT_METHOD_RULE REPL_RULE_GROUP

# 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 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.

3 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

4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

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

6 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

7 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.

8 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.

9 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.

10 MEASURE_BY Character(1) VARCHAR2(1) NOT NULL Determines how an amount field is derived. Currently there is only one value Per Unit.
1=Per Unit

11 ALIAS_NAME Character(30) VARCHAR2(30) NOT NULL "A user defined synonym
Prompt Table: POS_FLD_GRP_VW

12 FIELDNAME_TARGET Character(18) VARCHAR2(18) NOT NULL Allocations Target amount field
Prompt Table: TARGET_FLDS_VW

13 UNIT_AMOUNT Signed Number(17,4) DECIMAL(15,4) NOT NULL Unit Price

#	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	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.
3	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
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
5	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals Default Value: 1
6	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
7	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.
8	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.
9	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.
10	MEASURE_BY	Character(1)	VARCHAR2(1) NOT NULL	Determines how an amount field is derived. Currently there is only one value Per Unit. 1=Per Unit
11	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym Prompt Table: POS_FLD_GRP_VW
12	FIELDNAME_TARGET	Character(18)	VARCHAR2(18) NOT NULL	Allocations Target amount field Prompt Table: TARGET_FLDS_VW
13	UNIT_AMOUNT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price