# View: Update Earn/Ded Audit Details

RotoID: CP0224
Table: CPAUDED
DLL: CPAUDED

## Compositions: 1

RotoID | Table | Title | DLL
--- | --- | --- | ---
CP0223 | CPAUDE | Update Earn/Ded Audit | CPAUDE

## Keys: 1

Title | Fields
--- | ---
Run Sequence/Employee | RUNSEQ, EMPLOYEE, FIELDIDX

## Fields: 24

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
RUNSEQ | 1 | Long | Run Sequence | E A K R |
EMPLOYEE | 2 | String*12 | Employee | E A K R | Mask: %-12N
FIELDIDX | 3 | Long | Field Index | E A K R |
FIELDNAME | 4 | String*32 | Field Name | E A C |
EMPLNAME | 5 | String*60 | Employee Name | E A |
FIELDTYPE | 6 | Integer | Field Type | E A | List: 10 entries
0 | = | Undefined
1 | = | String
2 | = | Byte
3 | = | Date
4 | = | Time
5 | = | IEEE Long Real
6 | = | Amount
7 | = | Integer
8 | = | Long Integer
9 | = | Boolean
FIELDLEN | 7 | Integer | Field Length | E A |
FIELDSIZE | 8 | Integer | Field Size | E A |
FIELDDECS | 9 | Integer | Field Decimals | E A |
BCDTYPE | 10 | Integer | Type of BCD Field | E A | List: 5 entries
0 | = | N/A
1 | = | Rate
2 | = | Amount
3 | = | Percent
4 | = | Billing Rate
OPERATION | 11 | Integer | Operation | E A P | List: 19 entries
1 | = |
2 | = | Replace
3 | = | Increase
4 | = | Decrease
5 | = | Pct Inc
6 | = | Pct Dec
7 | = | Replace
8 | = | Increase
9 | = | Decrease
10 | = | Replace
11 | = | Replace
12 | = | Replace
13 | = | Replace
14 | = | Replace
15 | = | Replace
16 | = | Increase
17 | = | Decrease
18 | = | Pct Inc
19 | = | Pct Dec
TESTOLD | 12 | Boolean | Test Old Value | E A |
OLDSTRING | 13 | String*60 | Old String Value | E A X |
NEWSTRING | 14 | String*60 | New String Value | E A X |
OLDDATE | 15 | Date | Old Date Value | E A X |
NEWDATE | 16 | Date | New Date Value | E A X |
OLDINT | 17 | Integer | Old Integer Value | E A X |
NEWINT | 18 | Integer | New Integer Value | E A X |
OLDAMTPCT | 19 | BCD*9.5 | Old Amount or Percent | E A X |
AMTPCTCHG | 20 | BCD*9.5 | Amount/Percent Change | E A X |
OLDWCCGRUP | 21 | String*6 | Old WCC Group | E A X | Mask: %-6N
NEWWCCGRUP | 22 | String*6 | New WCC Group | E A X | Mask: %-6N
OLDBILLRAT | 23 | BCD*10.6 | Old Billing Rate | E A X |
NEWBILLRAT | 24 | BCD*10.6 | New Billing Rate | E A X |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.