BUSINESS_UNITPO_IDPO_LINE_NBRPV_SS_INV_DL_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.INV_ITEM_ID , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , %Substring(A.DESCR254_MIXED , 1 , 30) , C.ACCOUNT , C.ALTACCT , D.PRICE_PO , SUM(B.QTY_PO) , SUM(B.MERCHANDISE_AMT) FROM PS_PO_LINE A , PS_PO_LINE_SHIP B , PS_PV_SS_ACCT_VW C , PS_PV_SS_AMOUNT_VW D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.PO_ID=B.PO_ID AND A.PO_ID=C.PO_ID AND A.PO_ID=D.PO_ID AND A.LINE_NBR=B.LINE_NBR AND A.LINE_NBR=C.LINE_NBR AND A.LINE_NBR=D.LINE_NBR GROUP BY A.BUSINESS_UNIT, A.PO_ID, A.LINE_NBR, A.INV_ITEM_ID, A.ITM_ID_VNDR, A.VNDR_CATALOG_ID, A.DESCR254_MIXED, C.ACCOUNT, C.ALTACCT, D.PRICE_PO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | PO_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Purchase Order Line Number |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 6 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
| 7 | ITEM_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Item Description |
| 8 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL | Account |
| 9 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 10 | UNIT_PRICE | Signed Number(17,5) | DECIMAL(15,5) NOT NULL | Unit Price |
| 11 | QTY_VCHR | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity Vouchered |
| 12 | MERCHANDISE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label |