Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents |
|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
| MissionNumeroInt | int | 4 | null |
|
|
| MissionNumero | nvarchar | 16 | null |
|
|
| SocieteId | uniqueidentifier | 16 | null |
|
|
| SocieteCode | nvarchar | 20 | null |
|
|
| SocieteLibelle | nvarchar | 182 | null |
|
|
| ClientId | uniqueidentifier | 16 | null |
|
|
| ClientCode | nvarchar | 20 | null |
|
|
| ClientNomComplet | nvarchar | 182 | null |
|
|
| CollaborateurId | uniqueidentifier | 16 | null |
|
|
| CollaborateurCode | nvarchar | 20 | null |
|
|
| CollaborateurNomComplet | nvarchar | 164 | null |
|
|
| ArticleId | uniqueidentifier | 16 | null |
|
|
| ArticleCode | nvarchar | 20 | null |
|
|
| ArticleLibelleCourt | nvarchar | 120 | null |
|
|
| CompetenceCode | nvarchar | 20 | null |
|
|
| CompetenceLibelle | nvarchar | 200 | null |
|
|
| VentilationDate | date | 6 | null |
|
|
| Heures | decimal | 21,2 | null |
|
|
| Quantite | decimal | 21,2 | null |
|
|
| UniteCode | nvarchar | 4 | null |
|
|
| UniteLibelle | nvarchar | 2147483647 | null |
|
|