TR_FCST_AMT_AET (SQL Table)	Index Back
Cash Forecast Amount Rule AET Cash Forecast Rule for amount.

TR_FCST_AMT_AET

(SQL Table)

Cash Forecast Amount Rule AET

Cash Forecast Rule for amount.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

4 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

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

6 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

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

8 FIELDNAME_TARGET Character(18) VARCHAR2(18) NOT NULL Allocations Target amount field

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	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.
4	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
5	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals
6	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
7	ALIAS_NAME	Character(30)	VARCHAR2(30) NOT NULL	"A user defined synonym
8	FIELDNAME_TARGET	Character(18)	VARCHAR2(18) NOT NULL	Allocations Target amount field
9	UNIT_AMOUNT	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Unit Price
10	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code