Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              ARURTM FILE

The AR Return-to-maker Payment (User Analysis) file connects the user analysis
values to information about Return-to-Maker (RTM) payments.

UPDATED BY

AR282     AR300     AR82.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UTM-COMPANY          Numeric 4                                   AR282   AR300
Company              The company number represents an            AR82.1
                     established company and is entered on
                     all function codes.

UTM-CUSTOMER         Alpha 9  (Right Justified)                  AR282   AR300
Customer Number      This field contains the number that         AR82.1
                     represents a customer.

UTM-TRANS-NBR        Alpha 10  (Right Justified)                 AR282   AR300
Trans Nbr            A unique, user-defined value used to        AR82.1
                     identify the transaction.

UTM-BATCH-NBR        Numeric 6                                   AR282   AR300
Batch Number         This identifies the batch the entered       AR82.1
                     invoices, debit memos, and credit memos
                     are a part of.

UTM-SEQ              Numeric 3                                   AR282   AR300
Sequence Number      This field contains the record sequence     AR82.1
                     number.

UTM-SEGMENT-BLOCK    Alpha 103                                   AR282   AR300
User Analysis        This field identifies the user analysis     AR82.1
                     values included in the transaction.

                     You can either type up to four values
                     or use Define (F6) to open the User
                     Analysis Entry subform. Use this subform
                     to select the user analysis values you
                     want to include in the transaction. If
                     you choose to type values, use commas to
                     separate them. For example:
                     value1,value2,value3,value4

                     There are three conditions that affect
                     how you can select user analysis values.
                     See the User Analysis Entry form help or
                     the Strategic Ledger procedures manual
                     for additional information.

                         ARURTM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UTMSET1   COMPANY       This is the primary index for this file. AR282   AR300
          CUSTOMER                                               AR82.1
          TRANS-NBR
          BATCH-NBR
          SEQ

                         ARURTM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arrtm          ARRTM        Not Required

                            UTM-COMPANY      -> RTM-COMPANY
                            UTM-CUSTOMER     -> RTM-CUSTOMER
                            UTM-TRANS-NBR    -> RTM-TRANS-NBR
                            UTM-BATCH-NBR    -> RTM-BATCH-NBR