Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            ARUPMNTHDR FILE

The AR Payment Batch file (User Analysis) connects user analysis values to the
 batch header information for payments entered into the system. Batch header
records include balancing controls, transaction dates, currency indicators and
other information regarding all payments in that batch.

UPDATED BY

AR115     AR124     AR20.1    AR21.1    AR21.2    AR21.3
AR24.1    AR30.1    AR30.2    AR30.4    AR300     AR31.1
AR35.2    AR570     AR575     AR580     CB191

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UPH-COMPANY          Numeric 4                                   AR115   AR124
Company              The company number represents an            AR20.1  AR21.1
                     established company and is entered on       AR21.2  AR21.3
                     all function codes.                         AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR300   AR31.1
                                                                 AR35.2  AR570
                                                                 AR575   AR580
                                                                 CB191

UPH-BATCH-NBR        Numeric 6                                   AR115   AR124
Batch Number         This identifies the batch the entered       AR20.1  AR21.1
                     invoices, debit memos, and credit memos     AR21.2  AR21.3
                     are a part of.                              AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR300   AR31.1
                                                                 AR35.2  AR570
                                                                 AR575   AR580
                                                                 CB191

UPH-SEGMENT-BLOCK    Alpha 103                                   AR115   AR124
User Analysis        This field identifies the user analysis     AR20.1  AR21.1
                     values included in the transaction.         AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                     You can either type up to four values       AR30.2  AR30.4
                     or use Define (F6) to open the User         AR300   AR31.1
                     Analysis Entry subform. Use this subform    AR35.2  AR570
                     to select the user analysis values you      AR575   AR580
                     want to include in the transaction. If      CB191
                     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.

                         ARUPMNTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UPHSET1   COMPANY       This is the primary index for this file. AR115   AR124
          BATCH-NBR                                              AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR24.1  AR30.1
                                                                 AR30.2  AR30.4
                                                                 AR300   AR31.1
                                                                 AR35.2  AR570
                                                                 AR575   AR580
                                                                 CB191

                         ARUPMNTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arpymnthdr     ARPYMNTHDR   Not Required

                            UPH-COMPANY      -> APH-COMPANY
                            UPH-BATCH-NBR    -> APH-BATCH-NBR