ARSADJUST

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.
UPDATED BY
CB06.2 CB191

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ASJ-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
ASJ-TRANS-TYPE
Element: Trans Type
Alpha 1
The transaction type the adjustment is associated with. Valid values are: C = Credit memo D = Debit Memo I = Invoice
ASJ-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice, debit memo, or credit memo.
ASJ-PAYMENT-SEQ
Element: Payment Sequence
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
ASJ-ADJ-SEQ
Element: Adjustment Sequence
Numeric 3
The sequence number of the adjustment.
ASJ-ADJ-AMT
Element: Adjustment Amount
Signed 18.2
The amount of the adjustment in company base currency.
ASJ-ORIG-ADJ-AMT
Original Adjustment
Amount
Signed 18.2
The amount of the adjustment in transaction currency.
ASJ-CR-ORIG-AJ-AMT
Element: Intl Amt
Signed 18.2
The amount of the credit adjustment in the payment currency.
ASJ-REASON-CODE
Element: Reason Code
Alpha 4
The reason code for the adjustment.
ASJ-ACCT-UNIT
Element: Acct Unit
Alpha 15
The General Ldger accounting unit.
ASJ-ACCOUNT
Element: Account
Numeric 6
The General Ledger account.
ASJ-SUB-ACCT
Element: Sub Acct
Numeric 4
The General Ledger subaccount
ASJ-DESC
Element: Description
Alpha 30 (Lower Case)
The description of the adjustment.
ASJ-MEMO-COMPANY
Element: Memo Company
Numeric 4
This is the company which will own the memo chargeback once it is generated.
ASJ-MEMO-CUSTOMER
Element: Memo Customer
Alpha 9 (Right Justified)
This is the customer which will own the memo chargeback once it is generated.
ASJ-MEMO-PROC-LEV
Element: Memo Process Level
Alpha 5
This is the process level which will own the chargeback once it is generated.
ASJ-MEMO-INDIC
Element: Memo Indicator
Alpha 1
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
Memo Cross
Reference Number
Alpha 22 (Right Justified)
This will contain the cross reference number entered to memo chargeback creation.
ASJ-GL-DATE
Element: Posting Date
Numeric 8 (yyyymmdd)
This field contains the general ledger posting date.
ASJ-OPR-CODE
Element: Opr Code
Alpha 10 (Lower Case)
This field contains the operator code. This is the user ID of the person who last maintained this record.
ASJ-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
This is the journal book number for the adjustment record.
ASJ-ACTIVITY
Element: Activity
Alpha 15
The Activity associated with the adjustment.
ASJ-ACCT-CATEGORY
Element: Acct Category
Alpha 5
The Account Category associated with the Activity of the adjustment.
ASJ-BATCH-NBR
Element: Batch Nbr
Numeric 6
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
TRANS-TYPE
INVOICE
PAYMENT-SEQ
BATCH-NBR
ADJ-SEQ
CB06.2 CB191
ASJSET2 COMPANY
TRANS-TYPE
INVOICE
PAYMENT-SEQ
MEMO-INDIC
BATCH-NBR
ADJ-SEQ
CB191
ASJSET3 COMPANY
BATCH-NBR
PAYMENT-SEQ
ADJ-SEQ
Subset
WhereTRANS-TYPE ="P"


ARSADJUST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Arsapplied ARSAPPLIED Required
ASJ-COMPANY->ASG-COMPANY (ASGSET2)
ASJ-TRANS-TYPE->ASG-TRANS-TYPE
ASJ-INVOICE->ASG-INVOICE
ASJ-PAYMENT-SEQ->ASG-PAYMENT-SEQ


File created: Thu Jun 09 11:09:08 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.