SSF_ITM_INV_VW2

(SQL View)
 Index Back

View of SSF_ITEM_INV

This view summarizes SSF_ITEM_INV by invoice_id.

SELECT A.BUSINESS_UNIT ,A.COMMON_ID ,A.SA_ID_TYPE ,A.ITEM_NBR ,A.INVOICE_ID ,A.INVOICE_DT ,SUM(A.SSF_INVOICED_AMT) ,SUM(A.DUE_AMT) ,SUM(A.APPLIED_AMT) ,SUM(A.DUE_AMT) -SUM(A.APPLIED_AMT) FROM PS_SSF_ITEM_INV A GROUP BY A.BUSINESS_UNIT ,A.COMMON_ID ,A.SA_ID_TYPE ,A.ITEM_NBR ,A.INVOICE_ID ,A.INVOICE_DT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 COMMON_ID Character(11) VARCHAR2(11) NOT NULL Common ID to store Personal ID / Ext Org ID value
3 SA_ID_TYPE Character(1) VARCHAR2(1) NOT NULL ID Type
O=Organization
P=Person
4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
5 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
6 INVOICE_DT Date(10) DATE Invoice Date
7 SSF_INVOICED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Invoiced Amount
8 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
9 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount
10 BALANCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Charge Balance