AP_VCPOSCHDT_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.VOUCHER_LINE_NUM , A.BUSINESS_UNIT_PO , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , C.INV_ITEM_ID , C.DESCR254_MIXED , B.QTY_PO , B.MERCHANDISE_AMT , A.QTY_VCHR , A.MERCHANDISE_AMT , C.UNIT_OF_MEASURE , A.UNIT_OF_MEASURE FROM PS_VOUCHER_LINE A , PS_PO_LINE_SHIP B , PS_PO_LINE C WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT_PO AND B.PO_ID = A.PO_ID AND B.LINE_NBR = A.LINE_NBR AND B.SCHED_NBR = A.SCHED_NBR AND C.BUSINESS_UNIT = B.BUSINESS_UNIT AND C.PO_ID = B.PO_ID AND C.LINE_NBR = B.LINE_NBR

# 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 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
9 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
10 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
11 MERCH_AMT_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amount
12 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered
13 MERCH_AMT_VCHR Signed Number(28,3) DECIMAL(26,3) NOT NULL Voucher Merchandise Amount
14 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
15 UOM_VCHR Character(3) VARCHAR2(3) NOT NULL Unit Of Measure Voucher