Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARCATEGORY FILE

                              AR Category

The AR Category file is used for defaulting general ledger account
distributions for manual transaction entry in AR42 (Transaction Entry).

REFERENCED BY

AR215     AR293     AR42.2    AR42.7

UPDATED BY

AR15.4

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

ACA-ACCT-UNIT        Alpha 15                                    AR15.4
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
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
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
Description          The description of the category.

ACA-ACTIVITY         Alpha 15                                    AR15.4
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.


ACA-TAX-CODE         Alpha 10                                    AR15.4
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
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-ACCT-UNIT-FLAG   Alpha 1                                     AR15.4
Acct Unit Flag       Will determine if the account unit of
                     the category can be overriden during
                     processing.
                     N = Acct Unit Can be Overridden
                     Y = Acct Unit Can't be Overridden

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

                         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.                       AR293   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