PV_RECV_UPD_VW

(SQL View)
 Index Back

SELECT DISTINCT A.BUSINESS_UNIT , A.RECEIVER_ID , C.BUSINESS_UNIT_PO , C.PO_ID , A.BILL_OF_LADING , A.PO_RECEIPT_FLG , A.RECV_SOURCE , A.VENDOR_SETID , A.SHIPTO_ID , A.SHIPMENT_NO , A.VENDOR_ID , A.RECEIPT_DT , A.RECV_STATUS , A.OPRID , A.INTFC_ASSET , A.INTFC_INVENTORY , A.INTFC_MG , 0 , ' ' FROM PS_RECV_HDR A , PS_RECV_LN_SHIP C WHERE A.RECEIVER_ID = C.RECEIVER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT

# 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 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
6 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
7 RECV_SOURCE Character(1) VARCHAR2(1) NOT NULL Receive Source
1=On-line
2=ASN
3=Data Cllct
4=Mobile
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
10 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
11 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
12 RECEIPT_DT Date(10) DATE Received Date
13 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
14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
15 INTFC_ASSET Character(1) VARCHAR2(1) NOT NULL Process Assets
16 INTFC_INVENTORY Character(1) VARCHAR2(1) NOT NULL Process Inventory
17 INTFC_MG Character(1) VARCHAR2(1) NOT NULL Process Manufacturing
18 LINE_COUNT Number(5,0) INTEGER NOT NULL Line Count
19 PV_RECV_MSG1 Character(254) VARCHAR2(254) NOT NULL Inquire Receipts