PSPNLACEGRDDATA

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
2 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID
3 ACEMODELID Character(30) VARCHAR2(30) NOT NULL Model ID (see PSACEMDLDEFN).
4 ACECOLLNAME Character(30) VARCHAR2(30) NOT NULL Cube Collection Name
5 RECORDNAME Character(15) VARCHAR2(15) NOT NULL Record Name
01=MASTER_ITEM_EC
02=INV_ITEMS_EC
03=BU_ITM_INV_EC
04=BU_ITM_WTVL_EC
05=ITEM_VENDOR_EC
06=ITM_VNDR_LOC_EC
07=ITM_VNDR_UOM_EC
08=ITM_VND_UMPR_EC
09=INV_ITM_UOM_EC
10=PUR_ITM_ATTR_EC
11=MANUFACTURER_EC
12=ITEM_MFG_EC
13=EN_REVISION_EC
6 PROBINSTPNLFLDID Number(4,0) SMALLINT NOT NULL Problem Instance Pnl Field ID
7 ACEGRIDDISPLSLICER Character(1) VARCHAR2(1) NOT NULL Display Slicer
8 ACESLCDFTVIEWEXPAN Character(1) VARCHAR2(1) NOT NULL Ace Grid Slicers Default State
9 ACEGRIDAXISTYPE Number(3,0) SMALLINT NOT NULL Non Dimensional Field Axis
10 ACEGRIDFRZCOLMODE Number(1,0) SMALLINT NOT NULL Analytic Grid Freeze Col Mode
11 ACEGRIDMAXROWCOUNT Number(2,0) SMALLINT NOT NULL Maximun number of Visble rows
12 ACEGRIDNODRAGDROP Number(1,0) SMALLINT NOT NULL Allow/Disallow Drag drop