View: Update Earn/Ded Audit Details
RotoID: UP0224
Table: UPAUDEDProtocol: Detail, Ordered revisions
DLL:UPAUDED
Compositions: 1
RotoID |
Tables |
Title |
DLL |
|
UP0223 |
UPAUDE |
Update Earn/Ded Audit |
UPAUDE |
|
Keys: 1
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 |
|
|