PRTAXID – Tax Identification Number

System: Payroll (PR)
Prefix: PTI
Primary key: TAX-ID-CODE, COMPANY, PROCESS-LEVEL
Fields: 37
Updated by: 37 programs
Referenced by: 18 programs

PRTAXID is the Tax Identification Number table in Lawson Payroll (prefix PTI). It is indexed by TAX-ID-CODE, COMPANY, PROCESS-LEVEL (PTISET1). It is related 1:1 to PRSYSTEM and PRTAXAUTH. It is updated by HR00.1, HR01.1, PR06.1, PR06.2, PR06.4, PR06.5, PR06.6, PR06.7 and 29 more and referenced by PR206, PR227, PR250, PR251, PR252, PR253, PR287, PR290 and 10 more. The table has 37 fields, 1 index and 3 documented relations.

About PRTAXID

Contains the user-defined tax authority. Tax authorities provide a link between the Payroll system and the Business Software, Inc. tax tables. You can define tax authorities for a company or for a specific process level. Tax deductions must be tied to the appropriate BSI tax codes for proper calculation. Reports are available in the BSI system to provide listings of tax codes. This file also contains additional EINs (Employer Identification Numbers) for the company or process level as well as the minimum wage defined for the tax authority, and additional information required by specific states for state reporting.

Fields (37)

