Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ORGSTRUC FILE

REFERENCED BY

ACDL.1    ACDM.1    GLDM.1    GLDX.1    GLOP.1    IFBO.1
IFEO.1

UPDATED BY

IFOS.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ORG-USER-DIM-NAME    Alpha 50  (Lower Case)                      IFOS.1
User Dim Name        The User Dimension Name is the name
                     associated with the dimension in the
                     data mart outline. This user-defined
                     name can contain up to 50 alphanumeric
                     characters. For example, you might name
                     a dimension Fiscal Year or Organization.


ORG-ORG-PREFIX       Alpha 5  (Lower Case)                       IFOS.1
Org Prefix           The Organization Prefix field contains
                     a unique prefix name that differentiates
                     the members in the Organization
                     dimension with similar members in other
                     dimensions. This prefix can contain up
                     to five characters of any kind.

ORG-ORG-ALIAS-OPT    Alpha 1                                     IFOS.1
Organization Alias   The Organization Alias Option field
Option Name          contains the value that represents the
                     alias name for the members of this
                     dimension.

                     Valid values are:
                     1 = Company, accounting unit, and
                     description of accounting unit; Default
                     value.
                     2 = Company and accounting unit
                     3 = Description of accounting unit.

ORG-COMPANY          Numeric 4                                   IFOS.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

ORG-ACCT-UNIT        Alpha 15                                    IFOS.1
Accounting Unit      The accounting unit is a shorthand
                     notation representing the variable level
                     number. When used in the General Ledger
                     Account Master file, the accounting unit
                     must be defined in the General Ledger
                     Names file as a posting accounting unit.


ORG-COMPANY-GROUP    Alpha 12                                    IFOS.1
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.

                         ORGSTRUC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ORGSET1   USER-DIM-NAME                                          ACDL.1  ACDM.1
                                                                 GLDM.1  GLDX.1
                                                                 GLOP.1  IFBO.1
                                                                 IFEO.1  IFOS.1
                                                                 IFOS.2  IFOS.3

                         ORGSTRUC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acctunit       GLNAMES      Not Required

                            ORG-COMPANY          -> GLN-COMPANY
                            ORG-ACCT-UNIT        -> GLN-ACCT-UNIT

Company        GLSYSTEM     Not Required

                            ORG-COMPANY          -> GLS-COMPANY

Companygroup   GLCPYGRP     Not Required

                            ORG-COMPANY-GROUP    -> GCG-COMPANY-GROUP