PO_SSPOLN_VW

(SQL View)
 Index Back

SELECT C.BUSINESS_UNIT , C.VOUCHER_ID , A. BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.CANCEL_STATUS , A.CHANGE_STATUS , A.ITM_SETID , A.INV_ITEM_ID , A.DESCR254_MIXED , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , A.UNIT_OF_MEASURE , B.CURRENCY_CD , SUM(B.QTY_PO) , SUM(B.MERCHANDISE_AMT) FROM PS_PO_LINE_FS A , PS_PO_LINE_SHIP_FS B , PS_VCHR_LN_FS C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND B.BUSINESS_UNIT = C.BUSINESS_UNIT_PO AND B.PO_ID = C.PO_ID AND B.LINE_NBR = C.LINE_NBR AND B.SCHED_NBR = C.SCHED_NBR GROUP BY C.BUSINESS_UNIT, C.VOUCHER_ID, A. BUSINESS_UNIT, A.PO_ID, A.LINE_NBR, A.CANCEL_STATUS, A.CHANGE_STATUS, A.ITM_SETID, A.INV_ITEM_ID, A.DESCR254_MIXED, A.ITM_ID_VNDR, A.VNDR_CATALOG_ID, A.UNIT_OF_MEASURE, B.CURRENCY_CD

# 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 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
6 CANCEL_STATUS Character(1) VARCHAR2(1) NOT NULL Cancel Status
A=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
7 CHANGE_STATUS Character(1) VARCHAR2(1) NOT NULL Change Order Status
C=Changed
U=Unchanged
8 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
9 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
12 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
13 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
14 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
15 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity
16 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label