EX_SHT_RCIMG_VW

(SQL View)
 Index Back

Receipt Imaging View - Expense

Receipt Imaging View - Expense

SELECT A.SHEET_ID ,0 ,A.EMPLID ,B.FIRST_NAME ,B.LAST_NAME ,A.BUSINESS_UNIT_GL ,MIN(D.TRANS_DT) ,MAX(D.TRANS_DT) ,C.BUSINESS_UNIT_GL ,C.DEPTID ,' ' ,C.BUSINESS_UNIT_PC ,C.PROJECT_ID ,'0' FROM PS_EX_SHEET_HDR A ,PS_EX_SHEET_SPLIT C ,PS_EX_SHEET_LINE D , PS_PERSONAL_DATA B WHERE A.SHEET_ID = C.SHEET_ID AND A.SHEET_ID = D.SHEET_ID AND A.EMPLID = B.EMPLID AND A.SHEET_STATUS <> 'PND' AND A.RECEIPTS_RECEIVED <> 'Y' GROUP BY A.SHEET_ID ,A.EMPLID ,B.FIRST_NAME ,B.LAST_NAME ,A.BUSINESS_UNIT_GL, C.BUSINESS_UNIT_GL ,C.DEPTID ,C.BUSINESS_UNIT_PC,C.PROJECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SHEET_ID Character(10) VARCHAR2(10) NOT NULL Report ID
2 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
5 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
6 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit
7 DATE_FROM Date(10) DATE Date From
8 DATE_TO Date(10) DATE Date To
9 BUSINESS_UNIT_CHRG Character(5) VARCHAR2(5) NOT NULL Charged Business Unit
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 EXPENSE_TYPE Character(7) VARCHAR2(7) NOT NULL Expense Type
12 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
13 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
14 RECEIPT_ID Character(10) VARCHAR2(10) NOT NULL Receipt ID