Column = COBOL field name without the PTI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PTI-TAX-ID-CODE` PK TAX_ID_CODE	Alpha 10	Contains the user-defined tax authority.	PR06.1, PR06.2, PR06.4, PR06.5, PR06.6, PR06.7, PR06.8, PR06.9 +27 more
`PTI-COMPANY` PK COMPANY	Numeric 4	Contains the company number for state type tax authorities that require this additional information for quarterly reporting.	PR06.2, PR06.4, PR06.5, PR06.6, PR06.7, PR06.8, PR06.9, PR07.1 +26 more
`PTI-PROCESS-LEVEL` PK PROCESS_LEVEL	Alpha 5	Contains the process level for state type tax authorities that require this additional information for quarterly reporting.	PR06.2, PR06.4, PR06.5, PR06.6, PR06.7, PR06.8, PR06.9, PR07.1 +26 more
`PTI-TAX-ID-NBR` TAX_ID_NBR	Alpha 20	Contains the employer identification number associated with the tax authority.	PR06.1, PR06.2, PR69.2
`PTI-EMP-ACCT-NBR` EMP_ACCT_NBR	Alpha 20	Contains the employer account number associated with the tax authority.	PR06.1, PR06.2, PR69.2
`PTI-CONTACT-TITLE` CONTACT_TITLE	Alpha 30	Contains the title of the individual who is the contact person. This applies only to states that required this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.2, PR07.3, PR07.5, PR67.1, PR67.6, PR67.9 +2 more
`PTI-CONTACT-AREA` CONTACT_AREA	Numeric 3	Contains the area code portion of the telephone number for the contact person defined for the tax authority. This applies to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.2, PR07.3, PR07.5, PR67.1, PR67.6, PR67.9 +2 more
`PTI-CONTACT-PRE` CONTACT_PRE	Numeric 3	Contains the prefix portion of the telephone number for the contact person defined for the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.2, PR07.3, PR07.5, PR67.1, PR67.6, PR67.9 +2 more
`PTI-CONTACT-SUF` CONTACT_SUF	Numeric 4	Contains the suffix portion of the telephone number for the contact person defined for the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.2, PR07.3, PR07.5, PR67.1, PR67.6, PR67.9 +2 more
`PTI-CONTACT-EXT` CONTACT_EXT	Numeric 4	Contains the telephone extension number for the contact person defined for the tax authority. This applies only to state type tax authorities that require this additional information.	PR06.4, PR07.1, PR07.2, PR07.3, PR07.5, PR67.1, PR67.6, PR67.9 +1 more
`PTI-TAX-TYPE-CODE` TAX_TYPE_CODE	Alpha 1	Contains the value that indicates if the employer is a T (Taxable Employer) or a non-profit, R (Reimbursable Employer).	PR06.4, PR07.6, PR67.1, PR67.8, PR68.8
`PTI-UI-TAX-RATE` UI_TAX_RATE	Signed 5.3	Contains the unemployment insurance tax rate defined for the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR06.8, PR06.9, PR07.1, PR07.2, PR07.5, PR67.1, PR67.2 +8 more
`PTI-UNDERPAYMENT` UNDERPAYMENT	Signed 11.2	Contains the underpayment from the previous quarter. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.4, PR07.5, PR07.8, PR67.2, PR67.3, PR68.3 +2 more
`PTI-INTEREST` INTEREST	Signed 11.2	Contains the interest amount associated with tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.5, PR67.1, PR67.2, PR67.3, PR68.1, PR68.2 +4 more
`PTI-PENALTY` PENALTY	Signed 11.2	Contains the penalty amount associated with the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.5, PR67.1, PR67.2, PR67.3, PR68.3, PR68.4 +2 more
`PTI-CREDIT` CREDIT	Signed 11.2	Contains credits or overpayments that are associated with the tax authority. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR07.1, PR07.5, PR67.2, PR67.3, PR67.9, PR68.3, PR68.4 +1 more
`PTI-MONTH-1-EMPS` MONTH_1_EMPS	Numeric 7	Contains the number of employees covered by unemployment insurance who worked or received pay for the first month of the quarter, including the 12th day of the month. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR06.7, PR06.8, PR06.9, PR07.1, PR07.2, PR07.3, PR07.4 +18 more
`PTI-MONTH-2-EMPS` MONTH_2_EMPS	Numeric 7	Contains the number of employees covered by unemployment insurance who worked or received pay in the second month of the quarter including the 12th day of the month. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR06.7, PR06.8, PR06.9, PR07.1, PR07.2, PR07.3, PR07.4 +18 more
`PTI-MONTH-3-EMPS` MONTH_3_EMPS	Numeric 7	Contains the number of employees covered by unemployment insurance who worked or received pay for the third month of the quarter, including the 12th day of the month. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR06.7, PR06.8, PR06.9, PR07.1, PR07.2, PR07.3, PR07.4 +18 more
`PTI-DOC-CNTRL-NBR` DOC_CNTRL_NBR	Alpha 9	Contains the document control number. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR67.2, PR67.9, PR68.3, PR68.4
`PTI-TAPE-AUTH-NBR` TAPE_AUTH_NBR	Numeric 4	Contains the number assigned when authorization is granted, WR-43 (Magnetic Tape Transmittal Form). This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR06.5, PR07.9, PR68.4, PR68.9
`PTI-MULTI-CODE` MULTI_CODE	Numeric 1	Contains the value that indicates if the employer has employees in more than one county or industry. A value of 0 (zero) indicates No, and a value of 1 indicates Yes. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR68.9
`PTI-MULTI-LOC` MULTI_LOC	Numeric 1	Contains the value that indicates if the employer has employees at more than one location within the county. A value of 1 indicates Yes, and zero indicates No. This applies only to state type tax authorities that require this additional information for quarterly reporting.	PR67.1, PR68.9
`PTI-REMITTER-NBR` REMITTER_NBR	Numeric 6	Contains the remitter number assigned to the tax authority for the company or process level. The remitter number is used to track and process magnetic media. This only applies to state type tax authorities that require this additional information for quarterly reporting.	PR06.7, PR06.9, PR67.1, PR67.2, PR68.1, PR68.2, PR68.8
`PTI-SUFFIX-CODE` SUFFIX_CODE	Alpha 5	Contains the suffix code assigned to the company or process level. This only applies to state type tax authorities that require this additional information for quarterly reporting.	PR06.4, PR06.5, PR06.6, PR06.7, PR06.8, PR06.9, PR07.1, PR07.6 +9 more
`PTI-EMPLOY-CODE` EMPLOY_CODE	Alpha 1	" " = Regular `A` Agriculture `H` Household `M` Military `Q` Medicare Qualified Gov't EE `X` Railroad `R` Regular	PR06.2, PR69.2
`PTI-TAX-DIST-NBR` TAX_DIST_NBR	Alpha 3	—	PR06.8, PR68.8
`PTI-TAX-DIST-NAME` TAX_DIST_NAME	Alpha 40	—	PR67.1, PR67.2, PR68.3
`PTI-TAX-OFF-REF` TAX_OFF_REF	Alpha 7	—	PR68.6
`PTI-YE-PERMIT-NBR` YE_PERMIT_NBR	Alpha 12	—	PR07.7
`PTI-ECON-NBR` ECON_NBR	Alpha 9	To be valid, Econ Nbr field must be entered as an 'E' character followed by 7 digits between 3,000,000 and 3,900,000 then a final alphabetic character. Valid Examples could include E3121552K or E3899121M or E3000345H.	—
`PTI-ADDR1` ADDR1	Alpha 30 (Lower Case)	This field contains the first line of address information.	PR67.1, PR67.2
`PTI-ADDR2` ADDR2	Alpha 30 (Lower Case)	This field contains the first line of address information.	PR67.1
`PTI-ADDR3` ADDR3	Alpha 30 (Lower Case)	This field contains the first line of address information.	PR67.1
`PTI-ADDR4` ADDR4	Alpha 30 (Lower Case)	This field contains the first line of address information.	PR67.1, PR67.2
`PTI-STATE` STATE	Alpha 2	This field contains the two-character state code of the address.	PR67.1, PR67.2
`PTI-ZIP` ZIP	Alpha 10	This field contains the postal code of the address.	PR67.1, PR67.2

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PTISET1`	`TAX-ID-CODE`, `COMPANY`, `PROCESS-LEVEL`	Primary		HR00.1, HR01.1, PR06.1, PR06.2, PR06.4, PR06.5, PR06.6, PR06.7 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required	When PTI-COMPANY != Zeroes	`PTI-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Process Level	PRSYSTEM	Required	When PTI-COMPANY != Zeroes And PTI-PROCESS-LEVEL != Spaces	`PTI-COMPANY` → `PRS-COMPANY`, `PTI-PROCESS-LEVEL` → `PRS-PROCESS-LEVEL`
Tax Id Code	PRTAXAUTH	Required		`PTI-TAX-ID-CODE` → `PRX-TAX-ID-CODE`

Programs

Updated by (37)

HR00.1 Company
HR01.1 Process Level
PR06.1 United States Tax Authority
PR06.2 United States Additional EIN
PR06.4 State Reporting Information
PR06.5 State Reporting Information
PR06.6 State Reporting Information
PR06.7 State Reporting Information
PR06.8 State Reporting Information
PR06.9 State Reporting Information
PR07.1 State Reporting Information
PR07.2 State Reporting Information
PR07.3 State Reporting Information
PR07.4 State Reporting Information
PR07.5 State Reporting Information
PR07.6 State Reporting Information
PR07.7 State Reporting Information
PR07.8 State Reporting Information
PR07.9 State Reporting Information
PR67.1 State Reporting Information
PR67.2 State Reporting Information
PR67.3 State Reporting Information
PR67.4 State Reporting Information
PR67.6 State Reporting Information
PR67.7 State Reporting Information
PR67.8 State Reporting Information
PR67.9 State Reporting Information
PR68.1 New Mexico State Report
PR68.2 Not Used
PR68.3 Florida
PR68.4 Missouri
PR68.5 Tennessee
PR68.6 Nevada
PR68.7 Oklahoma
PR68.8 Vermont
PR68.9 Michigan
PR69.2 Additional Information

Referenced by (18)

PR206 Tax Authority Listing
PR227 Year-End Parameter Report
PR250 1099-R Form Reporting
PR251 1099-R File Creation
PR252 United States Territory W-2 Form Printing
PR253 1099-R Reporting
PR287 Quarterly Federal Tax Return
PR290 Quarterly Report
PR291 Unemployment Continuation Form
PR292 Quarterly Unemployment Ins
PR294 United States Balancing Report
PR296 New Hire Reporting
PR297 W-2 Forms
PR299 EFW2 File Creation
PR906 ALLTAX Tax Code Update
ZP296 New Hire Reporting
ZP529 Payroll CA state qtr tax
ZP551 Triad FSA Export Interface