Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SAIAORGDIM


                            SAIAORGDIM FILE

REFERENCED BY

SALD.1

UPDATED BY

SADM.2    SAOR.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SA1-ORG-DIM            Alpha 50  (Lower Case)                    SADM.2
Element: Org Dim

SA1-MEMBER-PREFIX      Alpha 5  (Lower Case)                     SADM.2
Element: Member Prefix The Member Prefix field contains a
                       unique prefix to differentiate the
                       dimension name from other like-named
                       dimensions.  This user-defined name can
                       contain up to five characters of any
                       kind.

SA1-SELECT-LVL         Alpha 1                                   SADM.2
Element: Select Lvl    1 = All Companies
                       2 = Company and/or Process Level

SA1-COMPANY-GROUP      Alpha 12                                  SADM.2
Element: Company Group You can type or select a company group.
                       A company group represents one or more
                       companies.

                       If you select a company group, leave
                       the Company field blank.

SA1-COMPANY            Numeric 4                                 SADM.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

SA1-FR-PROCESS-LEV     Alpha 5                                   SADM.2
Element: Fr Process Lev

SA1-TO-PROCESS-LEV     Alpha 5                                   SADM.2  SAOR.1
Element: To Process Lev

SA1-INTER-CO-FLAG      Alpha 1                                   SADM.2
Element: Inter Co Flag Y
                       N

SA1-LAST-MAINT-DT      Numeric 8  (yyyymmdd)                     SADM.2
Last Maintenance       This is the last date the Member was
Date                   imported to the budget.

SA1-LAST-MAINT-TM      Numeric 6  (hhmmss)                       SADM.2
Element: Sys Time      This is the last time the member was
                       imported to the budget.

SA1-LAST-LOAD-DT       Numeric 8  (yyyymmdd)                     SAOR.1
Element: Last Load Dt  This is the data the data this was used
                       in the data load.

SA1-LAST-LOAD-TM       Numeric 6  (hhmmss)                       SAOR.1
Element: Last Load Tm

                         SAIAORGDIM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SA1SET1   ORG-DIM                                                SADM.1  SADM.2
                                                                 SALD.1  SAOR.1

                         SAIAORGDIM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        SACOMPANY    Required

                            SA1-COMPANY    -> SAC-COMPANY