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 BN71.1 BN72.1
BS13.1 BS14.1 BS15.1 BS32.1 HR211 PR26.1
PR26.2 PR39.1 PR39.2 PR47.1 PR47.2 UK47.1
UK47.2 HR04.9
UPDATED BY
BN150 HR11.1 HR11.2 HR511 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 PR205 PR29.1 PR313 PR32.2 PR33.2
PR33.3 PR35.1 PR35.2 PR35.3 PR35.4 PR35.5
PR35.6 PR35.8 PR35.9 PR36.1 PR45.1 PR529
PR530 PR560 PR82.1 UK102 TA147 TP135
HR00.1 HR01.1 PA115 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PXL-COMPANY Numeric 4 BN150 HR11.1
Element: Company Hr Identifies the AP company if the HR11.2 HR511
resource type = V. Identifies the HR PA02.1 PA100
company if the resource type = E. It is PA102 PA13.1
blank for type A, P or Q resources. 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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-EMPLOYEE Numeric 9 BN150 HR11.1
Element: Employee Contains the employee number. Each HR11.2 HR511
person employed by the company is PA02.1 PA100
assigned a unique number. The system PA102 PA13.1
uses the employee number to correlate PA13.2 PA502
all of the information related to that PA513 PA52.1
person. 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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-RECORD-TYPE Alpha 1 BN150 HR11.1
Element: Record Type This field identifies the type of HR11.2 HR511
record defined. PA02.1 PA100
PA102 PA13.1
Valid values are: PA13.2 PA502
S = Summary PA513 PA52.1
D = Detail PA52.3 PA52.4
" " = System PA52.5 PR110
U = User PR113 PR120
PR128 PR13.1
PR13.5 PR13.6
PR13.7 PR13.8
PR130 PR131
PR132 PR134
PR136 PR14.1
PR15.2 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-LOCAT-CODE Alpha 10 BN150 HR11.1
Element: Location HR11.2 HR511
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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-DED-CODE Alpha 4 BN150 HR11.1
Element: Deduction Code HR11.2 HR511
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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-ACTIVE-FLAG Alpha 1 BN150 HR11.1
Element: Status The Active flag of the credit card HR11.2 HR511
type. PA02.1 PA100
A = Active PA102 PA13.1
I = Inactive 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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-DATE-STAMP Numeric 8 (yyyymmdd) BN150 HR11.1
Element: Date Stamp This field contains the server date HR11.2 HR511
(month, date, and year) of the last PA02.1 PA100
change to this record. 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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-TIME-STAMP Numeric 6 (hhmmss) BN150 HR11.1
Element: Time Stamp Contains the server time (hour, minute, HR11.2 HR511
and second) when the record was last PA02.1 PA100
changed. 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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PXL-USER-ID Alpha 10 (Lower Case) BN150 HR11.1
Element: User Contains the user ID of the person who HR11.2 HR511
last changed this record. 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 PR205
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 PR45.1
PR529 PR530
PR560 PR82.1
TA147 TP135
UK102
PRTAXLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PXLSET1 COMPANY BN100 BN101
EMPLOYEE BN102 BN103
LOCAT-CODE BN104 BN105
DED-CODE 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 HR11.1
HR11.2 HR211
HR511 PA02.1
...
PXLSET2 COMPANY HR04.9 PR113
LOCAT-CODE PR313
EMPLOYEE
DED-CODE
PXLSET3 COMPANY Subset BN150 HR11.1
EMPLOYEE Where ACTIVE-FLAG = "A" HR11.2 HR511
LOCAT-CODE PA02.1 PA100
DED-CODE 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 PR136
PR29.1 PR32.2
...
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
|