Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ARUADJUST FILE

UPDATED BY

AR129     AR130     AR131     AR135     AR230     AR232
AR233     AR235     AR30.1    AR30.2    AR30.3    AR30.4
AR30.8    AR300     AR31.5    AR31.6    AR35.1    AR35.2
AR48.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AGM-COMPANY          Numeric 4                                   AR129   AR130
Company              The company number represents an            AR131   AR135
                     established company and is entered on       AR230   AR232
                     all function codes.                         AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-TRANS-TYPE       Alpha 1                                     AR129   AR130
Transaction Type     Determines if amounts or units are          AR131   AR135
                     processed in each transaction.              AR230   AR232
                                                                 AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-INVOICE          Alpha 22                                    AR129   AR130
Invoice Number       Used to identify the invoice.               AR131   AR135
                                                                 AR230   AR232
                                                                 AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-PAYMENT-SEQ      Numeric 6                                   AR129   AR130
Payment Seq          Payment Sequence. This is the generated     AR131   AR135
                     sequence number to separate individual      AR230   AR232
                     invoice payment requirements.               AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-BATCH-NBR        Numeric 6                                   AR129   AR130
Batch Number         This identifies the batch the entered       AR131   AR135
                     invoices, debit memos, and credit memos     AR230   AR232
                     are a part of.                              AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-APP-SEQ          Numeric 5                                   AR129   AR130
App Seq                                                          AR131   AR135
                                                                 AR230   AR232
                                                                 AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-ADJ-SEQ          Numeric 3                                   AR129   AR130
Adj Seq                                                          AR131   AR135
                                                                 AR230   AR232
                                                                 AR233   AR235
                                                                 AR30.1  AR30.2
                                                                 AR30.3  AR30.4
                                                                 AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-SEGMENT-BLOCK    Alpha 103                                   AR129   AR130
User Analysis        This field identifies the user analysis     AR131   AR135
                     values included in the transaction.         AR230   AR232
                                                                 AR233   AR235
                     You can either type up to four values       AR30.1  AR30.2
                     or use Define (F6) to open the User         AR30.3  AR30.4
                     Analysis Entry subform. Use this subform    AR30.8  AR300
                     to select the user analysis values you      AR31.5  AR31.6
                     want to include in the transaction. If      AR35.1  AR35.2
                     you choose to type values, use commas to    AR48.3
                     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.

                         ARUADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGMSET1   COMPANY                                                AR129   AR130
          TRANS-TYPE                                             AR131   AR135
          INVOICE                                                AR230   AR232
          PAYMENT-SEQ                                            AR233   AR235
          BATCH-NBR                                              AR30.1  AR30.2
          APP-SEQ                                                AR30.3  AR30.4
          ADJ-SEQ                                                AR30.8  AR300
                                                                 AR31.5  AR31.6
                                                                 AR35.1  AR35.2
                                                                 AR48.3

                         ARUADJUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Aradjust       ARADJUST     Not Required

                            AGM-COMPANY        -> ADJ-COMPANY
                            AGM-TRANS-TYPE     -> ADJ-TRANS-TYPE
                            AGM-INVOICE        -> ADJ-INVOICE
                            AGM-PAYMENT-SEQ    -> ADJ-PAYMENT-SEQ
                            AGM-BATCH-NBR      -> ADJ-BATCH-NBR
                            AGM-APP-SEQ        -> ADJ-APP-SEQ
                            AGM-ADJ-SEQ        -> ADJ-ADJ-SEQ