Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| MainDebtorID | int | 4 | null |
|
|
|||
| MainDebtorStudentID | int | 4 | null |
|
|
|||
| LetterCode | varchar | 5 | null |
|
|
|||
| MainDebtorMailName | varchar | 100 | √ | null |
|
|
||
| MainDebtorSurname | varchar | 30 | √ | null |
|
|
||
| MainDebtorMailSalutation | varchar | 100 | √ | null |
|
|
||
| MainDebtorAddressFull | varchar | 602 | √ | null |
|
|
||
| LetterDate | datetime | 16,3 | null |
|
|
|||
| LetterDatePrint | varchar | 12 | √ | null |
|
|
||
| TotalOverdue | decimal | 10,2 | √ | null |
|
|
||
| DebtorStatementGroup | varchar | 10 | √ | null |
|
|
||
| RecipientSeq | tinyint | 1 | √ | null |
|
|
||
| RecipientID | int | 4 | √ | null |
|
|
||
| RecipientPrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||
| RecipientMailAddressCode | varchar | 1 | √ | null |
|
|
||
| RecipientMailName | varchar | 100 | √ | null |
|
|
||
| RecipientAddressFull | varchar | 602 | √ | null |
|
|
||
| FollowUpDate | datetime | 16,3 | √ | null |
|
|
||
| ResolvedFlag | bit | 1 | null |
|
|
Table contained 0 rows