BI_CONTR_VW

(SQL View)
 Index Back

Grants Contracts and Invoices

Defines non-blank contracts with invoices in Billing

SELECT DISTINCT CONTRACT_NUM FROM PS_BI_HDR WHERE CONTRACT_NUM <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract