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     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