Importing Tax Codes

The following table shows examples of data fields used in the State Tax Codes section of the MasterPR.DEF file:

State Header

Table: tblPRStateTaxSetup
Context Section: CONTEXT,STATETAX,HEADER,HSTATETAX
Field ID Req'd Field Length Default Value Notes

PRST_CODE

Y

2

 

State Code

PRST_WHTAX

Y

2

No

State Withholding Tax. If SUTA is "No," then this must be "Yes." 1 = Yes. Blank or any other value = No.

PRST_EMPLOYER_
TAXID_SWT

N

8

 

State Withholding Tax Account ID.

PRST_SUTA

Y

2

Yes

State Unemployment Tax. If WHTAX is "No," then SUTA must be "Yes." 0 = No. Blank or any other value = Yes.

PRST_EMPLOYER_
TAXID_SUTA

N

8

 

State Unemployment Tax Account ID.

PRST_SWT_LIAB

Y

User Defined

 

Required if SWT is selected. Must be set up using Maintain>Chart of Accounts Codes.

PRST_SUTA_EMPLOYER

Y

2

 

If SUTA tax is imported, must be either employer or employee paid. Employer paid. 1 = Yes; 0 = No

PRST_SUTA_EMPLOYEE

Y

2

 

If SUTA tax is imported, must be either employer or employee paid. Employee paid. 1 = Yes; 0 = No

PRST_SUTA_EXPENSE

Y

User Defined

 

Required if SUTA is selected and employer paid. Must be set up using Maintain>Chart of Accounts Codes.

PRST_SUTA_LIAB

Y

User Defined

 

Required if SUTA is selected. Must be set up using Maintain>Chart of Accounts Codes.

PRST_SUTA_
MAXWAGES_EE

N

Currency

0.00

Maximum subject wages—employee.

PRST_SUTA_PERC_EE

N

Single

000.0000

Employee rate. Enter 5% as 05 or 5.

PRST_SUTA_
MAXWAGES_ER

N

Currency

0.00

Maximum subject wages—employer.

PRST_SUTA_PERC_ER

N

Single

000.0000

Employer rate. Enter 5% as 05 or 5.

PRST_DISTMETHOD

Y

2

AE

Valid Distribution Methods: AE, CE, and DC. See Table 5.

PRST_DISTCODE

Y

User Defined

 

Required if using a distribution method of DC. Must be a valid code with a distribution type of "B" or "P" (Maintain>Payroll>Distribution Codes).

PRST_
SUTACALCMETHOD

Y

1

Y

Valid Calculation Methods: Y or C. See Table 3.

PRST_FUTA_CROVERRIDE

N

2

 

FUTA Override Default Credit Rate. 1 = Yes; 0 = No

PRST_FUTA_CREDITRATE

N

Single

000.0000%

FUTA Credit Rate.

The following tables show examples of data fields used in the Other Tax Codes section of the MasterPR.DEF file.

Local Header

Table: tblPRLocalCode
Context Section: CONTEXT,LOCALTAX,HEADER,HLOCALTAX
Field ID Req'd Field Length Default Value Notes

PRLT_CODE

Y

User Defined

 

Other Tax Code

PRLT_STATUS

N

1

A

A (Active), I (Inactive), or D (Discontinued)

PRLT_TITLE

Y

User Defined

 

Other Tax Title

PRLT_AATRIX_
TAX_TYPE

Y

60

 

Aatrix Tax Type, defaults to Local Tax. Other tax types: California State Disability Insurance, New Jersey State Disability Insurance, New Jersey State Private Disability Insurance, New Jersey State Private Family Disability Insurance, New York State Disability Insurance, or Rhode Island State Disability Insurance. NOTE: Additional tax types are available from Aatrix but must be selected using the Maintain>Payroll>Other Taxes form.

PRLT_EMPLOYER_
TAXID

N

   

Other Tax Employer Tax ID number.

PRLT_LWT

N

1

No

If Other withholding tax is imported, must be either employee and/or employer paid. Employee (LWT) paid. 1 = Yes; 0 = No

PRLT_CALCBASIS

N

2

TE

Valid Calculation Basis: TE (Taxable Earnings), SW (State Withholding), or FW (Federal Withholding).

PRLT_LWT_
LIABACCT

Y

User Defined

 

Required for employee paid other withholding tax codes. Must be set up using Maintain>Chart of Accounts Codes.

PRLT_LWT_
CALCMETHOD

Y

47

 

Required for employee paid other withholding tax codes. Valid Calculation Types: Annual Base Tax, Annual Tiered Tax with Cap Option, Base Tax per Period with Minimum Wage Threshold, Percent of Annual Wages with Cap Option, or Percent of Wages with Pay Cycle Cap Option.

PRLT_ERLT

N

1

No

If Other withholding tax is imported, must be either employee and/or employer paid. Employer (ERLT) paid. 1 = Yes; 0 = No

PRLT_ER_LT_
EXPACCT

Y

User Defined

 

Required for employer paid other withholding tax codes. Must be set up using Maintain>Chart of Accounts Codes.

PRLT_ER_LT_
LIABACCT

Y

User Defined

 

Required for employer paid other withholding tax codes. Must be set up using Maintain>Chart of Accounts Codes.

PRLT_ER_
CALCMETHOD

Y

