ARREASON – Accounts Receivable Reason Cd

System
Accounts Receivable (AR)
Prefix
ARR
Primary key
COMPANY, TYPE, REASON-CODE
Fields
26
Updated by
14 programs
Referenced by
4 programs

ARREASON is the Accounts Receivable Reason Cd table in Lawson Accounts Receivable (prefix ARR). It is indexed by COMPANY, TYPE, REASON-CODE (ARRSET1). It is related 1:1 to ARCOMP. It is updated by AR01.1, AR08.1, AR10.1, AR15.1, AR15.3, BR120, BR121, BR140 and 6 more and referenced by AR215, AR501, AR550 and ARLL.1. The table has 26 fields, 1 index and 1 documented relation.

About ARREASON

The AR Reason Codes file contains all of the adjustment, memo, and grouping 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 code and description fields are required. For grouping reason codes, which are used in AR44 Transaction Obligation Grouping, only the code and description fields are required.

Fields (26)

Column = COBOL field name without the ARR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ARR-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR01.1, AR15.1, AR15.3
ARR-TYPE PK
TYPE		Alpha 2This field will indicates the type of reason code. Valid values are:
  • AD Adjustment - Cash application
  • ME Memo entry
AR01.1, AR15.1, AR15.3
ARR-REASON-CODE PK
REASON_CODE		Alpha 4Reason Code. User defined and used for tracking adjustment and memo transactions.AR01.1, AR15.1, AR15.3
ARR-REASON-TYPE
REASON_TYPE		Alpha 2Adjustment Reason Type. This field indicates how the corresponding adjustment reason code will be classified. Valid values are:
  • CB Chargeback
  • DS Discount
  • OS Over/Short
  • GP Grouping
  • TR Payment transfer
AR01.1, AR15.1
ARR-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1This field will indicate if the Reason Code may be used for entry. Valid values are:
  • A Active
  • I Inactive
AR15.1, AR15.3
ARR-CB-TYPE
CB_TYPE		Alpha 1Indicates 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
AR15.1
ARR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the reason code.AR01.1, AR15.1, AR15.3
ARR-ACCT-UNIT
ACCT_UNIT		Alpha 15Accounting unit used as the AR or RNA offset account when making an adjustment or chargeback adjustment.AR15.1
ARR-ACCOUNT
ACCOUNT		Numeric 6Account number used as the AR or RNA offset account when making an adjustment or chargeback adjustment.AR15.1
ARR-SUB-ACCOUNT
SUB_ACCOUNT		Numeric 4Subaccount number used as the AR or RNA offset account when making adjustments or chargeback adjustments.AR15.1
ARR-CB-ACCT-UNIT
CB_ACCT_UNIT		Alpha 15This will contain the Chargeback contra accounting unit. It will be required if the Reason Type is = CB.AR15.1
ARR-CB-ACCOUNT
CB_ACCOUNT		Numeric 6This is the chargeback contra account. It will be required if the Reason Type
  • is CB.
AR15.1
ARR-CB-SUB-ACCT
CB_SUB_ACCT		Numeric 4This is the chargeback contra subaccount.AR15.1
ARR-APP-LIMIT
APP_LIMIT		Signed 18.2This field will contain the largest adjustment amount that is allowed before a review condition is required.AR15.1
ARR-APP-PERCENT
APP_PERCENT		Percent 5.2 (Percent)This field will contain the largest adjustment percentage of an open item that is allowed before a review condition is required.AR15.1
ARR-REVIEW-FL
REVIEW_FL		Alpha 1This 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
AR15.1
ARR-USED-FL
USED_FL		Alpha 1Used indicator. This field will be set to a value of "Y" when this reason code is used in the creation of an adjustment record, or memo header. Valid values are:
  • N No
  • Y Yes
AR01.1, AR08.1, AR10.1
ARR-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12Contains the journal book number for the reason code.—
ARR-ACCT-UNIT-FLAG
ACCT_UNIT_FLAG		Alpha 1Will determine if the account unit of the reason code can be overridden during processing.
  • N Acct Unit Can Be Overridden
  • Y Acct Unit Can't Be Overridden
AR15.1
ARR-ACTIVITY
ACTIVITY		Alpha 15The Activity value asociated with this reason code. Only valid on adjustment type reason codes.AR15.1
ARR-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5The Account Category associated with the Activity value.AR15.1
ARR-ACCR-ACCT-UNIT
ACCR_ACCT_UNIT		Alpha 15The 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.AR15.1
ARR-ACCR-ACCOUNT
ACCR_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AR15.1
ARR-ACCR-SUB-ACCT
ACCR_SUB_ACCT		Numeric 4This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AR15.1
ARR-DISPUTE-CD
DISPUTE_CD		Alpha 2—AR15.1
ARR-CB-DISPUTE-CD
CB_DISPUTE_CD		Alpha 2—AR15.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ARRSET1COMPANY, TYPE, REASON-CODEPrimaryAR01.1, AR08.1, AR10.1, AR15.1, AR15.2, AR15.3, AR215, AR501 +11 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredARR-COMPANY → ACO-COMPANY

Programs

Updated by (14)

Referenced by (4)