View: Update Taxes Audit Details

RotoID: UP0226
Table: UPAUDTD
Protocol: Detail, Ordered revisions
DLL:UPAUDTD

Compositions: 1

RotoID Tables Title DLL

UP0225 UPAUDT Update Taxes Audit UPAUDT

Keys: 1

Title Fields

Run Sequence/Employee RUNSEQEMPLOYEEFIELDIDX

Fields: 21

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:4 entries
0 = N/A
1 = Rate
2 = Amount
3 = Percent
OPERATION 11 Integer Operation E A P  List:14 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
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 
EMPTTYPE 21 Integer Employee Tax Type E A  List:5 entries
1 = No EMPT Processing
2 = Withholding Amount Override
3 = Withholding Percent Override
4 = Employee Tax Amount
5 = Employee Tax Percent