PRTAXPRDS

UPDATED BY
BN150 BN66.1 PR521 EXI2.1 EXI4.1 LP130
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 UK85.1 UK85.3
ZP530 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
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
TPSSET3 COMPANY
COUNTRY-CODE
PLAN-CODE
PD-END-D
...
BN150 BN66.1
PR521 EXI2.1
EXI4.1 LP130
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


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: Thu Jun 09 11:27:24 2016

Home
Contact Us



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