PO_REF_VW (SQL View)	Index Back
AR - Unique POs

PO_REF_VW

(SQL View)

AR - Unique POs

select C.po_ref, C.po_line from PS_ITEM C where C.po_ref <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.
Prompt Table: ITEM_PO_K_VW

2 PO_LINE Number(3,0) SMALLINT NOT NULL Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item. Prompt Table: ITEM_PO_K_VW
2	PO_LINE	Number(3,0)	SMALLINT NOT NULL	Specifies the line number of a purchase order associated with a receivables item. It is used with the field PO_REF.