AR_CWB_ROLE_OPT(SQL Table) |
Index Back |
|---|---|
CWB personalization recordCollections Workbench personalization record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ROLENAME |
Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 2 | ACTION_LIST_STATE | Character(1) | VARCHAR2(1) NOT NULL |
Specify the initial display state of the CWB action list.
C=Collapse Upon Entry E=Expand Upon Entry H=Always Hide Default Value: C |
| 3 | CUST_DETAILS_STATE | Character(1) | VARCHAR2(1) NOT NULL |
Initial display state for the CWB Customer Details section
C=Collapse Upon Entry E=Expand Upon Entry H=Always Hide Default Value: C |
| 4 | CUST_MSG_DISPLAY | Character(1) | VARCHAR2(1) NOT NULL |
View Customer Messages Alert
I=Icon Only W=Message Window Y/N Table Edit Default Value: Y |
| 5 | DISP_CURRENCY_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Display Currency Option
A=Always used D=Used as default only Default Value: D |
| 6 | DISP_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
Display Currency
Prompt Table: CURRENCY_CD_VW |
| 7 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |