BUSINESS_UNITPO_IDA=Active
C=Closed
D=Denied
H=Hold
O=Open
P=Pending Approval
X=Canceled
C=Changed
U=Unchanged
PO_SE_LINE_VW(SQL View) |
Index Back |
|---|---|
PO Line PTSF view |
| SELECT A.BUSINESS_UNIT , A.PO_ID , A.LINE_NBR , A.CANCEL_STATUS , A.CHANGE_STATUS , A.ITM_SETID , A.INV_ITEM_ID , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , A.CATEGORY_ID , A.MFG_ID , A.MFG_ITM_ID , A.CNTRCT_SETID , A.CNTRCT_ID , A.VRBT_ID , A.RFQ_ID , A.GPO_ID , A.GPO_CNTRCT_NBR , A.AUC_GROUP_ID , B.DESCR , C.DESCR60 , C.DESCRSHORT , D.DESCR60 , D.DESCRSHORT FROM (((PS_PO_LINE A LEFT OUTER JOIN PS_PURCH_ITEM_ATTR B ON B.INV_ITEM_ID = A.INV_ITEM_ID AND A.ITM_SETID = B.SETID ) LEFT OUTER JOIN PS_MANUFACTURER C ON C.MFG_ID = A.MFG_ID AND A.ITM_SETID = C.SETID ) LEFT OUTER JOIN PS_ITM_CAT_TBL D ON D.CATEGORY_ID = A.CATEGORY_ID AND A.ITM_SETID = D.SETID ) WHERE ( D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_ITM_CAT_TBL D1 WHERE D.SETID = D1.SETID AND D.CATEGORY_ID = D1.CATEGORY_ID AND D1.EFFDT <= %CurrentDateIn) ) |
| # | 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 | 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 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |
| 9 | VNDR_CATALOG_ID | Character(20) | VARCHAR2(20) NOT NULL | Vendor's Catalog Number |
| 10 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 11 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer ID |
| 12 | MFG_ITM_ID | Character(50) | VARCHAR2(50) NOT NULL | Manufacturer's Item ID |
| 13 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 14 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 15 | VRBT_ID | Character(25) | VARCHAR2(25) NOT NULL | Vendor Rebate ID |
| 16 | RFQ_ID | Character(10) | VARCHAR2(10) NOT NULL | RFQ ID |
| 17 | GPO_ID | Character(18) | VARCHAR2(18) NOT NULL | GPO ID |
| 18 | GPO_CNTRCT_NBR | Character(25) | VARCHAR2(25) NOT NULL | GPO Contract Number |
| 19 | AUC_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 21 | DESCR60_2 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 22 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 23 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 24 | DESCRSHORT2 | Character(10) | VARCHAR2(10) NOT NULL | Short Description |