Lawson Insight Technical Documentation |
|
PRTAXLOC
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
PR140 PR195 PR26.1 PR26.2 PR39.1 PR39.2
PR47.1 PR47.2 PR514 PR89.1 UK47.1 UK47.2
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 PR14.1 PR15.2 PR189 PR205
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 UK560 TA147 UK120 HR00.1
HR01.1 PA115 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXL-COMPANY Numeric 4 AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-EMPLOYEE Numeric 9 AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-RECORD-TYPE Alpha 1 AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-LOCAT-CODE Alpha 10 AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-DED-CODE Alpha 4 AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-ACTIVE-FLAG Alpha 1 AC541 AC542
Element: Status The Active flag of the credit card BN150 HR11.1
type. HR11.2 HR511
A = Active HR650 PA02.1
I = Inactive 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-DATE-STAMP Numeric 8 (yyyymmdd) AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-TIME-STAMP Numeric 6 (hhmmss) AC541 AC542
Element: 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
PR14.1 PR15.2
PR189 PR205
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 UK560
PXL-USER-ID Alpha 10 (Lower Case) AC541 AC542
Element: User 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
PR14.1 PR15.2
PR189 PR205
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 UK560
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
|