Lawson Insight Technical Documentation |
|
PRTAXAUTH
PRTAXAUTH FILE
Tax Authority
This file contains the tax authority that provides the link between the
Payroll system and the Business Software, Inc. tax tables. Tax authorities can
be company or process level specific.
REFERENCED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN305 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN340 BN45.1 BN531
BN65.1 BN66.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 ET530 ETI1.1 ETI2.1 HAP3.1
HEP4.1 HPOS.1 HPQC.1 HPRS.1 HPRX.1 HR100
HR11.1 HR11.2 HR15.1 HR155 HR170 HR211
HR511 HR515 HR54.1 HR55.2 HR70.1 HRS1.1
HRSC.1 LP100 LP101 LP130 PA02.1 PA100
PA102 PA113 PA115 PA13.1 PA13.2 PA16.1
PA20.1 PA21.1 PA22.1 PA24.1 PA27.1 PA272
PA34.1 PA35.1 PA36.1 PA38.1 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PA520 PA53.1
PA54.1 PA66.3 TR21.1 TR22.1 TR26.1 TR500
PR03.1 PR05.1 PR05.4 PR05.5 PR07.9 PR07.1
PR07.2 PR07.3 PR07.4 PR07.5 PR07.6 PR07.7
PR07.8 PR10.1 PR110 PR113 PR120 PR128
PR13.1 PR13.2 PR13.5 PR13.6 PR13.8 PR130
PR131 PR132 PR134 PR136 PR139 PR14.1
PR14.2 PR140 PR141 PR15.1 PR15.2 PR160
PR180 PR189 PR195 PR197 PR205 PR206
PR210 PR225 PR240 PR241 PR242 PR243
PR244 PR245 PR246 PR248 PR249 PR25.2
PR250 PR251 PR252 PR253 PR26.1 PR26.2
PR266 PR27.1 PR27.2 PR29.1 PR290 PR291
PR292 PR294 PR297 PR299 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR39.1 PR39.2
PR45.1 PR46.2 PR47.1 PR47.2 PR514 PR529
PR530 PR539 PR560 PR67.1 PR67.2 PR67.3
PR67.4 PR67.5 PR67.6 PR67.7 PR67.8 PR67.9
PR68.1 PR702 PR710 PR80.1 PR80.2 PR80.3
PR82.1 PR85.1 PR89.1 PR910 UK06.1 UK102
UK46.2 UK47.1 UK47.2 UK560 TA147 TA40.2
TA40.3 PR227 PR287 PR296 TA146 TA148
PR125 PR262 PR925
UPDATED BY
PR06.1 PR08.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PRX-TAX-ID-CODE Alpha 10 PR06.1 PR08.1
Element: Tax Id Code Contains the tax authority.
PRX-DESCRIPTION Alpha 30 (Lower Case) PR06.1 PR08.1
Element: Description Contains the tax authority description.
PRX-BSI-AUTHORITY Alpha 11 BN66.1 PR06.1
Element: Bsi Authority Contains the BSI tax code that PR08.1 PR89.1
determines the tax tables the system
uses. For proper calculation, you must
tie tax deductions to the appropriate
BSI tax codes.
PRX-W2-DESC Alpha 6 (Lower Case) PR06.1 PR08.1
Element: W2 Desc Contains the tax authority description
that prints on the W-2 form created by
PR297 (W-2 Forms) for state and local
taxes.
PRX-TAX-AUTH-TYPE Alpha 2 PR06.1 PR08.1
Element: Tax Auth Type Contains the tax authority type.
FD = Federal
ST = State
CI = City
CN = County
SD = School District
TD = Transportation District
PR = Province
PRX-TAX-STATE Alpha 2 PR06.1 PR08.1
Element: Tax State Contains the value that identifies the
state in which the tax authority is
located if the authority type is
anything but FD (Federal). This field
along with the Authority Type field
determines if the State Rpt subform is
accessible.
PRX-STATE-RECIP Alpha 1 PR06.1 PR08.1
Element: State Recip Contains the value that indicates if
the state associated with the tax
authority participates in reciprocity.
Y = Yes
N = No
PRX-COUNTY-CODE Numeric 2 PR06.1 PR08.1
Element: County Code Contains the 2-digit county code
required for W-2 tape reporting in the
state of Indiana.
PRX-SCH-DIST-NBR Alpha 4 PR06.1 PR08.1
Element: Sch Dist Nbr Contains the school district number
required by the state of Ohio for W-2
tape reporting.
PRX-GARN-ONLY Alpha 1 PR06.1 PR08.1
Element: Garn Only Determines what fields are required
when adding a tax authority.
Y = Yes
N = No
PRX-COUNTRY-CODE Alpha 2 PR06.1 PR08.1
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
CA
US
PRX-TAX-PROVINCE Alpha 2 PR08.1
Element: Province
PRTAXAUTH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PRXSET1 TAX-ID-CODE BN100 BN101
BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN340
BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
ET530 ETI1.1
ETI2.1 HAP3.1
...
PRXSET2 TAX-AUTH-TYPE KeyChange BN66.1 PR06.1
TAX-STATE PR08.1 PR139
TAX-PROVINCE PR140 PR189
TAX-ID-CODE PR195 PR227
PR250 PR251
PR252 PR253
PR26.1 PR287
PR291 PR292
PR296 PR297
PR299 PR47.1
PR514 PR80.1
PR89.1 UK47.1
TA146 TA148
PRXSET3 COUNTRY-CODE PR05.1 PR06.1
TAX-ID-CODE PR06.2 PR06.3
PR06.4 PR06.5
PR06.6 PR06.7
PR06.8 PR06.9
PR07.1 PR07.2
PR07.3 PR07.4
PR07.5 PR07.6
PR07.7 PR07.8
PR08.1 PR08.2
PR125 PR206
PR210 PR250
PR251 PR253
PR262 PR89.1
PR925
PRXSET4 BSI-AUTHORITY KeyChange BN150 BN305
TAX-ID-CODE ET530 ETI2.1
HR11.1 HR11.2
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
...
PRTAXAUTH FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Default Tax Id PRTAXID Required
PRX-TAX-ID-CODE -> PTI-TAX-ID-CODE
Zeroes -> PTI-COMPANY
Spaces -> PTI-PROCESS-LEVEL
Province PRPROVINCE Not Required
PRX-TAX-PROVINCE -> PPV-PROVINCE
State PRSTATE Required
When PRX-TAX-STATE != Spaces
PRX-TAX-STATE -> PSA-STATE
PRTAXAUTH FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Minimum Wage PRMINWAGE Delete Cascades
PRX-TAX-ID-CODE -> PMW-TAX-ID-CODE
PMW-EFFECT-DATE
Tax Id Nbrs PRTAXID Delete Cascades
PRX-TAX-ID-CODE -> PTI-TAX-ID-CODE
PTI-COMPANY
PTI-PROCESS-LEVEL
|