Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                              APUAVAL FILE

This file stores the user analysis values defined for transactions. The
values represent information your organization can use to measure
profitability. Data is written to this file as you create items. You must run
the posting program to interface the information to Strategic Ledger. For
additional information on user analysis values, see the Strategic Ledger
Procedures Manual.

REFERENCED BY

AP175

UPDATED BY

AP125     AP126     AP170     AP193     AP20.1    AP20.2
AP20.5    AP20.7    AP225     AP226     AP23.1    AP25.1
AP25.2    AP26.1    AP30.2    AP30.4    AP300     AP305
AP32.2    AP520     EE135     EE35.1    EE35.2    EE520
MA40.1    MA40.2    MA41.1    MA41.2    MA41.4    MA41.5
MA41.6    MA43.1    MA43.2    MA43.3    MA43.4    MA52.1
MA530     MA540     PO31.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UAV-SEG-TYPE         Alpha 1                                     AP125   AP126
Seg Type             Segment type.                               AP20.1  AP20.2
                                                                 AP20.5  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP520   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA40.1
                                                                 MA40.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA530
                                                                 MA540   PO31.1

UAV-API-OBJ-ID       Numeric 12                                  AP125   AP126
Api Obj Id           A unique identifier assigned to this        AP170   AP193
                     record.                                     AP20.1  AP20.2
                                                                 AP20.5  AP20.7
                                                                 AP225   AP226
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP32.2
                                                                 AP520   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA40.1
                                                                 MA40.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA530
                                                                 MA540   PO31.1

UAV-DIST-SEQ-NBR     Numeric 4                                   AP125   AP126
Distribution         A unique sequence number.                   AP170   AP20.1
Sequence Number                                                  AP20.2  AP20.5
                                                                 AP20.7  AP225
                                                                 AP226   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP30.2
                                                                 AP30.4  AP32.2
                                                                 AP520   EE135
                                                                 EE35.1  EE35.2
                                                                 EE520   MA40.1
                                                                 MA40.2  MA41.1
                                                                 MA41.2  MA41.4
                                                                 MA41.5  MA41.6
                                                                 MA43.1  MA43.2
                                                                 MA43.3  MA43.4
                                                                 MA52.1  MA530
                                                                 MA540   PO31.1

UAV-SEGMENT-BLOCK    Alpha 103                                   AP125   AP126
User Analysis        This field identifies the user analysis     AP20.1  AP20.2
                     values included in the transaction.         AP20.5  AP20.7
                                                                 AP225   AP226
                     You can either type up to four values       AP23.1  AP25.1
                     or use Define (F6) to open the User         AP25.2  AP26.1
                     Analysis Entry subform. Use this subform    AP30.2  AP32.2
                     to select the user analysis values you      AP520   EE135
                     want to include in the transaction. If      EE35.1  EE35.2
                     you choose to type values, use commas to    EE520   MA40.1
                     separate them. For example:                 MA40.2  MA41.1
                     value1,value2,value3,value4                 MA41.2  MA41.4
                                                                 MA41.5  MA41.6
                     There are three conditions that affect      MA43.1  MA43.2
                     how you can select user analysis values.    MA43.3  MA43.4
                     See the User Analysis Entry form help or    MA52.1  MA530
                     the Strategic Ledger procedures manual      MA540   PO31.1
                     for additional information.

                         APUAVAL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UAVSET1   SEG-TYPE      Used to determine if user analysis       AP170   AP175
          API-OBJ-ID    values exist for an expense              AP193   AP20.1
          DIST-SEQ-NBR  distribution.                            AP20.2  AP20.5
                                                                 AP20.7  AP225
                                                                 AP226   AP23.1
                                                                 AP25.2  AP26.1
                                                                 AP30.2  AP30.4
                                                                 AP300   AP305
                                                                 AP32.2  MA40.1
                                                                 MA40.2  MA41.1
                                                                 MA41.2  MA41.3
                                                                 MA41.4  MA41.5
                                                                 MA41.6  MA43.1
                                                                 MA43.2  MA43.3
                                                                 MA43.4  MA52.1
                                                                 ...

UAVSET2   API-OBJ-ID    Used to determine if user analysis
          DIST-SEQ-NBR  values exist for an invoice.
          SEG-TYPE