SSF_INV_EMP_VW

(SQL View)
 Index Back

Invoice Emplid View

Invoice Id for emplid

SELECT A.BUSINESS_UNIT , A.COMMON_ID , A.INVOICE_ID , A.COMMON_ID , A.SA_ID_TYPE , A.INVOICE_DT , SUM(A.DUE_AMT) - SUM(A.APPLIED_AMT) FROM PS_SSF_ITEM_INV A WHERE SA_ID_TYPE = 'P' AND INVOICE_ID <> ' ' GROUP BY A.BUSINESS_UNIT , A.COMMON_ID , A.INVOICE_ID , A.COMMON_ID,A.SA_ID_TYPE , A.INVOICE_DT HAVING SUM(A.DUE_AMT) - SUM(A.APPLIED_AMT) > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
4 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
5 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
6 INVOICE_DT Date(10) DATE Invoice Date
7 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount