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 Nbr      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: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

RDT-TH-ACCT-CAT        Alpha 5                                   AC36.1
Element: Acct Category Account categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

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