BI_CONTC_PO_VW (SQL View)	Index Back
BillCont Header PO Consol Vw

BI_CONTC_PO_VW

(SQL View)

BillCont Header PO Consol Vw

select distinct contract_num, po_ref 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 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KEY_QRY_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Key Query Value
2	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.