Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACGLTOTREV


                            ACGLTOTREV FILE

                     AC GL Acct Unit Total Revenue

This file maintains total revenue and total loss amounts by activity, account
category, company, and accounting unit. It is updated by AC170 (Revenue
Calculation).

UPDATED BY

AC300     AC310     BR130     BR140     BR530

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GRV-ACTIVITY           Alpha 15                                  BR130   BR530
Element: Activity      Required key. This is the activity for
                       the total revenue and total loss
                       amounts. Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity. Activities and
                       cost object activities are used
                       synonymously in the Lawson Activity
                       Management system. Direct costs are
                       posted to activities, and indirect costs
                       are allocated to activities based on
                       activity drivers.

                       Activities are grouped or organized by
                       activity levels. There are two types of
                       activities: posting allowed and summary
                       only. Use posting level activities to
                       budget and maintain all posted
                       transactions. Summary activities or
                       macro activities combine information and
                       balances from lower level activities for
                       reporting and inquiries.

GRV-ACCT-CATEGORY      Alpha 5                                   BR130   BR530
Element: Account CategoRequired key. This is the account
                       category for the total revenue and total
                       loss amounts. Account categories are
                       groupings of costs, revenues, or a
                       combination of both used for reporting
                       and inquiries for activities in the
                       Lawson 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.

GRV-COMPANY            Numeric 4                                 BR130   BR530
Element: Company       Required key. This is the company
                       number the transaction was posted to in
                       the general ledger.

GRV-ACCT-UNIT          Alpha 15                                  BR130   BR530
Element: Accounting UniRequired key. This is the accounting
                       unit the transaction was posted to in
                       the general ledger. The accounting unit
                       is a shorthand notation representing a
                       location (variable level) in the company
                       structure. The accounting unit must be
                       defined in the General Ledger Names file
                       as a posting accounting unit.

GRV-TOTAL-REVENUE      Signed 18.2                               BR130   BR530
Element: Total Revenue This is the life-to-date total revenue
                       amount for this record.

GRV-TOTAL-LOSS         Signed 18.2
Element: Total Loss    This is the life-to-date total loss
                       amount for this record.

                         ACGLTOTREV FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRVSET1   ACTIVITY                                               AC300   AC310
          ACCT-CATEGORY                                          BR130   BR140
          COMPANY                                                BR530
          ACCT-UNIT

                         ACGLTOTREV FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            GRV-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Acactivity     ACACTIVITY   Not Required

                            GRV-ACTIVITY         -> ACV-ACTIVITY

Glnames        GLNAMES      Not Required

                            GRV-COMPANY          -> GLN-COMPANY
                            GRV-ACCT-UNIT        -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Not Required

                            GRV-COMPANY          -> GLS-COMPANY