Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCATEGORY


                            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
Element: Company       The company number. Must be a valid
                       company in the AR Company file.

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

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

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


ACA-TAX-CODE           Alpha 10                                  AR15.4
Element: 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
Element: Tax Exempt CodUsed 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
Element: Category      The project account category.

ACA-ACCT-UNIT-FLAG     Alpha 1                                   AR15.4
Element: Acct Unit FlagWill 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
Element: 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