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