Table: Update Taxes Audit Details

Table: CPAUDTD
View: CP0226
Record length: 304
Flags: A R 

Keys: 1

Title  Flags  Fields
Run Sequence/Employee  RUNSEQ, EMPLOYEE, FIELDIDX

Fields: 25

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

This page was generated on 2008-May-02

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.