PV_TRANSACTIONADM=Administration
BYR=Buyer Center
CMN=Common Actions
EXP=Expense
INV=Invoice
PRG=Progress Log
RCV=Receiving
REQ=Requisition
SUP=Supplier Administration
SWO=Work Order
TIM=Timesheet
WKL=Workflow
PV_ACT_CATEGORY_CDPV_ACTIONPV_ACTIONS_E_VW(SQL View) |
Index Back |
|---|---|
Role Actions Search View |
| SELECT PV_TRANSACTION , PV_ACT_CATEGORY_CD , PV_ACTION , DESCRLONG FROM PS_PV_ACTIONS WHERE PV_ACT_TYPE ='E' OR PV_ACT_TYPE = 'B' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PV_TRANSACTION |
Character(3) | VARCHAR2(3) NOT NULL |
Transaction
ADM=Administration BYR=Buyer Center CMN=Common Actions EXP=Expense INV=Invoice PRG=Progress Log RCV=Receiving REQ=Requisition SUP=Supplier Administration SWO=Work Order TIM=Timesheet WKL=Workflow |
| 2 | PV_ACT_CATEGORY_CD |
Character(6) | VARCHAR2(6) NOT NULL | Category Code |
| 3 | PV_ACTION |
Character(60) | VARCHAR2(60) NOT NULL | Action Name |
| 4 | DESCRLONG | Long Character | CLOB | Long Description |