Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARUSADJUST FILE

UPDATED BY

AR130     AR30.1    AR30.2    AR30.4    AR30.6    AR30.7
AR30.8    AR31.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SGM-COMPANY          Numeric 4                                   AR130   AR30.1
Company              The company number represents an            AR30.2  AR30.4
                     established company and is entered on       AR30.6  AR30.7
                     all function codes.                         AR30.8  AR31.1


SGM-TRANS-TYPE       Alpha 1                                     AR130   AR30.1
Transaction Type     Determines if amounts or units are          AR30.2  AR30.4
                     processed in each transaction.              AR30.6  AR30.7
                                                                 AR30.8  AR31.1

SGM-INVOICE          Alpha 22                                    AR130   AR30.1
Invoice Number       Used to identify the invoice.               AR30.2  AR30.4
                                                                 AR30.6  AR30.7
                                                                 AR30.8  AR31.1

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


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

SGM-SEGMENT-BLOCK    Alpha 103                                   AR130   AR30.1
User Analysis        This field identifies the user analysis     AR30.2  AR30.4
                     values included in the transaction.         AR30.6  AR30.7
                                                                 AR30.8  AR31.1
                     You can either type up to four values
                     or use Define (F6) to open the User
                     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.2  AR30.4
          INVOICE                                                AR30.6  AR30.7
          PAYMENT-SEQ                                            AR30.8  AR31.1
          ADJ-SEQ

                         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