Lawson Insight Technical Documentation |
|
ARSADJUST
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 AR135 AR230 AR24.1 AR29.1
AR29.2 AR48.1 AR570 AR575 AR580 CB191
AR82.1
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
Element: 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
Element: Transaction TyThe 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
Element: Invoice NumberUsed 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
Element: Payment Sequence AR30.2 AR30.3
AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-ADJ-SEQ Numeric 3 AR115 AR30.1
Element: Adjustment SeqThe 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
Element: Adjustment AmoThe 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
Element: Adj 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
Accounts Receivable The reason code for the adjustment. AR30.2 AR30.3
Code AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-ACCT-UNIT Alpha 15 AR115 AR30.1
Element: Accounting UniThe 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
Element: 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
Element: 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.2
Element: Description The description of the adjustment. AR30.4 AR30.6
AR30.7 AR30.9
AR31.1
ASJ-MEMO-COMPANY Numeric 4 AR30.7
Element: 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
Element: Memo Customer This is the customer which will own the
memo chargeback once it is generated.
ASJ-MEMO-PROC-LEV Alpha 5 AR30.7
Element: Memo Process LThis is the process level which will
own the chargeback once it is generated.
ASJ-MEMO-INDIC Alpha 1 AR30.7
Element: Memo IndicatorIndicates 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
Element: Posting Date
ASJ-OPR-CODE Alpha 10 (Lower Case) AR30.7 AR31.1
Element: Requester
ASJ-JRNL-BOOK-NBR Alpha 12
Element: Journal Book NThis is the journal book number for the
adjustment record.
ASJ-ACTIVITY Alpha 15 AR115 AR30.1
Element: Activity Activities are the processes or AR30.2 AR30.4
procedures that produce work. Cost AR30.6 AR30.7
objects (products, services, customers, AR31.1
and so on) are the reasons for
performing the activity.
ASJ-ACCT-CATEGORY Alpha 5 AR115 AR30.1
Element: Account CategoAccount categories are groupings of AR30.2 AR30.4
costs, revenues, or a combination of AR30.6 AR30.7
both used for reporting and inquiries AR31.1
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
Element: 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 AR135
INVOICE order. AR20.1 AR21.1
PAYMENT-SEQ AR21.2 AR21.3
ADJ-SEQ 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 AR570 AR575
AR580 CB191
ASJSET3 COMPANY Subset AR130 AR30.1
BATCH-NBR Where TRANS-TYPE = "P" AR30.2 AR30.4
PAYMENT-SEQ AR30.6 AR30.7
ADJ-SEQ AR31.1 AR82.1
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
|