PO_RECV_WB_VW

(SQL View)
 Index Back

Receiver Workbench Search View

Receiver Workbench Data Search View

SELECT A.BUSINESS_UNIT ,A.RECEIVER_ID ,B.RECV_LN_NBR ,B.BUSINESS_UNIT_PO ,A.RECEIPT_DT ,A.SHIPMENT_NO ,A.VENDOR_ID ,A.RECV_STATUS ,A.SHIPTO_ID ,A.RECV_SOURCE ,A.PO_RECEIPT_FLG ,B.PO_ID ,A.BILL_OF_LADING ,A.OPRID ,B.INV_ITEM_ID ,B.DESCR254_MIXED ,B.CATEGORY_ID ,B.MFG_ITM_ID ,B.ITM_ID_VNDR ,B.PO_GROUP_ID ,B.PRoCesS_COMPLETE ,B.RECV_SHIP_STATUS ,B.MOVE_STAT_AM ,B.MOVE_STAT_INV ,B.MOVE_STAT_MFG ,B.LOT_STATUS ,B.SERIAL_STATUS ,B.INSPECT_STATUS ,B.ERS_STATUS ,B.MATCH_LINE_FLG ,B.RECV_LN_MATCH_OPT ,B.INVOICE_ID ,B.PACKSLIP_NO ,B.UPN_ID FROM PS_RECV_HDR A , PS_RECV_LN_SHIP B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.RECEIVER_ID=B.RECEIVER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

Prompt Table: BUS_UNIT_TBL_PM

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

Prompt Table: SP_BU_PM_NONVW

5 RECEIPT_DT Date(10) DATE Received Date
6 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number

Prompt Table: RECV_AOLN_VW2

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

Prompt Table: VENDOR_VW

8 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
9 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_VW

10 RECV_SOURCE Character(1) VARCHAR2(1) NOT NULL Receive Source
1=On-line
2=ASN
3=Data Cllct
4=Mobile
11 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

Default Value: Y

12 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

Prompt Table: PO_HDR_RC_WB_VW

13 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.

Prompt Table: RECV_AOLN_VW1

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

Prompt Table: PSOPRDEFN_VW

15 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: ITM_PURCH_VW

16 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
17 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
18 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID

Prompt Table: ITM_MFG_ID_VW

19 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID

Prompt Table: PO_SSITMVNDR_VW

20 PO_GROUP_ID Character(18) VARCHAR2(18) NOT NULL GroupID

Prompt Table: PO_GROUP_VW

21 RECV_PRCS_COMPLETE Character(1) VARCHAR2(1) NOT NULL Receiver Workbench Search Process Complete
N=No
Y=Yes

Default Value: N

22 RECV_SHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Schedule Status
C=Closed
H=Hold
O=Open
R=Received
X=Canceled
23 MOVE_STAT_AM Character(1) VARCHAR2(1) NOT NULL AM Move Status
M=Moved
N=N/A
P=Pending
24 MOVE_STAT_INV Character(1) VARCHAR2(1) NOT NULL MOVE_STAT_INV
M=Moved
N=N/A
P=Pending
25 MOVE_STAT_MFG Character(1) VARCHAR2(1) NOT NULL Mfg Move Status
M=Moved
N=N/A
P=Pending
26 LOT_STATUS Character(1) VARCHAR2(1) NOT NULL Lot Assigned Status
C=Complete
I=Incomplete
27 SERIAL_STATUS Character(1) VARCHAR2(1) NOT NULL Serial Status
C=Complete
I=Incomplete
28 INSPECT_STATUS Character(1) VARCHAR2(1) NOT NULL Inspection Status
C=Complete
I=Incomplete
29 ERS_STATUS Character(1) VARCHAR2(1) NOT NULL ERS Status
I=Invoiced
N=Not Invoiced
30 RECV_MATCH_FLG Character(1) VARCHAR2(1) NOT NULL Receiver Workbench Search Matching Flag
N=No
Y=Yes
31 RECV_LN_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Receipt Match Status
F=Matched
N=No Match
P=Partial
32 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
33 PACKSLIP_NO Character(22) VARCHAR2(22) NOT NULL Packing Slip Number
34 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number