Table: History Audit Detail Opt Fields

Table: UPHDOA
View: UP0136
Record Length: 382

Flags: A R 

Keys: 1

Title Flags Fields

Earn/Ded/Tax Opt Field EMPLOYEEEDITDATEEDITTIMECATEGORYEARNDEDLINETYPELINENOOPTFIELD

Fields: 23

Field Type Title Presentation

EMPLOYEE String*12 Employee Mask: %-12N
EDITDATE Date Edit Date
EDITTIME Time Edit Time
CATEGORY Integer Category List:10 entries
1 = Accrual
2 = Earning
3 = Advance
4 = Deduction
5 = Expense Reimbursement
6 = Benefit
7 = Federal Tax
8 = State Tax
9 = Local Tax
10 = User Tax
EARNDED String*6 Earn/Ded/Tax Mask: %-6N
LINETYPE Integer Transaction Type List:9 entries
1 = Payment
2 = Accrual
3 = Regular
4 = Overtime
5 = Shift Differential
6 = n/a
7 = Normal Withholding
8 = Backup Withholding
9 = Supplemental Withholding
LINENO Integer Line Number
OPTFIELD String*12 Optional Field Mask: %-12N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
OPERATION Integer Operation List:3 entries
1 = Add
2 = Modify
3 = Delete
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
FDESC String*60 Optional Field Description
VALUE1 String*60 Value - new
VDESC1 String*60 Value Description - new
VALUE2 String*60 Value - old
VDESC2 String*60 Value Description - old