Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkAgingCalcID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each aging calculation record |
||||
| AgingAmount | int | 4 | √ | null |
|
|
Aging amount - Calculated monetary amount for this aging category |
||||
| TimeVariable1 | int | 4 | √ | null |
|
|
Time variable 1 - First time-based grouping variable for aging calculation |
||||
| TimeVariable2 | int | 4 | √ | null |
|
|
Time variable 2 - Second time-based grouping variable for aging calculation |
||||
| AgingGrouping1 | int | 4 | √ | null |
|
|
Aging grouping 1 - First categorical grouping for aging analysis |
||||
| AgingGrouping2 | int | 4 | √ | null |
|
|
Aging grouping 2 - Second categorical grouping for aging analysis |
||||
| AgingGrouping3 | int | 4 | √ | null |
|
|
Aging grouping 3 - Third categorical grouping for aging analysis |
||||
| AgingGrouping4 | int | 4 | √ | null |
|
|
Aging grouping 4 - Fourth categorical grouping for aging analysis |
||||
| AgingGrouping5 | int | 4 | √ | null |
|
|
Aging grouping 5 - Fifth categorical grouping for aging analysis |
||||
| fkAgingTypeID | int | 4 | √ | null |
|
|
Aging type reference - Links to AgingType table for the type of aging calculation |
||||
| TransType | varchar | 50 | √ | null |
|
|
Transaction type - Type of financial transaction included in this aging calculation |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AgingCalculations | Primary key | Asc | pkAgingCalcID |
| IX_AgingType | Performance | Asc | fkAgingTypeID |
Relationships
Close relationships within degrees of separation
