ARCOMMENT

Customer Comments

The AR Customer Comments file contains comment records for customers and transactions identifiable by comment type.
UPDATED BY
AR17.1 AR301 AR10.1 AR217

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMT-COMPANY
Element: Company
Numeric 4
The number representing an AR company.
AR17.1
CMT-CUSTOMER
Element: Customer
Alpha 9 (Right Justified)
Customer number.
AR17.1
CMT-SEQ-NUMBER
Element: Seq Number
Numeric 6
A unique number assigned to each transaction to be interfaced into the Lawson system.
AR17.1
CMT-CMMT-TYPE
Element: Comment Type
Alpha 1
Type of comment entered. Valid values are: O = Order Entry comment C = Customer comment T = Transaction comment
AR17.1
CMT-TRANS-TYPE
Element: Transaction Type
Alpha 1
Identifies 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
Element: Invoice
Alpha 22
Used to identify the invoice.
AR17.1
CMT-BEG-DATE
Element: Beginning 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
Element: Ending 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
Element: Print Code
Alpha 1
The 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
Element: System 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
Element: System Time
Numeric 6 (hhmmss)
System time that the comment was added to the system. Used to determine sequence of redisplay of comments.
AR17.1


ARCOMMENT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMTSET1 COMPANY
CUSTOMER
SEQ-NUMBER
AR10.1 AR17.1
AR217 AR301
CMTSET2 COMPANY
CUSTOMER
CMMT-TYPE
TRANS-TYPE
INVOICE
BEG-DATE
SEQ-NUMBER
Subset
WhereCMMT-TYPE ="T"
AR17.1 AR217
CMTSET3 COMPANY
CUSTOMER
SYS-DATE*
SYS-TIME*
SEQ-NUMBER
Subset
WhereCMMT-TYPE ="C"
AR17.1 AR217
CMTSET4 COMPANY
CUSTOMER
SYS-DATE*
SYS-TIME*
SEQ-NUMBER
Subset
WhereCMMT-TYPE ="C"
And(PRINT-CODE ="B"
OrPRINT-CODE ="D")
CMTSET5 COMPANY
CUSTOMER
CMMT-TYPE
TRANS-TYPE
INVOICE
SEQ-NUMBER
Subset
WhereCMMT-TYPE ="O"
AR17.1 AR217


ARCOMMENT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Wed Jun 08 20:47:54 2016

Home
Contact Us



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