|
|
ARREASON FILE
AR Reason Codes
AR Reason Codes
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 AR10.1 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 AR981
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 AR981
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 AR10.1 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
Y = Yes
ARR-JRNL-BOOK-NBR Alpha 12
Journal Book Number Contains the journal book number for
the reason code.
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 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
|