Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SISETUP


                              SISETUP FILE

UPDATED BY

LO12.1    LO900     LO920     RD00.1    RD03.1    RD06.2
RD30.1    RD30.2    RD41.2    RD41.3    RD41.4    RD50.1
RD50.2    RD70.1    RD70.2    RD930     RD941     RD990
WF00.1    WF12.5    WF20.1    WF20.2    WF50.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SUP-SYSTEM-NAME        Alpha 10                                  LO12.1  LO900
Element: System Name                                             LO920   RD00.1
                                                                 RD03.1  RD06.2
                                                                 RD30.1  RD30.2
                                                                 RD41.2  RD41.3
                                                                 RD41.4  RD50.1
                                                                 RD50.2  RD70.1
                                                                 RD70.2  RD930
                                                                 RD941   RD990
                                                                 WF00.1  WF12.5
                                                                 WF20.1  WF20.2
                                                                 WF50.1

SUP-FIELD-NAME         Alpha 20  (Lower Case)                    LO12.1  LO900
Element: Field Name                                              LO920   RD00.1
                                                                 RD03.1  RD06.2
                                                                 RD30.1  RD30.2
                                                                 RD41.2  RD41.3
                                                                 RD41.4  RD50.1
                                                                 RD50.2  RD70.1
                                                                 RD70.2  RD930
                                                                 RD941   RD990
                                                                 WF00.1  WF12.5
                                                                 WF20.1  WF20.2
                                                                 WF50.1

SUP-CATEGORY           Alpha 9                                   RD00.1  RD06.2
Element: Category      A category code is user-defined and
                       represents a general ledger account for
                       a specific type of expense type during
                       expense entry.

SUP-FIELD-VALUE        Alpha 99  (Lower Case)                    LO12.1  LO900
Element: Field Value                                             LO920   RD00.1
                                                                 RD03.1  RD30.1
                                                                 RD30.2  RD41.2
                                                                 RD41.3  RD41.4
                                                                 RD50.1  RD50.2
                                                                 RD70.1  RD70.2
                                                                 RD930   RD941
                                                                 RD990   WF00.1
                                                                 WF20.1  WF20.2
                                                                 WF50.1

SUP-DESCRIPTION        Alpha 50  (Lower Case)                    RD00.1  RD06.2
Element: Description   This field contains the description.

                         SISETUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SUPSET1   SYSTEM-NAME                                            LO12.1  LO900
          FIELD-NAME                                             LO920   RD00.1
                                                                 RD03.1  RD06.1
                                                                 RD06.2  RD06.3
                                                                 RD30.1  RD30.2
                                                                 RD41.2  RD41.3
                                                                 RD41.4  RD50.1
                                                                 RD50.2  RD70.1
                                                                 RD70.2  RD930
                                                                 RD941   RD990
                                                                 WF00.1  WF12.5
                                                                 WF20.1  WF20.2
                                                                 WF50.1

SUPSET2   SYSTEM-NAME   KeyChange
          CATEGORY
          FIELD-NAME

SUPSET3   CATEGORY      KeyChange
          SYSTEM-NAME
          FIELD-NAME

                         SISETUP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdidpref     SIRDIDPREF   Not Required

                            SUP-SYSTEM-NAME    -> SIP-SYSTEM-NAME  (SIPSET3)
                            SUP-FIELD-NAME     -> SIP-FIELD-NAME

                         SISETUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdidpref1    SIRDIDPREF   Delete Cascades

                            SUP-SYSTEM-NAME    -> SIP-SYSTEM-NAME
                            SUP-FIELD-NAME     -> SIP-FIELD-NAME
                                                  SIP-ID