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-COLLECTION         Alpha 15
Element: Collection

RDT-ACTIVITY-GRP       Alpha 15
Element: Group

RDT-AC-MATRIX-LIST     Alpha 12                                  AC36.1
Element: Attribute 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       The company number represents an
                       established company and is entered on
                       all function codes.

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: Attribute 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

Acactgrp       ACACTGRP     Not Required

                            RDT-ACTIVITY-GRP      -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Not Required

                            RDT-ACTIVITY          -> ACV-ACTIVITY

Accatgrp       ACCATGRP     Not Required

                            RDT-GROUP             -> CGP-CAT-GROUP

Accolgrp       ACCOLGRP     Not Required

                            RDT-COLLECTION        -> CLG-COLLECTION

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