CONVR_BI_IN_VW

(SQL View)
 Index Back

Qualifier view for Conversatio

Qualifier view for Conversations

SELECT INVOICE , BUSINESS_UNIT , BILL_TO_CUST_ID FROM PS_BI_HDR WHERE BILL_STATUS NOT IN ('TMP', 'TMR')

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