Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | ||
|---|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
||
| DossierId | uniqueidentifier | 16 | null |
|
|
||
| ContratId | uniqueidentifier | 16 | null |
|
|
||
| ModeAmortContratId | int | 4 | null |
|
|
||
| Compte | nvarchar | 24 | null |
|
|
||
| DateAcquisition | date | 6 | null |
|
|
||
| DateAmort | date | 6 | null |
|
|
||
| MontantAmort | decimal | 21,4 | null |
|
|
||
| NbAnneeAmort | tinyint | 1 | null |
|
|
||
| NbMoisAmort | tinyint | 1 | null |
|
|
||
| TauxAmort | decimal | 10,5 | null |
|
|
||
| DateFinAmort | date | 6 | null |
|
|
||
| MontantAmortAnterieur | decimal | 21,4 | null |
|
|
||
| NbAnneeRestantAmortir | tinyint | 1 | null |
|
|
||
| NbMoisRestantAmortir | tinyint | 1 | null |
|
|