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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ARZ-COMPANY            Numeric 4                                 AR29.3
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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       Payment Sequence. This is the generated
Number                 sequence number to separate individual
                       invoice payment requirements.


ARZ-CANCEL-DATE        Numeric 8  (yyyymmdd)                     AR29.3
Element: Cancellation DThe cancellation date.

ARZ-CUSTOMER           Alpha 9  (Right Justified)                AR29.3
Element: Customer NumbeCustomer 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.

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

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