AgingType


Description

Aging type definitions defining different categories and methods for accounts receivable aging analysis. This lookup table manages various aging approaches and their associated database tables, enabling flexible aging calculations for different business scenarios and reporting requirements.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkAgingTypeID int identity 4 √ null
AgingBucket.fkAgingTypeID FK_AgingBucket_AgingType R
AgingCalculations.fkAgingTypeID FK_AgingCalculations_AgingType R

Primary key - Unique identifier for each aging type
AgingTypeDesc varchar 50 √ null

Type description - Descriptive name for the aging type (e.g., ‘Standard AR Aging’, ‘Insurance Aging’)
TableName varchar 50 √ null

Table name - Database table name associated with this aging type for data retrieval

Indexes

Constraint Name Type Sort Column(s)
PK_AgingType Primary key Asc pkAgingTypeID

Relationships

Close relationships within degrees of separation