ARCOMMENT – Customer Comments
- System
- Accounts Receivable (AR)
- Prefix
CMT- Primary key
COMPANY,CUSTOMER,SEQ-NUMBER- Fields
- 11
- Updated by
- 2 programs
- Referenced by
- 3 programs
ARCOMMENT is the Customer Comments table in Lawson Accounts Receivable (prefix CMT). It is indexed by COMPANY, CUSTOMER, SEQ-NUMBER (CMTSET1); alternate indexes: CMTSET2, CMTSET3, CMTSET4 and CMTSET5. It is related 1:1 to ARCOMP, ARCUSTOMER, AROIHDR and CUSTDESC. It is updated by AR17.1 and AR301 and referenced by AR10.1, AR217 and BLI2.1. The table has 11 fields, 5 indexes and 4 documented relations.
About ARCOMMENT
The AR Customer Comments file contains comment records for customers and transactions identifiable by comment type.
Fields (11)
Column = COBOL field name without the CMT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
CMT-COMPANY PKCOMPANY | Numeric 4 | The number representing an AR company. | AR17.1 |
CMT-CUSTOMER PKCUSTOMER | Alpha 9 (Right Justified) | Customer number. | AR17.1 |
CMT-SEQ-NUMBER PKSEQ_NUMBER | Numeric 6 | A unique number assigned to each transaction to be interfaced into the Lawson system. | AR17.1 |
CMT-CMMT-TYPECMMT_TYPE | Alpha 1 | Type of comment entered. Valid values are:
| AR17.1 |
CMT-TRANS-TYPETRANS_TYPE | Alpha 1 | Identifies the type of transaction to which the comment belongs. Valid values are:
| AR17.1 |
CMT-INVOICEINVOICE | Alpha 22 | Used to identify the invoice. | AR17.1 |
CMT-BEG-DATEBEG_DATE | Numeric 8 (yyyymmdd) | Date at which time the comment becomes effective for online and report selection. Comments are accessible in AR17 (Comments), until they are deleted by AR17 or AR300 (Transaction Purge). | AR17.1 |
CMT-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | Date at which time the comment becomes ineffective for online and report selection. Comments are accessible in AR17 (Comments), until they are deleted by AR17 Comments or by AR300 (Transaction Purge). | AR17.1 |
CMT-PRINT-CODEPRINT_CODE | Alpha 1 | The Print Code defines where the comment displays and/or prints. Valid values are:
| AR17.1 |
CMT-SYS-DATESYS_DATE | Numeric 8 (yyyymmdd) | System date that the comment was added to the system. Used to determine sequence of redisplay of comments. | AR17.1 |
CMT-SYS-TIMESYS_TIME | Numeric 6 (hhmmss) | System time that the comment was added to the system. Used to determine sequence of redisplay of comments. | AR17.1 |
Indexes (5)
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 |
|---|---|---|---|---|
CMTSET1 | COMPANY, CUSTOMER, SEQ-NUMBER | Primary | AR10.1, AR17.1, AR217, AR301 | |
CMTSET2 | COMPANY, CUSTOMER, CMMT-TYPE, TRANS-TYPE, INVOICE, BEG-DATE, SEQ-NUMBER | Subset | Where CMMT-TYPE = "T" | AR17.1, AR217 |
CMTSET3 | COMPANY, CUSTOMER, SYS-DATE*, SYS-TIME*, SEQ-NUMBER | Subset | Where CMMT-TYPE = "C" | AR17.1, AR217 |
CMTSET4 | COMPANY, CUSTOMER, SYS-DATE*, SYS-TIME*, SEQ-NUMBER | Subset | Where CMMT-TYPE = "C" And (PRINT-CODE = "B" Or PRINT-CODE = "D") | — |
CMTSET5 | COMPANY, CUSTOMER, CMMT-TYPE, TRANS-TYPE, INVOICE, SEQ-NUMBER | Subset | Where CMMT-TYPE = "O" | AR17.1, AR217, BLI2.1 |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Arcomp | ARCOMP | Required | CMT-COMPANY → ACO-COMPANY | |
| Arcustomer | ARCUSTOMER | Required | CMT-COMPANY → ACM-COMPANY, CMT-CUSTOMER → ACM-CUSTOMER | |
| Aroihdr | AROIHDR | Required | CMT-COMPANY → ARH-COMPANY, CMT-CUSTOMER → ARH-CUSTOMER, CMT-TRANS-TYPE → ARH-TRANS-TYPE, CMT-INVOICE → ARH-INVOICE | |
| Custdesc | CUSTDESC | Required | ACO-CUST-GROUP → CUD-CUST-GROUP, CMT-CUSTOMER → CUD-CUSTOMER |