Lawson Insight Technical Documentation |
|
PRTAXPRDS
PRTAXPRDS FILE
REFERENCED BY
AC541 AC542 BN150 BN66.1 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 PR36.1 PR39.1
PR45.1 PR529 PR530 PR560 PR80.1 PR80.2
PR82.1 PR85.1 PR89.1 UK102 UK13.1 UK145
UK201 UK202 UK50.2 UK50.3 UK560 TA147
UK120
UPDATED BY
UK85.1 UK85.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPS-COMPANY Numeric 4 UK85.1 UK85.3
Element: Company The company number represents an
established company and is entered on
all function codes.
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: Current PayrolContains the payroll year in which the
allocation was taken.
TPS-PLAN-CODE Alpha 4 UK85.1 UK85.3
Element: Plan 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 AC541 AC542
COUNTRY-CODE BN150 BN66.1
PLAN-CODE PR128 PR130
PAYROLL-YEAR PR131 PR132
PERIOD-NBR 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
PR36.1 PR39.1
...
TPSSET3 COMPANY AC541 AC542
COUNTRY-CODE BN150 BN66.1
PLAN-CODE PR128 PR130
PD-END-D 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
PR36.1 PR39.1
...
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
|