# Table: History Audit Details

Table: UPHDAU
View: UP0024
Record length: 533
Flags: A R

## Keys: 1

Title | Flags | Fields
--- | --- | ---
Employee Date |  | EMPLOYEE, EDITDATE, EDITTIME, CATEGORY1, EARNDED1, LINETYPE1, LINENO

## Fields: 64

Field | Type | Title | Presentation
--- | --- | --- | ---
EMPLOYEE | String*12 | Employee | Mask: %-12N
EDITDATE | Date | Edit Date |
EDITTIME | Time | Edit Time |
CATEGORY1 | Integer | Category code - new | 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
EARNDED1 | String*6 | Earnings/Deductions-Tax - new | Mask: %-6N
LINETYPE1 | Integer | Transaction Type - new | 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 |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
HISTDATE | Date | History Date |
OPERATION | Integer | Operation | List: 3 entries
1 | = | Add
2 | = | Modify
3 | = | Delete
EDTYPE1 | Integer | Earnings/Deductions-Tax Type - n | List: 15 entries
1 | = | Salary & Wages
2 | = | Reported Tips
3 | = | Allocated Tips
7 | = | Vacation
8 | = | Sick
9 | = | Compensatory Time
13 | = | Cash
14 | = | Noncash
18 | = | Insurance Tax
19 | = | Income Tax
20 | = | Unemployment Tax
21 | = | Pension Plan Tax
22 | = | Health Tax
23 | = | Other Tax
25 | = | n/a
ECNTBASE1 | BCD*10.3 | Employee Count or Base - new |
ERATE1 | BCD*9.5 | Employee Rate - new |
EEXTEND1 | BCD*10.3 | Employee Amount - new |
RCNTBASE1 | BCD*10.3 | Employee Count or Base - new |
RRATE1 | BCD*9.5 | Employee Rate - new |
REXTEND1 | BCD*10.3 | Employee Amount - new |
WCC1 | String*6 | Workers' Compensation Code - new | Mask: %-6N
GLSEG1A | String*15 | G/L Segment One - new |
GLSEG2A | String*15 | G/L Segment Two - new |
GLSEG3A | String*15 | G/L Segment Three - new |
TAXWEEKS1 | BCD*4.3 | Weeks Worked for the Taxing Auth |
TAXEARNS1 | BCD*10.3 | Taxable Earnings - new |
TXEARNCL1 | BCD*10.3 | Taxable Earnings Ceiling - new |
TAXTIPS1 | BCD*10.3 | Taxable Tips Without a Ceiling - |
TXTIPSCL1 | BCD*10.3 | Taxable Tips With a Ceiling - ne |
TXONTIPS1 | BCD*10.3 | Amount of Tax Calculated on Tips |
UNCOLLTX1 | BCD*10.3 | For Uncollected SS/Med - new |
DESC1 | String*15 | Description - new |
HOURS1 | BCD*4.3 | Hours - new |
REGRATE1 | BCD*9.5 | Regular Rate - new |
CATEGORY2 | Integer | Category code - old | 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
EARNDED2 | String*6 | Earnings/Deductions-Tax - old | Mask: %-6N
LINETYPE2 | Integer | Transaction Type - old | 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
EDTYPE2 | Integer | Earnings/Deductions-Tax Type - o | List: 15 entries
1 | = | Salary & Wages
2 | = | Reported Tips
3 | = | Allocated Tips
7 | = | Vacation
8 | = | Sick
9 | = | Compensatory Time
13 | = | Cash
14 | = | Noncash
18 | = | Insurance Tax
19 | = | Income Tax
20 | = | Unemployment Tax
21 | = | Pension Plan Tax
22 | = | Health Tax
23 | = | Other Tax
25 | = | n/a
ECNTBASE2 | BCD*10.3 | Employee Count or Base - old |
ERATE2 | BCD*9.5 | Employee Rate - old |
EEXTEND2 | BCD*10.3 | Employee Amount - old |
RCNTBASE2 | BCD*10.3 | Employee Count or Base - old |
RRATE2 | BCD*9.5 | Employee Rate - old |
REXTEND2 | BCD*10.3 | Employee Amount - old |
WCC2 | String*6 | Workers' Compensation Code - old | Mask: %-6N
GLSEG1B | String*15 | G/L Segment One - old |
GLSEG2B | String*15 | G/L Segment Two - old |
GLSEG3B | String*15 | G/L Segment Three - old |
TAXWEEKS2 | BCD*4.3 | Weeks Worked for the Taxing Auth |
TAXEARNS2 | BCD*10.3 | Taxable Earnings - old |
TXEARNCL2 | BCD*10.3 | Taxable Earnings Ceiling - old |
TAXTIPS2 | BCD*10.3 | Taxable Tips Without a Ceiling - |
TXTIPSCL2 | BCD*10.3 | Taxable Tips With a Ceiling - ol |
TXONTIPS2 | BCD*10.3 | Amount of Tax Calculated on Tips |
UNCOLLTX2 | BCD*10.3 | For Uncollected SS/Med - old |
DESC2 | String*15 | Description - old |
HOURS2 | BCD*4.3 | Hours - old |
REGRATE2 | BCD*9.5 | Regular Rate - old |
TAXNONPER1 | BCD*10.3 | Taxable Non-periodic Earnings - |
TAXNONPER2 | BCD*10.3 | Taxable Non-periodic Earnings - |
TAXEARNBD1 | BCD*10.3 | Subject to Income tax befor dedu |
TAXEARNBD2 | BCD*10.3 | Subject to Income tax befor dedu |
WCCGROUP1 | String*6 | Workers Comp. Group - new | Mask: %-6N
WCCGROUP2 | String*6 | Workers Comp. Group - old | Mask: %-6N

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.