TR_FCST_DTE_AET

#	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	PYMNT_METHOD	Character(3)	VARCHAR2(3) NOT NULL	Payment Method ACH=Automated Clearing House BEF=Draft - Customer EFT BOO=Draft - Customer Initiated CHK=System Check D=Deposit DD=Direct Debit DFT=Draft - Supplier Initiated DRA=Draft EFT=Electronic Funds Transfer GE=Giro - EFT GM=Giro - Manual LC=Letter of Credit MAN=Manual Check TRW=Treasury Wire WIR=Wire Transfer
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	VALUE_DT	Date(10)	DATE	Equivalent to a deal transaction's settlement date.
11	NEW_DATE	Date(10)	DATE	Service Order New Date
12	RETURN_DATE	Date(10)	DATE	Return Date
13	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	ERROR_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Error Flag