PRCR_LST_ARC_VW

(SQL View)
 Index Back

Prcr Receiver List View


SELECT DISTINCT T.REPORT_ENTITY ,S.ITM_SETID ,S.INV_ITEM_ID ,S.CATEGORY_ID ,H.VENDOR_SETID ,H.VENDOR_ID ,S.BUSINESS_UNIT ,S.RECEIVER_ID ,S.RECV_LN_NBR ,S.RECV_SHIP_SEQ_NBR ,H.RECEIPT_DT ,H.RECV_STATUS ,S.DUE_DT ,S.BUSINESS_UNIT_PO ,S.PO_ID ,S.LINE_NBR ,S.SCHED_NBR ,S.QTY_SH_RECVD_SUOM ,S.QTY_SH_RECVD_VUOM ,S.QTY_SH_ACCPT_SUOM ,S.QTY_SH_ACCPT_VUOM ,S.QTY_SH_REJCT_VUOM ,S.MERCHANDISE_AMT ,S.DISTRIB_MTHD_FLG ,S.SHIPTO_ID ,S.RECV_LN_MATCH_OPT ,S.PRICE_PO ,S.SHIP_QTY_STATUS ,S.SHIP_DATE_STATUS ,S.MATCH_LINE_FLG ,S.DESCR254_MIXED ,S.RMA_ID ,S.LOT_STATUS ,S.SERIAL_STATUS ,S.RECV_SHIP_STATUS ,H.ORIGIN ,P.BUYER_ID ,PS.QTY_PO ,PS.MERCHANDISE_AMT ,V.VENDOR_NAME_SHORT ,V.NAME1 FROM PS_PO_LINE_SHIP PS , PS_RECV_LN_SHIP S , PS_RECV_HDR H , PS_VENDOR V , PS_PO_HDR P , PS_PRCR_ENTITY_BU A , PS_PRCR_ENTITY_TBL T , PS_BUS_UNIT_TBL_PM BU WHERE ( (T.INCLUDE_ALL_PO_BU = 'Y' AND BU.BUSINESS_UNIT = H.BUSINESS_UNIT ) OR (T.INCLUDE_ALL_RC_BU = 'N' AND T.REPORT_ENTITY = A.REPORT_ENTITY AND A.UNIT_TYPE = 'R' AND A.BUSINESS_UNIT = H.BUSINESS_UNIT ) ) AND H.VENDOR_SETID = V.SETID AND H.VENDOR_ID = V.VENDOR_ID AND H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.RECEIVER_ID = S.RECEIVER_ID AND S.BUSINESS_UNIT_PO = PS.BUSINESS_UNIT AND S.PO_ID = PS.PO_ID AND S.LINE_NBR = PS.LINE_NBR AND S.SCHED_NBR = PS.SCHED_NBR AND PS.BUSINESS_UNIT = P.BUSINESS_UNIT AND PS.PO_ID = P.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REPORT_ENTITY Character(5) VARCHAR2(5) NOT NULL Reporting Entity ID
2 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 CATEGORY_ID Character(5) VARCHAR2(5) NOT NULL Category ID
5 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
6 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
9 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
10 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
11 RECEIPT_DT Date(10) DATE Received Date
12 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
13 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.
14 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
15 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
16 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
17 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
18 QTY_SH_RECVD_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt Quantity
19 QTY_SH_RECVD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt QTY in Supplier UOM
20 QTY_SH_ACCPT_SUOM Number(16,4) DECIMAL(15,4) NOT NULL Accepted Quantity
21 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
22 QTY_SH_REJCT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Reject QTY in Supplier UOM
23 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
24 DISTRIB_MTHD_FLG Character(1) VARCHAR2(1) NOT NULL Distribute by
A=Amount
Q=Quantity

Default Value: Q

25 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location
26 RECV_LN_MATCH_OPT Character(1) VARCHAR2(1) NOT NULL Receipt Match Status
F=Matched
N=No Match
P=Partial
27 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
28 SHIP_QTY_STATUS Character(1) VARCHAR2(1) NOT NULL Quantity Status
1=Passes Quantity Check
2=Over Shipment
3=Under Shipment
29 SHIP_DATE_STATUS Character(1) VARCHAR2(1) NOT NULL Ship Date Status
1=Passes Date Check
2=Early Shipment
3=Late Shipment
30 MATCH_LINE_FLG Character(1) VARCHAR2(1) NOT NULL Line Level Match Flag

Y/N Table Edit

Default Value: Y

31 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
32 RMA_ID Character(10) VARCHAR2(10) NOT NULL RMA Number
33 LOT_STATUS Character(1) VARCHAR2(1) NOT NULL Lot Assigned Status
C=Complete
I=Incomplete

Default Value: I

34 SERIAL_STATUS Character(1) VARCHAR2(1) NOT NULL Serial Status
C=Complete
I=Incomplete

Default Value: I

35 RECV_LN_STATUS Character(1) VARCHAR2(1) NOT NULL Receiver Line Status
C=Closed Item
H=Hold Item
I=In Inspection
M=Moved to Destination
O=Open
P=PO Partially Received
R=Fully Received
X=Canceled

Default Value: O

36 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
37 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
38 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
39 AMT_ORDERED Number(27,3) DECIMAL(26,3) NOT NULL Amount Ordered
40 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
41 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1