ARSADJUST FILE
Cash Application Adjust Select
The Cash Application Adjustment Select file contains adjustment information
for open items that have been selected for cash application, but not yet
processed into adjustment records.
REFERENCED BY
AR124 AR129 AR131 AR135 AR230 AR24.1
AR29.1 AR29.2 AR48.1 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 AR30.1
Company Company number. AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-TRANS-TYPE Alpha 1 AR115 AR30.1
Transaction Type The transaction type the adjustment is AR30.2 AR30.3
associated with. AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-INVOICE Alpha 22 AR115 AR30.1
Invoice Number Used to identify the invoice. AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-PAYMENT-SEQ Numeric 6 AR115 AR30.1
Payment Sequence Payment Sequence. This is the generated AR30.2 AR30.3
sequence number to separate individual AR30.4 AR30.6
invoice payment requirements. AR30.7 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
Cr Orig Aj Amt The amount of the credit adjustment in AR30.2 AR30.3
the 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.3
notation representing the variable level AR30.4 AR30.6
number. When used in the General Ledger AR30.7 AR30.9
Account Master file, the accounting unit AR31.1
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.3
unit and subaccount make up the location AR30.4 AR30.6
(account) where amounts and other AR30.7 AR30.9
account information is stored. AR31.1
ASJ-SUB-ACCT Numeric 4 AR115 AR30.1
Subaccount This field contains the subaccount from AR30.2 AR30.3
your general ledger chart of accounts AR30.4 AR30.6
that was charged with the amount carried AR30.7 AR30.9
on this record. AR31.1
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 22 (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-ACTIVITY Alpha 15 AR115 AR30.6
Activity Activities are the processes or AR30.7 AR31.1
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
ASJ-ACCT-CATEGORY Alpha 5 AR115 AR30.6
Account Category Account categories are groupings of AR30.7 AR31.1
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.
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 AR129
TRANS-TYPE ARSADJUST records in transaction number AR130 AR131
INVOICE order. AR135 AR20.1
PAYMENT-SEQ AR21.1 AR21.2
ADJ-SEQ AR21.3 AR230
AR24.1 AR29.1
AR29.2 AR30.1
AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.8
AR30.9 AR31.1
AR48.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
INVOICE 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-INVOICE -> ASG-INVOICE
ASJ-PAYMENT-SEQ -> ASG-PAYMENT-SEQ
Arusadjust ARUSADJUST Not Required
ASJ-COMPANY -> SGM-COMPANY
ASJ-TRANS-TYPE -> SGM-TRANS-TYPE
ASJ-INVOICE -> SGM-INVOICE
ASJ-PAYMENT-SEQ -> SGM-PAYMENT-SEQ
ASJ-ADJ-SEQ -> SGM-ADJ-SEQ
|
