PO_RECV_LN_VW

(SQL View)
Index Back

PO Line Received Activity View


SELECT BUSINESS_UNIT_PO , PO_ID , LINE_NBR , SCHED_NBR , BUSINESS_UNIT , RECEIVER_ID , RECV_LN_NBR , RECV_SHIP_SEQ_NBR , QTY_SH_ACCPT_VUOM , QTY_SH_RECVD_VUOM , QTY_SH_REJCT_VUOM , RECV_SHIP_STATUS , MERCHANDISE_AMT , CURRENCY_CD FROM PS_RECV_LN_SHIP WHERE BUSINESS_UNIT_PO <> ' ' AND PO_ID <> ' ' AND RECV_SHIP_STATUS <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL 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 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
6 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
7 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
8 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
9 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
10 QTY_SH_RECVD_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Receipt QTY in Supplier UOM
11 QTY_SH_REJCT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Reject QTY in Supplier UOM
12 RECV_SHIP_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Schedule Status
C=Closed
H=Hold
O=Open
R=Received
X=Canceled

Default Value: O

13 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code