Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

AC551     AR194     AR215     AR219     AR250     AR251
AR48.1    AR48.3    AR50.1    AR501     AR72.1    BL02.1
BL04.1    BL121     BL123     BL125     BL202     BL204
BL217     BL220     BL231     BL246     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
BL80.1    BL80.3    BL802     BL81.1    BL82.1    BL85.1
BL85.2    BL90.1    BR10.1    BR11.1    BR120     BR121
BR210     BR211     BR220     BR420     BR450     BRIP.1
IC02.1    PR197     TX140     TX40.1    WH110     WH120
WH130     WH21.2    WH33.1    WH33.2    WH33.3    WH33.4
WH33.5    WH33.6    WH33.8    WH33.9    WH34.1    WH34.2
WH34.3    WH34.4

UPDATED BY

AR08.1    AR15.8

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

AGE-AGING-CODE       Numeric 2                                   AR15.8
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
Description          Description of the aging code.

AGE-AGE-CREDITS      Alpha 1                                     AR15.8
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
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
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
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
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
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
Status               Indicates the status of the aging code.
                     Valid values are:

                     A = Active
                     I = Inactive

AGE-USED-FL          Alpha 1                                     AR08.1  AR15.8
Used                 This field indicates if a specific
                     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  AC551   AR08.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  BL121
                                                                 BL123   BL125
                                                                 BL202   BL204
                                                                 BL217   BL220
                                                                 BL231   BL246
                                                                 BL290   BL291
                                                                 BL31.1  BL31.2
                                                                 BL31.3  BL31.5
                                                                 ...

                         AGINGCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            AGE-COMPANY    -> ACO-COMPANY