WORKSHEET_SRCE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Prompt Table: SP_SETID_NONVW
2	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	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
5	WRKSHEET_LINE_ITEM	Character(30)	VARCHAR2(30) NOT NULL	Cash Forecast Worksheet Line item
6	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources. Prompt Table: SOURCE_SET_DEFN
7	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset Prompt Table: %EDITTABLE
8	SEL_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Cash Forecast Selection SQL statement. Prompt Table: POS_SRCE_SEL_VW
9	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: REPL_RULES_VW
10	AMOUNT_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Uniquely identifies a Cash Forecasting Rule with a rule type of Amount. Prompt Table: AMOUNT_RULES_VW
11	DATE_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	Uniquely identifies a Cash Forecasting Rule with a rule type of Date or Payment Method. Both are types of date rules. Prompt Table: DATE_RULES_VW
12	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals