Table: Process Result

Table: AHPROC
View: AH0020
Record length: 602
Flags: A R 

Keys: 6

Title  Flags  Fields

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

Fields: 19

Field  Type  Title  Presentation 

EMPID  String*12  Employee ID   
VIEWID  String*6  Accpac View ID   
FLDNAME  String*22  Accpac Field Name   
ACKEYVAL  String*30  Accpac Key Value   
RECTYPE  Integer  Record Type  List: 4 entries
0=Employee
1=Employer
2=Accrued Hour
3=Paid Hour
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
VIEWDESC  String*30  View Description   
EMPNAME  String*40  Name   
FLDDESC  String*30  Field Description   
CATEGORY  Integer  Category  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  String*60  Old Value   
NEWVALUE  String*60  New Value   
PROCTYPE  Integer  Process Type  List: 3 entries
0=Insert
1=Update
2=Delete
PARENTID  String*30  Parent ID   
STATUS  Integer  Status  List: 4 entries
0=Generated
1=Updated
2=Update With Error
3=Process With Error
ERRDESC  String*250  Error Description   

This page was generated on 2009-Nov-19

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