CONVR_BI_BU_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 CONVR_QUAL_FIELD Character(30) VARCHAR2(30) NOT NULL Conversation Qualifier Field
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer