Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ARFINRATE FILE

This file is used to store finance charges by date. At least one record per
financial charge code has to exist.

REFERENCED BY

AR137     AR207

UPDATED BY

AR07.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AFR-FIN-CHRG-CD      Alpha 2                                     AR07.2
Finance Charge Code  Finance charge code. At least one
                     effective rate and charge rate must be
                     attached to a finance charge code.
                     Multiple effective dates and rates can
                     be attached.

AFR-EFF-DATE         Numeric 8  (yyyymmdd)                       AR07.2
Effective Date       Effective date for the charge rate.

AFR-CHRG-RATE        Percent 7.5  (Percent)                      AR07.2
Charge Rate          Charge Rate by month. A charge rate is
                     specified for each effective date.

                         ARFINRATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AFRSET1   FIN-CHRG-CD   This path is used for record uniqueness  AR07.1  AR07.2
          EFF-DATE      and record selection.                    AR137   AR207

AFRSET2   FIN-CHRG-CD   This path is used for record uniqueness  AR137
          EFF-DATE*     and record selection.