Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | |
|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
|
| Societe | nvarchar | 20 | null |
|
|
|
| SocieteLibelle | nvarchar | 256 | null |
|
|
|
| Collaborateur | nvarchar | 20 | null |
|
|
|
| CollaborateurNomComplet | nvarchar | 164 | null |
|
|
|
| Date | date | 6 | null |
|
|
|
| NumeroSemaine | nvarchar | 14 | null |
|
|
|
| Client | nvarchar | 20 | null |
|
|
|
| ClientNomComplet | nvarchar | 256 | null |
|
|
|
| Mission | nvarchar | 16 | null |
|
|
|
| TypeDocumentMission | varchar | 2 | null |
|
|
|
| MissionLibelle | nvarchar | 120 | null |
|
|
|
| PeriodeCode | nvarchar | 20 | null |
|
|
|
| PeriodeLibelle | nvarchar | 100 | null |
|
|
|
| Exercice | smallint | 2 | null |
|
|
|
| ExerciceDateDebut | date | 6 | null |
|
|
|
| ExerciceDateFin | date | 6 | null |
|
|
|
| Article | nvarchar | 20 | null |
|
|
|
| LibelleLongId | int | 4 | null |
|
|
|
| ArticleLibelleCourt | nvarchar | 120 | null |
|
|
|
| ArticleLibelleLong | nvarchar | 2147483647 | null |
|
|
|
| ArticleLibelleCharge | nvarchar | 2147483647 | null |
|
|
|
| HeuresSaisies | decimal | 19,2 | null |
|
|
|
| QuantiteSaisies | decimal | 19,2 | null |
|
|
|
| Uniteid | nvarchar | 4 | null |
|
|
|
| Quantite | decimal | 19,2 | null |
|
|
|
| Unite | nvarchar | 4 | null |
|
|
|
| PrixUnitaireHT | decimal | 22,5 | null |
|
|
|
| PrixUnitaireModifie | bit | 1 | null |
|
|
|
| MontantHT | decimal | 40,7 | null |
|
|
|
| PrixRevientHT | decimal | 22,5 | null |
|
|
|
| PrixUnitaireRevientModifie | bit | 1 | null |
|
|
|
| MontantRevient | decimal | 40,7 | null |
|
|