EX_EXC_PG_VW2

(SQL View)
 Index Back

EX EXPENSES EXCEPTION

PIVOT GRID

SELECT B.SHEET_ID , B.LINE_NBR , 'NR' FROM PS_EX_SHEET_LINE B WHERE NO_RECEIPT_FLG = 'Y' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'PE' FROM PS_EX_SHEET_LINE B WHERE B.PERSONAL_EXPENSE = 'Y' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'OT' FROM PS_EX_SHEET_LINE B WHERE B.OLDER_TRANSACTION = 'Y' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'DE' FROM PS_EX_SHEET_LINE B WHERE B.DUPLICATES_EXIST = 'Y' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'TI' FROM PS_EX_SHEET_LINE B WHERE B.TAX_IMPLICATIONS = 'Y' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'VR' FROM PS_EX_SHEET_LINE B WHERE B.VAT_RECEIPT = 'Y' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'LA' FROM PS_EX_SHEET_LINE B WHERE B.EE_LOCAMT_COMMENT <> ' ' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0 UNION ALL SELECT B.SHEET_ID , B.LINE_NBR , 'LG' FROM PS_EX_SHEET_LINE B WHERE B.EE_LOCAMT_GRP_CMMT <> ' ' AND B.EX_LINE_STATUS NOT IN ('CLS', 'ESC', 'DEN','DNA', 'DNU', 'PND') AND B.MONETARY_AMOUNT > 0

# 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]

Default Value: 1

3 EX_EXCEPTION Character(2) VARCHAR2(2) NOT NULL Expenses exceptions
DE=Duplicate Exists
LA=Location Amount Exceeded
LG=Location Amount Group Exceeded
NR=No Receipt
OT=Older Transactions
PE=Non Reimbursable
TI=Tax Implications
VR=No VAT Receipt