 |
Lawson Insight Technical Documentation |
|
PRTAXLOC FILE
REFERENCED BY
BN100 BN101 BN102 BN103 BN104 BN105
BN145 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN45.1 BN531 BN65.1 BN66.1 BN71.1
BN72.1 BS13.1 BS14.1 BS15.1 BS32.1 HR211
PR14.1 PR140 PR15.1 PR15.2 PR195 PR205
PR26.1 PR26.2 PR39.1 PR39.2 PR47.1 PR47.2
PR514 PR89.1 HR04.9
UPDATED BY
AC541 AC542 BN150 HR11.1 HR11.2 HR511
HR650 PA02.1 PA100 PA102 PA13.1 PA13.2
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PR110 PR113 PR120 PR128 PR13.1 PR13.5
PR13.6 PR13.7 PR13.8 PR130 PR131 PR132
PR134 PR136 PR189 PR29.1 PR313 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 UK102 TA147
UK120 HR00.1 HR01.1 PA115 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXL-COMPANY Numeric 4 AC541 AC542
Company The company number represents an BN150 HR11.1
established company and is entered on HR11.2 HR511
all function codes. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-EMPLOYEE Numeric 9 AC541 AC542
Employee Contains the employee number. Each BN150 HR11.1
person employed by the company is HR11.2 HR511
assigned a unique number. The system HR650 PA02.1
uses the employee number to correlate PA100 PA102
all of the information related to that PA13.1 PA13.2
person. PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-RECORD-TYPE Alpha 1 AC541 AC542
Record Type This field identifies the type of BN150 HR11.1
record defined. HR11.2 HR511
HR650 PA02.1
Valid values are: PA100 PA102
S = Summary PA13.1 PA13.2
D = Detail PA502 PA513
" " = System PA52.1 PA52.3
U = User PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-LOCAT-CODE Alpha 10 AC541 AC542
Location BN150 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-DED-CODE Alpha 4 AC541 AC542
Deduction Code BN150 HR11.1
HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-ACTIVE-FLAG Alpha 1 AC541 AC542
Status The Active flag of the credit card BN150 HR11.1
type. HR11.2 HR511
HR650 PA02.1
A = Active PA100 PA102
I = Inactive PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-DATE-STAMP Numeric 8 (yyyymmdd) AC541 AC542
Date Stamp This field contains the server date BN150 HR11.1
(month, date, and year) of the last HR11.2 HR511
change to this record. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-TIME-STAMP Numeric 6 (hhmmss) AC541 AC542
Time Stamp Contains the server time (hour, minute, BN150 HR11.1
and second) when the record was last HR11.2 HR511
changed. HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PXL-USER-ID Alpha 10 (Lower Case) AC541 AC542
User ID Name Contains the user ID of the person who BN150 HR11.1
last changed this record. HR11.2 HR511
HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR130
PR131 PR132
PR134 PR136
PR189 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
PR529 PR530
PR560 PR80.1
PR82.1 TA147
UK102 UK120
PRTAXLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXLSET1 COMPANY AC541 AC542
EMPLOYEE BN100 BN101
LOCAT-CODE BN102 BN103
DED-CODE BN104 BN105
BN145 BN150
BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN45.1 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BS13.1 BS14.1
BS15.1 BS32.1
HR00.1 HR01.1
HR11.1 HR11.2
...
PXLSET2 COMPANY HR04.9 PR113
LOCAT-CODE PR313
EMPLOYEE
DED-CODE
PXLSET3 COMPANY Subset AC541 AC542
EMPLOYEE Where ACTIVE-FLAG = "A" BN150 HR11.1
LOCAT-CODE HR11.2 HR511
DED-CODE HR650 PA02.1
PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR130 PR131
PR132 PR134
...
PRTAXLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PXL-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deduction Code DEDCODE Required
PXL-COMPANY -> DDC-COMPANY
PXL-DED-CODE -> DDC-DED-CODE
Emp Deduction EMDEDMASTR Required
PXL-COMPANY -> EDM-COMPANY
PXL-EMPLOYEE -> EDM-EMPLOYEE
PXL-DED-CODE -> EDM-DED-CODE
Zeroes -> EDM-SEQ-NBR
Employee EMPLOYEE Required
PXL-COMPANY -> EMP-COMPANY
PXL-EMPLOYEE -> EMP-EMPLOYEE
Location PCODES Required
"LO" -> PCO-TYPE
PXL-LOCAT-CODE -> PCO-CODE
|