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, thereby creating application adjustment records.
REFERENCED BY
AR124 AR129 AR135 AR230 AR24.1 AR29.1
AR29.2 AR38.1 AR38.2 AR38.3 AR48.1 AR570
AR575 AR580 AR91.1 CB191 AR82.1
UPDATED BY
AR115 AR130 AR30.1 AR30.2 AR30.3 AR30.6
AR30.7 AR30.8 AR32.1 AR32.3 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 The number representing an AR company. AR30.2 AR30.3
AR30.6 AR30.7
AR32.1 AR32.3
AR33.1 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-TRANS-TYPE Alpha 1 AR115 AR30.1
Element: Trans Type The transaction type the adjustment is AR30.2 AR30.3
associated with. Valid values are: AR30.6 AR30.7
AR32.1 AR32.3
C = Credit memo AR33.1 AR34.1
D = Debit Memo AR34.2 AR34.3
I = Invoice AR34.4
ASJ-INVOICE Alpha 22 AR115 AR30.1
Element: Invoice Used to identify the invoice, debit AR30.2 AR30.3
memo, or credit memo. AR30.6 AR30.7
AR32.1 AR32.3
AR33.1 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-PAYMENT-SEQ Numeric 6 AR115 AR30.1
Element: Payment SequenA unique number assigned to each AR30.2 AR30.3
transaction to be interfaced into the AR30.6 AR30.7
Lawson system. AR32.1 AR32.3
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
AR32.1 AR32.3
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 in company AR30.2 AR30.3
base currency. AR30.6 AR30.7
AR32.1 AR32.3
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
AR32.1 AR32.3
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
AR32.1 AR32.3
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
AR32.1 AR32.3
AR33.1 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-ACCT-UNIT Alpha 15 AR115 AR30.1
Element: Acct Unit The General Ldger accounting unit. AR30.2 AR30.3
AR30.6 AR30.7
AR32.1 AR32.3
AR33.1 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-ACCOUNT Numeric 6 AR115 AR30.1
Element: Account The General Ledger account. AR30.2 AR30.3
AR30.6 AR30.7
AR32.1 AR32.3
AR33.1 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-SUB-ACCT Numeric 4 AR115 AR30.1
Element: Sub Acct The General Ledger subaccount AR30.2 AR30.3
AR30.6 AR30.7
AR32.1 AR32.3
AR33.1 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 AR32.3
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 AR34.3 AR34.4
posting date.
ASJ-OPR-CODE Alpha 10 (Lower Case) AR30.1 AR30.2
Element: Opr Code This field contains the operator code. AR30.3 AR30.6
This is the user ID of the person who AR30.7 AR32.3
last maintained this record. AR34.3 AR34.4
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 The Activity associated with the AR30.3 AR30.6
adjustment. AR30.7 AR32.1
AR32.3 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-ACCT-CATEGORY Alpha 5 AR115 AR30.1
Element: Acct Category The Account Category associated with the AR30.3 AR30.6
Activity of the adjustment. AR30.7 AR32.1
AR32.3 AR34.1
AR34.2 AR34.3
AR34.4
ASJ-BATCH-NBR Numeric 6 AR30.3 AR30.7
Element: Batch Nbr This identifies the batch the entered AR34.3 AR34.4
invoices, debit memos, and credit memos
are a part of.
ARSADJUST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ASJSET1 COMPANY AR124 AR129
TRANS-TYPE AR130 AR135
INVOICE 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
AR32.1 AR32.3
AR33.1 AR33.3
AR34.1 AR34.2
AR34.3 AR34.4
AR38.1 AR38.2
AR38.3 AR48.1
...
ASJSET2 COMPANY AR124 AR20.1
TRANS-TYPE AR21.1 AR21.2
INVOICE AR21.3 AR24.1
PAYMENT-SEQ AR30.1 AR30.7
MEMO-INDIC AR32.1 AR34.1
ADJ-SEQ AR34.3 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 AR32.1
ADJ-SEQ AR32.3 AR34.2
AR34.3 AR34.4
AR82.1 AR91.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
|