Table: Employee Optional Field Values

Table: UPEMPO
View: UP0122
Record Length: 120

Flags: A R 

Keys: 2

Title Flags Fields

Employee Optional Field Value EMPLOYEEOPTFIELD
Optional Field/Employee OPTFIELDEMPLOYEE

Fields: 13

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
OPTFIELD String*12 Optional Field Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
VALUE String*60 Value Mask: %-60c
TYPE Integer Type List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH Integer Length
DECIMALS Integer Decimals
ALLOWNULL Boolean Allow Blank List:2 entries
0 = No
1 = Yes
VALIDATE Boolean Validate List:2 entries
0 = No
1 = Yes
SWSET Integer Value Set List:3 entries
0 = No
1 = Yes
99 = Not Applicable