OPR_DSP_TBL_IN(SQL Table) |
Index Back |
|---|---|
Operator display options invSets the display options at operator level for inventory panels. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
|
| 2 | Character(30) | VARCHAR2(30) NOT NULL | Page Name (see PSPNLDEFN). | |
| 3 | TR_DYN_REF1_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 210 |
| 4 | TR_DYN_REF2_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 020 |
| 5 | TR_DYN_REF3_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
050=Date Timestamp Default Value: 050 |
| 6 | TR_DYN_REF4_SW | Character(3) | VARCHAR2(3) NOT NULL | Dynamic Character Switch |
| 7 | TR_DYN_REF5_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 040 |
| 8 | TR_DYN_REF6_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 060 |
| 9 | TR_DYN_REF7_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 020 |
| 10 | TR_DYN_REF8_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 041 |
| 11 | TR_DYN_REF9_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 050 |
| 12 | TR_DYN_REF10_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 042 |
| 13 | TR_DYN_REF11_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 043 |
| 14 | TR_DYN_REF12_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 044 |
| 15 | TR_DYN_REF13_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 020 |
| 16 | TR_DYN_REF14_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 070 |
| 17 | TR_DYN_REF15_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 050 |
| 18 | TR_DYN_REF16_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 060 |
| 19 | TR_DYN_REF17_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 160 |
| 20 | TR_DYN_REF18_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 140 |
| 21 | TR_DYN_REF19_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 020 |
| 22 | TR_DYN_REF20_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 080 |
| 23 | TR_DYN_REF21_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 050 |
| 24 | TR_DYN_REF22_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 170 |
| 25 | TR_DYN_REF23_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 180 |
| 26 | TR_DYN_REF24_SW | Character(3) | VARCHAR2(3) NOT NULL |
Dynamic Character Switch
Default Value: 190 |
| 27 | TR_DYN_REF25_SW | Character(3) | VARCHAR2(3) NOT NULL | Dynamic Character Switch |
| 28 | MAX_ROWS | Number(3,0) | SMALLINT NOT NULL |
Maximum Rows retrieved
Default Value: 22 |