HRMAS90 - Sage 100 Payroll Setup (Sage 100) Database
Seq | Field Name | Type | Length | Dec | Description |
---|---|---|---|---|---|
1 |
AUTOPAY |
L |
1 |
0 |
Autopay Employee (T/F) |
2 |
BENECODE |
C |
2 |
0 |
Benefit Accrual Code |
3 |
CHADATE |
D |
8 |
0 |
Last Change Date |
4 |
COMPANY |
C |
3 |
0 |
Company Code |
5 |
DIRECT |
L |
1 |
0 |
Direct Deposit (T/F) |
6 |
EMPNO |
C |
9 |
0 |
Employee ID |
7 |
FEDAMT |
N |
8 |
2 |
Federal Override Amount |
8 |
FEDDEP |
N |
3 |
0 |
Federal Dependent Exemptions |
9 |
FEDFILE |
C |
3 |
0 |
Federal Filing Status Code |
10 |
FEDOVER |
C |
1 |
0 |
Federal Override Code |
11 |
LOCAL |
C |
3 |
0 |
Local Code |
12 |
LOCALAMT |
N |
8 |
2 |
Local Override Amount |
13 |
LOCALDEP |
N |
3 |
0 |
Local Dependent Exemptions |
14 |
LOCALFILE |
C |
3 |
0 |
Local Filing Status Code |
15 |
LOCALOVER |
C |
1 |
0 |
Local Override Code |
16 |
LOCALPER |
N |
3 |
0 |
Local Personal Exemptions |
17 |
M90EMPNO |
C |
9 |
0 |
Sage 100 Employee ID |
18 |
PENSION |
L |
1 |
0 |
Pension/Profit Sharing (T/F) |
19 |
STATE |
C |
2 |
0 |
Primary State Code |
20 |
STATE1WC |
C |
7 |
0 |
Primary State W/C Code |
21 |
STATE2 |
C |
2 |
0 |
Secondary State Code |
22 |
STATE2AMT |
N |
8 |
2 |
Secondary State Override Amount |
23 |
STATE2DEP |
N |
3 |
0 |
Secondary State Dependent Exemption |
24 |
STATE2FILE |
C |
3 |
0 |
Secondary State Filing Status Code |
25 |
STATE2OVER |
C |
1 |
0 |
Secondary State Override Code |
26 |
STATE2PER |
N |
3 |
0 |
Secondary State Personal Exemptions |
27 |
STATE2WC |
C |
7 |
0 |
Secondary State W/C Code |
28 |
STATEAMT |
N |
8 |
2 |
Primary State Override Amount |
29 |
STATEDEP |
N |
3 |
0 |
Primary State Dependent Exemptions |
30 |
STATEFILE |
C |
3 |
0 |
Primary State Filing Status Code |
31 |
STATEOVER |
C |
1 |
0 |
Primary State Override Code |
32 |
STATEPER |
N |
3 |
0 |
Primary State Personal Exemptions |
33 |
SUISTATE |
C |
2 |
0 |
SUI State code |