ARSADJUST – Cash Application Adjust Select
- System
- Accounts Receivable (AR)
- Prefix
ASJ- Primary key
COMPANY,TRANS-TYPE,INVOICE,PAYMENT-SEQ,BATCH-NBR,ADJ-SEQ- Fields
- 24
- Updated by
- 1 program
- Referenced by
- 1 program
ARSADJUST is the Cash Application Adjust Select table in Lawson Accounts Receivable (prefix ASJ). It is indexed by COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, ADJ-SEQ (ASJSET1); alternate indexes: ASJSET2 and ASJSET3. It is related 1:1 to ARSAPPLIED. It is updated by CB06.2 and referenced by CB191. The table has 24 fields, 3 indexes and 1 documented relation.
About ARSADJUST
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.
Fields (24)
Column = COBOL field name without the ASJ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ASJ-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | — |
ASJ-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | The transaction type the adjustment is associated with. Valid values are:
| — |
ASJ-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice, debit memo, or credit memo. | — |
ASJ-PAYMENT-SEQ PKPAYMENT_SEQ | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | — |
ASJ-ADJ-SEQ PKADJ_SEQ | Numeric 3 | The sequence number of the adjustment. | — |
ASJ-ADJ-AMTADJ_AMT | Signed 18.2 | The amount of the adjustment in company base currency. | — |
ASJ-ORIG-ADJ-AMTORIG_ADJ_AMT | Signed 18.2 | The amount of the adjustment in transaction currency. | — |
ASJ-CR-ORIG-AJ-AMTCR_ORIG_AJ_AMT | Signed 18.2 | The amount of the credit adjustment in the payment currency. | — |
ASJ-REASON-CODEREASON_CODE | Alpha 4 | The reason code for the adjustment. | — |
ASJ-ACCT-UNITACCT_UNIT | Alpha 15 | The General Ldger accounting unit. | — |
ASJ-ACCOUNTACCOUNT | Numeric 6 | The General Ledger account. | — |
ASJ-SUB-ACCTSUB_ACCT | Numeric 4 | The General Ledger subaccount | — |
ASJ-DESCDESC | Alpha 30 (Lower Case) | The description of the adjustment. | — |
ASJ-MEMO-COMPANYMEMO_COMPANY | Numeric 4 | This is the company which will own the memo chargeback once it is generated. | — |
ASJ-MEMO-CUSTOMERMEMO_CUSTOMER | Alpha 9 (Right Justified) | This is the customer which will own the memo chargeback once it is generated. | — |
ASJ-MEMO-PROC-LEVMEMO_PROC_LEV | Alpha 5 | This is the process level which will own the chargeback once it is generated. | — |
ASJ-MEMO-INDICMEMO_INDIC | Alpha 1 | Indicates if the adjustment select record for a payment is for a chargeback memo. Valid values are:
| — |
ASJ-MEMO-XREF-NBRMEMO_XREF_NBR | Alpha 22 (Right Justified) | This will contain the cross reference number entered to memo chargeback creation. | — |
ASJ-GL-DATEGL_DATE | Numeric 8 (yyyymmdd) | This field contains the general ledger posting date. | — |
ASJ-OPR-CODEOPR_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-NBRJRNL_BOOK_NBR | Alpha 12 | This is the journal book number for the adjustment record. | — |
ASJ-ACTIVITYACTIVITY | Alpha 15 | The Activity associated with the adjustment. | — |
ASJ-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | The Account Category associated with the Activity of the adjustment. | — |
ASJ-BATCH-NBR PKBATCH_NBR | Numeric 6 | This identifies the batch the entered invoices, debit memos, and credit memos are a part of. | — |
Indexes (3)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ASJSET1 | COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ, BATCH-NBR, ADJ-SEQ | Primary | 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 | Where TRANS-TYPE = "P" | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arsapplied | ARSAPPLIED | Required | ASJ-COMPANY → ASG-COMPANY (ASGSET2), ASJ-TRANS-TYPE → ASG-TRANS-TYPE, ASJ-INVOICE → ASG-INVOICE, ASJ-PAYMENT-SEQ → ASG-PAYMENT-SEQ |
Programs
Updated by (1)
- CB06.2 Bank Statement Detail Entry
Referenced by (1)
- CB191 Bank Statement Close