View: Process Result

RotoID: AH0020
Table: AHPROC
Protocol: Flat
DLL: AHPROC

Compositions: 0

Keys: 6

Title  Fields
Primary Key - Emp. ID, View ID,  EMPID, VIEWID, FLDNAME, ACKEYVAL, RECTYPE
View ID, Field Name  VIEWID, FLDNAME
Status  STATUS
View ID, Field Name,Parent ID  VIEWID, FLDNAME, PARENTID
ViewList Sort - Emp.ID, View ID,  EMPID, VIEWID, CATEGORY, FLDNAME, ACKEYVAL
ViewList Sort 2 - Emp.ID, Key Va  EMPID, ACKEYVAL, CATEGORY, FLDNAME

Fields: 15

Field  Index  Type  Title  Attributes  Presentation
EMPID  1  String*12  Employee ID  E A K R   
VIEWID  2  String*6  Accpac View ID  E A K R   
FLDNAME  3  String*22  Accpac Field Name  E A K R   
ACKEYVAL  4  String*30  Accpac Key Value  E A K R   
RECTYPE  5  Integer  Record Type  E A K R  List: 4 entries
0=Employee
1=Employer
2=Accrued Hour
3=Paid Hour
VIEWDESC  6  String*30  View Description  E A   
EMPNAME  7  String*40  Name  E A   
FLDDESC  8  String*30  Field Description  E A   
CATEGORY  9  Integer  Category  E A  List: 28 entries
0=Demographics
1=Class
2=Cost Center
3=Earning
4=Deduction
5=Advance
6=Expense Reimbursement
7=Optional Field
31=Earning Distribution Code
41=Deduction Distribution Code
51=Advance Distribution Code
61=Expense Reimbursement Distribution Code
32=Earning Start Date
42=Deduction Start Date
52=Advance Start Date
62=Expense Reimbursement Start Date
33=Earning End Date
43=Deduction End Date
53=Advance End Date
63=Expense Reimbursement End Date
34=Earning Default Hour
8=Accrual
81=Accrual Distribution Code
82=Accrual Start Date
83=Accrual Carry-over Date
84=Accrued Hours
85=Paid Hours
9=Shift Schedule
OLDVALUE  10  String*60  Old Value  E A   
NEWVALUE  11  String*60  New Value  E A   
PROCTYPE  12  Integer  Process Type  E A  List: 3 entries
0=Insert
1=Update
2=Delete
PARENTID  13  String*30  Parent ID  E A   
STATUS  14  Integer  Status  E A  List: 4 entries
0=Generated
1=Updated
2=Update With Error
3=Process With Error
ERRDESC  15  String*250  Error Description  E A   

This page was generated on 2009-Nov-19

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