Table: History Audit details

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

Keys: 1


Title  Flags  Fields

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

Fields: 62


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/Deduction-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/Deduction-Tax Type - ne  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 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/Deduction-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/Deduction-Tax Type - ol  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 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   

This page was generated on 2003-May-05

Copyright © 2003 ACCPAC International, Inc. All rights reserved.