Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARICUSTCMT FILE

                     AR Customer Comment Conversion

AR Customer Comment Conversion

UPDATED BY

AR501

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ICN-COMPANY          Numeric 4
Company              Company number.  Required.

ICN-CUSTOMER         Alpha 9  (Right Justified)
Customer             Customer number.   Required.

ICN-SEQ-NBR          Numeric 4
Sequence Number      The automatically assigned sequence
                     number.  Required.

ICN-CMMT-TYPE        Alpha 1
Comment Type         Comment type indicator. Required.
                     Valid values are:

                     C = Accounts Receivable comment
                     O = Order Entry comment

ICN-COMMENT          Alpha 40  (Lower Case)
Comment Line         This field contains the comment
                     narrative.  Required.

ICN-BEG-DATE         Numeric 8  (yyyymmdd)
Beginning Date       Beginning effective date for comment to
                     be selected by inquires and reports.
                     Required.

ICN-END-DATE         Numeric 8  (yyyymmdd)
Ending Date          Ending effective date for comment to be
                     selected by inquires and reports.
                     Required.

ICN-SYS-DATE         Numeric 8  (yyyymmdd)
System Date          System date of comment creation.
                     Required.

ICN-SYS-TIME         Numeric 6  (hhmmss)
System Time          System time of comment creation.
                     Required.

ICN-PRINT-CODE       Alpha 1
Print Code           The print code defines where the
                     comment displays and/or prints. Valid
                     values are:

                     B = Both print and display
                     D = Display only
                     P = Print only
                     R = Receiving only

                         ARICUSTCMT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICNSET1   COMPANY       The path is used to keep the records     AR501
          CUSTOMER      unique.
          SEQ-NBR