Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             AGINGCODE FILE

                             AR Aging Code

AR Aging Code

REFERENCED BY

AC115     AC15.1    AC15.2    AC450     AR194     AR215
AR250     AR251     AR50.1    AR501     AR72.1    AR73.1
BL02.1    BL02.2    BL04.1    BL120     BL121     BL122
BL123     BL130     BL20.1    BL20.3    BL202     BL204
BL21.2    BL21.5    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     BL80.1    BL80.3
BL802     BL81.1    BL820     BL85.1    BL85.2    BL90.1
BL902     BL92.1    BL940     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     OE112     OE113
OE114     OE129     OE130     OE14.3    OE14.4    OE15.1
OE15.2    OE15.3    OE15.4    OE15.5    OE15.7    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
OE54.1    OE60.1    OE80.1    OE80.2    OE81.1    OE81.2
OE810     OE830     OE85.1    OE90.1    OE90.2    OE920
OE950     PBIP.1    SA03.1    SA100     SA252     SA254
SA256     SA261     SA271     SA281     SA291     SA300
SA80.2    SA90.2    TX140     TX40.1    WH110     WH120
WH130     WH132     WH190     WH20.2    WH20.7    WH21.2
WH30.1    WH30.2    WH30.3    WH31.1    WH31.2    WH31.3
WH32.1    WH32.2    WH32.3    WH33.5    WH34.1    WH34.2
WH34.3    WH34.4    WH40.1    WH40.2    WH520     WH830

UPDATED BY

AR08.1    AR10.1    AR15.8    AR970

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

                     A = Active
                     I = Inactive

AGE-USED-FL          Alpha 1                                     AR08.1  AR10.1
Used                 This field indicates if a specific          AR15.8  AR970
                     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  AC115   AC15.1
          AGING-CODE    the aging code file.                     AC15.2  AC450
                                                                 AR08.1  AR10.1
                                                                 AR15.8  AR194
                                                                 AR215   AR250
                                                                 AR251   AR50.1
                                                                 AR501   AR72.1
                                                                 AR73.1  BL02.1
                                                                 BL02.2  BL04.1
                                                                 BL120   BL121
                                                                 BL122   BL123
                                                                 BL130   BL20.1
                                                                 BL20.3  BL202
                                                                 BL204   BL21.2
                                                                 BL21.5  BL220
                                                                 ...

                         AGINGCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            AGE-COMPANY    -> ACO-COMPANY