RECV_PO_LINE_VW

(SQL View)
Index Back

Receiver PO Line View


SELECT BUSINESS_UNIT , PO_ID , LINE_NBR , DESCR254_MIXED , INV_ITEM_ID , UNIT_OF_MEASURE FROM PS_PO_LINE WHERE CANCEL_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage