PRTAXPRDS

UPDATED BY
UK85.1 UK85.3 BN150 BN66.1 PR521 EXI2.1
EXI4.1 LP130 LP140 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR140 PR160 PR180 PR189 PR195 PR197
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR37.1 PR39.1 PR45.1
PR529 PR530 PR539 PR560 PR582 PR80.1
PR80.2 PR80.4 PR82.1 PR85.1 PR89.1 UK102
UK13.1 UK145 UK201 UK202 UK50.2 UK50.3
UK560 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPS-COMPANY
Element: Company Hr		Numeric 4
UK85.1 UK85.3
TPS-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
UK85.1 UK85.3
TPS-PAYROLL-YEAR
Element: Payroll Year		Numeric 4
Contains the payroll year in which the allocation was taken.
UK85.1 UK85.3
TPS-PLAN-CODE
Element: Plan Code		Alpha 4
Contains the user-defined code that represents a benefit plan.
UK85.1 UK85.3
TPS-PD-START-D
Element: Pd Start D		Numeric 8 (yyyymmdd)
UK85.1 UK85.3
TPS-PD-END-D
Element: Pd End D		Numeric 8 (yyyymmdd)
UK85.1 UK85.3
TPS-PERIOD-NBR
Element: Period Nbr		Numeric 3
UK85.1 UK85.3
TPS-DFLT-PAY-DATE
Element: Dflt Pay Date		Numeric 8 (yyyymmdd)
UK85.1 UK85.3


PRTAXPRDS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPSSET1 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
PLAN-CODE
PD-END-D
UK85.1
TPSSET2 COMPANY
COUNTRY-CODE
PLAN-CODE
PAYROLL-YEAR
PERIOD-NBR
KeyChange
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR139
PR140 PR160
PR180 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
TPSSET3 COMPANY
COUNTRY-CODE
PLAN-CODE
PD-END-D
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
LP140 PR128
PR130 PR131
PR132 PR134
PR135 PR136
PR137 PR139
PR140 PR160
PR180 PR189
PR195 PR197
PR29.1 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2


PRTAXPRDS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Wed Jun 08 20:51:13 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.