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.8    AR300     AR31.5
AR31.6    AR33.1    AR33.3    AR33.5    AR33.6    AR34.1
AR35.1    AR35.2    AR48.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AGM-COMPANY            Numeric 4                                 AR129   AR130
Element: Company       Identifies the AP company if the          AR131   AR135
                       resource type = V.  Identifies the HR     AR230   AR232
                       company if the resource type = E.  It is  AR233   AR235
                       blank for type A, P or Q resources.       AR30.1  AR30.8
                                                                 AR300   AR31.5
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 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.8
                                                                 AR300   AR31.5
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 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.8
                                                                 AR300   AR31.5
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 AR35.1  AR35.2
                                                                 AR48.3

AGM-PAYMENT-SEQ        Numeric 6                                 AR129   AR130
Record Sequence        Payment Sequence. This is the generated   AR131   AR135
Number                 sequence number to separate individual    AR230   AR232
                       invoice payment requirements.             AR233   AR235
                                                                 AR30.1  AR30.8
                                                                 AR300   AR31.5
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 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.8
                                                                 AR300   AR31.5
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 AR35.1  AR35.2
                                                                 AR48.3

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

AGM-ADJ-SEQ            Numeric 3                                 AR129   AR130
Element: Adj Seq                                                 AR131   AR135
                                                                 AR230   AR232
                                                                 AR233   AR235
                                                                 AR30.1  AR30.8
                                                                 AR300   AR31.5
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 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.8
                       or use Define (F6) to open the User       AR300   AR31.5
                       Analysis Entry subform. Use this subform  AR31.6  AR33.1
                       to select the user analysis values you    AR33.3  AR33.5
                       want to include in the transaction. If    AR33.6  AR34.1
                       you choose to type values, use commas to  AR35.1  AR35.2
                       separate them. For example:               AR48.3
                       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.8
          APP-SEQ                                                AR300   AR31.5
          ADJ-SEQ                                                AR31.6  AR33.1
                                                                 AR33.3  AR33.5
                                                                 AR33.6  AR34.1
                                                                 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