Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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.

REFERENCED BY

AR137     AR150     AR229     AR251     AR252     AR253
AR256     AR250     AR255

UPDATED BY

AR29.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ARZ-COMPANY          Numeric 4                                   AR29.3
Company              The company number represents an
                     established company and is entered on
                     all function codes.

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

                     C = Credit Memo
                     D = Debit Memo
                     I = Invoice

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

ARZ-PAYMENT-SEQ      Numeric 6                                   AR29.3
Payment Sequence     Payment Sequence. This is the generated
Number               sequence number to separate individual
                     invoice payment requirements.


ARZ-CANCEL-DATE      Numeric 8  (yyyymmdd)                       AR29.3
Cancellation Date    The cancellation date.

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

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

ARZ-ORIG-AMT         Signed 15.2                                 AR29.3
Original Amount      Transaction amount in transaction
                     currency.

ARZ-TRAN-AMT         Signed 15.2                                 AR29.3
Transaction Amount   Transaction amount.

ARZ-ACTIVITY         Alpha 15                                    AR29.3
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.


                         ARITEMAUD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ARZSET1   COMPANY       This path is used for record uniqueness. AR137   AR150
          TRANS-TYPE                                             AR229   AR251
          INVOICE                                                AR252   AR253
          PAYMENT-SEQ                                            AR256

ARZSET2   COMPANY       This path is used to validate            AR137   AR150
          CUSTOMER      transaction ownership.                   AR250   AR251
          TRANS-TYPE                                             AR253   AR255
          INVOICE
          PAYMENT-SEQ