|
|
ARREASON FILE
AR Reason Codes
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.
REFERENCED BY
AR115 AR120 AR132 AR190 AR191 AR215
AR230 AR232 AR233 AR234 AR235 AR237
AR238 AR239 AR265 AR36.1 AR37.3 AR37.5
AR37.7 AR37.9 AR38.1 AR38.2 AR38.3 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.8 AR32.1
AR33.1 AR33.3 AR33.6 AR34.1 AR35.1 AR35.2
AR39.1 AR39.2 AR44.3 AR48.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ARR-COMPANY Numeric 4 AR01.1 AR15.1
Element: Company The number representing an AR company. 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
Element: 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
Element: Active 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: Acct Unit Accounting 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: Sub Acct 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 18.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 Fl 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.8 AR32.1
are: AR33.1 AR33.3
AR33.6 AR34.1
N = No AR35.1 AR35.2
Y = Yes AR39.1 AR39.2
AR44.3 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: Acct Unit FlagWill 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 The Activity value asociated with this
reason code. Only valid on adjustment
type reason codes.
ARR-ACCT-CATEGORY Alpha 5 AR15.1
Element: Acct Category The Account Category associated with
the Activity value.
ARR-ACCR-ACCT-UNIT Alpha 15 AR15.1
Element: Acct Unit The 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.
ARR-ACCR-ACCOUNT Numeric 6 AR15.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ARR-ACCR-SUB-ACCT Numeric 4 AR15.1
Element: Sub Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ARR-DISPUTE-CD Alpha 2 AR15.1
Element: Dispute Cd
ARR-CB-DISPUTE-CD Alpha 2 AR15.1
Element: Dispute Cd
ARREASON FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ARRSET1 COMPANY AR01.1 AR08.1
TYPE AR10.1 AR115
REASON-CODE AR120 AR129
AR130 AR131
AR132 AR135
AR15.1 AR15.2
AR15.3 AR190
AR191 AR215
AR230 AR232
AR233 AR234
AR235 AR237
AR238 AR239
AR265 AR30.1
AR30.2 AR30.3
AR30.6 AR30.7
...
ARREASON FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
ARR-COMPANY -> ACO-COMPANY
|
