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.6
AR30.7 AR30.8 AR31.1 AR33.1 AR33.3 AR34.1
AR34.2 AR34.3 AR34.4 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.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-TRANS-TYPE Alpha 1 AR115 AR30.1
Element: Transaction TyThe transaction type the adjustment is AR30.2 AR30.3
associated with. AR30.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-INVOICE Alpha 22 AR115 AR30.1
Element: Invoice NumberUsed to identify the invoice. AR30.2 AR30.3
AR30.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-PAYMENT-SEQ Numeric 6 AR115 AR30.1
Element: Payment SequenPayment Sequence. This is the generated AR30.2 AR30.3
sequence number to separate individual AR30.6 AR30.7
invoice payment requirements. AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-ADJ-SEQ Numeric 3 AR115 AR30.1
Element: Adjustment SeqThe sequence number of the adjustment. AR30.2 AR30.3
AR30.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-ADJ-AMT Signed 18.2 AR115 AR30.1
Element: Adjustment AmoThe amount of the adjustment. AR30.2 AR30.3
AR30.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-ORIG-ADJ-AMT Signed 18.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.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-CR-ORIG-AJ-AMT Signed 18.2 AR115 AR30.1
Element: Intl Amt The amount of the credit adjustment in AR30.2 AR30.3
the payment currency. AR30.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-REASON-CODE Alpha 4 AR115 AR30.1
Element: Reason Code The reason code for the adjustment. AR30.2 AR30.3
AR30.6 AR30.7
AR31.1 AR33.1
AR34.1 AR34.2
AR34.3 AR34.4
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.6 AR30.7
number. When used in the General Ledger AR31.1 AR33.1
Account Master file, the accounting unit AR34.1 AR34.2
must be defined in the General Ledger AR34.3 AR34.4
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.6 AR30.7
(account) where amounts and other AR31.1 AR33.1
account information is stored. AR34.1 AR34.2
AR34.3 AR34.4
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.6 AR30.7
that was charged with the amount carried AR31.1 AR33.1
on this record. AR34.1 AR34.2
AR34.3 AR34.4
ASJ-DESC Alpha 30 (Lower Case) AR115 AR30.2
Element: Description The description of the adjustment. AR30.3 AR30.6
AR30.7 AR31.1
AR34.1 AR34.2
AR34.3 AR34.4
ASJ-MEMO-COMPANY Numeric 4 AR30.7 AR34.3
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 AR34.3
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 AR34.3
Element: Memo Process LThis is the process level which will
own the chargeback once it is generated.
ASJ-MEMO-INDIC Alpha 1 AR30.7 AR34.3
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 AR34.3
Memo Cross This will contain the cross reference
Reference Number number entered to memo chargeback
creation.
ASJ-GL-DATE Numeric 8 (yyyymmdd) AR30.3 AR30.7
Element: Posting Date This field contains the general ledger AR31.1 AR34.3
posting date. AR34.4
ASJ-OPR-CODE Alpha 10 (Lower Case) AR30.3 AR30.7
Element: Operator Code This field contains the operator code. AR31.1 AR34.3
This is the user ID of the person who AR34.4
last maintained this record.
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.3 AR30.6
procedures that produce work. Cost AR30.7 AR31.1
objects (products, services, customers, AR34.1 AR34.2
and so on) are the reasons for AR34.3 AR34.4
performing the activity.
ASJ-ACCT-CATEGORY Alpha 5 AR115 AR30.1
Element: Account CategoAccount categories are groupings of AR30.3 AR30.6
costs, revenues, or a combination of AR30.7 AR31.1
both used for reporting and inquiries AR34.1 AR34.2
for activities in the Activity AR34.3 AR34.4
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.
Valid account category types are:
cost
revenue
accrual
pass thru
ASJ-BATCH-NBR Numeric 6 AR30.3 AR30.7
Element: Batch Number This identifies the batch the entered AR31.1 AR34.3
invoices, debit memos, and credit memos AR34.4
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.6
AR30.7 AR30.8
AR31.1 AR33.1
AR33.3 AR34.1
AR34.2 AR34.3
AR34.4 AR48.1
AR570 AR575
AR580 CB06.2
...
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.7
MEMO-INDIC AR34.1 AR34.3
ADJ-SEQ AR34.4 AR570
AR575 AR580
CB191
ASJSET3 COMPANY Subset AR130 AR30.1
BATCH-NBR Where TRANS-TYPE = "P" AR30.3 AR30.6
PAYMENT-SEQ AR30.7 AR31.1
ADJ-SEQ AR34.2 AR34.3
AR34.4 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
|