ARSAPPLIED – Cash Application Select
- System
- Accounts Receivable (AR)
- Prefix
ASG- Primary key
CR-COMPANY,CR-BATCH,CR-PYMNT-SEQ,COMPANY,TRANS-TYPE,INVOICE,PAYMENT-SEQ- Fields
- 15
- Updated by
- 1 program
- Referenced by
- 1 program
ARSAPPLIED is the Cash Application Select table in Lawson Accounts Receivable (prefix ASG). It is indexed by CR-COMPANY, CR-BATCH, CR-PYMNT-SEQ, COMPANY, TRANS-TYPE, INVOICE, PAYMENT-SEQ (ASGSET1); alternate indexes: ASGSET2 and ASGSET3. It is related 1:1 to AROITEMS and ARPAYMENT and 1:M to ARSADJUST. It is updated by CB06.2 and referenced by CB191. The table has 15 fields, 3 indexes and 3 documented relations.
About ARSAPPLIED
The Cash Application Select file contains the cash application select records that have been selected but not yet processed, thereby creating application records.
Fields (15)
Column = COBOL field name without the ASG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#ASG-CR-COMPANY PKCR_COMPANY | Numeric 4 | The number representing an AR company. | — |
#ASG-CR-BATCH PKCR_BATCH | Numeric 6 | The batch of the payment. | — |
#ASG-CR-PYMNT-SEQ PKCR_PYMNT_SEQ | Numeric 6 | The sequence number of the payment. | — |
#ASG-COMPANY PKCOMPANY | Numeric 4 | The company number of the transaction. | — |
#ASG-TRANS-TYPE PKTRANS_TYPE | Alpha 1 | The transaction type associated with the selected application. Valid values are:
| — |
#ASG-INVOICE PKINVOICE | Alpha 22 | Used to identify the invoice. | — |
#ASG-PAYMENT-SEQ PKPAYMENT_SEQ | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | — |
#ASG-OPEN-AMTOPEN_AMT | Signed 18.2 | The open amount of the transaction. | — |
#ASG-ORIG-OPEN-AMTORIG_OPEN_AMT | Signed 18.2 | The open amount in transaction currency. | — |
#ASG-CR-ORIG-AP-AMTCR_ORIG_AP_AMT | Signed 18.2 | The amount of the application in the payment currency. | — |
#ASG-ADJ-SEQADJ_SEQ | Numeric 3 | The sequence number of the adjustment. | — |
#ASG-GL-DATEGL_DATE | Numeric 8 (yyyymmdd) | This field contains the date the applications will be posted to the general ledger. | — |
#ASG-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. | — |
#ASG-EFT-FLEFT_FL | Alpha 1 | Indicates if the open amount was selected for application during EFT processing. Valid values are: processing processing
| — |
#ASG-SELECT-SEQ SET3SELECT_SEQ | Numeric 6 | The payment application order. | — |
Indexes (3)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ASGSET1 |
| Primary | CB06.2, CB191 | |
ASGSET2 |
| — | ||
ASGSET3 |
| — |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aroitems | AROITEMS | Required |
| |||||||||||||
| Arpayment | ARPAYMENT | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Arsadjust | ARSADJUST | Delete Cascades |
|
Programs
Updated by (1)
- CB06.2 Bank Statement Detail Entry
Referenced by (1)
- CB191 Bank Statement Close