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

AC551     AR194     AR215     AR219     AR250     AR251
AR48.1    AR48.3    AR50.1    AR501     AR72.1    BR10.1
BR11.1    BR120     BR121     BR122     BR123     BR15.1
BR151     BR152     BR155     BR156     BR16.1    BR16.2
BR210     BR211     BR215     BR220     BR251     BR252
BR253     BR420     BR450     BR51.1    BR51.2    BR52.1
BR52.2    BR521     BR53.1    BR55.2    BR91.1    BRIP.1
BRPI.1    CB06.2    IC02.1    IC531     PBIP.1    PR197
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  AC551   AR08.1
          AGING-CODE    the aging code file.                     AR10.1  AR15.8
                                                                 AR194   AR215
                                                                 AR219   AR250
                                                                 AR251   AR48.1
                                                                 AR48.3  AR50.1
                                                                 AR501   AR72.1
                                                                 BR10.1  BR11.1
                                                                 BR120   BR121
                                                                 BR122   BR123
                                                                 BR15.1  BR151
                                                                 BR152   BR155
                                                                 BR156   BR16.1
                                                                 BR16.2  BR210
                                                                 BR211   BR215
                                                                 ...

                         AGINGCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            AGE-COMPANY    -> ACO-COMPANY