BI_CUSTID_VW

(SQL View)
Index Back

Customers BUs from BI_HDR

Customers and Business Units from the BI_HDR Table.

SELECT DISTINCT BUSINESS_UNIT ,BILL_TO_CUST_ID FROM PS_BI_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer