EX_MYWAL_EXP_VW

(SQL View)
 Index Back

My Wallet to Expense view

My Wallet to Expense consumption

SELECT A.SHEET_ID , A.LINE_NBR , D.DISTRIB_LINE_NUM , ROUND(%DateDiff(A.TRANS_DT, B.CREATION_DT) ,2) AS DAYS FROM PS_EX_TRANS A , PS_EX_SHEET_HDR B , PS_EX_SHEET_LINE C , PS_EX_SHEET_DIST D WHERE A.SHEET_ID <> ' ' AND A.SHEET_ID = B.SHEET_ID AND B.SHEET_ID = C.SHEET_ID AND A.EMPLID = B.EMPLID AND A.LINE_NBR = C.LINE_NBR AND A.SHEET_ID = D.SHEET_ID AND A.LINE_NBR = D.LINE_NBR AND D.DISTRIB_LINE_NUM = ( SELECT MAX(D1.DISTRIB_LINE_NUM) FROM PS_EX_SHEET_DIST D1 WHERE D1.SHEET_ID = A.SHEET_ID AND D1.LINE_NBR = A.LINE_NBR) AND EX_DOC_TYPE = 'S'

# 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 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
4 EX_MYWAL_TO_EXP Signed Number(14,2) DECIMAL(12,2) NOT NULL My Wallet to Expense consumption in days