Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARUADJUST


                             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
Element: 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
Element: Transaction TyDetermines 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
Element: Invoice NumberUsed 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
Record Sequence                                                  AR131   AR135
Number                                                           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-BATCH-NBR          Numeric 6                                 AR129   AR130
Element: 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
Element: 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
Element: Sequence Number                                         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
Element: 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