WRKSHT_LINES (SQL View)	Index Back
Worksheet Line Item View View over Cash Forecast Worksheet Line Items that selects only Cash Line Items.

WRKSHT_LINES

(SQL View)

Worksheet Line Item View

View over Cash Forecast Worksheet Line Items that selects only Cash Line Items.

SELECT L.SETID , L.WORKSHEET_ID , L.EFFDT , L.LINE_ITEM_TYPE , L.LINE_NBR , L.WRKSHEET_LINE_ITEM , S.SOURCE_SET , S.POS_SOURCE_ID , S.SEL_SQLCNTRL_ID , S.CSH_FCST_RULE_ID , S.WEIGHTING FROM PS_WORKSHEET_LINES L , PS_WORKSHEET_SRCE S WHERE L.SETID = S.SETID AND L.WORKSHEET_ID = S.WORKSHEET_ID AND L.EFFDT = S.EFFDT AND L.LINE_ITEM_TYPE = S.LINE_ITEM_TYPE AND L.WRKSHEET_LINE_ITEM = S.WRKSHEET_LINE_ITEM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EFFDT Date(10) DATE NOT NULL Effective 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
Default Value: 1

5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]

6 WRKSHEET_LINE_ITEM Character(30) VARCHAR2(30) NOT NULL Cash Forecast Worksheet Line item

7 SOURCE_SET Character(20) VARCHAR2(20) NOT NULL A field name describing a group od position sources.

8 POS_SOURCE_ID Character(18) VARCHAR2(18) NOT NULL "A unique key identifier that represents a position source dataset

9 SEL_SQLCNTRL_ID Character(20) VARCHAR2(20) NOT NULL The system code used to identify a Cash Forecast Selection SQL statement.

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	WORKSHEET_ID	Character(20)	VARCHAR2(20) NOT NULL	Cash Flows Worksheet ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective 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 Default Value: 1
5	LINE_NBR	Number(5,0)	INTEGER NOT NULL	Line Number: 11/24/08 - Added TARGET label [PC product]
6	WRKSHEET_LINE_ITEM	Character(30)	VARCHAR2(30) NOT NULL	Cash Forecast Worksheet Line item
7	SOURCE_SET	Character(20)	VARCHAR2(20) NOT NULL	A field name describing a group od position sources.
8	POS_SOURCE_ID	Character(18)	VARCHAR2(18) NOT NULL	"A unique key identifier that represents a position source dataset
9	SEL_SQLCNTRL_ID	Character(20)	VARCHAR2(20) NOT NULL	The system code used to identify a Cash Forecast Selection SQL statement.
10	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.
11	WEIGHTING	Signed Number(10,5)	DECIMAL(8,5) NOT NULL	Used for applying a weighting to totals. e.g. Limit Utilisation totals