AGINGCODE – Accounts Receivable Aging Code

System
Accounts Receivable (AR)
Prefix
AGE
Primary key
COMPANY, AGING-CODE
Fields
11
Updated by
3 programs
Referenced by
95 programs

AGINGCODE is the Accounts Receivable Aging Code table in Lawson Accounts Receivable (prefix AGE). It is indexed by COMPANY, AGING-CODE (AGESET1). It is related 1:1 to ARCOMP. It is updated by AR08.1, AR10.1 and AR15.8 and referenced by AC56.1, AC560, AR215, AR501, BR00.1, BR00.2, BR02.3, BR10.1 and 87 more. The table has 11 fields, 1 index and 1 documented relation.

About AGINGCODE

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.

Fields (11)

Column = COBOL field name without the AGE- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
AGE-COMPANY PK
COMPANY		Numeric 4The company number. Must be a valid company in the AR Company file.AR15.8
AGE-AGING-CODE PK
AGING_CODE		Numeric 2This 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.AR15.8
AGE-DESC
DESC		Alpha 30 (Lower Case)Description of the aging code.AR15.8
AGE-AGE-CREDITS
AGE_CREDITS		Alpha 1Specifies 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
AR15.8
AGE-AGE-PYMNT
AGE_PYMNT		Alpha 1Specifies 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
AR15.8
AGE-AGE-DISPUTES
AGE_DISPUTES		Alpha 1Specifies if disputed invoices will be aged. Valid values are:
  • N Not aged - current column
  • Y Aged respective to date
AR15.8
AGE-AGE-TYPE
AGE_TYPE		Alpha 1Default aging method respecting either invoice date or due date. Valid values are:
  • D Age by due date
  • T Age by transaction date
AR15.8
AGE-AGE-CURRENT
AGE_CURRENT		Numeric 3Used 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.AR15.8
AGE-AGE-PERIODS
AGE_PERIODS		Numeric 3 Occurs 4 Times ×4These 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.AR15.8
AGE-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1Indicates the status of the aging code. Valid values are:
  • A Active
  • I Inactive
AR15.8
AGE-USED-FL
USED_FL		Alpha 1This 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
AR08.1, AR10.1, AR15.8

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
AGESET1COMPANY, AGING-CODEPrimaryAC56.1, AC560, AR08.1, AR10.1, AR15.8, AR215, AR501, BR00.1 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ArcompARCOMPRequiredAGE-COMPANY → ACO-COMPANY

Programs

Updated by (3)

Referenced by (95)