ADD_LINEITEM_VW

(SQL View)
Index Back

Worksheet Line Item View

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

SELECT SETID , WORKSHEET_ID , WRKSHEET_LINE_ITEM , EFFDT FROM PS_WORKSHEET_LINES WHERE LINE_ITEM_TYPE = '1'

# 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 WRKSHEET_LINE_ITEM Character(30) VARCHAR2(30) NOT NULL Cash Forecast Worksheet Line item
4 EFFDT Date(10) DATE NOT NULL Effective Date