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 |