Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ARDUNHIST FILE

                           AR Dunning History

This file maintains dunning history records.  It keeps track of the status of
the dunning cycle ID (Selected, Printed, Complete, or Historical) and of the
last dunning level applied to transactions.

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 Number      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-INVOICE          Alpha 22                                    AR141
Invoice Number       Used to identify the invoice.

DUH-DUN-CYCLE-ID     Numeric 6                                   AR141
Dun Cycle Id         Last dunning letter cycle ID.

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


DUH-DUN-LEVEL        Numeric 2                                   AR141
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 transaction on the letter.

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

DUH-PAST-DUE-AMT     Signed 15.2                                 AR141
Past Due Amt         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
Tobe Dunned Fl       This field indicates whether or not the
                     record is due for dunning.
                     Y = Yes
                     N = No

DUH-COLLECTION-LVL   Alpha 1                                     AR141
Collection Lvl       Whether the level indicates that the
                     invoice will be turned over to a
                     collection agency.  Yes or No.

                     Y = Yes
                     N = No

                         ARDUNHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DUHSET1   COMPANY                                                AR145   AR274
          CUSTOMER
          TRANS-TYPE
          INVOICE
          DUN-PROCESS-CD
          DUN-LEVEL
          DUN-CYCLE-ID