47

 

Required for employer paid other withholding tax codes. Valid Calculation Types: Base Tax per Period with Minimum Wage Threshold, Fixed Amount, or Percent of Annual Wages with Cap Option.

Detail

The following table Field IDs are only available if the tblPRLocalCode has Field ID PRLT_LWT = 1 in the Other Tax Codes section of the MasterPR.DEF file.

Table: tblPRLocalRates
Context Section: CONTEXT,LOCALTAX,DETAILRATE,DLOCALTAXEE
Field ID Req'd Field Length Default Value Notes

PRLT_AR_EE_
LOCALCODE

Y

User Defined

 

Other Tax Code

PRLT_AR_EE_BASETAX

N

Currency

0.00

Base Tax. Required if PRLT_LWT_CALCMETHOD is Annual Base Tax, Annual Tiered Tax with Cap Option, or Base Tax per Period with Minimum Wage Threshold.

PRLT_AR_EE_PERCENT

N

Single

000.0000

Percent. Required if PRLT_LWT_CALCMETHOD is Annual Tiered Tax with Cap Option, Percent of Annual Wages with Cap Option, or Percent of Wages with Pay Cycle Cap Option. Enter 5% as 05 or 5.

PRLT_AR_EE_
AMOUNTUNDER

N

Currency

0.00

Taxable Amount Under. Required if PRLT_LWT_CALCMETHOD is Annual Tiered Tax with Cap Option or Percent of Annual Wages with Cap Option.

PRLT_AR_EE_
EXCLUSION

N

Currency

0.00

Exclusion amount. Required if PRLT_LWT_CALCMETHOD is Annual Tiered Tax with Cap Option.

PRLT_AR_EE_
CALCMETHOD

N

12

 

Calculation Methods: Year to Date or Current. Required if PRLT_LWT_CALCMETHOD is Percent of Annual Wages with Cap Option.

PRLT_AR_EE_
WAGETHRES

N

Currency

0.00

Wage Threshold. Required if PRLT_LWT_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold.

PRLT_AR_EE_
THRESPERIOD

N

14

 

Wage Threshold Periods: Calendar Month or Calendar Year. Required if PRLT_LWT_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold.

PRLT_AR_EE_
PAYCYCLE

N

11

Monthly, Semimonthly, Biweekly, Weekly

Pay Cycle: Monthly, Semimonthly, Biweekly, and Weekly. Required if PRLT_LWT_CALCMETHOD is Percent of Wages with Pay Cycle Cap Option.

PRLT_AR_EE_
PAYCYCLECAP

N

Currency

0.00

Pay Cycle Cap. Required if PRLT_LWT_CALCMETHOD is Percent of Wages with Pay Cycle Cap Option.

Detail

The following table Field IDs are only available if the tblPRLocalCode has Field ID PRLT_ERLT = 1 in the Other Tax Codes section of the MasterPR.DEF file.

Table: tblPRLocalRates
Context Section: CONTEXT,LOCALTAX,DETAILRATE,DLOCALTAXER
Field ID Req'd Field Length Default Value Notes

PRLT_AR_ER_
LOCALCODE

Y

User Defined

 

Other Tax Code

PRLT_AR_ER_
BASETAX

N

Currency

0.00

Base Tax. Required if PRLT_ER_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold.

PRLT_AR_ER_
PERCENT

N

Single

000.0000

Percent. Required if PRLT_ER_CALCMETHOD is Percent of Annual Wages with Cap Option. Enter 5% as 05 or 5.

PRLT_AR_ER_
AMOUNTUNDER

N

Currency

0.00

Taxable Amount Under. Required if PRLT_ER_CALCMETHOD is Percent of Annual Wages with Cap Option.

PRLT_AR_ER_
FIXEDAMOUNT

N

Currency

0.00

Fixed Amount. Required if PRLT_ER_CALCMETHOD is Fixed Amount.

PRLT_AR_ER_
CALCMETHOD

N

12

 

Calculation Methods: Year to Date or Current. Required if PRLT_ER_CALCMETHOD is Percent of Annual Wages with Cap Option.

PRLT_AR_ER_
WAGETHRES

N

Currency

0.00

Wage Threshold. Required if PRLT_ER_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold.

PRLT_AR_ER_
THRESPERIOD

N

14

 

Wage Threshold Periods: Calendar Month or Calendar Year. Required if PRLT_ER_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold.

Detail

The following table Field IDs are only available if the tblPRLocalCode has Field ID PRLT_LWT = 1 in the Other Tax Codes section of the MasterPR.DEF file.

Table: tblPRLocalRates
Context Section: CONTEXT,LOCALTAX,DETAILEXEMPT,DLOCALEXEMPT
Field ID Req'd Field Length Default Value Notes

PRLT_EXEMPT_
LOCALCODE

Y

User Defined

 

Other Tax Code

PRLT_EXEMPT_CODE

N

User Defined

 

Exemptions/Deductions Code. Only available if PRLT_LWT_CALCMETHOD is Annual Tiered Tax with Cap Option or Percent of Annual Wages with Cap Option.

PRLT_EXEMPT_DESC

N

User Defined

 

Exemptions/Deductions Code Description

PRLT_EXEMPT_
ANNUALAMOUNT

N

Currency

0.00

Exemptions/Deductions Annual Amount