PV_CM_LINKS_VW2

(SQL View)
Index Back

SELECT PV_ADM_MAIN_ITEM , PV_ADM_SUB_ITEM1 , PV_ADM_SUB_ITEM2 , DESCR100 , PV_MENUITEM , PV_BARNAME , BARITEMNAME , PANELITEMNAME , PV_ADM_REL_SUB_GRP , MESSAGE_SET_NBR , MESSAGE_NBR , PV_ADM_QUERYSTRING , PV_ADM_DESCR FROM PS_PV_CM_LINKS_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PV_ADM_MAIN_ITEM Character(30) VARCHAR2(30) NOT NULL Main Item
2 PV_ADM_SUB_ITEM1 Character(50) VARCHAR2(50) NOT NULL
3 PV_ADM_SUB_ITEM2 Character(50) VARCHAR2(50) NOT NULL Sub-item Group
4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
5 PV_MENUITEM Character(30) VARCHAR2(30) NOT NULL Menu Item
DCF=DESIGN_CHARTFIELDS
DGO=DEFINE_GENERAL_OPTIONS
DIC=DEFINE_ITEM_CONTROL_DATA
EAP=ESTABLISH_ASSET_PROCESSING
EBU=ESTABLISH_BUSINESS_UNITS
MIR=MANAGE_INTEGRATION_RULES
MIT=DEFINE_ITEMS
MMS=PV_MARKETSITE
MPC=MANAGE_PROCUREMENT_CARDS
MRO=MAINTAIN_ROLES
MSE=MAINTAIN_SECURITY
MUR=MAINTAIN_USER_PROFILES
MVN=MAINTAIN_SUPPLIERS
POT=PROCESS_OUTBOUND_TRANSACTIONS
PV=PV_MAIN_MENU
SPO=STRUCTURE_PROCUREMENT_OPTIONS
UTI=UTILITIES
WFA=WORKFLOW_ADMINISTRATOR
6 PV_BARNAME Character(30) VARCHAR2(30) NOT NULL Bar Name
ADM=PV_ADMIN
EXF=EXPRESS_FORMS
INQ=INQUIRE
MKS=PV_MARKETSITE
PCD=PCARD
PRC=PROCESS
PRO=PV_PROCESSES
REC=RECEIVING
SET=SETUP
UAD=USE_A-D
UAI=USE_A-I
UAM=USE_A-M
UEP=USE_E-P
UJR=USE_J-R
UNZ=USE_N_Z
URZ=USE_R-Z
USE=USE
USZ=USE_S-Z
VSS=VENDOR_SS
WLT=WORKLIST
7 BARITEMNAME Character(30) VARCHAR2(30) NOT NULL Bar Item Name
8 PANELITEMNAME Character(30) VARCHAR2(30) NOT NULL Panel Item Name
9 PV_ADM_REL_SUB_GRP Character(50) VARCHAR2(50) NOT NULL Related Sub Item Group
10 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

Default Value: 18036

11 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
12 PV_ADM_QUERYSTRING Character(254) VARCHAR2(254) NOT NULL Query String
13 PV_ADM_DESCR Long Character CLOB Description