Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              ARURTM FILE

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                                                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