Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARICOMMENT FILE

                      Comment Conversion/Interface

Comment Conversion/Interface

UPDATED BY

AR503     AR506     AR560

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AIM-COMPANY          Numeric 4
Company              Required. The transaction company
                     number.

AIM-CUSTOMER         Alpha 9  (Right Justified)
Customer             Required. The customer number.

AIM-TRANS-TYPE       Alpha 1
Transaction Type     Required. Transaction type of record
                     that has comments. Valid values are:

                     C = Credit Memo
                     D = Debit Memo
                     I = Invoice

AIM-TRANS-NBR        Alpha 10  (Right Justified)
Transaction Number   Required. Transaction number of record
                     that has comments. This will be a unique
                     number, within transaction type, for a
                     given credit memo, debit memo, or
                     invoice.

AIM-PAYMENT-SEQ      Numeric 6
Payment Sequence     Payment obligation sequence. Used for
                     transaction types C, D and I.

AIM-SEQ-NBR          Numeric 4
Sequence Number      Required. Sequence number for record
                     uniqueness.

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

AIM-BEG-DATE         Numeric 8  (yyyymmdd)
Beginning Date       The beginning date that the comment
                     will be effective for displays and
                     reports.

AIM-END-DATE         Numeric 8  (yyyymmdd)
Ending Date          The ending date the comment will be
                     effective for displays and reporting.

AIM-SYS-DATE         Numeric 8  (yyyymmdd)
System Date          The system date that the comment was
                     created.

AIM-SYS-TIME         Numeric 6  (hhmmss)
System Time          The system time that the comment was
                     created.

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

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

                         ARICOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIMSET1   COMPANY       The path is used to keep records         AR503   AR506
          CUSTOMER      unique.                                  AR560
          TRANS-TYPE
          TRANS-NBR
          PAYMENT-SEQ
          SEQ-NBR