Lawson Insight Technical Documentation |
|
PRREGPARM
PRREGPARM FILE
REFERENCED BY
PR160 PR180 PR227 PR240 PR241 PR242
PR243 PR244 PR245 PR250 PR251 PR252
PR253 PR292 PR297 PR298 PR299
UPDATED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN150 BN245 BN31.1 BN31.2 BN32.1
BN32.2 BN32.3 BN45.1 BN531 BN65.1 BN71.1
BN72.1 BS13.1 BS14.1 BS15.1 BS32.1 HR11.1
HR11.2 HR18.3 HR511 PA02.1 PA100 PA102
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR05.5 PR11.1 PR110 PR113
PR120 PR127 PR128 PR13.1 PR13.2 PR13.5
PR13.6 PR13.8 PR130 PR131 PR132 PR134
PR136 PR14.1 PR15.1 PR15.2 PR197 PR205
PR26.1 PR27.1 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 PR39.2 PR45.1
PR47.1 PR529 PR530 PR560 PR67.3 PR67.4
PR67.5 PR82.1 PR927 UK102 UK47.1 TA147
TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RGP-COMPANY Numeric 4 BN100 BN101
Element: Company Hr Identifies the AP company if the BN102 BN103
resource type = V. Identifies the HR BN104 BN105
company if the resource type = E. It is BN145 BN150
blank for type A, P or Q resources. BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-COUNTRY-CODE Alpha 2 BN100 BN101
Element: Country Code The country code. Required for VAT and BN102 BN103
intrastat reporting. Must be defined in BN104 BN105
IN01.1 (Country Maintenance). BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-RECORD-TYPE Alpha 1 BN100 BN101
Element: Record Type This field identifies the type of BN102 BN103
record defined. BN104 BN105
BN145 BN150
Valid values are: BN245 BN31.1
S = Summary BN31.2 BN32.1
D = Detail BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-PAYROLL-YEAR Numeric 4 BN100 BN101
Element: Current PayrolContains the payroll year in which the BN102 BN103
allocation was taken. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-REPORT-ENTITY Alpha 5 BN100 BN101
Element: Report Entity BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-TAX-ID-CODE Alpha 10 BN100 BN101
Element: Tax Id Code BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-EMPLOYEE Numeric 9 BN100 BN101
Element: Employee Contains the employee number. Each BN102 BN103
person employed by the company is BN104 BN105
assigned a unique number. The system BN145 BN150
uses the employee number to correlate BN245 BN31.1
all of the information related to that BN31.2 BN32.1
person. BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-TOPIC Alpha 2 BN100 BN101
Element: Topic BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-FLD-NBR Numeric 4 BN100 BN101
Dictionary Field This field contains the PO dictionary BN102 BN103
Number field number. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-SEQ-NBR Numeric 4 BN100 BN101
Element: Sequence NumbeAn automatically assigned sequence BN102 BN103
number. BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR128 PR13.1
PR13.2 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.1 PR15.2
PR197 PR205
...
RGP-A-VALUE Alpha 30 (Lower Case) HR11.1 HR11.2
Element: A Value HR18.3 HR511
PA02.1 PA100
PA102 PA502
PA52.1 PA52.3
PA52.4 PA52.5
PR05.5 PR11.1
PR110 PR113
PR120 PR127
PR13.1 PR13.5
PR13.6 PR13.8
PR197 PR27.1
PR67.5
RGP-S-VALUE Signed 17.4 BN100 BN101
Element: S Value BN102 BN103
BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR511
PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR05.5
PR11.1 PR110
PR113 PR120
PR127 PR128
PR13.1 PR13.2
PR13.5 PR13.6
PR13.8 PR130
PR131 PR132
PR134 PR136
PR14.1 PR15.1
PR15.2 PR160
PR180 PR197
...
RGP-D-VALUE Numeric 8 (yyyymmdd) PR05.5 PR127
Element: D Value PR197 PR27.1
RGP-DESCRIPTION Alpha 30 (Lower Case) PR05.5 PR127
Element: Description This field displays the description. PR197 PR27.1
RGP-BUS-NBR-GRP Alpha 4
Element: Bus Nbr Grp
PRREGPARM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RGPSET1 COMPANY BN100 BN101
COUNTRY-CODE BN102 BN103
PAYROLL-YEAR BN104 BN105
RECORD-TYPE BN145 BN150
REPORT-ENTITY BN245 BN31.1
TAX-ID-CODE BN31.2 BN32.1
EMPLOYEE BN32.2 BN32.3
TOPIC BN45.1 BN531
FLD-NBR BN65.1 BN71.1
SEQ-NBR BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR11.1
HR11.2 HR18.3
HR511 PA02.1
PA100 PA102
...
RGPSET2 COMPANY HR18.3 PR05.1
COUNTRY-CODE PR05.5 PR127
RECORD-TYPE PR292 PR298
REPORT-ENTITY PR67.3 PR67.5
TAX-ID-CODE
EMPLOYEE
PAYROLL-YEAR
TOPIC
FLD-NBR
SEQ-NBR
RGPSET3 COMPANY Subset PR11.1 PR127
COUNTRY-CODE Where RECORD-TYPE = "E" PR297 PR299
RECORD-TYPE
EMPLOYEE
REPORT-ENTITY
PAYROLL-YEAR*
TOPIC
FLD-NBR
SEQ-NBR
RGPSET4 COMPANY
COUNTRY-CODE
PAYROLL-YEAR
BUS-NBR-GRP
RECORD-TYPE
REPORT-ENTITY
TAX-ID-CODE
EMPLOYEE
TOPIC
FLD-NBR
SEQ-NBR
PRREGPARM FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
RGP-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When RGP-RECORD-TYPE = "E"
RGP-COMPANY -> EMP-COMPANY
RGP-EMPLOYEE -> EMP-EMPLOYEE
Prtaxauth PRTAXAUTH Required
When RGP-TAX-ID-CODE != Spaces
RGP-TAX-ID-CODE -> PRX-TAX-ID-CODE
|