|
|
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 AR251 AR257
AR271 AR36.2 AR38.1 AR38.2 AR39.1 AR39.2
AR45.1 AR46.1 AR48.1 AR72.1 AR90.1 AR91.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 number representing an AR company.
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
Element: Seq Number A unique number assigned to each AR29.3 ARI1.1
transaction to be interfaced 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 Used 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 AR10.1 AR17.1
CUSTOMER AR217 AR29.1
SEQ-NUMBER AR300 AR301
ARI1.1
CMTSET2 COMPANY Subset AR140 AR17.1
CUSTOMER Where CMMT-TYPE = "T" AR217 AR245
CMMT-TYPE AR251 AR257
TRANS-TYPE AR271 AR29.3
INVOICE AR300 AR36.2
BEG-DATE AR38.1 AR38.2
SEQ-NUMBER AR39.1 AR39.2
AR42.2 AR45.1
AR46.1 AR48.1
AR72.1 AR90.1
AR91.1
CMTSET3 COMPANY Subset AR17.1 AR217
CUSTOMER Where CMMT-TYPE = "C" AR271 AR72.1
SYS-DATE* AR75.1
SYS-TIME*
SEQ-NUMBER
CMTSET4 COMPANY Subset AR70.2
CUSTOMER Where CMMT-TYPE = "C"
SYS-DATE* And (PRINT-CODE = "B"
SYS-TIME* Or PRINT-CODE = "D" )
SEQ-NUMBER
CMTSET5 COMPANY Subset AR17.1 AR217
CUSTOMER Where CMMT-TYPE = "O" BLI2.1
CMMT-TYPE
TRANS-TYPE
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
|
