| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
Comments |
| ObjectAgreementSeq |
int identity |
4 |
|
√ |
null |
|
|
|
| AgreementTypeCode |
varchar |
15 |
|
|
('') |
|
|
|
| Description |
varchar |
100 |
|
|
('') |
|
|
|
| Reference |
varchar |
100 |
|
|
('') |
|
|
|
| AgreementDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| CreditorID |
int |
4 |
√ |
|
null |
|
|
|
| RenewedDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
| AgreementValue |
money |
21,4 |
√ |
|
null |
|
|
|
| StaffID |
int |
4 |
√ |
|
null |
|
|
|
|
varchar |
200 |
|
|
('') |
|
|
|
| ActiveFlag |
bit |
1 |
|
|
((1)) |
|
|
|
| AgreementMonths |
int |
4 |
|
|
((0)) |
|
|
|
| ReminderDays |
int |
4 |
√ |
|
null |
|
|
|
| JobPositionCode |
varchar |
15 |
√ |
|
null |
|
|
|
| OriginalAgreementDate |
datetime |
16,3 |
√ |
|
null |
|
|
|
Table contained -1 rows
| Constraint Name |
Type |
Sort |
Column(s) |
| PK_ObjectAgreements |
Primary key |
Asc |
ObjectAgreementSeq |