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.

REFERENCED BY

AR137     AR150     AR229     AR250     AR251     AR252
AR253     AR256     AR255

UPDATED BY

AR29.3    AR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

ARZ-TRANS-TYPE         Alpha 1                                   AR29.3
Element: Transaction TyIndicates the transaction type. Valid
                       value are

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

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

ARZ-PAYMENT-SEQ        Numeric 6                                 AR29.3
Payment Sequence
Number

ARZ-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AR29.3
Element: Cancellation Date

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

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

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

ARZ-TRAN-AMT           Signed 15.2                               AR29.3
Element: Adj Amt       Transaction amount.

ARZ-ACTIVITY           Alpha 15                                  AR29.3
Element: 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   AR250
          INVOICE                                                AR251   AR252
          PAYMENT-SEQ                                            AR253   AR256
                                                                 AR300

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