PO_SSPOLN_VW3

(SQL View)
 Index Back

Po Lines , no vouchewr


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