Lawson Insight Technical Documentation |
|
PRDEDDTL
PRDEDDTL FILE
REFERENCED BY
PR141 PR294
UPDATED BY
BN66.1 ET530 PR140 PR189 PR195 PR197
PR300 PR80.1 PR82.1 PR85.1 PR89.1 HR00.1
HR01.1 HR11.1 PA115
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PDE-COMPANY Numeric 4 BN66.1 PR140
Element: Company Hr PR189 PR195
PR80.1 PR89.1
PDE-EMPLOYEE Numeric 9 BN66.1 PR140
Element: Employee Contains the employee number. Each PR189 PR195
person employed by the company is PR80.1 PR89.1
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PDE-PYD-OBJ-ID Numeric 12 BN66.1 PR140
Element: Pyd Obj Id PR189 PR195
PR80.1 PR85.1
PR89.1
PDE-QTD-OBJ-ID Numeric 12 BN66.1 ET530
Element: Qtd Obj Id PR140 PR189
PR195 PR197
PR80.1 PR82.1
PR85.1 PR89.1
PDE-TAX-STATUS Alpha 2 BN66.1 PR140
Element: Tax Status PR189 PR195
PR80.1 PR89.1
PDE-NONTAX-REMUN Signed 13.2 BN66.1 PR140
Element: Nontax Remun PR189 PR195
PR80.1 PR85.1
PR89.1
PDE-TAXABLE-MATCH Signed 13.2 BN66.1 PR140
Element: Taxable Match PR189 PR195
PR80.1 PR85.1
PR89.1
PDE-REMUN-CODE Alpha 4
Element: Remun Code
PRDEDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PDESET1 PYD-OBJ-ID BN66.1 ET530
TAX-STATUS PR140 PR141
PR189 PR195
PR197 PR80.1
PR82.1 PR85.1
PR89.1
PDESET2 QTD-OBJ-ID KeyChange, Subset PR294 PR300
TAX-STATUS Where QTD-OBJ-ID != Zeroes
PYD-OBJ-ID
PDESET3 COMPANY Subset HR00.1 HR01.1
EMPLOYEE Where TAX-STATUS != Spaces HR11.1 PA115
PYD-OBJ-ID
TAX-STATUS
PRDEDDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
PDE-COMPANY -> EMP-COMPANY
PDE-EMPLOYEE -> EMP-EMPLOYEE
|