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
Company              The company number represents an
                     established company and is entered on
                     all function codes.


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

PHD-DESCRIPTION      Alpha 30  (Lower Case)                      PA94.1
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