Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

AGINGCODE


                             AGINGCODE FILE

                             AR Aging Code

The AR Aging Code file contains aging code override information. To age
customers using different aging parameters than the company defaults, an aging
code is assigned. Then, when an aging is done for a single customer, using
AR50 (Customer Aging), the aging parameters of the assigned aging code are
used.

REFERENCED BY

AC56.1    AC560     AR120     AR194     AR215     AR219
AR250     AR251     AR48.1    AR48.3    AR50.1    AR501
AR72.1    BL02.1    BL04.1    BL10.1    BL120     BL121
BL122     BL123     BL125     BL130     BL20.1    BL20.3
BL20.6    BL202     BL204     BL21.2    BL21.5    BL217
BL220     BL231     BL246     BL29.1    BL29.2    BL290
BL291     BL31.1    BL31.2    BL31.3    BL31.5    BL31.7
BL32.3    BL32.4    BL33.1    BL331     BL34.1    BL46.1
BL46.2    BL520     BL530     BL546     BL80.1    BL80.3
BL802     BL81.1    BL82.1    BL820     BL85.1    BL85.2
BL90.1    BL92.1    BR00.1    BR00.2    BR02.3    BR10.1
BR10.9    BR11.1    BR120     BR121     BR122     BR123
BR140     BR151     BR152     BR155     BR156     BR16.1
BR16.2    BR17.1    BR180     BR19.1    BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR20.7    BR21.2    BR210
BR211     BR216     BR217     BR220     BR251     BR252
BR253     BR400     BR420     BR45.1    BR450     BR46.1
BR46.2    BR46.4    BR51.1    BR51.2    BR52.1    BR52.2
BR521     BR53.1    BR55.2    BR70.1    BR70.2    BR91.1
BRIP.1    CB06.2    IC02.1    PW110     TX140     TX40.1
WH110     WH120     WH130     WH132     WH190     WH20.1
WH20.2    WH20.7    WH21.2    WH224     WH226     WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.5
WH34.1    WH34.2    WH34.3    WH34.4    WH40.1    WH40.2
WH520     WH830

UPDATED BY

AR08.1    AR10.1    AR15.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

AGE-COMPANY            Numeric 4                                 AR15.8
Element: Company       The company number. Must be a valid
                       company in the AR Company file.

AGE-AGING-CODE         Numeric 2                                 AR15.8
Element: Aging Code    This is an optional aging code that may
                       be assigned to specific customers at the
                       company level. If assigned to a
                       customer, this aging code will override
                       the company level default if the
                       customer is selected for a single aging.


AGE-DESC               Alpha 30  (Lower Case)                    AR15.8
Element: Description   Description of the aging code.

AGE-AGE-CREDITS        Alpha 1                                   AR15.8
Element: Age Credits   Specifies if and how credits should be
                       aged. Valid values are:

                       L = Aged to last debit column
                       N = Not aged - current column
                       R = Aged respective to date

AGE-AGE-PYMNT          Alpha 1                                   AR15.8
Element: Age Payment   Specifies if and how payments will be
                       aged. Valid values are:

                       L = Aged to last debit column
                       N = Not aged - current column
                       R = Aged respective to date


AGE-AGE-DISPUTES       Alpha 1                                   AR15.8
Element: Age Disputes  Specifies if disputed invoices will be
                       aged. Valid values are:

                       N = Not aged - current column
                       Y = Aged respective to date

AGE-AGE-TYPE           Alpha 1                                   AR15.8
Element: Aging Method  Default aging method respecting either
                       invoice date or due date. Valid values
                       are:

                       D = Age by due date
                       T = Age by transaction date


AGE-AGE-CURRENT        Numeric 3                                 AR15.8
Element: Age Current   Used to define the transactions going
                       into the future or current aging
                       buckets. The days entered will represent
                       a cutoff into the future to divide
                       current and future.

AGE-AGE-PERIODS        Numeric 3 Occurs 4 Times                  AR15.8
Element: Aging Periods These aging days represent the last day
                       of each aging period. For example, a 30
                       entered in the 1st aging period
                       represents 1-30, and a 60 entered in the
                       2nd aging period will represent 31-60, a
                       continuation from the 1st period.

AGE-ACTIVE-STATUS      Alpha 1                                   AR15.8
Element: Active Status Indicates the status of the aging code.
                       Valid values are:

                       A = Active
                       I = Inactive

AGE-USED-FL            Alpha 1                                   AR08.1  AR10.1
Element: Used Fl       This field indicates if a specific        AR15.8
                       aging code has been used. If the record
                       has not been used (N), it may be
                       deleted. If the record has been used
                       (Y), it may only be changed to inactive
                       status. Valid values are:

                       N = No
                       Y = Yes

                         AGINGCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AGESET1   COMPANY                                                AC56.1  AC560
          AGING-CODE                                             AR08.1  AR10.1
                                                                 AR120   AR15.8
                                                                 AR194   AR215
                                                                 AR219   AR250
                                                                 AR251   AR48.1
                                                                 AR48.3  AR50.1
                                                                 AR501   AR72.1
                                                                 BL02.1  BL04.1
                                                                 BL10.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 ...

                         AGINGCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            AGE-COMPANY    -> ACO-COMPANY