Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARICOMMENT FILE

                      Comment Conversion/Interface

The AR Comment Conversion/Interface file is used to interface and convert
comment records for invoice, debit memo and credit memo transactions. Once
interfaced or converted, these comments will reside in the Accounts Receivable
comment file.

Note: When you are converting, these records are loaded by AR503 (Payment
Conversion) and AR506 (Dispute and Comment Conversion). When you are
interfacing, these records are loaded by AR560 (Transaction Interface0.

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-INVOICE          Alpha 22
Invoice Number       Used to identify the 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
          INVOICE
          PAYMENT-SEQ
          SEQ-NBR