Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ARDUNSLDTL FILE

This file is generated by the DUNNING Letter Selection program (AR140).  It
contains a list of the invoices that are past due for a customer.  The records
on this file are displayed on the Dunning Letter Selection Maintenance form
(AR74.1), where the Credit Analyst has the option of either including or not
including them in the list of invoices to be included on a dunning letter.

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
Dun Cycle Id         Last dunning letter cycle ID.

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

DDL-INVOICE          Alpha 22                                    AR140   AR74.1
Invoice Number       The user-defined value identifying the
                     transaction that is past due. Open
                     transaction numbers are stored 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 Amt         Total amount that is past due on the
                     invoice in transaction currency.


DDL-TOBE-DUNNED-FL   Alpha 1                                     AR140
Tobe Dunned Fl       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
Dun Level            This represents the DUN-LEVEL for which
                     this transaction would be dunned in
                     isolation.  I.E.  As if it were the only
                     overdue transactioin on the letter.

DDL-COLLECTION-LVL   Alpha 1                                     AR140
Collection Lvl       Specifies whether this transaction
                     should be turned over to a collection
                     agency.
                     Y = Yes
                     N = No

                         ARDUNSLDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DDLSET1   COMPANY                                                AR140   AR141
          CUSTOMER                                               AR145   AR74.1
          INVOICE
          TRANS-TYPE