Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ARDUNHIST


                             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     AR300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DUH-COMPANY            Numeric 4                                 AR141
Element: Company       The number representing an AR company.

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

DUH-TRANS-TYPE         Alpha 1                                   AR141
Element: Trans Type    The transaction type.  Valid values are:

                       C = Credit Memo
                       D = Debit Memo
                       I = Invoice

DUH-INVOICE            Alpha 22                                  AR141
Element: Invoice       Used to identify the invoice.

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

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


DUH-DUN-LEVEL          Numeric 2                                 AR141
Element: Dun Level     This represents the dunning 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
Element: 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 18.2                               AR141
Element: Intl 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
Element: Printed Date  The date in which this transaction was
                       printed on the dunning letter.

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

DUH-COLLECTION-LVL     Alpha 1                                   AR141
Element: Collection LvlWhether the level indicates that the
                       invoice will be turned over to a
                       collection agency. Valid values are:
                       Y = Yes
                       N = No

                         ARDUNHIST FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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