OPR_DSP_TBL_IN

(SQL Table)
Index Back

Operator display options inv

Sets the display options at operator level for inventory panels.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPERATOR_VW

2 PNLNAME 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