 |
Lawson Insight Technical Documentation |
|
PRPENPAY FILE
REFERENCED BY
PR229 AC541 AC542 BN150 BN66.1 PR128
PR130 PR131 PR132 PR134 PR136 PR140
PR160 PR180 PR189 PR195 PR197 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR45.1 PR530
PR80.1 PR80.2 PR85.1 PR89.1 UK102 TA147
UK120
UPDATED BY
PR29.1 PR529 PR560 PR82.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PNP-COMPANY Numeric 4 PR29.1 PR529
Company The company number represents an PR560 PR82.1
established company and is entered on
all function codes.
PNP-EMPLOYEE Numeric 9 PR29.1 PR529
Employee Contains the employee number. Each PR560 PR82.1
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PNP-EFFECT-DATE Numeric 8 (yyyymmdd) PR29.1 PR529
Effective Date PR560 PR82.1
PNP-END-DATE Numeric 8 (yyyymmdd) PR29.1 PR529
Ending Date The ending date in a range of dates. PR560 PR82.1
PNP-PENS-SEQ-NBR Numeric 4 PR29.1 PR529
Pens Seq Nbr PR560 PR82.1
PNP-PENS-DIST-TYPE Numeric 2 PR29.1 PR529
Pens Dist Type 01 = Partial; Hardship PR560 PR82.1
02 = Partial; Non-hardship
03 = Partial; Rollover to IRA
04 = Total; Non-rollover
05 = Total Rollover to IRA
06 = Total rollover to qual plan
07 = Periodic; > 10 years
08 = Periodic; < 10 years
09 = Periodic; < 10 years; Roll IRA
10 = Periodic; Tax not determined
11 = Periodic; W-2
12 = Lump sum payment; W-2
13 = Retro-payment
14 = Retro-payment; Rollover to IRA
15 = Loan issued
16 = Dividend
17 = Minimum distribution
18 = Excess deferrals
19 = Non-spousal death benefit
20 = Periodic non-res alien; 1042S
21 = Lump sum NRA; 1042S
22 = Periodic; 480.6
23 = Lump sum; 480.6
24 = Retro; W-2
PNP-PENS-DIST-CODE Alpha 1 PR29.1 PR529
Pens Dist Code 1 = Early distrib; No exception PR560 PR82.1
2 = Early distrib; With exception
3 = Disability
4 = Death benefit
5 = Prohibited transaction
6 = Section 1035 exchange
7 = Normal distribution
8 = Excess contrib;Taxable curr yr
9 = PS 58 costs
A = Qualified for 5/10yr averaging
D = Exs cntrb;Txb in pri yr;Pri yr
E = Excess annual addtns; Sec 415
G = Direct rollover to IRA
H = R-over to qual plan/tax sh ann
L = Loan default
P = Excess contrib;Txbl prior year
PNP-PENS-DST-CODE2 Alpha 1 PR29.1 PR529
Pens Dst Code2 A = Qualified for 5/10yr averaging PR560 PR82.1
D = Exs cntrb;Txb in pri yr;Pri yr
G = Direct rollover to IRA
H = R-over to qual plan/tax sh ann
P = Excess contrib;Txbl prior year
PNP-TAX-CATEGORY Numeric 2 PR29.1 PR529
Tax Category 00 = Regular PR560 PR82.1
70 = Periodic
71 = Non-periodic;Not elig rollover
72 = Eligible for rollover
PNP-ADDL-FED-TAX Signed 9.2 PR29.1 PR529
Addl Fed Tax PR560 PR82.1
PNP-PERC-TOT-DIST Numeric 3 PR29.1 PR529
Perc Tot Dist PR560 PR82.1
PNP-PAYABLE-TO Alpha 38 (Lower Case) PR29.1 PR529
Payable To PR560 PR82.1
PNP-FBO-NAME Alpha 38 (Lower Case) PR29.1 PR529
Fbo Name PR560 PR82.1
PNP-ADDR1 Alpha 30 (Lower Case) PR29.1 PR529
Address 1 This field contains the first line of PR560 PR82.1
address information.
PNP-ADDR2 Alpha 30 (Lower Case) PR29.1 PR529
Address 2 This field contains the second line of PR560 PR82.1
address information.
PNP-ADDR3 Alpha 30 (Lower Case) PR29.1 PR529
Address 3 This field contains the third line of PR560 PR82.1
address information.
PNP-ADDR4 Alpha 30 (Lower Case) PR29.1 PR529
Address 4 This field contains the fourth line of PR560 PR82.1
address information.
PNP-CITY Alpha 18 (Lower Case) PR29.1 PR529
City This field contains the city of the PR560 PR82.1
address.
PNP-STATE Alpha 2 PR29.1 PR529
State or Province This field contains the two-character PR560 PR82.1
state code of the address.
PNP-POSTAL-CODE Alpha 10 (Lower Case) PR29.1 PR529
Postal Code This field contains the postal code. PR560 PR82.1
PNP-COUNTRY-CODE Alpha 2 PR29.1 PR529
Country Code The country code. Required for VAT and PR560 PR82.1
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
PNP-ROLLOVER-ACCT Alpha 17 PR29.1 PR529
Rollover Acct PR560 PR82.1
PNP-MISCELLANEOUS Alpha 6 PR29.1 PR529
Miscellaneous PR560 PR82.1
PNP-MISCELLANEOUS2 Alpha 6 PR29.1 PR529
Miscellaneous2 PR560 PR82.1
PNP-WIRE-IND Numeric 1 PR29.1 PR529
Wire Ind 1 = Foreign PR560 PR82.1
2 = Domestic
PNP-CA-EFT Alpha 1 PR29.1 PR529
Ca Eft N = No PR560 PR82.1
Y = Yes
PRPENPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PNPSET1 COMPANY PR229 PR29.1
EMPLOYEE PR529 PR560
EFFECT-DATE PR82.1
PENS-SEQ-NBR
PNPSET2 COMPANY AC541 AC542
EMPLOYEE BN150 BN66.1
PENS-SEQ-NBR* PR128 PR130
PR131 PR132
PR134 PR136
PR140 PR160
PR180 PR189
PR195 PR197
PR229 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR45.1
...
PNPSET3 COMPANY PR29.1 PR529
EMPLOYEE
EFFECT-DATE*
PENS-SEQ-NBR
PRPENPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PNP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PNP-COMPANY -> EMP-COMPANY
PNP-EMPLOYEE -> EMP-EMPLOYEE
PRPENPAY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Paymastr PAYMASTR
PNP-COMPANY -> PYM-COMPANY
PNP-EMPLOYEE -> PYM-EMPLOYEE
PNP-PENS-SEQ-NBR -> PYM-PENS-SEQ-NBR
PYM-CHECK-ID
Prcheck PRCHECK
PNP-COMPANY -> PCH-COMPANY
PNP-EMPLOYEE -> PCH-EMPLOYEE
PNP-PENS-SEQ-NBR -> PCH-PENS-SEQ-NBR
PCH-CHECK-ID
|