Table: Update Earn/Ded Audit Details

Table: UPAUDED
View: UP0224
Record Length: 334

Flags: A R 

Keys: 1

Title Flags Fields

Run Sequence/Employee RUNSEQEMPLOYEEFIELDIDX

Fields: 28

Field Type Title Presentation

RUNSEQ Long Run Sequence
EMPLOYEE String*12 Employee Mask: %-12N
FIELDIDX Long Field Index
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
FIELDNAME String*32 Field Name
EMPLNAME String*60 Employee Name
FIELDTYPE Integer Field Type 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 Integer Field Length
FIELDSIZE Integer Field Size
FIELDDECS Integer Field Decimals
BCDTYPE Integer Type of BCD Field List:5 entries
0 = N/A
1 = Rate
2 = Amount
3 = Percent
4 = Billing Rate
OPERATION Integer Operation 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 Boolean Test Old Value
OLDSTRING String*60 Old String Value
NEWSTRING String*60 New String Value
OLDDATE Date Old Date Value
NEWDATE Date New Date Value
OLDINT Integer Old Integer Value
NEWINT Integer New Integer Value
OLDAMTPCT BCD*9.5 Old Amount or Percent
AMTPCTCHG BCD*9.5 Amount/Percent Change
OLDWCCGRUP String*6 Old WC Group Mask: %-6N
NEWWCCGRUP String*6 New WC Group Mask: %-6N
OLDBILLRAT BCD*10.6 Old Billing Rate
NEWBILLRAT BCD*10.6 New Billing Rate