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_ACT_CAT_VW(SQL View) |
Index Back |
|---|
| SELECT A.PV_TRANSACTION ,A.PV_ACT_CATEGORY_CD ,A.DESCR ,A.DESCR254 FROM PS_PV_ACT_CATEGORY A WHERE EXISTS( SELECT B.PV_TRANSACTION FROM PS_PV_ACTIONS B WHERE A.PV_TRANSACTION = B.PV_TRANSACTION AND A.PV_ACT_CATEGORY_CD = B.PV_ACT_CATEGORY_CD) |
| # | 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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |