ARDUNHIST FILE

                            Dunning History

Dunning History

REFERENCED BY

AR145     AR274

UPDATED BY

AR141

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DUH-COMPANY          Numeric 4                                   AR141
Company              The company number represents an
                     established company and is entered on
                     all function codes.

DUH-CUSTOMER         Alpha 9  (Right Justified)                  AR141
Customer             This field contains the number that
                     represents a customer.

DUH-TRANS-TYPE       Alpha 1                                     AR141
Transaction Type     Determines if amounts or units are
                     processed in each transaction.


DUH-TRANS-NBR        Alpha 10  (Right Justified)                 AR141
Transaction Number   A unique, user-defined value used to
                     identify the transaction (invoice or
                     debit memo).

DUH-DUN-CYCLE-ID     Numeric 6                                   AR141
Dunning Cycle ID     Last dunning cycle ID.

DUH-DUN-PROCESS-CD   Alpha 6                                     AR141
Dunning Process Code Dunning letter process code.  A unique
                     code that represents a combination of
                     Dunning Letter options.

DUH-DUN-LEVEL        Numeric 2                                   AR141
Dunning Level        This represents the DUN-LEVEL for which
                     this transaction would be dunned in
                     isolation.  I.E.  As if it were the only
                     overdue transaction on the letter.

DUH-DUN-TEXT-CODE    Alpha 6                                     AR141
Dunning Letter text  The last dunning text code used for this
Code                 customer.  The text code represents a
                     specific dunning letter text and its
                     translations.

DUH-PAST-DUE-AMT     Signed 15.2                                 AR141
Past Due Amount      Total amount that is open on the
                     invoice in transaction currency.  This
                     amount may or may not be past due.

DUH-PRINTED-DATE     Numeric 8  (yyyymmdd)                       AR141
Printed Date         The date in which this transaction was
                     printed on the dunning letter.

DUH-TOBE-DUNNED-FL   Alpha 1                                     AR141
To Be Dunned Flag    This field indicates whether or not the
                     record is due for dunning.

DUH-COLLECTION-LVL   Alpha 1                                     AR141
Collection Level     Specifies whether this transaction
                     should be turned over to a collection
                     agency.

                         ARDUNHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DUHSET1   COMPANY       This index is used to access dunning     AR145   AR274
          CUSTOMER      history records.
          TRANS-TYPE
          TRANS-NBR
          DUN-PROCESS-CD
          DUN-LEVEL
          DUN-CYCLE-ID