RECV_RC_VW3

(SQL View)
 Index Back

Receipt ID RC Search


SELECT DISTINCT A.BUSINESS_UNIT , A.RECEIVER_ID , A.PO_RECEIPT_FLG , A.SHIPTO_ID , A.VENDOR_ID , B.NAME1 , A.RECEIPT_DT , A.RECV_STATUS FROM PS_RECV_HDR A , PS_VENDOR B , PS_RECV_LN_DISTRIB C WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.RECV_STATUS <> 'C' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RECEIVER_ID = C.RECEIVER_ID AND C.BUSINESS_UNIT_IN = ' ' AND C.LOC_RECV_LBL_FLG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
4 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
5 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
6 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
7 RECEIPT_DT Date(10) DATE Received Date
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