Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARAUDIT


                              ARAUDIT FILE

REFERENCED BY

AR285

UPDATED BY

AR09.1    AR09.4    AR10.1    AR112     AR12.1    AR12.2
AR17.1    AR301     AR501     AR550     AR70.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DIT-CUST-GROUP         Alpha 5                                   AR09.1  AR09.4
Element: Customer GroupCustomer group. Used to identify a        AR301   AR501
                       group of customer associated with one or  AR550
                       more companies.

DIT-COMPANY            Numeric 4                                 AR10.1  AR112
Element: Company       Identifies the AP company if the          AR12.1  AR12.2
                       resource type = V.  Identifies the HR     AR17.1  AR501
                       company if the resource type = E.  It is  AR550   AR70.2
                       blank for type A, P or Q resources.

DIT-CUSTOMER           Alpha 9  (Right Justified)                AR09.1  AR09.4
Element: Customer NumbeThis field contains the number that       AR10.1  AR112
                       represents a customer.                    AR12.1  AR12.2
                                                                 AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

DIT-DATE               Numeric 8  (yyyymmdd)                     AR09.1  AR09.4
Element: Date          This field displays the system date       AR10.1  AR112
                       when this was created.                    AR12.1  AR12.2
                                                                 AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

DIT-TIME               Numeric 8                                 AR09.1  AR09.4
Element: Time          This field is updated automatically to    AR10.1  AR112
                       indicate the time that the GL entry was   AR12.1  AR12.2
                       created. It is system-maintained.         AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

DIT-SEQ-NBR            Numeric 4                                 AR09.1  AR09.4
Element: Sequence NumbeAn automatically assigned sequence        AR10.1  AR112
                       number.                                   AR12.1  AR12.2
                                                                 AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

DIT-NAME               Alpha 30  (Lower Case)                    AR10.1
Element: Name          Displays the company description.

DIT-BILL-TO            Numeric 4                                 AR09.4  AR301
Element: Bill To       This field contains the mailing address   AR501
                       for the invoice.  Bill to addresses are
                       maintained in the Accounts Receviable
                       Bill To form AR09.4.

DIT-OPERATOR           Alpha 10                                  AR09.1  AR09.4
Element: Operator Code This field is used to store the login     AR10.1  AR112
                       id of the person who entered the record.  AR12.1  AR12.2
                                                                 AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

DIT-FIELD-ID           Numeric 3                                 AR09.1  AR09.4
Element: Field ID                                                AR10.1  AR112
                                                                 AR12.1  AR12.2
                                                                 AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

DIT-BEFORE-IMAGE       Alpha 32                                  AR09.1  AR09.4
Element: Before Change This field contains the field image       AR10.1  AR112
                       before the change.                        AR12.1  AR12.2
                                                                 AR17.1  AR550
                                                                 AR70.2

DIT-AFTER-IMAGE        Alpha 32                                  AR09.1  AR09.4
Element: Before Change This field contains the field image       AR10.1  AR112
                       after the change.                         AR12.1  AR12.2
                                                                 AR17.1  AR550
                                                                 AR70.2

DIT-ACTION             Alpha 1                                   AR09.1  AR09.4
Element: Action                                                  AR10.1  AR112
                                                                 AR12.1  AR12.2
                                                                 AR17.1  AR301
                                                                 AR501   AR550
                                                                 AR70.2

                         ARAUDIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DITSET1   CUST-GROUP    KeyChange                                AR301
          COMPANY
          DATE
          CUSTOMER
          TIME
          SEQ-NBR

DITSET2   CUST-GROUP                                             AR285
          COMPANY
          OPERATOR
          DATE
          CUSTOMER
          TIME
          SEQ-NBR

DITSET4   CUST-GROUP                                             AR285
          COMPANY
          CUSTOMER
          DATE
          TIME
          SEQ-NBR

DITSET5   CUST-GROUP                                             AR285
          COMPANY
          NAME
          DATE
          TIME
          SEQ-NBR