|
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), the aging parameters of the assigned aging code are
used.
REFERENCED BY
AC56.1 AC560 AR120 AR194 AR215 AR219
AR250 AR251 AR48.1 AR48.3 AR50.1 AR501
AR72.1 BL02.1 BL04.1 BL10.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
BR10.9 BR11.1 BR120 BR121 BR122 BR123
BR140 BR151 BR152 BR155 BR156 BR16.1
BR16.2 BR17.1 BR180 BR19.1 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.7 BR21.2 BR210
BR211 BR216 BR217 BR220 BR251 BR252
BR253 BR400 BR420 BR45.1 BR450 BR46.1
BR46.2 BR46.4 BR51.1 BR51.2 BR52.1 BR52.2
BR521 BR53.1 BR55.2 BR70.1 BR70.2 BR91.1
BRIP.1 CB06.2 IC02.1 PW110 TX140 TX40.1
WH110 WH120 WH130 WH132 WH190 WH20.1
WH20.2 WH20.7 WH21.2 WH224 WH226 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
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: Active 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 Fl 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 AC56.1 AC560
AGING-CODE AR08.1 AR10.1
AR120 AR15.8
AR194 AR215
AR219 AR250
AR251 AR48.1
AR48.3 AR50.1
AR501 AR72.1
BL02.1 BL04.1
BL10.1 BL120
BL121 BL122
BL123 BL125
BL130 BL20.1
BL20.3 BL20.6
BL202 BL204
...
AGINGCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Arcomp ARCOMP Required
AGE-COMPANY -> ACO-COMPANY
|