Lawson Insight Technical Documentation |
|
PRTAXPRDS
PRTAXPRDS FILE
REFERENCED BY
BN150 BN66.1 ET530 ETI2.1 LP130 PR128
PR130 PR131 PR132 PR134 PR136 PR139
PR140 PR160 PR180 PR189 PR195 PR197
PR29.1 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 PR45.1 PR529 PR530 PR539
PR560 PR80.1 PR80.2 PR82.1 PR85.1 PR89.1
UK102 UK13.1 UK145 UK201 UK202 UK50.2
UK50.3 UK560 TA147
UPDATED BY
UK85.1 UK85.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPS-COMPANY Numeric 4 UK85.1 UK85.3
Element: Company Hr
TPS-COUNTRY-CODE Alpha 2 UK85.1 UK85.3
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
TPS-PAYROLL-YEAR Numeric 4 UK85.1 UK85.3
Element: Payroll Year Contains the payroll year in which the
allocation was taken.
TPS-PLAN-CODE Alpha 4 UK85.1 UK85.3
Element: Plan Code Contains the user-defined code that
represents a benefit plan.
TPS-PD-START-D Numeric 8 (yyyymmdd) UK85.1 UK85.3
Element: Pd Start D
TPS-PD-END-D Numeric 8 (yyyymmdd) UK85.1 UK85.3
Element: Pd End D
TPS-PERIOD-NBR Numeric 3 UK85.1 UK85.3
Element: Period Nbr
TPS-DFLT-PAY-DATE Numeric 8 (yyyymmdd) UK85.1 UK85.3
Element: Dflt Pay Date
PRTAXPRDS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPSSET1 COMPANY UK85.1
COUNTRY-CODE
PAYROLL-YEAR
PLAN-CODE
PD-END-D
TPSSET2 COMPANY KeyChange BN150 BN66.1
COUNTRY-CODE ET530 ETI2.1
PLAN-CODE LP130 PR128
PAYROLL-YEAR PR130 PR131
PERIOD-NBR PR132 PR134
PR136 PR139
PR140 PR160
PR180 PR189
PR195 PR197
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
TPSSET3 COMPANY BN150 BN66.1
COUNTRY-CODE ET530 ETI2.1
PLAN-CODE LP130 PR128
PD-END-D PR130 PR131
PR132 PR134
PR136 PR139
PR140 PR160
PR180 PR189
PR195 PR197
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
...
PRTAXPRDS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TPS-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Country INSTCTRYCD Required
TPS-COUNTRY-CODE -> INT-COUNTRY-CODE
Instctrycd INSTCTRYCD Required
TPS-COUNTRY-CODE -> INT-COUNTRY-CODE
|