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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

DUH-COMPANY            Numeric 4                                 AR141
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

DUH-TRANS-TYPE         Alpha 1                                   AR141
Element: Transaction TyDetermines if amounts or units are
                       processed in each transaction.

DUH-INVOICE            Alpha 22                                  AR141
Element: Invoice NumberUsed 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 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
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.
                       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.  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