EOTL_TB_BTNS(SQL Table) |
Index Back |
---|---|
Buttons within a CRM ToolbarRecord to store the buttons used with a specific CRM Toolbar definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOTL_TOOLBAR_ID | Character(30) | VARCHAR2(30) NOT NULL | TOOLBAR_ID |
2 | EOTL_TB_BTN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Toolbar Button Type
P=Primary S=Secondary Default Value: S |
3 | SEQUENCE_NBR | Number(2,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |
4 | EOTL_TB_BTN_SEQ | Number(3,0) | SMALLINT NOT NULL |
EOTL_TB_BTN_SEQ
Default Value: 10 |
5 | EOTL_TB_BTN_ID | Character(30) | VARCHAR2(30) NOT NULL |
EOTL_TB_BTN_
Prompt Table: EOTL_BTN_DEFN |
6 | EOTL_BTN_TXT_LNK | Character(20) | VARCHAR2(20) NOT NULL | Toolbar Button Text label |
7 | EOTL_TB_LABEL | Character(60) | VARCHAR2(60) NOT NULL | EOTL_TB_LAB |
8 | EOTL_ALT_CONTNAME | Character(30) | VARCHAR2(30) NOT NULL |
Alternate Conent Name
Prompt Table: EOTL_TB_IMG_VW |
9 | EOTL_ALT_CONTNAMED | Character(30) | VARCHAR2(30) NOT NULL |
Alternate Content / Diabled
Prompt Table: EOTL_TB_IMG_VW |
10 | EOTL_ACCESS_KEY | Character(1) | VARCHAR2(1) NOT NULL | Access Key........................ |
11 | EOTL_USR_HIDE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Field to determinate if a user can hide a toolbar icon.
N=N Y=Y Y/N Table Edit Default Value: Y |
12 | EOTL_SYSD_FLG | Character(1) | VARCHAR2(1) NOT NULL |
System data flag
N=No S=Sample Y=Yes Default Value: N |
13 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
14 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
15 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
16 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |