Field Name

Required

Data Type

Max

Description

EmployeeID

Yes

String

50

Stores the unique identifier of a specific employee

CheckDate

Yes

Datetime

Stores the check date

CheckNumber

Yes

String

50

Stores the check number

BatchCode

Yes

String

20

Batch code differentiates payroll batches

DeductionCodeID

Yes

 String

20

Stores the unique identifier to a specific deduction

CodeDescription

Yes

String

100

Stores the description of the benefit in question

StartDate

Yes

Datetime

Stores the deduction start date

EndDate

Yes

Datetime

Stores the deduction end date

DeductionAmount

Yes

Decimal

Stores the amount of the deduction

Custom1

String

30

User-defined field

Custom2

String

30

User-defined field