View: History Audit Header Opt Fields

RotoID: UP0135
Table: UPHHOA
Protocol: Detail, Ordered revisions
DLL:UPHHOA

Compositions: 1

RotoID Tables Title DLL

UP0021 UPHHAU History Audit Headers UPHHAU

Keys: 1

Title Fields

Employee Optional Field EMPLOYEEEDITDATEEDITTIMEOPTFIELD

Fields: 15

Field Index Type Title Attributes Presentation

EMPLOYEE 1 String*12 Employee E A K R  Mask: %-12N
EDITDATE 2 Date Edit Date E A K R 
EDITTIME 3 Time Edit Time E A K R 
OPTFIELD 4 String*12 Optional Field E A K R  Mask: %-12N
OPERATION 5 Integer Operation E A  List:3 entries
1 = Add
2 = Modify
3 = Delete
TYPE 6 Integer Type E A  List:7 entries
1 = Text
100 = Amount
6 = Number
8 = Integer
9 = Yes/No
3 = Date
4 = Time
LENGTH 7 Integer Length E A 
DECIMALS 8 Integer Decimals E A 
ALLOWNULL 9 Boolean Allow Blank E A  List:2 entries
0 = No
1 = Yes
VALIDATE 10 Boolean Validate E A  List:2 entries
0 = No
1 = Yes
FDESC 11 String*60 Optional Field Description E A 
VALUE1 12 String*60 Value - new E A X 
VDESC1 13 String*60 Value Description - new E A X 
VALUE2 14 String*60 Value - old E A X 
VDESC2 15 String*60 Value Description - old E A X