Table: History Audit Details

Table: UPHDAU
View: UP0024
Record Length: 721

Flags: A R 

Keys: 1

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

Fields: 87

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 Earn/Ded/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 Earn/Ded/Tax Type - new 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 Tax Auth - new
TAXEARNS1 BCD*10.3 Taxable Earnings - new
TXEARNCL1 BCD*10.3 Taxable Earnings Ceiling - new
TAXTIPS1 BCD*10.3 Taxable Tips Without Ceil - new
TXTIPSCL1 BCD*10.3 Taxable Tips With a Ceil - new
TXONTIPS1 BCD*10.3 Amount of Tax Calc on Tips - new
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 Earn/Ded/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 Earn/Ded/Tax Type - old 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 Tax Auth - old
TAXEARNS2 BCD*10.3 Taxable Earnings - old
TXEARNCL2 BCD*10.3 Taxable Earnings Ceiling - old
TAXTIPS2 BCD*10.3 Taxable Tips Without Ceil - old
TXTIPSCL2 BCD*10.3 Taxable Tips With a Ceil - old
TXONTIPS2 BCD*10.3 Amount of Tax Calc on Tips - old
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 Earn - new
TAXNONPER2 BCD*10.3 Taxable Non-periodic Earn - old
TAXEARNBD1 BCD*10.3 Subject to Inc tax bef ded - new
TAXEARNBD2 BCD*10.3 Subject to Inc tax bef ded - old
WCCGROUP1 String*6 Workers Comp. Group - new Mask: %-6N
WCCGROUP2 String*6 Workers Comp. Group - old Mask: %-6N
POOLEDTIP1 BCD*10.3 RESERVED - Cdn Only
POOLEDTIP2 BCD*10.3 RESERVED - Cdn Only
EARDEDDAT1 Date Earning/Deduction Date - new
EARDEDDAT2 Date Earning/Deduction Date - old
STARTTIME1 Integer Start Time - new
STARTTIME2 Integer Start Time - old
STOPTIME1 Integer Stop Time - new
STOPTIME2 Integer Stop Time - old
VALUES Long Number of Optional Fields
ECALCMETH Integer Employee Calculation Method
RCALCMETH Integer Employer Calculation Method
WCBASE1 BCD*10.3 WC Base - new
WCBASE2 BCD*10.3 WC Base - old
WCRATE1 BCD*6.6 WC Rate - new
WCRATE2 BCD*6.6 WC Rate - old
WCEXTEND1 BCD*10.5 WC Assessment - new
WCEXTEND2 BCD*10.5 WC Assessment - old
GLSEG4A String*15 G/L Segment Four - new
GLSEG5A String*15 G/L Segment Five - new
GLSEG6A String*15 G/L Segment Six - new
GLSEG4B String*15 G/L Segment Four - old
GLSEG5B String*15 G/L Segment Five - old
GLSEG6B String*15 G/L Segment Six - old

This page was generated on 2022-Aug-18

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).