Lawson Insight Technical Documentation

                             PACANHDR FILE

REFERENCED BY

PA294     PA594

UPDATED BY

PA94.1    HR00.1    HR01.1    PBIP.1    PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PHD-COMPANY            Numeric 4                                 PA94.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

PHD-SIC                Numeric 3                                 PA94.1
Element: Sic           Contains Canadian Standard Industry Code
                       (SIC) provided by Canadian Government.

PHD-DESCRIPTION        Alpha 30  (Lower Case)                    PA94.1
Element: Description   This field displays the description.

                         PACANHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PHDSET1   COMPANY                                                HR00.1  HR01.1
          SIC                                                    PA294   PA594
                                                                 PA94.1  PBIP.1
                                                                 PR197

                         PACANHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PHD-COMPANY    -> PRS-COMPANY
                            Spaces         -> PRS-PROCESS-LEVEL

                         PACANHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pacaneea       PACANEEA

                            PHD-COMPANY    -> PCE-COMPANY
                            PHD-SIC        -> PCE-SIC
                                              PCE-PROCESS-LEVEL
                                              PCE-DEPARTMENT
                                              PCE-LOCAT-CODE