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

TaxCodeID

String

20

Unique Identifier for a specific tax; when providing Federal Income, Social Security, and Medicare tax rows, you must use FED, SS, and MED as the Code

CodeDescription

String

100

Description of the specific tax

JurisdictionType

String

50

The jurisdiction type, e.g. Federal, State, Local

Jurisdiction

String

100

Use Greenshades Jurisdiction Name, e.g US, US-FL, US-GA

TaxType

String

50

Stores the type of tax, e.g. Withholding, Unemployment

SubType

String

50

Stores the subtype of the tax, e.g. Employee, Employer

StartDate

Yes

Datetime

Stores the tax start date

EndDate

Yes

Datetime

Stores the tax end date

TaxAmount

Yes

Decimal

Stores the tax amount

TaxAmountJustOnTips

Decimal

Stores the Tax amount just on tips

TaxableWages

Decimal

Stores the taxable wages

Custom1

String

30

User-defined field

Custom2

String

30

User-defined field

EmployeeWithheld

Yes

Bool

1 visible to employee on paystubs, 0 not visible to employee on paystubs.