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