Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARREASON


                             ARREASON FILE

                            AR Reason Codes

The AR Reason Codes file contains all of the adjustment and memo reason codes
that may be used in the Accounts Receivable system. The adjustment reason
codes will be used when discounts, write-offs or chargebacks are created while
applying cash/credit memos to open items. Memo reason codes are required when
manually entering a batch of debit/credit memos. For memo reason codes, only
the type, code and description fields are allowed.

REFERENCED BY

AR115     AR132     AR190     AR191     AR215     AR230
AR232     AR233     AR234     AR235     AR36.1    AR37.3
AR37.5    AR37.7    AR37.9    AR42.2    AR42.6    AR42.7
AR501     AR504     AR550     DT170     DT180     DT181
DT185

UPDATED BY

AR01.1    AR08.1    AR10.1    AR129     AR130     AR131
AR135     AR15.1    AR15.3    AR30.1    AR30.2    AR30.3
AR30.4    AR30.8    AR31.6    AR35.1    AR35.2    AR44.3
AR48.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARR-COMPANY            Numeric 4                                 AR01.1  AR15.1
Element: Company       Company number.                           AR15.3

ARR-TYPE               Alpha 2                                   AR01.1  AR15.1
Element: Type          This field will indicates the type of     AR15.3
                       reason code. Valid values are:

                       AD = Adjustment - Cash application
                       ME = Memo entry

ARR-REASON-CODE        Alpha 4                                   AR01.1  AR15.1
Accounts Receivable    Reason Code. User defined and used for    AR15.3
Code                   tracking adjustment and memo
                       transactions.

ARR-REASON-TYPE        Alpha 2                                   AR01.1  AR15.1
Adjustment Reason      Adjustment Reason Type. This field
Type                   indicates how the corresponding
                       adjustment reason code will be
                       classified. Valid values are:

                       CB = Chargeback
                       DS = Discount
                       OS = Over/Short
                       GP = Grouping

ARR-ACTIVE-STATUS      Alpha 1                                   AR15.1  AR15.3
Element: Status        This field will indicate if the Reason
                       Code may be used for entry. Valid values
                       are:

                       A = Active
                       I = Inactive

ARR-CB-TYPE            Alpha 1                                   AR15.1
Element: Chargeback TypIndicates the type of chargeback a
                       particular reason code represents. Valid
                       values are:

                       D = Detail chargeback
                       S = Summary chargeback
                       M = Memo chargeback
                       Blank = Not a chargeback adjustment

ARR-DESCRIPTION        Alpha 30  (Lower Case)                    AR01.1  AR15.1
Element: Description   The description of the reason code.       AR15.3

ARR-ACCT-UNIT          Alpha 15                                  AR15.1
Element: Accounting UniAccounting unit used as the AR or RNA
                       offset account when making an adjustment
                       or chargeback adjustment.

ARR-ACCOUNT            Numeric 6                                 AR15.1
Element: Account       Account number used as the AR or RNA
                       offset account when making an adjustment
                       or chargeback adjustment.

ARR-SUB-ACCOUNT        Numeric 4                                 AR15.1
Element: Subaccount    Subaccount number used as the AR or RNA
                       offset account when making adjustments
                       or chargeback adjustments.

ARR-CB-ACCT-UNIT       Alpha 15                                  AR15.1
Chargeback Account     This will contain the Chargeback contra
Unit                   accounting unit.  It will be required if
                       the Reason Type is = CB.

ARR-CB-ACCOUNT         Numeric 6                                 AR15.1
Element: Chargeback AccThis is the chargeback contra account.
                       It will be required if the Reason Type
                       is = CB.

ARR-CB-SUB-ACCT        Numeric 4                                 AR15.1
Chargeback             This is the chargeback contra
Subaccount             subaccount.

ARR-APP-LIMIT          Signed 13.2                               AR15.1
Element: Adjustment LimThis field will contain the largest
                       adjustment amount that is allowed before
                       a review condition is required.

ARR-APP-PERCENT        Percent 5.2  (Percent)                    AR15.1
Element: Adjustment PerThis field will contain the largest
                       adjustment percentage of an open item
                       that is allowed before a review
                       condition is required.

ARR-REVIEW-FL          Alpha 1                                   AR15.1
Element: Review Flag   This flag will prompt an adjustment
                       using this reason code to be displayed
                       on AR36 (Adjustments Exceeded Review).
                       Valid values are:

                       O = Optional discount review
                       N = No; conditional review required
                       Y = Yes; always reviewed

ARR-USED-FL            Alpha 1                                   AR01.1  AR08.1
Element: Used          Used indicator. This field will be set    AR10.1  AR129
                       to a value of "Y" when this reason code   AR130   AR131
                       is used in the creation of an adjustment  AR135   AR30.1
                       record, or memo header. Valid values      AR30.2  AR30.3
                       are:                                      AR30.4  AR30.8
                                                                 AR31.6  AR35.1
                       N = No                                    AR35.2  AR44.3
                       Y = Yes                                   AR48.3

ARR-JRNL-BOOK-NBR      Alpha 12
Element: Journal Book NContains the journal book number for
                       the reason code.

ARR-ACCT-UNIT-FLAG     Alpha 1                                   AR15.1
Element: All Flag      Will determine if the account unit if
                       the reason code can be overridden during
                       processing.
                       N = Acct Unit Can Be Overridden
                       Y = Acct Unit Can't Be Overridden

ARR-ACTIVITY           Alpha 15                                  AR15.1
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.


ARR-ACCT-CATEGORY      Alpha 5                                   AR15.1
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

                         ARREASON FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARRSET1   COMPANY       This path is used for record uniqueness  AR01.1  AR08.1
          TYPE          and selection.                           AR10.1  AR115
          REASON-CODE                                            AR129   AR130
                                                                 AR131   AR132
                                                                 AR135   AR15.1
                                                                 AR15.2  AR15.3
                                                                 AR190   AR191
                                                                 AR215   AR230
                                                                 AR232   AR233
                                                                 AR234   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.6  AR30.7
                                                                 AR30.8  AR30.9
                                                                 AR31.1  AR31.5
                                                                 ...

                         ARREASON FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            ARR-COMPANY    -> ACO-COMPANY