Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACRANGEDTL


                            ACRANGEDTL FILE

REFERENCED BY

AC121     AC123     AC130     AC20.1    AC20.2    AC20.3
AC20.4    AC20.5    AC32.1    AC37.1    AC490

UPDATED BY

AC36.1    AC36.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RDT-AC-HEAD-NAME       Alpha 10                                  AC36.1
Element: Ac Head Name

RDT-LINE-NBR           Numeric 6                                 AC36.1
Element: Line Number   This field contains the line number.

RDT-AC-MATRIX-LIST     Alpha 12                                  AC36.1
Element: Ac Matrix ListActivity List.

RDT-ACTIVITY           Alpha 15                                  AC36.1
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


RDT-FR-ACCT-CAT        Alpha 5                                   AC36.1
Element: Account Category

RDT-TH-ACCT-CAT        Alpha 5                                   AC36.1
Element: Account Category

RDT-GROUP              Alpha 15                                  AC36.1
Element: Group

RDT-COMPANY            Numeric 4                                 AC36.1
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.

RDT-COMPANY-GROUP      Alpha 12                                  AC36.1
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.

RDT-AU-MATRIX-LIST     Alpha 12                                  AC36.1
Element: Au Matrix List

RDT-ACCT-UNIT          Alpha 15                                  AC36.1
Element: Accounting UniThe 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.


                         ACRANGEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RDTSET1   AC-HEAD-NAME                                           AC121   AC123
          LINE-NBR                                               AC130   AC20.1
                                                                 AC20.2  AC20.3
                                                                 AC20.4  AC20.5
                                                                 AC32.1  AC36.1
                                                                 AC36.2  AC37.1
                                                                 AC490

                         ACRANGEDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ac Mxlisthdr   MXLISTHDR    Not Required

                            "ACTVY"               -> MLH-OBJ-TYPE
                            RDT-AC-MATRIX-LIST    -> MLH-MATRIX-LIST

Acactivity     ACACTIVITY   Not Required

                            RDT-ACTIVITY          -> ACV-ACTIVITY

Accatgrp       ACCATGRP     Not Required

                            RDT-GROUP             -> CGP-CAT-GROUP

Acrangehdr     ACRANGEHDR   Required

                            RDT-AC-HEAD-NAME      -> RHD-AC-HEAD-NAME

Au Mxlisthdr   MXLISTHDR    Not Required

                            "ACCTU"               -> MLH-OBJ-TYPE
                            RDT-AU-MATRIX-LIST    -> MLH-MATRIX-LIST

Glcpygrp       GLCPYGRP     Not Required

                            RDT-COMPANY-GROUP     -> GCG-COMPANY-GROUP

Glnames        GLNAMES      Not Required

                            RDT-COMPANY           -> GLN-COMPANY
                            RDT-ACCT-UNIT         -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Not Required

                            RDT-COMPANY           -> GLS-COMPANY