PV_ACT_CAT_SRCH

(SQL View)

SELECT DISTINCT A.PV_TRANSACTION , B.XLATLONGNAME FROM PS_PV_ACT_CATEGORY A , PSXLATITEM B WHERE A.PV_TRANSACTION = B.FIELDVALUE AND B.FIELDNAME = 'PV_TRANSACTION' AND %EffdtCheck(PSXLATITEM BB, B, %CurrentDateIn)

# 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_DESCR Character(30) VARCHAR2(30) NOT NULL Merchant

#	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_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Merchant