Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACRANGEDTL FILE

REFERENCED BY

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

UPDATED BY

AC36.1    AC36.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

RDT-COLLECTION       Alpha 15
Collection

RDT-ACTIVITY-GRP     Alpha 15
Activity Group

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

RDT-ACTIVITY         Alpha 15                                    AC36.1
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
From Account
Category

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

RDT-GROUP            Alpha 15                                    AC36.1
Group

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

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

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

RDT-ACCT-UNIT        Alpha 15                                    AC36.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.


                         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
                                                                 AC30.2  AC30.3
                                                                 AC32.1  AC36.1
                                                                 AC36.2  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