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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#CMT-COMPANY PK
COMPANY		Numeric 4The number representing an AR company.AR17.1
#CMT-CUSTOMER PK
CUSTOMER		Alpha 9 (Right Justified)Customer number.AR17.1
#CMT-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.AR17.1
#CMT-CMMT-TYPE SET2 SET5
CMMT_TYPE		Alpha 1Type of comment entered. Valid values are:
  • O Order Entry comment
  • C Customer comment
  • T Transaction comment
AR17.1
#CMT-TRANS-TYPE SET2 SET5
TRANS_TYPE		Alpha 1Identifies the type of transaction to which the comment belongs. Valid values are:
  • C Credit Memo
  • D Debit Memo
  • I Invoice
  • P Payment
  • M Mixed
AR17.1
#CMT-INVOICE SET2 SET5
INVOICE		Alpha 22Used to identify the invoice.AR17.1
#CMT-BEG-DATE SET2
BEG_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-DATE
END_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-CODE
PRINT_CODE		Alpha 1The Print Code defines where the comment displays and/or prints. Valid values are:
  • B Both Display and Print
  • D Display
  • P Print
  • R Order Entry forms
AR17.1
#CMT-SYS-DATE SET3 SET4
SYS_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-TIME SET3 SET4
SYS_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
CMTSET1
  1. COMPANY
  2. CUSTOMER
  3. SEQ-NUMBER
PrimaryAR10.1, AR17.1, AR217, AR301
CMTSET2
  1. COMPANY
  2. CUSTOMER
  3. CMMT-TYPE
  4. TRANS-TYPE
  5. INVOICE
  6. BEG-DATE
  7. SEQ-NUMBER
SubsetWhere CMMT-TYPE = "T"AR17.1, AR217
CMTSET3
  1. COMPANY
  2. CUSTOMER
  3. SYS-DATE ↓
  4. SYS-TIME ↓
  5. SEQ-NUMBER
SubsetWhere CMMT-TYPE = "C"AR17.1, AR217
CMTSET4
  1. COMPANY
  2. CUSTOMER
  3. SYS-DATE ↓
  4. SYS-TIME ↓
  5. SEQ-NUMBER
SubsetWhere CMMT-TYPE = "C" And (PRINT-CODE = "B" Or PRINT-CODE = "D")—
CMTSET5
  1. COMPANY
  2. CUSTOMER
  3. CMMT-TYPE
  4. TRANS-TYPE
  5. INVOICE
  6. SEQ-NUMBER
SubsetWhere CMMT-TYPE = "O"AR17.1, AR217, BLI2.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ARCOMPARCUSTOMERAROIHDRCUSTDESCARCOMMENT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequired
CMT-COMPANY→ACO-COMPANY
ArcustomerARCUSTOMERRequired
CMT-COMPANY→ACM-COMPANY
CMT-CUSTOMER→ACM-CUSTOMER
AroihdrAROIHDRRequired
CMT-COMPANY→ARH-COMPANY
CMT-CUSTOMER→ARH-CUSTOMER
CMT-TRANS-TYPE→ARH-TRANS-TYPE
CMT-INVOICE→ARH-INVOICE
CustdescCUSTDESCRequired
ACO-CUST-GROUP→CUD-CUST-GROUP
CMT-CUSTOMER→CUD-CUSTOMER

Programs

Updated by (2)

Referenced by (3)