PO_RECV_WB_SCR (SQL Table)	Index Back
Receiver Workbench Search Receiver Workbench Search Results Table

PO_RECV_WB_SCR

(SQL Table)

Receiver Workbench Search

Receiver Workbench Search Results Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID

3 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

4 SELECT_PO Character(1) VARCHAR2(1) NOT NULL Select PO
N=Off
Y=On

5 RECEIPT_DT Date(10) DATE Received Date

6 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
C=Closed Receipt
H=Hold Receipt
M=Moved to Destination
N=PO Not Received
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

7 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
Y/N Table Edit

8 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

10 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number

11 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

12 LAST_DTTM_UPDATE DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	WORKBENCH_ID	Character(10)	VARCHAR2(10) NOT NULL	WorkBench ID
3	RECEIVER_ID	Character(10)	VARCHAR2(10) NOT NULL	Receiver number
4	SELECT_PO	Character(1)	VARCHAR2(1) NOT NULL	Select PO N=Off Y=On
5	RECEIPT_DT	Date(10)	DATE	Received Date
6	RECV_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Receipt Status C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled
7	PO_RECEIPT_FLG	Character(1)	VARCHAR2(1) NOT NULL	PO Receipt Flag - identifies if the receipt is related to a purchase order Y/N Table Edit
8	SHIPTO_ID	Character(10)	VARCHAR2(10) NOT NULL	Ship To Location
9	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
10	SHIPMENT_NO	Character(30)	VARCHAR2(30) NOT NULL	Shipment Number
11	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
12	LAST_DTTM_UPDATE	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.