Lawson Insight Technical Documentation |
|
PRQCENTGRP
PRQCENTGRP FILE
REFERENCED BY
BN150 BN305 BN55.2 BN555 ET530 ETI2.1
HPQC.1 HR11.1 HR11.2 HR200 HR201 HR511
LP130 PA02.1 PA100 PA102 PA115 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 PR189 PR240 PR241 PR242
PR243 PR244 PR245 PR249 PR274 PR29.1
PR30.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 PR80.1
PR82.1 UK102 UK560 TA147
UPDATED BY
HR00.1 HR00.3 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PQC-COMPANY Numeric 4 HR00.1 HR00.3
Element: Company Hr HR01.1
PQC-PROCESS-LEVEL Alpha 5 HR00.1 HR00.3
Element: Process Lev Hr HR01.1
PQC-QC-ENT-NBR-GRP Alpha 4 HR00.1 HR00.3
Element: Qc Ent Nbr Grp HR01.1
PQC-QC-ENT-NBR Alpha 16 HR00.1 HR00.3
Element: Qc Ent Nbr HR01.1
PRQCENTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PQCSET1 COMPANY BN150 BN305
PROCESS-LEVEL BN55.2 BN555
QC-ENT-NBR-GRP ET530 ETI2.1
HPQC.1 HR00.1
HR00.3 HR01.1
HR11.1 HR11.2
HR200 HR201
HR511 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
...
PRQCENTGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PQC-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Process Level PRSYSTEM Required
PQC-COMPANY -> PRS-COMPANY
PQC-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
PRQCENTGRP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employees EMPLOYEE
PQC-COMPANY -> EMP-COMPANY
PQC-PROCESS-LEVEL -> EMP-PROCESS-LEVEL
EMP-EMPLOYEE
|