BI_IVC_CONTR_VW

(SQL View)
Index Back

Grants Invoices with Contracts


SELECT DISTINCT A.BUSINESS_UNIT ,A.INVOICE ,A.CONTRACT_NUM ,A.FROM_DT ,A.TO_DT FROM PS_BI_HDR A WHERE CONTRACT_NUM <> ' ' AND A.BILL_STATUS IN ('RDY','FNL','INV')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice
3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
4 FROM_DT Date(10) DATE From Date
5 TO_DT Date(10) DATE To Date