Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARUSADJUST


                            ARUSADJUST FILE

UPDATED BY

AR130     AR30.1    AR30.3    AR30.6    AR30.7    AR30.8
AR31.1    AR33.3    AR34.1    AR34.2    AR34.3    AR34.4

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SGM-COMPANY            Numeric 4                                 AR130   AR30.1
Element: Company       Identifies the AP company if the          AR30.3  AR30.6
                       resource type = V.  Identifies the HR     AR30.7  AR30.8
                       company if the resource type = E.  It is  AR31.1  AR33.3
                       blank for type A, P or Q resources.       AR34.1  AR34.2
                                                                 AR34.3  AR34.4

SGM-TRANS-TYPE         Alpha 1                                   AR130   AR30.1
Element: Transaction TyDetermines if amounts or units are        AR30.3  AR30.6
                       processed in each transaction.            AR30.7  AR30.8
                                                                 AR31.1  AR33.3
                                                                 AR34.1  AR34.2
                                                                 AR34.3  AR34.4

SGM-INVOICE            Alpha 22                                  AR130   AR30.1
Element: Invoice NumberUsed to identify the invoice.             AR30.3  AR30.6
                                                                 AR30.7  AR30.8
                                                                 AR31.1  AR33.3
                                                                 AR34.1  AR34.2
                                                                 AR34.3  AR34.4

SGM-PAYMENT-SEQ        Numeric 6                                 AR130   AR30.1
Record Sequence        Payment Sequence. This is the generated   AR30.3  AR30.6
Number                 sequence number to separate individual    AR30.7  AR30.8
                       invoice payment requirements.             AR31.1  AR33.3
                                                                 AR34.1  AR34.2
                                                                 AR34.3  AR34.4

SGM-ADJ-SEQ            Numeric 3                                 AR130   AR30.1
Element: Adj Seq                                                 AR30.3  AR30.6
                                                                 AR30.7  AR30.8
                                                                 AR31.1  AR33.3
                                                                 AR34.1  AR34.2
                                                                 AR34.3  AR34.4

SGM-SEGMENT-BLOCK      Alpha 103                                 AR130   AR30.1
Element: User Analysis This field identifies the user analysis   AR30.3  AR30.6
                       values included in the transaction.       AR30.7  AR30.8
                                                                 AR31.1  AR33.3
                       You can either type up to four values     AR34.1  AR34.2
                       or use Define (F6) to open the User       AR34.3  AR34.4
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       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.

                         ARUSADJUST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGMSET1   COMPANY                                                AR130   AR30.1
          TRANS-TYPE                                             AR30.3  AR30.6
          INVOICE                                                AR30.7  AR30.8
          PAYMENT-SEQ                                            AR31.1  AR33.3
          ADJ-SEQ                                                AR34.1  AR34.2
                                                                 AR34.3  AR34.4

                         ARUSADJUST FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arsadjust      ARSADJUST    Not Required

                            SGM-COMPANY        -> ASJ-COMPANY
                            SGM-TRANS-TYPE     -> ASJ-TRANS-TYPE
                            SGM-INVOICE        -> ASJ-INVOICE
                            SGM-PAYMENT-SEQ    -> ASJ-PAYMENT-SEQ
                            SGM-ADJ-SEQ        -> ASJ-ADJ-SEQ