Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| SynergyUser | varchar | 30 | √ | null |
|
|
||
| DebtorID | int | 4 | √ | ((0)) |
|
|
||
| DebtorStudentID | int | 4 | √ | ((0)) |
|
|
||
| DebtorReference | varchar | 200 | √ | ('') |
|
|
||
| OldestPeriodOverdue | tinyint | 1 | √ | ((0)) |
|
|
||
| OldestAmountOverdue | money | 21,4 | √ | ((0)) |
|
|
||
| LetterCode | varchar | 5 | √ | ('') |
|
|
||
| OtherAmountOverdue | money | 21,4 | √ | ((0)) |
|
|
||
| ProcessDate | datetime | 16,3 | √ | (getdate()) |
|
|
||
| Owing | money | 21,4 | √ | ((0)) |
|
|
||
| CurrentOwing | money | 21,4 | √ | ((0)) |
|
|
||
| OverduePeriod1 | money | 21,4 | √ | ((0)) |
|
|
||
| OverduePeriod2 | money | 21,4 | √ | ((0)) |
|
|
||
| OverduePeriod3 | money | 21,4 | √ | ((0)) |
|
|
||
| OverduePeriod4 | money | 21,4 | √ | ((0)) |
|
|
||
| OverduePeriod5 | money | 21,4 | √ | ((0)) |
|
|
||
| TotalOverdue | money | 21,4 | √ | ((0)) |
|
|
||
| StatementGroup | varchar | 5 | √ | ('') |
|
|
Table contained -1 rows