BI_CUSTC_CON_VW

(SQL View)
 Index Back

BillCust Header Cont Consol Vw


SELECT DISTINCT bill_to_cust_id , %Substring(contract_num, 1, 15) FROM PS_BI_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 KEY_QRY_VALUE Character(30) VARCHAR2(30) NOT NULL Key Query Value
2 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer