BI_CUST_SS_VW

(SQL View)
Index Back

SELECT DISTINCT O.OPRID , H.BILL_TO_CUST_ID ,S.SETID FROM PS_BI_HDR H , PSOPRALIAS O , PS_SET_CNTRL_REC S WHERE H.BILL_STATUS = 'INV' AND CONSOL_HDR <> 'Y' AND H.BILL_TO_CUST_ID = O.OPRALIASVALUE AND O.OPRALIASTYPE = 'CST' AND S.RECNAME = 'CUSTOMER' AND S.SETID = O.SETID AND S.SETCNTRLVALUE = H.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID