Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARCATEGORY FILE

                              AR Category

AR Category

REFERENCED BY

AR215     AR42.2    AR42.7

UPDATED BY

AR15.4    AR951

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ACA-COMPANY          Numeric 4                                   AR15.4  AR951
Company              The company number. Must be a valid
                     company in the AR Company file.

ACA-AR-CATEGORY      Alpha 5                                     AR15.4  AR951
AR Category          User-defined category code used to
                     default general ledger accounts during
                     manual transaction entry.

ACA-ACCT-UNIT        Alpha 15                                    AR15.4  AR951
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.


ACA-ACCOUNT          Numeric 6                                   AR15.4  AR951
Account              This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

ACA-SUB-ACCOUNT      Numeric 4                                   AR15.4  AR951
Subaccount           This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

ACA-DESCRIPTION      Alpha 30  (Lower Case)                      AR15.4  AR951
Description          The description of the category.

ACA-ACTIVITY         Alpha 15                                    AR15.4  AR951
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. Activities and
                     cost object activities are used
                     synonymously in the 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 kinds 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.

ACA-TAX-CODE         Alpha 10                                    AR15.4  AR951
Tax Code             This field contains a code representing
                     specific tax information.  This must be
                     valid Tax Code.

ACA-TAX-EXEMPT-CD    Alpha 1                                     AR15.4  AR951
Tax Exempt Code      Used By Lawson Order Entry. Determines
                     whether category is tax exempt or not.
                     Valid values are:

                     E = Exempt
                     T = Taxable

ACA-ACCT-CATEGORY    Alpha 5                                     AR15.4
Category             The project account category.

ACA-LINE-TYPE        Alpha 1                                     AR15.4
Line Type            This field contains the type of
                     inventory on this line.
                     G = Goods
                     S = Services

                         ARCATEGORY FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACASET1   COMPANY       This is the primary path used to access  AR15.4  AR215
          AR-CATEGORY   the category file.                       AR42.2  AR42.7

                         ARCATEGORY FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ACA-COMPANY        -> ACO-COMPANY

Glmaster       GLMASTER     Required

                            ACA-COMPANY        -> GLM-COMPANY
                            ACA-ACCT-UNIT      -> GLM-ACCT-UNIT
                            ACA-ACCOUNT        -> GLM-ACCOUNT
                            ACA-SUB-ACCOUNT    -> GLM-SUB-ACCOUNT

Txtaxcode      TXTAXCODE    Not Required

                            ACA-COMPANY        -> TAC-COMPANY
                            ACA-TAX-CODE       -> TAC-TAX-CODE