BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_PM_NONVW
REQ_IDDefault Value: NEXT
PO_IDLINE_NBRSCHED_NBRPrompt Table: VENDOR
Prompt Table: VENDOR
PV_REQ_PO_D_VW2(SQL View) |
Index Back |
|---|---|
ePro PO Views |
| SELECT DISTINCT A.BUSINESS_UNIT , C.REQ_ID , A.PO_ID , A.LINE_NBR , A.SCHED_NBR , C.PO_DT ,C.VENDOR_ID ,C.VENDOR_NAME_SHORT ,C.MATCH_CNTRL_ID ,C.VNDR_LOC FROM PS_PO_LINE_SHIP A , PS_PO_LINE B , PS_PV_REQ_PO_B_VW2 C WHERE A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.PO_ID= B.PO_ID AND A.LINE_NBR = B.LINE_NBR AND A.BUSINESS_UNIT= C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_PM_NONVW |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 4 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 5 | SCHED_NBR |
Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 6 | PO_DT | Date(10) | DATE | Date |
| 7 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL |
Vendor Identifier
Prompt Table: VENDOR |
| 8 | VENDOR_NAME_SHORT | Character(14) | VARCHAR2(14) NOT NULL |
Short Vendor Name
Prompt Table: VENDOR |
| 9 | MATCH_CNTRL_ID | Character(10) | VARCHAR2(10) NOT NULL | Match Rule |
| 10 | VNDR_LOC | Character(10) | VARCHAR2(10) NOT NULL | Vendor Location |