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_ |
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_ |
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_ |
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_ |
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_ |
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_ |
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_ |
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_ |
Y |
User Defined |
Required for employee paid other withholding tax codes. Must be set up using Maintain>Chart of Accounts Codes. |
|
PRLT_LWT_ |
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_ |
Y |
User Defined |
Required for employer paid other withholding tax codes. Must be set up using Maintain>Chart of Accounts Codes. |
|
PRLT_ER_LT_ |
Y |
User Defined |
Required for employer paid other withholding tax codes. Must be set up using Maintain>Chart of Accounts Codes. |
|
PRLT_ER_ |
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_ |
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_ |
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_ |
N |
Currency |
0.00 |
Exclusion amount. Required if PRLT_LWT_CALCMETHOD is Annual Tiered Tax with Cap Option. |
PRLT_AR_EE_ |
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_ |
N |
Currency |
0.00 |
Wage Threshold. Required if PRLT_LWT_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold. |
PRLT_AR_EE_ |
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_ |
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_ |
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_ |
Y |
User Defined |
Other Tax Code |
|
PRLT_AR_ER_ |
N |
Currency |
0.00 |
Base Tax. Required if PRLT_ER_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold. |
PRLT_AR_ER_ |
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_ |
N |
Currency |
0.00 |
Taxable Amount Under. Required if PRLT_ER_CALCMETHOD is Percent of Annual Wages with Cap Option. |
PRLT_AR_ER_ |
N |
Currency |
0.00 |
Fixed Amount. Required if PRLT_ER_CALCMETHOD is Fixed Amount. |
PRLT_AR_ER_ |
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_ |
N |
Currency |
0.00 |
Wage Threshold. Required if PRLT_ER_CALCMETHOD is Base Tax per Period with Minimum Wage Threshold. |
PRLT_AR_ER_ |
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_ |
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_ |
N |
Currency |
0.00 |
Exemptions/Deductions Annual Amount |