|
|
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
|
