View: Update Earn/Ded Audit Details

RotoID: CP0224
Table: CPAUDED
Protocol: Detail, Ordered revisions
DLL:CPAUDED

Compositions: 1

RotoID Tables 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 WC Group E A X  Mask: %-6N
NEWWCCGRUP 22 String*6 New WC 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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).