Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARITEMAUD


                             ARITEMAUD FILE

                            Open Item Audit

The Item Audit file is used to reconstruct a point-in-time view of the open
item records that have been transferred.  This file is used mainly is "as of"
date type programs such as aging reports.

REFERENCED BY

AR115     AR129     AR130     AR131     AR135     AR137
AR150     AR180     AR190     AR194     AR196     AR198
AR20.1    AR21.1    AR21.2    AR21.3    AR229     AR250
AR251     AR252     AR253     AR255     AR256     AR257
AR275     AR30.1    AR30.8    AR32.1    AR33.1    AR33.3
AR33.5    AR33.6    AR34.1    AR35.1    AR35.2    AR37.1
AR37.2    AR37.3    AR37.4    AR37.5    AR37.6    AR37.7
AR38.1    AR38.2    AR38.3    AR39.1    AR39.2    AR42.1
AR42.2    AR42.6    AR42.7    AR43.1    AR44.3    AR45.1
AR48.3    AR502     AR504     AR506     AR525     AR560
AR80.1    AR80.2    AR800     ARLL.1    CB06.2    DT150


UPDATED BY

AR29.3    AR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARZ-COMPANY            Numeric 4                                 AR29.3
Element: Company       The number representing an AR company.

ARZ-TRANS-TYPE         Alpha 1                                   AR29.3
Element: Trans Type    Indicates the transaction type. Valid
                       value are

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

ARZ-INVOICE            Alpha 22                                  AR29.3
Element: Invoice       Used to identify the invoice.

ARZ-PAYMENT-SEQ        Numeric 6                                 AR29.3
Payment Sequence       A unique number assigned to each
Number                 transaction to be interfaced into the
                       Lawson system.

ARZ-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AR29.3
Element: Cancellation DThe reassign date as specified in
                       AR29.3.

ARZ-CUSTOMER           Alpha 9  (Right Justified)                AR29.3
Element: Customer      Customer number.

ARZ-DUE-DATE           Numeric 8  (yyyymmdd)                     AR29.3
Element: Due Date      The transaction due date.

ARZ-ORIG-AMT           Signed 18.2                               AR29.3
Element: Intl Amt      Transaction amount in transaction
                       currency.

ARZ-TRAN-AMT           Signed 18.2                               AR29.3
Element: Intl Amt      Transaction amount in company base
                       currency.

ARZ-ACTIVITY           Alpha 15                                  AR29.3
Element: Activity      The Activity value of the transaction.

ARZ-OPR-CODE           Alpha 10  (Lower Case)
Element: Opr Code      This field contains the user's login
                       code during the transfer payment
                       process.

                         ARITEMAUD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARZSET1   COMPANY                                                AR115   AR129
          TRANS-TYPE                                             AR130   AR131
          INVOICE                                                AR135   AR137
          PAYMENT-SEQ                                            AR150   AR180
                                                                 AR190   AR194
                                                                 AR196   AR198
                                                                 AR20.1  AR21.1
                                                                 AR21.2  AR21.3
                                                                 AR229   AR250
                                                                 AR251   AR252
                                                                 AR253   AR255
                                                                 AR256   AR257
                                                                 AR275   AR29.3
                                                                 AR30.1  AR30.8
                                                                 AR300   AR32.1
                                                                 ...

ARZSET2   COMPANY                                                AR137   AR150
          CUSTOMER                                               AR250   AR251
          TRANS-TYPE                                             AR253   AR255
          INVOICE                                                AR257
          PAYMENT-SEQ