Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARURTM


                              ARURTM FILE

This file contains the User Analysis values associated with expense
transactions with an RTM payment.

UPDATED BY

AR282     AR300     AR82.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

UTM-COMPANY            Numeric 4                                 AR282   AR300
Element: Company       The number representing an AR company.    AR82.1

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

UTM-TRANS-NBR          Alpha 10  (Right Justified)               AR282   AR300
Element: Trans Nbr     The payment number.                       AR82.1

UTM-BATCH-NBR          Numeric 6                                 AR282   AR300
Element: Batch Nbr     This identifies the payment batch.        AR82.1

UTM-SEQ                Numeric 3                                 AR282   AR300
Element: Seq           This field contains the record sequence   AR82.1
                       number.

UTM-SEGMENT-BLOCK      Alpha 103                                 AR282   AR300
Element: Segment Block This field contains the user analysis     AR82.1
                       values for the expenses of an RTM
                       payment.  Commas separate user analysis
                       values.

                         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