# View: History Audit Details

RotoID: CP0024
Table: CPHDAU
DLL: CPHDAU

## Compositions: 2

RotoID | Table | Title | DLL
--- | --- | --- | ---
CP0021 | CPHHAU | History Audit Headers | CPHHAU
CP0136 | CPHDOA | History Audit Detail Opt Fields | CPHDOA

## Keys: 1

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

## Fields: 71

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 | = | Provincial Tax
9 | = | Local Tax
10 | = | User Tax
EARNDED1 | 5 | String*6 | Earn/Ded/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 | Earn/Ded/Tax Type - new | 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 Tax Auth - new | 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 Ceil - new | E A X |
TXTIPSCL1 | 25 | BCD*10.3 | Taxable Tips With a Ceil - new | E A X |
TXONTIPS1 | 26 | BCD*10.3 | Amount of Tax Calc on Tips - new | 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 | = | Provincial Tax
9 | = | Local Tax
10 | = | User Tax
EARNDED2 | 32 | String*6 | Earn/Ded/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 | Earn/Ded/Tax Type - old | 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 Tax Auth - old | 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 Ceil - old | E A X |
TXTIPSCL2 | 49 | BCD*10.3 | Taxable Tips With a Ceil - old | E A X |
TXONTIPS2 | 50 | BCD*10.3 | Amount of Tax Calc on Tips - old | 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 Earn - new | E A X |
TAXNONPER2 | 56 | BCD*10.3 | Taxable Non-periodic Earn - old | E A X |
TAXEARNBD1 | 57 | BCD*10.3 | Subject to Inc tax bef ded - new | E A X |
TAXEARNBD2 | 58 | BCD*10.3 | Subject to Inc tax bef ded - old | E A X |
WCCGROUP1 | 59 | String*6 | Workers Comp. Group - new | E A | Mask: %-6N
WCCGROUP2 | 60 | String*6 | Workers Comp. Group - old | E A | Mask: %-6N
POOLEDTIP1 | 61 | BCD*10.3 | Pooled Tips - new | E A X |
POOLEDTIP2 | 62 | BCD*10.3 | Pooled Tips - old | E A X |
EARDEDDAT1 | 63 | Date | Earning/Deduction Date - new | E A X |
EARDEDDAT2 | 64 | Date | Earning/Deduction Date - old | E A X |
STARTTIME1 | 65 | Integer | Start Time - new | E A X |
STARTTIME2 | 66 | Integer | Start Time - old | E A X |
STOPTIME1 | 67 | Integer | Stop Time - new | E A X |
STOPTIME2 | 68 | Integer | Stop Time - old | E A X |
VALUES | 69 | Long | Number of Optional Fields | E A C |
ECALCMETH | 70 | Integer | Employee Calculation Method | E A X |
RCALCMETH | 71 | Integer | Employer Calculation Method | E A X |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.