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 |