VNDR_MTCHLN_VW2

(SQL View)
 Index Back

Voucher Ln PO Sched Num Prompt


SELECT DISTINCT c.vendor_id , a.business_unit , a.po_id , b.line_nbr , b.sched_nbr , a.po_dt , b.price_po , b.qty_po , b.merchandise_amt , c.vendor_name_short , a.currency_cd FROM ps_po_hdr_fs a , PS_PO_LINE_SHIP_FS b , ps_vendor c , ps_po_line_fs d WHERE a.business_unit = b.business_unit AND a.po_id = b.po_id AND a.vendor_setid = c.setid AND a.vendor_id = c.vendor_id AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PO_ID = D.PO_ID AND (a.po_status IN ('C','D','X','PX') OR (a.chng_ord_batch > 0 AND a.po_status IN ('A','PA','O')) OR (D.CNTRCT_ID <> ' ' AND A.PO_STATUS = 'A') OR (EXISTS ( SELECT 'X' FROM PS_CC_TRANS_LINE CCL WHERE CCL.BUSINESS_UNIT = B.BUSINESS_UNIT AND CCL.PO_ID = B.PO_ID AND CCL.PO_LINE_NBR = B.LINE_NBR AND CCL.PO_SCHED_NBR = B.SCHED_NBR AND A.PO_STATUS = 'A'))) AND a.ers_action = 'N' AND a.in_process_flg = 'N' AND b.cancel_status <> 'X'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
2 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
4 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
5 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
6 PO_DT Date(10) DATE Date
7 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
8 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
9 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
10 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
11 TXN_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Transaction Currency