Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDUNSLDTL


                            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
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

DDL-DUN-CYCLE-ID       Numeric 6                                 AR140
Element: Dun Cycle Id  Last dunning letter cycle ID.

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

DDL-INVOICE            Alpha 22                                  AR140   AR74.1
Element: Invoice NumberThe 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
Element: Transaction TyType of transaction (Debit Memo or
                       Invoice).

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

DDL-PAST-DUE-AMT       Signed 15.2                               AR140
Element: Past Due Amt  Total amount that is past due on the
                       invoice in transaction currency.

DDL-TOBE-DUNNED-FL     Alpha 1                                   AR140
Element: Tobe Dunned FlThis field indicates whether or not the
                       record is due for dunning.
                       Y = Yes
                       N = No

DDL-ORIG-AMT           Signed 15.2                               AR140
Element: Adj Amt       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
Element: 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
Element: Collection LvlSpecifies 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