ARADJUST FILE
AR Application Adjustment
AR Application Adjustment
REFERENCED BY
AC115 AR132 AR161 AR190 AR194 AR196
AR230 AR232 AR233 AR235 AR250 AR251
AR252 AR253 AR255 AR256 AR282 AR286
AR287 AR42.2 AR42.7 AR53.1 AR560 AR80.1
AR80.2 AR82.1
UPDATED BY
AR130 AR131 AR135 AR150 AR180 AR191
AR20.1 AR21.1 AR21.2 AR21.3 AR30.1 AR30.2
AR30.3 AR30.4 AR30.8 AR300 AR31.5 AR31.6
AR35.1 AR35.2 AR36.1 AR36.2 AR37.1 AR37.2
AR37.3 AR37.4 AR37.5 AR37.6 AR37.7 AR44.3
AR504 AR700 AR972 AR980 CB06.2 DT45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ADJ-COMPANY Numeric 4 AR130 AR131
Company The company number represents an AR135 AR180
established company and is entered on AR30.1 AR30.2
all function codes. AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-TRANS-TYPE Alpha 1 AR130 AR131
Transaction Type This field will contain the type of AR135 AR180
transaction being adjusted. Valid AR30.1 AR30.2
values are: AR30.3 AR30.4
AR30.8 AR31.5
C = Credit memo AR31.6 AR35.1
D = Debit memo AR35.2 AR44.3
I = Invoice AR504 AR972
P = Payment DT45.1
ADJ-TRANS-NBR Alpha 10 (Right Justified) AR130 AR131
Transaction Number This field will contain the transaction AR135 AR180
number of the open item that is being AR30.1 AR30.2
adjusted. AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-PAYMENT-SEQ Numeric 6 AR130 AR131
Payment Sequence Payment Sequence. This is the generated AR135 AR180
sequence number to separate individual AR30.1 AR30.2
invoice payment requirements. AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-BATCH-NBR Numeric 6 AR130 AR131
Batch Number The batch that the entered invoices, AR135 AR180
debit memos, credit memos, or payments AR30.1 AR30.2
are a part of. AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
AR980
ADJ-APP-SEQ Numeric 5 AR130 AR131
Application Sequence This is the application sequence that AR135 AR180
the adjustment is being made against. AR30.1 AR30.2
Transaction Type, Number, and AR30.3 AR30.4
Application Sequence will point back to AR30.8 AR31.5
the application record that is being AR31.6 AR35.1
adjusted. AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-ADJ-SEQ Numeric 3 AR130 AR131
Adjustment Sequence This is the sequence number of AR135 AR180
adjustment for a given application. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-ADJ-AMT Signed 15.2 AR130 AR131
Adjustment Amount This is the amount of the adjustment. AR135 AR180
AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-REASON-CODE Alpha 4 AR130 AR131
Adjustment Reason The reason code assigned to the AR135 AR180
Code adjustment. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-REASON-TYPE Alpha 2 AR130 AR131
Adjustment Reason Indicates the type of adjustment reason AR135 AR180
Type code assigned to the adjustment. Valid AR30.1 AR30.2
values are: AR30.3 AR30.4
AR30.8 AR31.5
CB = Chargeback AR31.6 AR35.1
DS = Discount AR35.2 AR44.3
OS = Over/short AR504 AR972
GP = Grouping DT45.1
ADJ-DESC Alpha 30 (Lower Case) AR130 AR131
Description The description of the adjustment as AR135 AR180
defined for the adjustment reason code AR30.1 AR30.2
in AR15.1 (Adjustment Reasons), or keyed AR30.3 AR30.4
during cash application. AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-ACCT-UNIT Alpha 15 AR130 AR131
Accounting Unit The general ledger accounting unit of AR135 AR180
this transaction. This will default from AR30.1 AR30.2
the open item's process level's AR30.3 AR30.4
accounting unit or the accounting unit AR30.8 AR31.5
of the reason code item that this AR31.6 AR35.1
adjustment references. AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-ACCOUNT Numeric 6 AR130 AR131
Account The general ledger account of this AR135 AR180
transaction. Defaults from the reason AR30.1 AR30.2
code file. AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-SUB-ACCT Numeric 4 AR130 AR131
Subaccount The general ledger subaccount for this AR135 AR180
transaction. This subaccount will AR30.1 AR30.2
default from the reason code file. AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-REVIEW-STATUS Numeric 1 AR130 AR131
Review Status This status code will indicate any AR135 AR180
processing or review cycles to an AR191 AR30.1
application adjustment. If the AR30.2 AR30.3
adjustment needs a review, the AR30.4 AR30.8
application will not be set for posting AR31.5 AR31.6
until approval is made. Valid values AR35.1 AR35.2
are: AR36.1 AR36.2
AR44.3 AR972
0 = Unreleased adjustment DT45.1
2 = Review - needs approval
4 = Approval complete/approval na
5 = Posted
ADJ-CREATE-DATE Numeric 8 (yyyymmdd) AR130 AR131
Creation Date System date when this adjustment was AR135 AR180
created. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-CREATE-TIME Numeric 6 (hhmmss) AR130 AR131
Creation Time System time when this adjustment was AR135 AR180
created. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-ORIG-ADJ-AMT Signed 15.2 AR130 AR131
Transaction The amount of the adjustment in the AR135 AR180
Adjustment Amount currency of the adjustment. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.5
AR31.6 AR35.1
AR35.2 AR44.3
AR504 AR972
DT45.1
ADJ-CR-ORIG-AJ-AMT Signed 15.2 AR130 AR131
Credit Adj Original The amount of the credit adjustment in AR135 AR180
Amount payment currency. AR30.1 AR30.2
AR30.3 AR30.4
AR30.8 AR31.6
AR35.1 AR35.2
AR504 AR700
AR980
ADJ-ADJUST-SOURCE Alpha 1 AR130 AR131
Adjustment Type Indicates the type of the adjustment. AR135 AR150
Valid values are AR180 AR30.1
AR30.2 AR30.3
C = Credit adjustment AR30.4 AR30.8
D = Debit adjustment AR31.5 AR31.6
AR35.1 AR35.2
AR44.3 AR972
AR980
ADJ-ADJUST-TYPE Alpha 1 AR130 AR131
Credit Adjustment Indicates if the adjustment is the AR135 AR180
Type result of a payment being turned into a AR30.1 AR30.2
credit memo. Valid values are: AR30.3 AR30.4
AR30.8 AR31.5
C = Credit memo origin AR31.6 AR35.1
N = Non credit memo origin AR35.2 AR44.3
ARADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ADJSET1 COMPANY This is the primary path for accessing AC115 AR130
TRANS-TYPE adjustment records by transaction AR132 AR150
TRANS-NBR number. AR161 AR180
PAYMENT-SEQ AR190 AR191
BATCH-NBR AR194 AR196
APP-SEQ AR20.1 AR21.1
ADJ-SEQ AR21.2 AR21.3
AR230 AR232
AR233 AR235
AR250 AR251
AR252 AR253
AR255 AR256
AR282 AR286
AR287 AR30.1
AR30.2 AR30.4
...
ADJSET2 COMPANY This path is used to access any AR36.1 AR36.2
TRANS-TYPE adjustment which requires review.
TRANS-NBR Subset
PAYMENT-SEQ Where REVIEW-STATUS = 2
BATCH-NBR
APP-SEQ
ADJ-SEQ
ARADJUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arapplied ARAPPLIED Required
ADJ-COMPANY -> ARA-COMPANY
ADJ-TRANS-TYPE -> ARA-TRANS-TYPE
ADJ-TRANS-NBR -> ARA-TRANS-NBR
ADJ-PAYMENT-SEQ -> ARA-PAYMENT-SEQ
ADJ-BATCH-NBR -> ARA-BATCH-NBR
ADJ-APP-SEQ -> ARA-APP-SEQ
Arcode ARCODE Required
ADJ-COMPANY -> RCD-COMPANY
ARA-AR-CODE -> RCD-AR-CODE
Arcomp ARCOMP Required
ADJ-COMPANY -> ACO-COMPANY
Aroihdr AROIHDR Required
ADJ-COMPANY -> ARH-COMPANY
ADJ-TRANS-TYPE -> ARH-TRANS-TYPE
ADJ-TRANS-NBR -> ARH-TRANS-NBR
Aroitems AROITEMS Required
ADJ-COMPANY -> ARO-COMPANY
ADJ-TRANS-TYPE -> ARO-TRANS-TYPE
ADJ-TRANS-NBR -> ARO-TRANS-NBR
ADJ-PAYMENT-SEQ -> ARO-PAYMENT-SEQ
Arreason ARREASON Required
ADJ-COMPANY -> ARR-COMPANY
"AD" -> ARR-TYPE
ADJ-REASON-CODE -> ARR-REASON-CODE
Aruadjust ARUADJUST Not Required
ADJ-COMPANY -> AGM-COMPANY
ADJ-TRANS-TYPE -> AGM-TRANS-TYPE
ADJ-TRANS-NBR -> AGM-TRANS-NBR
ADJ-PAYMENT-SEQ -> AGM-PAYMENT-SEQ
ADJ-BATCH-NBR -> AGM-BATCH-NBR
ADJ-APP-SEQ -> AGM-APP-SEQ
ADJ-ADJ-SEQ -> AGM-ADJ-SEQ
|