ARDUNSLDTL FILE

                        Dunning Selection Detail

Dunning Selection Detail

REFERENCED BY

AR141

UPDATED BY

AR140     AR145     AR74.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

DDL-DUN-CYCLE-ID     Numeric 6                                   AR140
Dunning Cycle ID     Cycle ID generated by the Dunning
                     Letter Selection program (AR140) that
                     also generated dunning transaction
                     records  for this file.  The  cycle ID
                     is  incremented by 1 each time  you run
                     AR140.

DDL-CUSTOMER         Alpha 9  (Right Justified)                  AR140   AR74.1
Customer Number      Customer to whom dunning letter is to be
                     sent.

DDL-TRANS-NBR        Alpha 10  (Right Justified)                 AR140   AR74.1
Transaction Number   The user-defined value identifying the
                     transaction that is past due. Open
                     transactions numbers are stored in in
                     the AROITEMS file.

DDL-TRANS-TYPE       Alpha 1                                     AR140   AR74.1
Transaction Type     Type of transaction (Debit Memo or
                     Invoice).

DDL-DUE-DATE         Numeric 8  (yyyymmdd)                       AR140   AR74.1
Due Date             The transaction due date.

DDL-PAST-DUE-AMT     Signed 15.2                                 AR140
Past Due Amount      Total amount that is open on the invoice
                     in transaction currency.

DDL-TOBE-DUNNED-FL   Alpha 1                                     AR140
To Be Dunned Flag    This field indicates whether or not the
                     record is due for dunning.
                     Y = Yes
                     N = No

DDL-ORIG-AMT         Signed 15.2                                 AR140
Original Amount      The original amount of the transaction.
                     This field is populated from  the field
                     ORIG-AMT within the AROITEMS  file.

DDL-DUN-LEVEL        Numeric 2                                   AR140
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.

DDL-COLLECTION-LVL   Alpha 1                                     AR140
Collection Level     Specifies whether this transaction
                     should be turned over to a collection
                     agency.
                     Y = Send to collection
                     N = Do not send to collection

                         ARDUNSLDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DDLSET1   COMPANY       Accesses individual transaction records  AR140   AR141
          CUSTOMER      selected for dunning for a customer      AR145   AR74.1
          TRANS-NBR     within a  company
          TRANS-TYPE