BI_HDR_CANC_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT ,A.INVOICE_ID ,A.EMPLID ,A.EXT_ORG_ID ,A.BILL_TYPE_ID ,A.SF_BILL_STATUS FROM PS_BI_BILL_HEADER A WHERE A.SF_BILL_STATUS = 'I' AND (A.BILL_DATE_TIME = ( SELECT MAX(C.BILL_DATE_TIME) FROM PS_BI_BILL_HEADER C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.EMPLID = A.EMPLID AND C.SF_BILL_STATUS = 'I' ) OR A.BI_REQ_NBR = ( SELECT MAX(C1.BI_REQ_NBR) FROM PS_BI_BILL_HEADER C1 WHERE C1.BUSINESS_UNIT = A.BUSINESS_UNIT AND C1.EXT_ORG_ID = A.EXT_ORG_ID AND C1.SF_BILL_STATUS = 'I' ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
5 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type ID
PP=Payment Plan
PRE=Pre-Payment
STU=Student
TP=Third Party
6 SF_BILL_STATUS Character(1) VARCHAR2(1) NOT NULL Billing Status
C=Cancelled
I=Initiated