RECV_LOG_LN_VW

(SQL View)
 Index Back

ERS Log Exceptions


SELECT a.business_unit_recv , a.receiver_id , a.recv_ln_nbr , a.recv_ship_seq_nbr , a.business_unit , a.voucher_id , a.voucher_line_num , a.business_unit_po , a.po_id , a.line_nbr , a.sched_nbr , a.vendor_po , a.pymnt_terms_cd_po , a.inv_item_id , a.inv_item_id_po , a.qty_po , 0 , a.qty_received_cnvt , a.qty_received_cnvt , a.qty_vchr , a.qty_sh_accpt_vuom , a.price_po , a.unit_price_cnvt , a.qty_recv_tol_pct FROM PS_VCHR_MTCH_DETLS a

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_RECV Character(5) VARCHAR2(5) NOT NULL Receiving Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
7 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
8 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
9 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
10 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
11 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
12 VENDOR_PO Character(10) VARCHAR2(10) NOT NULL Supplier ID PO
13 PYMNT_TERMS_CD_PO Character(5) VARCHAR2(5) NOT NULL PO Payment Terms
14 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
15 INV_ITEM_ID_PO Character(18) VARCHAR2(18) NOT NULL Item Number PO
16 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
17 QTY_MATCHED Number(16,4) DECIMAL(15,4) NOT NULL Quantity Matched
18 QTY_RECEIVED_CNVT Number(16,4) DECIMAL(15,4) NOT NULL Received Qty Converted
19 QTY_RECEIPT_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Receipt Quantity Cnvt
20 QTY_VCHR_CNVT Signed Number(17,4) DECIMAL(15,4) NOT NULL Voucher Qty Converted
21 QTY_SH_ACCPT_VUOM Number(16,4) DECIMAL(15,4) NOT NULL Accept QTY in Supplier UOM
22 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
23 UNIT_PRICE_CNVT Number(16,5) DECIMAL(15,5) NOT NULL Unit Price Converted
24 QTY_RECV_TOL_PCT Number(6,2) DECIMAL(5,2) NOT NULL Qty Rcvd Tolerance %