Table: History Audit Details

Table: CPHDAU
View: CP0024
Record length: 579
Flags: A R 

Keys: 1

Title  Flags  Fields

Employee Date  EMPLOYEE, EDITDATE, EDITTIME, CATEGORY1, EARNDED1, LINETYPE1, LINENO

Fields: 75

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=Provincial 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: 16 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
7=Vacation
8=Sick
9=Banked Time
10=
13=Cash
14=Noncash
18=Insurance Tax
19=Income Tax
20=Employment 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=Provincial 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: 16 entries
1=Salary & Wages
2=Reported Tips
3=Allocated Tips
7=Vacation
8=Sick
9=Banked Time
10=
13=Cash
14=Noncash
18=Insurance Tax
19=Income Tax
20=Employment 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  Pooled Tips - new   
POOLEDTIP2  BCD*10.3  Pooled Tips - old   
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   

This page was generated on 2008-May-02

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