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 DT170 DT180 DT181 DT185
UPDATED BY
AR01.1 AR08.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
Company Company number. AR15.3
ARR-TYPE Alpha 2 AR01.1 AR15.1
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
Reason Code Reason Code. User defined and used for AR15.3
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
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
Chargeback Type Indicates 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
Description The description of the reason code. AR15.3
ARR-ACCT-UNIT Alpha 15 AR15.1
Accounting Unit Accounting unit used as the AR or RNA
offset account when making an adjustment
or chargeback adjustment.
ARR-ACCOUNT Numeric 6 AR15.1
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
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
Chargeback Account This 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
Adjustment Limit This 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
Adjustment Percent This 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
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
Used Used indicator. This field will be set AR129 AR130
to a value of "Y" when this reason code AR131 AR135
is used in the creation of an adjustment AR30.1 AR30.2
record, or memo header. Valid values AR30.3 AR30.4
are: AR30.8 AR31.6
AR35.1 AR35.2
N = No AR44.3 AR48.3
Y = Yes
ARR-JRNL-BOOK-NBR Alpha 12
Journal Book Number Contains the journal book number for
the reason code.
ARR-ACCT-UNIT-FLAG Alpha 1 AR15.1
Acct Unit 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
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
Account Category Account 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. AR115 AR129
REASON-CODE 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 AR31.6
...
ARREASON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARR-COMPANY -> ACO-COMPANY
|
