VNDR_MTCHLN_V11

(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 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.po_status IN ('C', 'D', 'X', 'PX') OR (a.chng_ord_batch > 0 AND a.po_status IN ('A', 'PA', 'O'))) AND a.ers_action = 'Y' 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