Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIDEPTHD


                             SIDEPTHD FILE

REFERENCED BY

HR11.1    HR11.2    HR511     HR650     PA02.1    PA100
PA102     PA13.1    PA13.2    PA502     PA513     PA52.1
PA52.3    PA52.4    PA52.5    PR110     PR113     PR120
PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

SDH-ALL-DEPT-FL        Alpha 1
Element: All Dept Fl

SDH-INTG-FLAG          Alpha 1
Element: Intg Flag

                         SIDEPTHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SDHSET1   COMPANY                                                HR11.1  HR11.2
                                                                 HR511   HR650
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

                         SIDEPTHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sideptdtl      SIDEPTDTL    Delete Cascades

                            SDH-COMPANY    -> SDD-COMPANY
                                              SDD-PROCESS-LEVEL
                                              SDD-DEPARTMENT