View: History Audit details

RotoID: CP0024
Table: CPHDAU
DLL: CPHDAU

Compositions: 1


RotoID  Table  Title  DLL 
CP0021  CPHHAU  History Audit Headers  CPHHAU

Keys: 1


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

Fields: 58


Field  Index  Type  Title  Attributes  Presentation
EMPLOYEE  1  String*12  Employee  E A K R  Mask: %-12N
EDITDATE  2  Date  Edit Date  E A K R   
EDITTIME  3  Time  Edit Time  E A K R   
CATEGORY1  4  Integer  Category code - new  E A K R  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  5  String*6  Earnings/Deduction-Tax - new  E A K R  Mask: %-6N
LINETYPE1  6  Integer  Transaction Type - new  E A K R X  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  7  Integer  Line Number  E A K R X   
HISTDATE  8  Date  History Date  E A   
OPERATION  9  Integer  Operation  E A  List: 3 entries
1=Add
2=Modify
3=Delete
EDTYPE1  10  Integer  Earnings/Deduction-Tax Type - ne  E A X  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  11  BCD*10.3  Employee Count or Base - new  E A X   
ERATE1  12  BCD*9.5  Employee Rate - new  E A X   
EEXTEND1  13  BCD*10.3  Employee Amount - new  E A X   
RCNTBASE1  14  BCD*10.3  Employee Count or Base - new  E A X   
RRATE1  15  BCD*9.5  Employee Rate - new  E A X   
REXTEND1  16  BCD*10.3  Employee Amount - new  E A X   
WCC1  17  String*6  Workers' Compensation Code - new  E A X  Mask: %-6N
GLSEG1A  18  String*15  G/L Segment One - new  E A X   
GLSEG2A  19  String*15  G/L Segment Two - new  E A X   
GLSEG3A  20  String*15  G/L Segment Three - new  E A X   
TAXWEEKS1  21  BCD*4.3  Weeks Worked for the Taxing Auth  E A X   
TAXEARNS1  22  BCD*10.3  Taxable Earnings - new  E A X   
TXEARNCL1  23  BCD*10.3  Taxable Earnings Ceiling - new  E A X   
TAXTIPS1  24  BCD*10.3  Taxable Tips Without a Ceiling -  E A X   
TXTIPSCL1  25  BCD*10.3  Taxable Tips With a Ceiling - ne  E A X   
TXONTIPS1  26  BCD*10.3  Amount of Tax Calculated on Tips  E A X   
UNCOLLTX1  27  BCD*10.3  For Uncollected SS/Med - new  E A X   
DESC1  28  String*15  Description - new  E A   
HOURS1  29  BCD*4.3  Hours - new  E A X   
REGRATE1  30  BCD*9.5  Regular Rate - new  E A X   
CATEGORY2  31  Integer  Category code - old  E A  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  32  String*6  Earnings/Deduction-Tax - old  E A  Mask: %-6N
LINETYPE2  33  Integer  Transaction Type - old  E A X  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  34  Integer  Earnings/Deduction-Tax Type - ol  E A X  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  35  BCD*10.3  Employee Count or Base - old  E A X   
ERATE2  36  BCD*9.5  Employee Rate - old  E A X   
EEXTEND2  37  BCD*10.3  Employee Amount - old  E A X   
RCNTBASE2  38  BCD*10.3  Employee Count or Base - old  E A X   
RRATE2  39  BCD*9.5  Employee Rate - old  E A X   
REXTEND2  40  BCD*10.3  Employee Amount - old  E A X   
WCC2  41  String*6  Workers' Compensation Code - old  E A X  Mask: %-6N
GLSEG1B  42  String*15  G/L Segment One - old  E A X   
GLSEG2B  43  String*15  G/L Segment Two - old  E A X   
GLSEG3B  44  String*15  G/L Segment Three - old  E A X   
TAXWEEKS2  45  BCD*4.3  Weeks Worked for the Taxing Auth  E A X   
TAXEARNS2  46  BCD*10.3  Taxable Earnings - old  E A X   
TXEARNCL2  47  BCD*10.3  Taxable Earnings Ceiling - old  E A X   
TAXTIPS2  48  BCD*10.3  Taxable Tips Without a Ceiling -  E A X   
TXTIPSCL2  49  BCD*10.3  Taxable Tips With a Ceiling - ol  E A X   
TXONTIPS2  50  BCD*10.3  Amount of Tax Calculated on Tips  E A X   
UNCOLLTX2  51  BCD*10.3  For Uncollected SS/Med - old  E A X   
DESC2  52  String*15  Description - old  E A   
HOURS2  53  BCD*4.3  Hours - old  E A X   
REGRATE2  54  BCD*9.5  Regular Rate - old  E A X   
TAXNONPER1  55  BCD*10.3  Taxable Non-periodic Earnings -  E A X   
TAXNONPER2  56  BCD*10.3  Taxable Non-periodic Earnings -  E A X   
TAXEARNBD1  57  BCD*10.3  Subject to Income tax befor dedu  E A X   
TAXEARNBD2  58  BCD*10.3  Subject to Income tax befor dedu  E A X   

This page was generated on 2003-May-05

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