Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| bucketID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each aging bucket |
||||
| daysFrom | int | 4 | √ | null |
|
|
Start days - Beginning of the aging range in days |
||||
| daysTo | int | 4 | √ | null |
|
|
End days - End of the aging range in days |
||||
| daysRange | varchar | 50 | √ | null |
|
|
Range description - Human-readable description of the aging range (e.g., ‘0-30 days’, ‘31-60 days’) |
||||
| fkAgingTypeID | int | 4 | √ | null |
|
|
Aging type reference - Links to AgingType table for the type of aging calculation this bucket applies to |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AgingBucket | Primary key | Asc | bucketID |
| IX_AgingType | Performance | Asc | fkAgingTypeID |
Relationships
Close relationships within degrees of separation
