Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             AR50WORK FILE

                             AR50 Work File

AR50 Work File

UPDATED BY

AR50.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

A50-NAME-USER        Alpha 12                                    AR50.1
User Name            User name. Used for record uniqueness.

A50-PERIOD           Numeric 2                                   AR50.1
Aging Period         The aging period number that identifies
                     the aged time reference for this
                     transaction.

A50-TRANS-DATE       Numeric 8  (yyyymmdd)                       AR50.1
Transaction Date     Date of the transaction.

A50-TRANS-TYPE       Alpha 1                                     AR50.1
Transaction Type     Indicates transaction type. Valid
                     values are:

                     1 = Invoice
                     2 = Debit memo
                     3 = Payments
                     4 = Credit memo
                     5 = Bill of Exchange

A50-TRANS-NBR        Alpha 10  (Right Justified)                 AR50.1
Transaction Number   Transaction number.

A50-PAYMENT-SEQ      Numeric 6                                   AR50.1
Payment Sequence     Payment Sequence. This is the generated
                     sequence number to separate individual
                     transaction payment requirements.

A50-COMPANY          Numeric 4                                   AR50.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

A50-CUSTOMER         Alpha 9  (Right Justified)                  AR50.1
Customer             Customer number identifying a unique
                     customer.

A50-BATCH-NBR        Numeric 6                                   AR50.1
Batch Number         Identifies the batch the transactions
                     are a part of.

A50-SEQ-NBR          Numeric 4                                   AR50.1
Sequence Number      The automatically assigned sequence
                     number.

A50-COMP             Numeric 4                                   AR50.1
Transaction Company  Transaction company.

A50-CUST             Alpha 9                                     AR50.1
Transaction Customer The transaction customer.

A50-PROCESS-LEVEL    Alpha 5                                     AR50.1
Process Level        The process level of the transaction.

A50-DUE-DATE         Numeric 8  (yyyymmdd)                       AR50.1
Due Date             The due date of the transaction.

A50-TRAN-AMT         Signed 15.2                                 AR50.1
Transaction Amount   The transaction amount in company base
                     or customer group currency.

A50-APPLD-AMT        Signed 15.2                                 AR50.1
Applied Amount       The applied amount of the transaction.
                     This is used to calculate the open
                     amount.

A50-ADJ-AMT          Signed 15.2                                 AR50.1
Adjustment Amount    The adjustment amount of the
                     transaction. This is used in the
                     calculation of the open amount.

A50-ORIG-RATE        Signed 12.6                                 AR50.1
Exchange Rate        The exchange rate of the transaction.

A50-CURR-MUDV        Alpha 1                                     AR50.1
Currency             The currency multiply/divide indicator.
Multiply/Divide

A50-TRAN-TYPE        Alpha 1                                     AR50.1
Cross Reference      The cross reference transaction type.
Trans Type

A50-XREF-NBR         Alpha 10                                    AR50.1
Cross Reference      The cross reference transaction number.
Number

A50-DRAFT-SOURCE     Alpha 1                                     AR50.1
Bill of Exchange     The source of the bill of exchange.
Source

A50-ORIG-CURRENCY    Alpha 5                                     AR50.1
Original Currency    The transaction currency of the open
                     item.

                         AR50WORK FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

A50SET1   NAME-USER     This path is used to display selected    AR50.1  AR50.2
          PERIOD        transactions in AR50.
          TRANS-DATE
          TRANS-TYPE
          TRANS-NBR
          PAYMENT-SEQ
          COMPANY
          CUSTOMER
          BATCH-NBR
          SEQ-NBR