Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARICOMMENT


                            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 and can be viewed in AR17 Comments.

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     ARLL.1    AR560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AIM-COMPANY            Numeric 4                                 ARLL.1
Element: Company       Required. The transaction company
                       number.

AIM-CUSTOMER           Alpha 9  (Right Justified)                ARLL.1
Element: Customer      Required. The customer number.

AIM-TRANS-TYPE         Alpha 1                                   ARLL.1
Element: Transaction TyRequired. Transaction type of record
                       that has comments. Valid values are:

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

AIM-INVOICE            Alpha 22                                  ARLL.1
Element: Invoice       Used to identify the invoice.

AIM-PAYMENT-SEQ        Numeric 6                                 ARLL.1
Element: Payment SequenPayment obligation sequence. Used for
                       transaction types C, D and I.

AIM-SEQ-NBR            Numeric 4                                 ARLL.1
Element: Sequence NumbeRequired. Sequence number for record
                       uniqueness.

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

AIM-BEG-DATE           Numeric 8  (yyyymmdd)                     ARLL.1
Element: Beginning DateThe beginning date that the comment
                       will be effective for displays and
                       reports.

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

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

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

AIM-PRINT-CODE         Alpha 1                                   ARLL.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 only
                       P = Print only

                         ARICOMMENT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AIMSET1   COMPANY                                                AR503   AR506
          CUSTOMER                                               AR560
          TRANS-TYPE
          INVOICE
          PAYMENT-SEQ
          SEQ-NBR

AIMSET2   COMPANY       KeyChange                                AR560
          CUSTOMER
          INVOICE
          TRANS-TYPE
          PAYMENT-SEQ
          SEQ-NBR