Lawson Insight Technical Documentation

                            ARUSADJUST FILE

This file contains the User Analysis value associated with selected cash
application adjustment records.

UPDATED BY

AR130     AR30.1    AR30.3    AR30.6    AR30.7    AR30.8
AR32.1    AR32.3    AR33.3    AR34.1    AR34.2    AR34.3
AR34.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SGM-COMPANY            Numeric 4                                 AR130   AR30.1
Element: Company       The number representing an AR company.    AR30.3  AR30.6
                                                                 AR30.7  AR30.8
                                                                 AR32.1  AR32.3
                                                                 AR33.3  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4

SGM-TRANS-TYPE         Alpha 1                                   AR130   AR30.1
Element: Trans Type    The transaction type of the adjustment.   AR30.3  AR30.6
                       Valid values are:                         AR30.7  AR30.8
                                                                 AR32.1  AR32.3
                       C = Credit Memo                           AR33.3  AR34.1
                       D = Debit Memo                            AR34.2  AR34.3
                       I = Invoice                               AR34.4

SGM-INVOICE            Alpha 22                                  AR130   AR30.1
Element: Invoice       Used to identify the invoice, credit      AR30.3  AR30.6
                       memo, or debit memo.                      AR30.7  AR30.8
                                                                 AR32.1  AR32.3
                                                                 AR33.3  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4

SGM-PAYMENT-SEQ        Numeric 6                                 AR130   AR30.1
Element: Seq Number    Payment Sequence. This is the generated   AR30.3  AR30.6
                       sequence number to separate individual    AR30.7  AR30.8
                       invoice, credit memo, or debit memo       AR32.1  AR32.3
                       payment requirements.                     AR33.3  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4

SGM-ADJ-SEQ            Numeric 3                                 AR130   AR30.1
Element: Adj Seq       The adjustment sequence number.           AR30.3  AR30.6
                                                                 AR30.7  AR30.8
                                                                 AR32.1  AR32.3
                                                                 AR33.3  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4

SGM-SEGMENT-BLOCK      Alpha 103                                 AR130   AR30.1
Element: Segment Block This field contains the user analysis     AR30.3  AR30.6
                       values for the associated adjustment.     AR30.7  AR30.8
                       Commas separate user analysis values.     AR32.1  AR32.3
                                                                 AR33.3  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4

                         ARUSADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGMSET1   COMPANY                                                AR130   AR30.1
          TRANS-TYPE                                             AR30.3  AR30.6
          INVOICE                                                AR30.7  AR30.8
          PAYMENT-SEQ                                            AR32.1  AR32.3
          ADJ-SEQ                                                AR33.3  AR34.1
                                                                 AR34.2  AR34.3
                                                                 AR34.4

                         ARUSADJUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arsadjust      ARSADJUST    Not Required

                            SGM-COMPANY        -> ASJ-COMPANY
                            SGM-TRANS-TYPE     -> ASJ-TRANS-TYPE
                            SGM-INVOICE        -> ASJ-INVOICE
                            SGM-PAYMENT-SEQ    -> ASJ-PAYMENT-SEQ
                            SGM-ADJ-SEQ        -> ASJ-ADJ-SEQ