ITEM_DUE_SF2_VW

(SQL View)
Index Back

View of ITEM_DUE_SF

This view gives the open items in ITEM_SF

SELECT A.BUSINESS_UNIT ,A.COMMON_ID ,A.SA_ID_TYPE ,A.EMPLID ,A.EXT_ORG_ID ,A.ITEM_NBR ,A.DUE_DT ,SUM(A.DUE_AMT-A.APPLIED_AMT) FROM PS_ITEM_DUE_SF A WHERE A.DUE_AMT-A.APPLIED_AMT > 0 GROUP BY A.BUSINESS_UNIT ,A.COMMON_ID ,SA_ID_TYPE ,A.ITEM_NBR ,A.DUE_DT ,A.EMPLID ,A.EXT_ORG_ID

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
6 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
7 DUE_DT Date(10) DATE Due Date
8 DUE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Due Amount