Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCODE


                              ARCODE FILE

                               AR GL Code

The AR GL Code file holds codes that represent accounts receivable, received
not applied and finance charge general ledger accounts to be used in the
Accounts Receivable System.

REFERENCED BY

AR08.1    AR10.1    AR115     AR124     AR190     AR196
AR20.1    AR21.1    AR21.2    AR21.3    AR21.4    AR21.6
AR215     AR24.1    AR242     AR256     AR286     AR287
AR29.2    AR30.1    AR31.5    AR33.5    AR34.1    AR43.1
AR44.3    AR501     AR507     AR550     AR560     AR570
AR575     AR580     AR82.1    ARLL.1    BL213     CB191
DT150     DT155     DT160     DT165     DT166     DT180
DT181     DT185     DT30.1    DT30.2    DT40.1    DT45.1
DT520     DT60.1    DT60.2    DT70.1    DT70.3    DT80.1
DT85.1    DT85.2    DT90.1    DT92.1

UPDATED BY

AR01.1    AR02.1    AR137     AR15.7    AR42.1    AR42.2
AR502     BL120     BL122     BL123     BL13.1    BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL290     BL520     BL80.1    BL820     BL92.1    BRIP.1
OE114     OE129     OE30.1    OE30.2    OE30.3    OE30.4
OE30.5    OE30.6    OE30.7    OE30.9    OE530     OE830
PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RCD-COMPANY            Numeric 4                                 AR01.1  AR15.7
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.

RCD-AR-CODE            Alpha 4                                   AR01.1  AR15.7
Accounts Receivable    This code is used to identify accounts
Code                   receivable accounts (trade, non-trade,
                       etc), received not applied accounts and
                       finance charge accounts.

RCD-DESC               Alpha 30  (Lower Case)                    AR01.1  AR15.7
Element: Description   Contains a description of the code.       BL213

RCD-ACCT-UNIT          Alpha 15                                  AR01.1  AR15.7
Element: Accounting UniThis is the general ledger accounting
                       unit of the associated AR Code.

RCD-ACCOUNT            Numeric 6                                 AR01.1  AR15.7
Element: Account       This is the general ledger account        DT185
                       number of the AR code.

RCD-SUB-ACCT           Numeric 4                                 AR01.1  AR15.7
Element: Subaccount    This is the general ledger subaccount     DT185
                       of the AR Code.

RCD-USED-FL            Alpha 1                                   AR01.1  AR02.1
Element: Used Flag     The used flag that  signifies if a code   AR137   AR15.7
                       has been used. A code cannot be deleted   AR42.1  AR42.2
                       once it has been used, and only the       AR502   BL120
                       description will be allowed to change     BL122   BL123
                       once in use. By adding this code to a     BL13.1  BL130
                       process level record, the code will be    BL20.1  BL20.3
                       considered used. Valid values are:        BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                       N = Not used                              BL290   BL520
                       Y = Used                                  BL80.1  BL820
                                                                 BL92.1  BRIP.1
                                                                 OE114   OE129
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE530   OE830
                                                                 PR197

RCD-ACTIVE-STATUS      Alpha 1                                   AR01.1  AR15.7
Element: Active Status Indicates whether the code has an
                       active or inactive status. Valid values
                       are:

                       A = Active
                       I = Inactive

RCD-JRNL-BOOK-NBR      Alpha 12
Element: Journal Book NThis is the journal book number for the
                       AR code.

                         ARCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RCDSET1   COMPANY       This is the primary path used to access  AR01.1  AR02.1
          AR-CODE       accounts receivable code records.        AR08.1  AR10.1
                                                                 AR115   AR124
                                                                 AR137   AR15.7
                                                                 AR190   AR196
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR21.4  AR21.6
                                                                 AR215   AR24.1
                                                                 AR242   AR256
                                                                 AR286   AR287
                                                                 AR29.2  AR30.1
                                                                 AR31.5  AR33.5
                                                                 AR34.1  AR42.1
                                                                 AR42.2  AR42.6
                                                                 ...

                         ARCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            RCD-COMPANY    -> ACO-COMPANY