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) for example, the aging parameters of the assigned aging
code are used.

REFERENCED BY

AR194     AR215     AR219     AR250     AR251     AR48.1
AR48.3    AR50.1    AR501     AR72.1    BL02.1    BL04.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    BR11.1    BR120     BR121     BR122
BR140     BR16.1    BR17.1    BR19.1    BR20.1    BR20.2
BR20.3    BR20.4    BR20.5    BR20.7    BR21.2    BR210
BR211     BR216     BR217     BR220     BR400     BR420
BR45.1    BR450     BR46.1    BR46.2    BR46.4    BR521
BRIP.1    CB06.2    IC02.1    IC531     OE10.1    OE10.2
OE10.3    OE10.4    OE10.5    OE10.6    OE10.7    OE10.8
OE11.1    OE11.4    OE11.8    OE11.9    OE110     OE111
OE112     OE113     OE114     OE116     OE129     OE13.2
OE13.3    OE13.5    OE13.6    OE130     OE14.3    OE14.4
OE16.1    OE230     OE254     OE260     OE270     OE271
OE272     OE284     OE285     OE286     OE290     OE291
OE292     OE293     OE294     OE30.1    OE30.2    OE30.3
OE30.4    OE30.5    OE30.6    OE30.7    OE30.9    OE330
OE510     OE53.1    OE530     OE54.1    OE60.1    OE80.1
OE80.2    OE81.1    OE81.2    OE810     OE830     OE85.1
OE85.3    OE86.1    OE90.1    OE90.2    PBIP.1    PR197
SA03.1    SA100     SA252     SA254     SA256     SA261
SA271     SA281     SA291     SA300     SA80.2    SA90.2
TX140     TX40.1    WH110     WH120     WH130     WH132
WH190     WH20.1    WH20.2    WH20.7    WH21.2    WH224
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     WO30.1

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: 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          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       This is the primary path used to access  AR08.1  AR10.1
          AGING-CODE    the aging code file.                     AR15.8  AR194
                                                                 AR215   AR219
                                                                 AR250   AR251
                                                                 AR48.1  AR48.3
                                                                 AR50.1  AR501
                                                                 AR72.1  BL02.1
                                                                 BL04.1  BL120
                                                                 BL121   BL122
                                                                 BL123   BL125
                                                                 BL130   BL20.1
                                                                 BL20.3  BL20.6
                                                                 BL202   BL204
                                                                 BL21.2  BL21.5
                                                                 BL217   BL220
                                                                 ...

                         AGINGCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            AGE-COMPANY    -> ACO-COMPANY