PV_RQSTR_OPR_VW(SQL View) |
Index Back |
|---|---|
Active Requestor Table |
| SELECT A.REQUESTOR_ID ,B.OPRDEFNDESC , A.SHIPTO_SETID , A.SHIPTO_ID , A.LOCATION_SETID , A.LOCATION , A.DEPTID_SETID , A.DEPTID , A.PHONE , B.EMAILID , A.BUSINESS_UNIT_GL , A.ACCOUNT , A.ALTACCT FROM PS_REQUESTOR_TBL A ,PSOPRDEFN B WHERE A.REQUESTOR_ID = B.OPRID AND A.ACTIVE_FLG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  REQUESTOR_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Requestor id
Prompt Table: ROLEXLATOPR_VW |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 3 | SHIPTO_SETID | Character(5) | VARCHAR2(5) NOT NULL |
ShipTo SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 4 | SHIPTO_ID | Character(10) | VARCHAR2(10) NOT NULL |
Ship To Location
Prompt Table: SHIP_SHIPSET_VW |
| 5 | LOCATION_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Location Set ID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 6 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL |
Location Code
Prompt Table: LOC_LOCSET_VW |
| 7 | DEPTID_SETID | Character(5) | VARCHAR2(5) NOT NULL |
Department SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 8 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 10 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 11 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL |
GL Business Unit
Prompt Table: SP_BUPRCR_NONVW |
| 12 | ACCOUNT | Character(10) | VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDIT_ACCOUNT
|
| 13 | ALTACCT | Character(10) | VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDIT_ALTACCT
|