# 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.