AP_MEC_P_VW

(SQL View)
 Index Back

AP MECC - PO Details View

AP MECC - Purchase Order Details View

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , B.PRICE_PO , C.UNIT_OF_MEASURE , B.QTY_PO ,C.INV_ITEM_ID , B.CURRENCY_CD , B.MERCHANDISE_AMT , D.BUYER_ID FROM PS_VOUCHER_LINE A , PS_PO_LINE_SHIP B , PS_PO_LINE C , PS_PO_HDR D WHERE A.BUSINESS_UNIT_PO = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_NBR = B.SCHED_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PO_ID = C.PO_ID AND B.LINE_NBR = C.LINE_NBR AND A.BUSINESS_UNIT_PO = D.BUSINESS_UNIT AND A.PO_ID = D.PO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 VOUCHER_LINE_NUM Number(5,0) INTEGER NOT NULL Voucher Line Number
4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
5 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
6 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
7 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
8 PRICE_PO Signed Number(17,5) DECIMAL(15,5) NOT NULL Purchase Order Price
9 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
10 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
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 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer