Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCOMP


                              ARCOMP FILE

                               AR Company

The AR Company file contains the accounts receivable company records. A
company record contains the highest set of processing rules that are used for
customers that have been identified with that company.  Prior to adding a
company to this file, the same company number must be a  valid company in the
Lawson  General Ledger or General Ledger Interface  system.

REFERENCED BY

AC56.1    AC560     AP125     AP126     AP131     AP20.1
AP20.2    AP20.3    AP20.4    AP20.5    AP20.7    AP21.1
AP23.1    AP25.1    AP25.2    AP26.1    AP27.1    AP30.4
API1.1    AR02.1    AR03.1    AR03.2    AR04.1    AR06.1
AR06.2    AR06.3    AR06.4    AR08.1    AR08.2    AR09.1
AR09.4    AR10.1    AR10.2    AR10.3    AR100     AR105
AR11.1    AR110     AR112     AR12.1    AR12.2    AR120
AR124     AR129     AR13.1    AR13.2    AR131     AR132
AR135     AR136     AR14.1    AR15.1    AR15.2    AR15.3
AR15.4    AR15.5    AR15.6    AR15.7    AR15.8    AR150
AR155     AR160     AR161     AR17.1    AR170     AR18.1
AR180     AR19.4    AR19.5    AR19.6    AR19.7    AR191
AR194     AR195     AR196     AR197     AR198     AR199
AR201     AR203     AR204     AR206     AR208     AR209
AR21.1    AR21.2    AR21.3    AR21.4    AR21.5    AR21.6
AR21.7    AR210     AR211     AR212     AR213     AR215
AR217     AR218     AR219     AR220     AR222     AR223
AR227     AR228     AR229     AR23.1    AR23.3    AR23.4
AR230     AR232     AR233     AR234     AR235     AR237
AR238     AR239     AR24.1    AR242     AR245     AR25.1
AR25.2    AR250     AR251     AR252     AR253     AR255
AR256     AR257     AR258     AR264     AR265     AR271
AR274     AR275     AR28.1    AR28.2    AR28.3    AR28.4
AR28.5    AR28.6    AR28.7    AR28.8    AR282     AR285
AR286     AR287     AR29.1    AR29.2    AR29.3    AR290
AR291     AR292     AR293     AR294     AR295     AR296
AR300     AR301     AR35.1    AR35.2    AR36.1    AR36.2
AR37.1    AR37.2    AR37.3    AR37.4    AR37.5    AR37.6
AR37.7    AR37.8    AR37.9    AR38.1    AR38.2    AR38.3
AR38.4    AR38.5    AR39.1    AR39.2    AR39.3    AR39.4
AR45.1    AR46.1    AR48.1    AR48.2    AR48.3    AR48.4
AR50.1    AR501     AR504     AR506     AR507     AR515
AR520     AR525     AR53.1    AR55.1    AR550     AR58.1
AR58.2    AR70.1    AR70.2    AR72.1    AR72.2    AR74.1
AR75.1    AR80.1    AR80.2    AR800     AR90.1    AR90.2
AR95.1    AR96.1    AR99.6    BL00.1    BL01.1    BL02.1
BL04.1    BL05.1    BL10.1    BL120     BL121     BL122
BL123     BL125     BL13.1    BL130     BL20.1    BL20.3
BL20.6    BL200     BL201     BL202     BL204     BL21.2
BL21.5    BL217     BL220     BL231     BL232     BL246
BL29.1    BL29.2    BL290     BL291     BL31.1    BL31.2
BL31.3    BL31.5    BL31.7    BL32.3    BL32.4    BL33.1
BL331     BL34.1    BL46.1    BL46.2    BL47.1    BL520
BL530     BL546     BL80.1    BL80.3    BL802     BL81.1
BL82.1    BL820     BL85.1    BL85.2    BL85.3    BL90.1
BL91.1    BL92.1    BL98.1    BR00.1    BR00.2    BR02.3
BR10.1    BR10.9    BR11.1    BR120     BR121     BR122
BR123     BR131     BR140     BR145     BR151     BR152
BR155     BR156     BR157     BR16.1    BR16.2    BR17.1
BR180     BR19.1    BR20.1    BR20.2    BR20.3    BR20.4
BR20.5    BR20.7    BR21.1    BR21.2    BR210     BR211
BR216     BR217     BR220     BR245     BR251     BR252
BR253     BR300     BR400     BR420     BR45.1    BR450
BR46.1    BR46.2    BR46.4    BR48.1    BR51.1    BR51.2
BR52.1    BR52.2    BR521     BR53.1    BR55.1    BR55.2
BR70.1    BR70.2    BR91.1    BRIP.1    CB191     DT170
DT181     DT185     DT190     DT220     DT270     DT280
DT42.1    DT52.1    DT90.1    DT90.3    DT95.1    GL286
GL287     IC02.1    ICLM.1    MX123     MX500     MA180
MA41.1    MA41.2    MA41.4    MA41.7    MA43.1    MA43.2
MA43.3    MA43.7    MA530     MA531     MA60.2    MA60.3
MA60.5    MA61.1    MA66.2    MA66.3    MA67.2    MA67.3
MA68.2    MA68.3    MA68.5    MA70.1    MA75.1    MA80.1
MAI1.1    PD10.1    PD10.2    PD130     PD20.1    PD20.2
PD20.3    PO100     PO101     PO122     PO131     PO20.1
PO21.1    PO21.2    PO21.3    PO21.4    PO21.5    PO22.1
PO23.1    PO24.1    PO25.1    PO25.5    PO25.6    PO25.7
PO27.2    PO29.1    PO30.1    PO30.2    PO30.3    PO300
PO31.1    PO31.2    PO32.2    PO32.4    PO33.1    PO34.1
PO35.1    PO36.1    PO36.2    PO38.1    PO39.1    PO39.2
PO44.1    PO50.1    PO52.1    PO520     PO536     POI3.1
POID.1    POII.1    POIJ.1    PW110     PW550     RQ10.1
RQ10.2    IN20.1    TX100     TX101     TX130     TX140
TX226     TX301     TX40.1    WH110     WH120     WH130
WH132     WH190     WH20.1    WH20.2    WH20.7    WH21.2
WH224     WH226     WH30.1    WH30.2    WH30.3    WH30.4
WH31.1    WH31.2    WH31.3    WH31.4    WH32.1    WH32.2
WH32.3    WH32.4    WH33.5    WH34.1    WH34.2    WH34.3
WH34.4    WH40.1    WH40.2    WH520     WH830     AR00.1
AR200     AR260     AR261     AR505

UPDATED BY

AR01.1    AR115     AR130     AR137     AR140     AR141
AR145     AR190     AR20.1    AR30.1    AR30.8    AR32.1
AR33.3    AR34.1    AR42.1    AR42.2    AR42.6    AR42.7
AR43.1    AR44.3    AR502     AR503     AR560     AR570
AR575     AR580     AR82.1    ARLL.1    CB06.2    DT150
DT155     DT160     DT161     DT165     DT166     DT180
DT30.1    DT30.2    DT40.1    DT45.1    DT520     DT60.1
DT60.2    DT70.1    DT70.3    DT80.1    DT85.1    DT85.2
DT92.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACO-COMPANY            Numeric 4                                 AR01.1
Element: Company       The number representing an AR company.

ACO-CUST-GROUP         Alpha 5                                   AR01.1  AR35.1
Element: Customer GroupCustomer group assigned to this           TX130
                       company. Only customers initially
                       defined with this customer group are
                       eligible to be customers of this
                       company.


ACO-NAME               Alpha 30  (Lower Case)                    AR01.1
Element: Company Name  The name or description of the Accounts
                       Receivable company. The name defaults
                       from General Ledger unless you override
                       it in Accounts Receivable.

ACO-ADDR1              Alpha 30  (Lower Case)                    AR01.1
Element: Address 1     First line of address information.
                       Defaults from the general ledger or
                       interface company address and will be
                       maintainable once it is initially added.


ACO-ADDR2              Alpha 30  (Lower Case)                    AR01.1
Element: Address 2     Second line of address information.
                       Defaults from the general ledger or
                       interface company address, and will be
                       maintainable once it is initially added.


ACO-ADDR3              Alpha 30  (Lower Case)                    AR01.1
Element: Address 3     Third line of address information.
                       Defaults from the general ledger or
                       interface company address, and will be
                       maintainable once it is initially added.


ACO-ADDR4              Alpha 30  (Lower Case)                    AR01.1
Element: Address 4     Fourth line of address information.
                       Defaults from the general ledger or
                       interface company address, and will be
                       maintainable once it is initially added.


ACO-CITY               Alpha 18  (Lower Case)                    AR01.1
Element: City          City Name. Defaults from the general
                       ledger or interface company address and
                       will be maintainable once it is
                       initially added.

ACO-STATE              Alpha 2                                   AR01.1
Element: State or ProviState or province abbreviation.
                       Defaults from the general ledger or
                       interface  company address, and will be
                       maintainable once it is initially added.


ACO-ZIP                Alpha 10                                  AR01.1
Element: Postal Code   Postal code. Defaults from the general
                       ledger or interface company address, and
                       will be maintainable once it is
                       initially added.

ACO-COUNTRY            Alpha 30  (Lower Case)                    AR01.1
Element: Country or othCountry name. Defaults from the general
                       ledger or interface company address, and
                       will be maintainable once it is
                       initially added.

ACO-COUNTY             Alpha 25  (Lower Case)                    AR01.1
Element: County        County. Defaults from the general ledger
                       or interface company address, and will
                       be maintainable once it is initially
                       added.

ACO-PHONE-NMBR         Alpha 15                                  AR01.1
Element: Telephone NumbThe company phone number.

ACO-FAX-NMBR           Alpha 15                                  AR01.1
Element: Fax Number    The company fax number.

ACO-CHRG-BACK-NBR      Numeric 7                                 AR01.1  AR130
Element: Chargeback NumThis field will contain the last used     AR190   AR30.1
                       transaction number for created            AR30.8  AR32.1
                       chargebacks. The chargebacks will be in   AR33.3  AR34.1
                       the form of debit memos in the open item
                       file. This number will be prefixed by
                       "CB-".

ACO-INV-BTCH-FL        Alpha 1                                   AR01.1
Auto Number Trans      Specifies whether the manual invoice
Batches                batches will be automatically assigned.
                       Valid values are:

                       N = No automatic batch numbering
                       Y = Automatic batch numbering

ACO-INV-BTCH-NBR       Numeric 6                                 AR01.1  AR42.1
Last Transaction       The last batch number assigned for
Batch Number           manual invoice entry.

ACO-INV-BTCH-TL        Alpha 1                                   AR01.1
Trans Batch Control    This option allows system batch totals
Totals                 to be force balanced to header totals
                       prior to release. Valid values are:

                       N = No total balancing required
                       Y = Total balancing required

ACO-AUTO-BTCH-FL       Alpha 1                                   AR01.1
Auto Number Cash       This option will specify whether or not
Batches                automatic batch numbering will be used
                       in cash entry. Valid values are:

                       N = No automatic batch numbering
                       Y = Automatic batch numbering

ACO-AUTO-BAT-NBR       Numeric 6                                 AR01.1  AR115
Last Auto Batch        The last number assigned for the          AR20.1  AR42.1
Number Used            payment batch header. When a new batch    AR42.2  AR42.6
                       is assigned, 1 will be added to this      AR42.7  AR43.1
                       number and used to create the new batch   AR44.3  AR502
                       record. This number can be maintained     AR503   AR560
                       but cannot be changed to a value less     AR570   AR575
                       than the highest batch number used.       AR580   ARLL.1
                       Note: This number sequence will also be   CB06.2  DT150
                       used for lock box interfaced cash.        DT155   DT160
                                                                 DT165   DT166
                                                                 DT180   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT45.1  DT520
                                                                 DT60.1  DT60.2
                                                                 DT70.1  DT70.3
                                                                 DT80.1  DT85.1
                                                                 DT85.2  DT92.1

ACO-BTCH-CNTRL-TL      Alpha 1                                   AR01.1
Cash Batch Control     This cash option allows system batch
Total                  totals to be force balanced to control
                       totals. Valid values are:

                       N = No total balancing required
                       Y = Control balancing required

ACO-SUMM-BTCH-NBR      Numeric 6                                 AR01.1  AR137
Element: Summary Batch The last system-assigned batch number     AR190   AR82.1
                       used when creating chargeback records.

ACO-LAST-RTM-NBR       Numeric 7                                 AR01.1  AR82.1
Element: Last RTM NumbeReturn-to-maker debit memo number. This   DT92.1
                       is the numeric portion of the last RTM
                       document to be generated by the system.
                       RTM debit memos are identified by a
                       preceding "RM-" followed by this
                       ascending seven digit number.

ACO-LAST-CONV-BTCH     Numeric 3                                 AR503
Last Converted         The last payment batch number the
Batch Number           system assigned to converted payments.
                       The last 999 batch numbers (999000 -
                       999999) are reserved for this purpose.
                       The system will not allow users to use
                       batch numbers greater that 999000.

ACO-RISK-CD            Alpha 1                                   AR01.1
Element: Risk Code     The default risk code that will be
                       assigned to all new customers being
                       added for this company.

ACO-OFFSET-FL          Alpha 1                                   AR01.1
Automatic              Specifies if application will occur for
Application            cross referenced debits from a credit
                       memo. Valid values are:

                       N = No automatic memo application
                       Y = Automatic memo application allowed

ACO-AR-CODE            Alpha 4                                   AR01.1
Element: AR Code       The default accounts receivable code
                       for the company level.

ACO-NOT-APPLD-CD       Alpha 4                                   AR01.1
Received Not           The default received not applied code
Applied Code           at the company level.

ACO-PRE-PAY-CODE       Alpha 4                                   AR01.1
Element: Prepayment CodPrepayment code. This is the default
                       code to be used for a check entered as a
                       prepayment. This will be the offset
                       instead of RNA to cash.

ACO-CUST-RETEN         Numeric 3                                 AR01.1
Last Customer          The number of months that must elapse,
Activity               after the last customer activity date,
                       before a customer can be automatically
                       deleted.

ACO-AGE-CREDITS        Alpha 1                                   AR01.1
Element: Age Credits   Specifies how credit memos should be
                       aged. Valid values are:

                       L = Aged to last debit-containing
                       column N = Not aged - aged in current
                       column
                       R = Aged respective to credit memo date

ACO-AGE-PYMNT          Alpha 1                                   AR01.1
Element: Age Payment   Specifies how payments should be aged.
                       Valid values are:

                       L = Aged to last debit-containing column

                       N = Not aged - aged in current column
                       R = Aged respective to payment date



ACO-AGE-DISPUTES       Alpha 1                                   AR01.1
Element: Age Disputes  Specifies how disputed transactions
                       will be aged. Valid values are:

                       N = Not aged - aged in current column
                       Y = Aged respective to transaction date

ACO-AGE-TYPE           Alpha 1                                   AR01.1
Element: Age Type      Default aging method respecting either
                       invoice date or due date. Valid values
                       are:

                       D = Age by due date
                       T = Age by transaction date

ACO-AGE-CURRENT        Numeric 3                                 AR01.1
Element: Age Current   This field will be used to define the
                       transactions going into the "current"
                       and "future" aging buckets. This
                       provides the ability to have two aging
                       columns (current and future) that
                       reflect transactions that are not past
                       invoice (for an invoice date based
                       aging) or not past due (for a due date
                       based aging).

ACO-AGE-PERIODS        Numeric 3 Occurs 4 Times                  AR01.1
Element: Age Periods   Aging periods established by entering
                       the last day of each period in these
                       fields. If left blank, these periods
                       will default from this company's
                       assigned customer group. Future and
                       current aging periods will be defined
                       with a separate field.

ACO-DISPUTES-FIN       Alpha 1                                   AR01.1
Element: Finance DisputSpecifies if disputed transactions are
                       exempt from being assessed finance
                       charges. Valid values are:

                       N = No finance charges on disputed
                       items
                       Y = Yes, subject to finance charges

ACO-OI-DISP-SEQ        Alpha 1                                   AR01.1
Element: Oi Disp Seq   Indicates the default display sequence
                       of the open items. Valid values are:
                       1 = Trans Type Number
                       2 = Due Date
                       3 = Open Amount
                       4 = Process Level
                       5 = Trans User 1
                       6 = Activity
                       7 = Customer PO

ACO-AUDIT-APP-FL       Alpha 1                                   AR01.1
Cash Application       Indicates if the operator code field is
Operator Code          required during the entry of cash and
                       during the application of cash. Valid
                       values are:

                       N = No - operator code not required
                       Y = Yes - operator code required

ACO-AUDIT-MEMO-FL      Alpha 1                                   AR01.1
Memo/Invoice           Indicates if operator code is required
Operator Code          during the entry of debit/credit memos
                       or the entry of invoices. Valid values
                       are:

                       N = No - operator code not required
                       Y = Yes - operator code required

ACO-APP-REVIEW-FL      Alpha 1                                   AR01.1
Element: Application ReIndicates if applications are required
                       to go through an audit listing prior to
                       applications being posted to the general
                       ledger. Valid values are:

                       N = No
                       Y = Yes

ACO-DISC-GRACE-PD      Numeric 2                                 AR01.1
Discount Grade         Number of grace days added to discount
Period                 date to allow automatic discount during
                       cash application.

ACO-LATE-PAY-FL        Alpha 1                                   AR01.1
Late Payment &         Indicates what type of charges will be
Finance Charges        assessed. This option can be overridden
                       at the default codes and customer
                       levels. Valid values are:

                       Blank = No charges
                       F = Finance charges assessed
                       L = Late payments charges assessed
                       B = Both finance and late payment
                       charges will be assessed

ACO-FIN-CALC-TYPE      Alpha 1                                   AR01.1
Finance Charge         Determines how finance charges will be
Calculation            calculated. Depending upon this
                       calculation type, finance charges will
                       either be assessed individually for each
                       overdue open item (Detail option) or one
                       summary charge for the net amount of
                       overdue open items (Net option). Valid
                       values are:

                       D = Detail calculation
                       N = Net calculation

ACO-FIN-AUTO-NBR       Numeric 7                                 AR01.1  AR137
Last Finance Charge    This field will hold the last finance
Number                 charge number used by the system. It
                       will contain an ascending seven digit
                       number. The finance charge debit memo
                       number will be prefixed with "FC-".

ACO-FIN-CHRG-CD        Alpha 2                                   AR01.1
Element: Finance ChargeFinance charge code. This code must be
                       predefined and will contain a monthly
                       finance charge percentage rates.

ACO-FIN-GRAC-DAYS      Numeric 2                                 AR01.1
Finance Charge         The number of grace days added to a
Grace Days             transaction's due date before finance
                       charges will be assessed.

ACO-FIN-MIN-CHRG       Signed 7.2                                AR01.1
Minimum Finance        Override minimum finance charge amount
Charge                 assessed if calculated finance charge is
                       less than this minimum amount. If a
                       minimum is zero, no override will occur.


ACO-FIN-DOC-PRNT       Alpha 1                                   AR01.1
Element: Fin Doc Prnt  This option will specify whether or not
                       finance charge documents are required to
                       be printed. Valid values are:

                       N = No finance charge documents printed
                       Y = Yes, print finance charge documents

ACO-FIN-GL-CODE        Alpha 4                                   AR01.1
Element: Finance GL CodThis is the default GL code to be used
                       for finance charges at the company
                       level. It is tied to the finance charge
                       general ledger account.

ACO-CURRENCY-CD        Alpha 5                                   AR01.1
Element: Currency Code The base currency defined for the
                       company in the Lawson General Ledger
                       system. Used by the accounts receivable
                       company for processing and reporting.
                       Transactions entered in a non-base
                       currency retain their original,
                       transaction amounts and are converted to
                       the company base currency.

ACO-MULTI-CURR-FL      Alpha 1                                   AR01.1
Element: Multi CurrencyDetermines if transactions in
                       currencies differing from company base
                       currency will be allowed.
                       N = Not Multi Currency
                       Y = Multi Currency

ACO-RATE-OVR-FL        Alpha 1                                   AR01.1
Conversion Rate        Determines whether or not user will be
Override               able to override conversion rate
                       tolerances when adding non company-based
                       currency transactions. Valid values are:


                       N = No
                       Y = Yes

ACO-INV-CUR-OVR        Alpha 1                                   AR01.1
Invoice Currency       Indicates whether users will be able to
Override               override the default customer invoice
                       currency code when entering manual
                       invoices.
                       N = No
                       Y = Yes

ACO-VERIFY-GLDATE      Alpha 1                                   AR01.1
Element: Verify GL DateEstablishes whether the system should
                       edit transaction's GL date against the
                       GL date range set up in IF01 (System
                       Control). Valid values are:

                       N = No - do not general date editing
                       Y = Yes - edit general ledger date

ACO-DFLT-APP-DATE      Alpha 1                                   AR01.1
Default Application    Defines what default general ledger
Date                   date the application records should
                       have. Valid values are:

                       P = Payment general ledger date
                       S = System date

ACO-HOLD-CODE          Alpha 4                                   AR01.1
Element: Hold Code     The Hold Code found on the company
                       record is the default Hold Code to be
                       used by AR70.2 (Analyst Review Detail).
                       This code is available to be used by
                       order processing systems to help make a
                       decision on whether or not to process a
                       particular customer's orders.

ACO-OVER-APP-FL        Alpha 1                                   AR01.1
Over Application       Determines whether users should be able
Flag                   to over apply a short payment to fully
                       exhaust an invoice and create a
                       chargeback for the remaining portion of
                       the invoice. Valid values are:

                       N = No, over-application not allowed
                       Y = Yes, over-application allowed

ACO-DISC-DSP-FL        Alpha 1                                   AR01.1
Discount Display       Determines if past-due discount amounts
Flag                   will display during cash application.
                       Valid values are:

                       N = No past due discount amounts
                       displayed
                       Y = Display past due discounts

ACO-UPD-DUE-DATE       Alpha 1                                   AR01.1
Update Trans Date /    Determines if transactions will be
Due Date               allowed to have their transaction or due
                       date changed. This affects AR42.6
                       (Obligations), AR45.1 (Disputes), and
                       DT42.1 (Bill of Exchange Maintenance).
                       Valid values are:

                       N = No, due date change not allowed
                       Y = Yes, due date change allowed

ACO-INCOMPLETE-FL      Alpha 1                                   AR01.1
Element: Incomplete ComIndicates that the AR company is only
                       partially set up.

ACO-BASE-ND            Numeric 1                                 AR01.1
Base Number of         The number of decimal positions defined
Decimals               for the company base currency.

ACO-DISPLAY-DATE       Alpha 1                                   AR01.1
Element: Display Date  Display date. This field will control
                       the open obligation data displayed on
                       the aging reports. It will work
                       independently from the date used for
                       aging. The transaction date will be the
                       default with an option to display the
                       due date. Payments and credits will
                       always use GL date. Valid values are:

                       T = Transaction date
                       D = Due date (obligations only)

ACO-TRANS-SEQUENCE     Alpha 1                                   AR01.1
Element: Transaction SeTransaction sequence. This field will
                       control the display sequence of the
                       transactions in aging reports. This is
                       within the runtime indicated report
                       sequence. The due date option will use
                       due dates from open obligation and GL
                       dates from payments and credits. Valid
                       values are:

                       T = Transaction sequence
                       D = Due date sequence

ACO-BANK-RISK-OPT      Alpha 1                                   AR01.1
Element: Bank Risk OptiBank risk option. This field will be
                       used if the company is using bill of
                       exchange processing. If so, this option
                       will indicate if bank risk processing
                       should be done. Valid values are:

                       N = No; don't check bank risk
                       Y = Yes; check bank risk

ACO-ACCEPT-ACCTING     Alpha 1                                   AR01.1
Acceptance             Acceptance accounting. This option is
Accounting             only used if the company is doing bill
                       of exchange processing. If so, the
                       options are to post to bill of exchange
                       receivable upon acceptance or to level
                       the value in accounts receivable. Valid
                       values are:

                       Y = Yes; GL required at acceptance
                       N = No; GL not required at acceptance

ACO-DT-ACCPT-CODE      Alpha 4                                   AR01.1
Element: BOE AcceptanceBill of exchange acceptance code. This
                       option is only used if the company is
                       processing bills of exchange. If so,
                       this code will be required if the accept
                       accounting option is equal to yes. It
                       represents the BOE receivable account.
                       This will edit to the GL Codes file in
                       AR.

ACO-FIN-REV-CODE       Alpha 4                                   AR01.1
Financial Revenue      Financial revenue code. This will be
Code                   used if the company is processing bills
                       of exchange. If so, this code will edit
                       to the AR Codes file and will be used to
                       post financial revenue.

ACO-FIN-EXP-CODE       Alpha 4                                   AR01.1
Financial Expense      Financial expense code. This code will
Code                   be used if the company is processing
                       bills of exchange. If so, the code will
                       edit to the AR GL Code file and be used
                       to post the financial expenses to GL.

ACO-DIS-EXP-CODE       Alpha 4                                   AR01.1
Dishonored Expense     Dishonored expense code. This code will
Code                   be used if the company is processing
                       bills of exchange. If so, the code will
                       be used to post to GL any dishonored
                       bill of exchange expenses.

ACO-LAST-DRAFT-NBR     Numeric 10                                AR01.1  AR42.1
Last Bill of           Last bill of exchange number assigned.    AR42.2  AR42.6
Exchange Number        This will be used only if the company     AR42.7  AR43.1
                       will be  processing bills of exchange.    AR44.3  AR502
                       If so, it will contain the last bill of   AR560   ARLL.1
                       exchange number assigned for this         DT150   DT40.1
                       company if bill of exchange numbers are   DT520   DT92.1
                       to be automatically assigned.

ACO-REMIT-NUMBER       Numeric 7                                 AR01.1  DT160
Element: Remittance NumRemittance number. This will be used if   DT161   DT165
                       the company is processing bills of        DT166   DT180
                       exchange. If so, this will contain the    DT60.1  DT60.2
                       last remittance number assigned for the   DT70.1  DT70.3
                       company.                                  DT80.1

ACO-REASSIGN-NBR       Numeric 7                                 AR01.1  AR44.3
Element: Reassignment NReassignment number. Contains the last
                       DB number used in the reassignment of
                       open obligations. It will have a prefix
                       of "GP-".

ACO-DRAFT-NBR-OPT      Alpha 1                                   AR01.1
Bill of Exchange       Indicates the type of bill of exchange
Numbering              numbering that will be used for the
                       company. Valid values are:

                       A = Automatic BOE numbering
                       M = Manual BOE numbering

ACO-DEP-INST-CODE      Alpha 3                                   AR01.1
Element: Deposit Code  Default deposit bank code. Must be a
                       valid bank service transaction code in
                       the Lawson Cash Ledger system.

ACO-RTM-INST-CODE      Alpha 3                                   AR01.1
Element: RTM Payment CoDefault return-to-maker payment code.
                       Must be a valid bank service transaction
                       code in the Lawson Cash Ledger system.

ACO-ADJ-INST-CODE      Alpha 3                                   AR01.1
Additional Bank        Default additional bank charges code.
Charges                Must be a valid bank service transaction
                       code in the Lawson Cash Ledger system.

ACO-EFT-INST-CODE      Alpha 3                                   AR01.1
Element: Deposit PaymenThe EFT deposit payment code.

ACO-EFTPAY-INST-CD     Alpha 3                                   AR01.1
Element: Credit PaymentThe EFT credit payment code.

ACO-DSC-REMIT-INST     Alpha 3                                   AR01.1
Discounted             Default payment code when a discounted
Remittance             remittance is cashed. Must be a valid
                       bank service transaction code in the
                       Lawson Cash Ledger system.

ACO-DTL-PAYMENT        Alpha 1                                   AR01.1
Element: Payment GL IntDetail payment accrual general ledger
                       interface record option. Valid values
                       are:

                       N = No; detail payment general ledger
                       interface records not created. Default.
                       Y = Yes; create detail payment general
                       ledger interface records.

ACO-DTL-APPL           Alpha 1                                   AR01.1
Application GL         Detail application accrual general
Interface              ledger interface record option. Valid
                       values are:

                       N = No; detail application accrual
                       general ledger interface records not
                       created. Default.
                       Y = Yes; create detail application
                       accrual general ledger interface
                       records.

ACO-DTL-FIN-CHRG       Alpha 1                                   AR01.1
Finance Charge GL      Detail finance charge accrual general
Interface              ledger interface record option. Valid
                       values are:

                       N = No; detail finance charge accrual
                       general ledger interface records not
                       created. Default.
                       Y = Yes; create detail finance charge
                       accrual general ledger interface
                       records.

ACO-MINIMUM            Alpha 1                                   AR01.1
Minimum Finance        Determines if a minimum finance charge
Charge                 will be assessed. Valid values are


                       Y = Use minimum amount
                       N = Minimum amount not used

ACO-FIN-CYCLE          Alpha 2                                   AR01.1
Finance Charge         Finance charge cycle code.
Cycle Code

ACO-HIST-PER           Numeric 2                                 AR01.1
Element: History PeriodThe number of periods (as defined by the
                       run requency of AR198 Transaction Status
                       Update) before the status of a fully
                       applied payment or transaction is
                       updated.

                       This has two results:

                       1. This value is the number of periods
                       until the status of a payment or
                       transaction will be updated from Fully
                       Applied to Closed.

                       2. This value is also the number of
                       periods until the status of a payment or
                       transaction will be updated from Closed
                       to Historical.

                       Therefore, a payment or transaction is
                       elgible for "as of reporting" for the
                       number of periods equal to two times the
                       value of this field.
                       01
                       12

ACO-CASH-CODE          Alpha 4                                   AR01.1
Element: Cash Code     A cash code represents a bank account.
                       More than one company can use the same
                       cash code.  The cash code must be linked
                       to a bank in the Lawson Cash Ledger
                       system.


ACO-CR-CASH-CODE       Alpha 4                                   AR01.1
Element: Credit Cash CoThe credit cash code. Must be a valid
                       cash code in the Lawson Cash Ledger
                       system.

ACO-ACH-COMP-ID        Alpha 10                                  AR01.1
Element: EFT Company IDEFT company ID number. Used for ACH
                       processing to identify the entity that
                       is sending or receiving funds.

ACO-LAST-EFT-NBR       Numeric 7                                 AR01.1  AR115
Last EFT Debit Memo    Last EFT debit memo number. Used for
Number                 cash application purposes for credit
                       balance processing. As funds are
                       withdrawn or sent to a customer for a
                       credit balance, a zero check is created
                       with a corresponding debit memo for the
                       funds amount. This is used for
                       accounting purposes, and as a balancing
                       record to complete the cash
                       application/removal process of a credit
                       balance.

ACO-CURR-DISPLAY       Alpha 1                                   AR01.1
Element: Currency DisplYou can choose to display transaction
                       amounts throughout the system in base
                       currency or transaction currency.

                       Valid values are:

                       B = Base currency
                       T = Transaction currency

ACO-EDIT-REMIT         Alpha 1                                   AR01.1
Element: Edit RemittancDetermines if payment remittance will be
                       edited against existing transactions.
                       N = No
                       Y = Yes

ACO-SUM-LINE           Alpha 1                                   AR01.1
Element: Summary Line  Determines whether to display multi line
                       open items in detail or summary.
                       N = No
                       Y = Yes

ACO-THIRD-PARTY        Alpha 1                                   AR01.1
Element: Third Party   This field indicates if this customer's
                       payments may be applied to any
                       customer's open transactions.
                       N = No third party payment
                       Y = Third party payment allowed

ACO-INT-BY-DATE-FL     Alpha 1                                   AR01.1
Element: Int By Date FlIndicates if finance charegs will be
                       assessed by potentailly multiple finance
                       charge rates, over a period of time, for
                       a past due or paid late transaction.

ACO-DUN-CYCLE-ID       Numeric 6                                 AR01.1  AR140
Element: Dun Cycle Id  Last Dunning Letter Cycle ID.  Gets
                       incremented by 1 when you run AR140
                       (Dunning Letter Selection).  You can
                       view the last dunning cycle ID on AR01.1
                       (Company).

ACO-DUN-CYCLE-STAT     Alpha 1                                   AR140   AR141
Element: Dun Cycle StatThe dunning cycle status.  Values are:    AR145
                       1 = Selected (after running AR140)
                       2 = Printed (after running AR141)
                       3 = Dunning History Produced
                       4 = Cycle complete (after running AR145)

ACO-OB-DRF-FL          Alpha 1                                   AR01.1
Element: Ob Drf Fl     This field specifies whether to include
                       or exclude BOE item balances.  "Y" means
                       to include BOE items in balances.  "N"
                       means to exclude BOE items from
                       balances.
                       Y = Include BOE items
                       N = Do not include BOE items

ACO-REMIT-CNTL         Alpha 1                                   AR01.1
Element: Remit Cntl    Y = Process Draft on Remittance
                       N = Do Not process Draft on remitt

ACO-DISC-TAX-RCV       Alpha 1                                   AR01.1
Element: All Flag      Determines if a prorated amount of tax
                       will be recognized from cash
                       application discounting on transactions
                       that have tax-based distribution
                       records.  Valid values are:

                       N = No
                       Y = Yes

ACO-COUNTRY-CODE       Alpha 2                                   AR01.1
Element: Country Code  The country code representing the
                       country of the company.
                       Y = Yes recover tax on discount
                       N = Do not recover tax on discount

ACO-REGION             Alpha 2                                   AR01.1
Element: Region        The region code, if applicable for the
                       country. Used by Intrastat. Must be
                       defined in IN02.1 (Region Maintenance)

ACO-LATE-CH-RND-FL     Alpha 1                                   AR01.1
Element: Late Ch Rnd FlInterest by date charges rounding
                       preference.  If set to "Y", any
                       resulting interest charge invoices will
                       be rounded to the nearest currency unit.


ACO-VEN-CLASS          Alpha 3                                   AR01.1
Element: Ven Class     A user-defined code representing a
                       subset of vendors within a vendor group.
                       Used in AR48 AR to AP Interface.

ACO-VEND-AR-TO-AP      Alpha 1                                   AR01.1
Element: Vend Ar To Ap Controls if the interface between AR
                       and AP is allowed, as well as the
                       automatic vendor creation aspect of this
                       interface.
                       Y = Allow Vendor creation AR to AP
                       N = No Vendor creation AR to AP

ACO-EFT-PROCESS        Alpha 1                                   AR01.1
Element: Eft Process   Indicates whether this company will
                       process EFt tranascations.  Valid values
                       are:

                       N = No EFT processing
                       Y = EFT processing

ACO-CALENDAR           Alpha 15                                  AR01.1
Element: Calendar      The calendar used for EFT processing.
                       The calendar must be defined in the
                       Universe calendar definition program.

ACO-DUE-DAYS           Numeric 3                                 AR01.1
Element: Due Days      The number of days used to calculate
                       the ending due date range in EFT
                       processing.

ACO-DUE-TYPE           Alpha 1                                   AR01.1
Element: Due Type      The type of days used to calulate the
                       ending due date range. Valid values are.

                       A= Actual Days
                       M= Marked Days
                       A = Actual Days
                       M = Marked Days

ACO-GL-DAYS            Numeric 3                                 AR01.1
Element: Gl Days       The number of days used to calculate
                       the ending GL date range.

ACO-GL-TYPE            Alpha 1                                   AR01.1
Element: Gl Type       The type of days used to calculate the
                       ending GL date range.  Valid values are:

                       A = Actual Days
                       M = Marked Days

ACO-DEPOSIT-DAYS       Numeric 3                                 AR01.1
Element: Deposit Days  The number of days used to calculate
                       the end deposit days date range.

ACO-DEPOSIT-TYPE       Alpha 1                                   AR01.1
Element: Deposit Type  The type of days used to calculate the
                       ending deposit days date reange.  Valid
                       values are:

                       A = Actual Days
                       M = Marked Days

ACO-CUST-AUDIT         Alpha 1                                   AR01.1
Element: Cust Audit    Indicates whether customer changes will
                       be tracked at the company level.
                       Valid values are:

                       N = No changes audited
                       Y = Changes audited

ACO-NA-TRAN-FL         Alpha 1                                   AR01.1
Element: Flag          Indicates whether national account
                       transaction records will be created or
                       deleted in AR12 National Account, or in
                       AR112 National Account Transaction
                       Update. If a company will have national
                       accounts with a very high number of open
                       transactions amongst a national account
                       relationship, for performance
                       considerations, it is recommended that
                       this option =  "Y".  Valid values are:

                       N = AR12 will maintain transactions
                       Y = AR112 will maintain transactions

ACO-PROCURE-GROUP      Alpha 4                                   AR01.1
Element: Procure Group This field contains the identifier for a
                       group of companies that share a common
                       procurement effort. They buy items and
                       services together.

ACO-CREDIT-CB-PRFX     Alpha 2                                   AR01.1
Element: Credit Cb Prfx

ACO-CREDIT-CB-NBR      Numeric 7                                 AR01.1  AR190
Element: Credit Cb Nbr

ACO-INTRF-DST-CREA     Alpha 1                                   AR01.1
Element: Flag          Indicates whether interface transactions
                       will have a historical AR Code based
                       distribution record created, used for
                       reporting purposes in AR197 Self
                       Balancing Report.
                       " " = Space
                       N = No
                       Y = Yes

ACO-INTRF-DST-SUM      Alpha 1                                   AR01.1
Element: Flag          Indicates whether interface transactions
                       will create historical AR Code based
                       distribution records in detail or in
                       summary.
                       " " = Space
                       N = No
                       Y = Yes

                         ARCOMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACOSET1   COMPANY                                                AC56.1  AC560
                                                                 AP125   AP126
                                                                 AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  AR01.1
                                                                 AR02.1  AR03.1
                                                                 AR03.2  AR04.1
                                                                 AR06.1  AR06.2
                                                                 AR06.3  AR06.4
                                                                 AR08.1  AR08.2
                                                                 ...

ACOSET2   CUST-GROUP                                             AR00.1  AR01.1
          COMPANY                                                AR09.1  AR100
                                                                 AR105   AR110
                                                                 AR115   AR130
                                                                 AR180   AR200
                                                                 AR232   AR235
                                                                 AR237   AR239
                                                                 AR25.1  AR250
                                                                 AR260   AR261
                                                                 AR292   AR30.1
                                                                 AR30.6  AR301
                                                                 AR32.1  AR33.1
                                                                 AR34.1  AR50.1
                                                                 AR505   AR80.1
                                                                 AR80.2  DT170
                                                                 ...

                         ARCOMP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcustgrp      ARCUSTGRP    Required

                            ACO-CUST-GROUP    -> ACG-CUST-GROUP

                         ARCOMP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Agingcode      AGINGCODE

                            ACO-COMPANY       -> AGE-COMPANY
                                                 AGE-AGING-CODE

Arcategory     ARCATEGORY

                            ACO-COMPANY       -> ACA-COMPANY
                                                 ACA-AR-CATEGORY

Archgbaktx     ARCHGBAKTX   Delete Restricted

                            ACO-COMPANY       -> AKT-COMPANY
                                                 AKT-TEXT-CODE
                                                 AKT-LANGUAGE-CODE

Arcode         ARCODE       Delete Cascades

                            ACO-COMPANY       -> RCD-COMPANY
                                                 RCD-AR-CODE

Arcustomers    ARCUSTOMER   Delete Restricted

                            ACO-COMPANY       -> ACM-COMPANY
                                                 ACM-CUSTOMER

Aroitems       AROITEMS     Delete Restricted

                            ACO-COMPANY       -> ARO-COMPANY
                                                 ARO-TRANS-TYPE
                                                 ARO-INVOICE
                                                 ARO-PAYMENT-SEQ

Arpaynottx     ARPAYNOTTX   Delete Restricted

                            ACO-COMPANY       -> ANT-COMPANY
                                                 ANT-TEXT-CODE
                                                 ANT-LANGUAGE-CODE

Arproclevels   ARPROCLEVL   Delete Restricted

                            ACO-COMPANY       -> APV-COMPANY
                                                 APV-PROCESS-LEVEL

Arpymntheaders ARPYMNTHDR   Delete Restricted

                            ACO-COMPANY       -> APH-COMPANY
                                                 APH-BATCH-NBR

Arreasons      ARREASON     Delete Cascades

                            ACO-COMPANY       -> ARR-COMPANY
                                                 ARR-TYPE
                                                 ARR-REASON-CODE

Arrtmtx        ARRTMTX      Delete Restricted

                            ACO-COMPANY       -> RTX-COMPANY
                                                 RTX-TEXT-CODE
                                                 RTX-LANGUAGE-CODE

Arstmprttx     ARSTMPRTTX   Delete Restricted

                            ACO-COMPANY       -> ASX-COMPANY
                                                 ASX-TEXT-CODE
                                                 ASX-LANGUAGE-CODE

Arsummary      ARSUMMARY    Delete Cascades

                            ACO-COMPANY       -> ARS-COMPANY
                                                 ARS-TYPE
                                                 ARS-PROCESS-LEVEL

Cranalyst      CRANALYST    Delete Restricted

                            ACO-COMPANY       -> CAN-COMPANY
                                                 CAN-CREDIT-ANLYST

Cust Defaults  CUSTDEFLTS   Delete Cascades

                            ACO-COMPANY       -> CDF-COMPANY
                                                 CDF-DEFAULT-CODE

Salesrep       SALESREP     Delete Cascades

                            ACO-COMPANY       -> SAW-COMPANY
                                                 SAW-SALESMAN

Staticcust     STATICCUST

                            ACO-COMPANY       -> STA-COMPANY
                                                 STA-CUSTOMER

Territory      TERITORY     Delete Cascades

                            ACO-COMPANY       -> TRY-COMPANY
                                                 TRY-TERRITORY