SSF_ITEM_INV_VW

(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.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.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 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
5 INVOICE_DT Date(10) DATE Invoice Date
6 SSF_INVOICED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Invoiced Amount
7 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount
8 APPLIED_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Applied Amount
9 BALANCE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Charge Balance