Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARCOMMENT


                             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