 |
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 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 HR211 PR14.1
PR15.1 PR15.2 PR205 PR26.1 PR26.2 PR39.1
PR39.2 PR47.1 PR47.2 PR514 HR04.9
UPDATED BY
AC541 AC542 BN150 HR511 HR650 PA502
PA513 PR128 PR13.1 PR13.5 PR13.6 PR13.7
PR13.8 PR131 PR132 PR134 PR136 PR313
PR32.2 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR36.1 PR530
PR82.1 UK102 UK120 HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXL-COMPANY Numeric 4 AC541 AC542
Company The company number represents an BN150 HR511
established company and is entered on HR650 PA502
all function codes. PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-EMPLOYEE Numeric 9 AC541 AC542
Employee Contains the employee number. Each BN150 HR511
person employed by the company is HR650 PA502
assigned a unique number. The system PA513 PR128
uses the employee number to correlate PR13.1 PR13.5
all of the information related to that PR13.6 PR13.7
person. PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-RECORD-TYPE Alpha 1 AC541 AC542
Record Type This field identifies the type of BN150 HR511
record defined. HR650 PA502
PA513 PR128
Valid values are: PR13.1 PR13.5
S = Summary PR13.6 PR13.7
D = Detail PR13.8 PR131
" " = System PR132 PR134
U = User PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-LOCAT-CODE Alpha 10 AC541 AC542
Location BN150 HR511
HR650 PA502
PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-DED-CODE Alpha 4 AC541 AC542
Deduction Code BN150 HR511
HR650 PA502
PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-ACTIVE-FLAG Alpha 1 AC541 AC542
Status The Active flag of the credit card BN150 HR511
type. HR650 PA502
A = Active PA513 PR128
I = Inactive PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-DATE-STAMP Numeric 8 (yyyymmdd) AC541 AC542
Date Stamp This field contains the server date BN150 HR511
(month, date, and year) of the last HR650 PA502
change to this record. PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-TIME-STAMP Numeric 6 (hhmmss) AC541 AC542
Time Stamp Contains the server time (hour, minute, BN150 HR511
and second) when the record was last HR650 PA502
changed. PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
UK102 UK120
PXL-USER-ID Alpha 10 (Lower Case) AC541 AC542
User ID Name Contains the user ID of the person who BN150 HR511
last changed this record. HR650 PA502
PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.7
PR13.8 PR131
PR132 PR134
PR136 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR530 PR82.1
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 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR00.1
HR01.1 HR211
HR511 HR650
...
PXLSET2 COMPANY HR04.9 PR313
LOCAT-CODE
EMPLOYEE
DED-CODE
PXLSET3 COMPANY Subset AC541 AC542
EMPLOYEE Where ACTIVE-FLAG = "A" BN150 HR511
LOCAT-CODE HR650 PA502
DED-CODE PA513 PR128
PR13.1 PR13.5
PR13.6 PR13.8
PR131 PR132
PR134 PR136
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR36.1 PR530
PR82.1 UK102
...
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
|