ADD_LINEITEM_VW(SQL View) |
Index Back |
---|---|
Worksheet Line Item ViewView 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 |