Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              ARCODE FILE

                               AR GL Code

AR GL Code

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    AR30.2    AR30.4    AR31.5    AR43.1
AR44.3    AR501     AR507     AR550     AR560     AR570
AR575     AR580     AR82.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    AR502
BL120     BL123     BL13.1    BL130     BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL290     BL520
BL80.1    BL820     BL92.1    BL940     OE114     OE129
OE30.1    OE30.2    OE30.3    OE30.4    OE30.5    OE30.6
OE30.7    OE30.9    OE830     OE950

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RCD-COMPANY          Numeric 4                                   AR01.1  AR15.7
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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
Description          Contains a description of the code.         BL213

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

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

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

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

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

                     A = Active
                     I = Inactive

RCD-JRNL-BOOK-NBR    Alpha 12
Journal Book Number  This 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
                                                                 AR30.2  AR30.4
                                                                 AR31.5  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