# 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 |  | EMPLOYEE, EDITDATE, EDITTIME, CATEGORY, EARNDED, LINETYPE, LINENO, OPTFIELD

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

This page was generated on 2008-May-02

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