ARSADJUST FILE
Cash Application Adjust Select
Cash Application Adjust Select
REFERENCED BY
AR124 AR135 AR230 AR24.1 AR29.1 AR29.2
AR570 AR575 AR580 CB191
UPDATED BY
AR115 AR130 AR30.1 AR30.2 AR30.3 AR30.4
AR30.6 AR30.7 AR30.8 AR30.9 AR31.1 AR20.1
AR21.1 AR21.2 AR21.3 CB06.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASJ-COMPANY Numeric 4 AR115 AR130
Company Company number. AR30.1 AR30.2
AR30.3 AR30.4
AR30.6 AR30.7
AR30.8 AR30.9
AR31.1
ASJ-TRANS-TYPE Alpha 1 AR115 AR130
Transaction Type The transaction type the adjustment is AR30.1 AR30.2
associated with. AR30.3 AR30.4
AR30.6 AR30.7
AR30.8 AR30.9
AR31.1
ASJ-TRANS-NBR Alpha 10 (Right Justified) AR115 AR130
Transaction Number The transaction number the adjustment AR30.1 AR30.2
is associated with. AR30.3 AR30.4
AR30.6 AR30.7
AR30.8 AR30.9
AR31.1
ASJ-PAYMENT-SEQ Numeric 6 AR115 AR130
Payment Sequence Payment Sequence. This is the generated AR30.1 AR30.2
sequence number to separate individual AR30.3 AR30.4
invoice payment requirements. AR30.6 AR30.7
AR30.8 AR30.9
AR31.1
ASJ-ADJ-SEQ Numeric 3 AR115 AR30.1
Adjustment Sequence The sequence number of the adjustment. AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-ADJ-AMT Signed 15.2 AR115 AR30.1
Adjustment Amount The amount of the adjustment. AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-ORIG-ADJ-AMT Signed 15.2 AR115 AR20.1
Original Adjustment The amount of the adjustment in AR21.1 AR21.2
Amount transaction currency. AR21.3 AR30.1
AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-CR-ORIG-AJ-AMT Signed 15.2 AR115 AR30.1
Credit Adjustment The amount of the adjustment in the AR30.2 AR30.3
Orig Amt payment currency. AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-REASON-CODE Alpha 4 AR115 AR30.1
Reason Code The reason code for the adjustment. AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-ACCT-UNIT Alpha 15 AR115 AR30.1
Accounting Unit The accounting unit is a shorthand AR30.2 AR30.4
notation representing the variable level AR30.6 AR30.7
number. When used in the General Ledger AR30.9 AR31.1
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
ASJ-ACCOUNT Numeric 6 AR115 AR30.1
Account This field along with the accounting AR30.2 AR30.4
unit and subaccount make up the location AR30.6 AR30.7
(account) where amounts and other AR30.9 AR31.1
account information is stored.
ASJ-SUB-ACCT Numeric 4 AR115 AR30.1
Subaccount This field contains the subaccount from AR30.2 AR30.4
your general ledger chart of accounts AR30.6 AR30.7
that was charged with the amount carried AR30.9 AR31.1
on this record.
ASJ-DESC Alpha 30 (Lower Case) AR115 AR30.1
Description The description of the adjustment. AR30.2 AR30.4
AR30.6 AR30.7
AR30.9 AR31.1
ASJ-MEMO-COMPANY Numeric 4 AR30.7
Memo Company This is the company which will own the
memo chargeback once it is generated.
ASJ-MEMO-CUSTOMER Alpha 9 (Right Justified) AR30.7
Memo Customer This is the customer which will own the
memo chargeback once it is generated.
ASJ-MEMO-PROC-LEV Alpha 5 AR30.7
Memo Process Level This is the process level which will
own the chargeback once it is generated.
ASJ-MEMO-INDIC Alpha 1 AR30.7
Memo Indicator Indicates if the adjustment select
record for a payment is for a chargeback
memo. Valid values are:
Blank = Not a memo chargeback memo
M = Chargeback memo
ASJ-MEMO-XREF-NBR Alpha 10 (Right Justified) AR30.7
Memo Cross This will contain the cross reference
Reference Number number entered to memo chargeback
creation.
ASJ-GL-DATE Numeric 8 (yyyymmdd) AR30.7 AR31.1
Posting Date This field contains the general ledger
posting date.
ASJ-OPR-CODE Alpha 10 (Lower Case) AR30.7 AR31.1
Operator Code This field contains the operator code.
This is the user ID of the person who
last maintained this record.
ASJ-JRNL-BOOK-NBR Alpha 12
Journal Book Number This is the journal book number for the
adjustment record.
ASJ-BATCH-NBR Numeric 6 AR30.7 AR31.1
Batch Number This identifies the batch the entered
invoices, debit memos, and credit memos
are a part of.
ARSADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASJSET1 COMPANY This index is used to access the AR124 AR130
TRANS-TYPE ARSADJUST records in transaction number AR135 AR20.1
TRANS-NBR order. AR21.1 AR21.2
PAYMENT-SEQ AR21.3 AR230
ADJ-SEQ AR24.1 AR29.1
AR29.2 AR30.1
AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.8
AR30.9 AR31.1
AR570 AR575
AR580 CB06.2
CB191
ASJSET2 COMPANY This index is used for processing AR124 AR20.1
TRANS-TYPE payment ARSADJUST records. AR21.1 AR21.2
TRANS-NBR AR21.3 AR24.1
PAYMENT-SEQ AR30.1 AR30.2
MEMO-INDIC AR30.4 AR30.7
ADJ-SEQ AR31.1 AR570
AR575 AR580
CB191
ASJSET3 COMPANY Subset AR130
BATCH-NBR Where TRANS-TYPE = "P"
PAYMENT-SEQ
ADJ-SEQ
ARSADJUST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arsapplied ARSAPPLIED Required
ASJ-COMPANY -> ASG-COMPANY
ASJ-TRANS-TYPE -> ASG-TRANS-TYPE
ASJ-TRANS-NBR -> ASG-TRANS-NBR
ASJ-PAYMENT-SEQ -> ASG-PAYMENT-SEQ
|