RECV_PO_SIT1_VW

(SQL View)
 Index Back

PO Line Item View


SELECT DISTINCT S.BUSINESS_UNIT_PO , S.PO_ID , S.LINE_NBR , S.SCHED_NBR , I.DEVICE_TRACKING , S.DUE_DT , S.INV_ITEM_ID , B.ITEM_BU_ATTR , S.ITM_ID_VNDR , S.ITM_SETID , I.LOT_CONTROL , S.MFG_ID , S.MFG_ITM_ID , P.MODEL , P.QTY_RECV_TOL_PCT , P.RECV_PARTIAL_FLG , S.RELEASE_NBR , P.RJCT_OVER_TOL_FLAG , P.ROUTING_ID , P.REJECT_DAYS , I.SERIAL_CONTROL , S.SHIP_TYPE_ID , S.SHIPTO_ID , I.UNIT_MEASURE_STD , S.VENDOR_ID , S.UPN_TYPE_CD , S.UPN_ID FROM PS_RECV_PO_SHIP_VW S , PS_BUS_UNIT_TBL_PM B , PS_PURCH_ITEM_ATTR P , PS_MASTER_ITEM_TBL I WHERE S.BUSINESS_UNIT_PO = B.BUSINESS_UNIT AND S.ITM_SETID = P.SETID AND S.INV_ITEM_ID = P.INV_ITEM_ID AND S.ITM_SETID = I.SETID AND S.INV_ITEM_ID = I.INV_ITEM_ID

# 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 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 DEVICE_TRACKING Character(1) VARCHAR2(1) NOT NULL Device Tracking Indicator

Y/N Table Edit

6 DUE_DT Date(10) DATE Specifies the date that a transaction is due. It is a generic field used in multiple PeopleSoft applications including Receivables Payables and Purchasing. For example it represents the date that payment is due for a voucher or the date that a scheduled shipment is due to be received.
7 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
8 ITEM_BU_ATTR Character(1) VARCHAR2(1) NOT NULL Allow Business Item Attributes

Y/N Table Edit

9 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
10 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
11 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y

Y/N Table Edit

12 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID
13 MFG_ITM_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer's Item ID
14 MODEL Character(30) VARCHAR2(30) NOT NULL Model
15 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %
16 RECV_PARTIAL_FLG Character(1) VARCHAR2(1) NOT NULL Partial Qty
1=Recvd
2=Recvd/Warn
3=Open
4=Open/Warn
5=Open/Error
17 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
18 RJCT_OVER_TOL_FLAG Character(1) VARCHAR2(1) NOT NULL Reject Qty Over Tolerance

Y/N Table Edit

19 ROUTING_ID Character(10) VARCHAR2(10) NOT NULL Inspection Routing ID
20 REJECT_DAYS Number(3,0) SMALLINT NOT NULL Early Ship Rjct Days
21 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y

Y/N Table Edit

22 SHIP_TYPE_ID Character(10) VARCHAR2(10) NOT NULL Ship Via Code
23 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

Prompt Table: SHIPTO_TBL

24 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
25 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
26 UPN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Universal Product Number Format Type
27 UPN_ID Character(20) VARCHAR2(20) NOT NULL Universal Product Number