# Table: Employee Optional Field Values

Table: UPEMPO
View: UP0122
Record length: 120
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
Employee Optional Field Value |  | EMPLOYEE, OPTFIELD
Optional Field/Employee |  | OPTFIELD, EMPLOYEE

## 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

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.