# View: History Audit Detail Opt Fields

RotoID: CP0136
Table: CPHDOA
DLL: CPHDOA

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
CP0024 | CPHDAU | History Audit Details | CPHDAU

## Keys: 1

Title | Fields
--- | ---
Earn/Ded/Tax Opt Field | EMPLOYEE, EDITDATE, EDITTIME, CATEGORY, EARNDED, LINETYPE, LINENO, OPTFIELD

## Fields: 19

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 |
CATEGORY | 4 | Integer | Category | 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
EARNDED | 5 | String*6 | Earn/Ded/Tax | E A K R | Mask: %-6N
LINETYPE | 6 | Integer | Transaction Type | E A K R | 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 |
OPTFIELD | 8 | String*12 | Optional Field | E A K R | Mask: %-12N
OPERATION | 9 | Integer |  | E A | List: 3 entries
1 | = | Add
2 | = | Modify
3 | = | Delete
TYPE | 10 | Integer | Type | E A | List: 7 entries
1 | = | Text
100 | = | Amount
6 | = | Number
8 | = | Integer
9 | = | Yes/No
3 | = | Date
4 | = | Time
LENGTH | 11 | Integer | Length | E A |
DECIMALS | 12 | Integer | Decimals | E A |
ALLOWNULL | 13 | Boolean | Allow Blank | E A | List: 2 entries
0 | = | No
1 | = | Yes
VALIDATE | 14 | Boolean | Validate | E A | List: 2 entries
0 | = | No
1 | = | Yes
FDESC | 15 | String*60 | Optional Field Description | E A |
VALUE1 | 16 | String*60 | Value - new | E A X |
VDESC1 | 17 | String*60 | Value Description - new | E A X |
VALUE2 | 18 | String*60 | Value - old | E A X |
VDESC2 | 19 | String*60 | Value Description - old | E A X |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.