ARDUNNING FILE

                           AR Dunning Letters

AR Dunning Letters

REFERENCED BY

AR160     AR161     AR17.1    AR218

UPDATED BY

AR01.1    AR18.1    AR70.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DNN-COMPANY          Numeric 4                                   AR18.1
Company              Company number.

DNN-DUNNING-NBR      Numeric 2                                   AR18.1
Dunning Number       Dunning text number. Up to 99 sets of
                     text may be created.

DNN-DUNNING-TEXT     Alpha 55 Occurs 6 Times                     AR18.1
Dunning Text         Dunning text line text, in the language
                     represented by the language code. This
                     is free formatted text that will print
                     on past due notices.

DNN-USED-FL          Alpha 1                                     AR70.2
Used Flag            Indicates whether this dunning letter
                     has been used. Valid values are:

                     N = Not used
                     Y = Used

DNN-LANGUAGE-CODE    Alpha 10                                    AR18.1
Language Code        The language code representing the
                     language in which the dunning text is
                     written. If no language code is
                     specified, the company base language is
                     assumed. The language code must be
                     defined in IFLC.1 (Language Code
                     Maintenance).

                         ARDUNNING FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DNNSET1   COMPANY       The path is used to keep the records     AR01.1  AR160
          DUNNING-NBR   unique.                                  AR161   AR17.1
          LANGUAGE-CODE                                          AR18.1  AR218
                                                                 AR70.2

                         ARDUNNING FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            DNN-COMPANY    -> ACO-COMPANY