|
|
ARCOMMENT FILE
Customer Comments
The AR Customer Comments file contains comment records for customers and
transactions identifiable by comment type.
REFERENCED BY
AR10.1 AR217 AR140 AR245 AR271 AR36.2
AR45.1 AR46.1 AR48.1 AR72.1 AR90.1 AR75.1
AR70.2 BLI2.1
UPDATED BY
AR17.1 AR29.1 AR29.3 AR300 AR301 ARI1.1
AR42.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CMT-COMPANY Numeric 4 AR17.1 ARI1.1
Element: Company The company number represents an
established company and is entered on
all function codes.
CMT-CUSTOMER Alpha 9 (Right Justified) AR17.1 AR29.1
Element: Customer Customer number. AR29.3 ARI1.1
CMT-SEQ-NUMBER Numeric 6 AR17.1 AR29.1
Record Sequence A unique number assigned to each AR29.3 ARI1.1
Number transaction to be transferred into the
Lawson system.
CMT-CMMT-TYPE Alpha 1 AR17.1 ARI1.1
Element: Comment Type Type of comment entered. Valid values
are:
O = Order Entry comment
C = Customer comment
T = Transaction comment
CMT-TRANS-TYPE Alpha 1 AR17.1 ARI1.1
Element: Transaction TyIdentifies the type of transaction to
which the comment belongs. Valid values
are:
C = Credit Memo
D = Debit Memo
I = Invoice
P = Payment
M = Mixed
CMT-INVOICE Alpha 22 AR17.1 ARI1.1
Element: Invoice NumberUsed to identify the invoice.
CMT-BEG-DATE Numeric 8 (yyyymmdd) AR17.1 ARI1.1
Element: Beginning DateDate 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).
CMT-END-DATE Numeric 8 (yyyymmdd) AR17.1 ARI1.1
Element: Ending Date 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).
CMT-PRINT-CODE Alpha 1 AR17.1 ARI1.1
Element: Print Code 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
CMT-SYS-DATE Numeric 8 (yyyymmdd) AR17.1 ARI1.1
Element: System Date System date that the comment was added
to the system. Used to determine
sequence of redisplay of comments.
CMT-SYS-TIME Numeric 6 (hhmmss) AR17.1 ARI1.1
Element: System Time System time that the comment was added
to the system. Used to determine
sequence of redisplay of comments.
ARCOMMENT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CMTSET1 COMPANY This is the primary path used to access AR10.1 AR17.1
CUSTOMER comment records. AR217 AR29.1
SEQ-NUMBER AR300 AR301
ARI1.1
CMTSET2 COMPANY This path is used to access transaction AR140 AR17.1
CUSTOMER level comments. AR217 AR245
CMMT-TYPE Subset AR271 AR29.3
TRANS-TYPE Where CMMT-TYPE = "T" AR300 AR36.2
INVOICE AR42.2 AR45.1
BEG-DATE AR46.1 AR48.1
SEQ-NUMBER AR72.1 AR90.1
CMTSET3 COMPANY This path is used to access customer AR17.1 AR217
CUSTOMER level comments. AR271 AR72.1
SYS-DATE* Subset AR75.1
SYS-TIME* Where CMMT-TYPE = "C"
SEQ-NUMBER
CMTSET4 COMPANY This path is used to access customer AR70.2
CUSTOMER level comments in the customer review
SYS-DATE* program.
SYS-TIME* Subset
SEQ-NUMBER Where CMMT-TYPE = "C"
And (PRINT-CODE = "B"
Or PRINT-CODE = "D" )
CMTSET5 COMPANY This path is used to access order entry AR17.1 AR217
CUSTOMER comments. BLI2.1
CMMT-TYPE Subset
TRANS-TYPE Where CMMT-TYPE = "O"
INVOICE
SEQ-NUMBER
ARCOMMENT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
