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 |
|
|
| NumeroOrdre | smallint | 2 | 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 |
|
|
| Libelle | nvarchar | 2147483647 | null |
|
|
| CompetenceCode | nvarchar | 20 | null |
|
|
| CompetenceLibelle | nvarchar | 200 | null |
|
|
| Quantite | decimal | 21,2 | null |
|
|
| UniteCode | nvarchar | 4 | null |
|
|
| UniteLibelle | nvarchar | 2147483647 | null |
|
|
| PrixUnitaireHT | decimal | 23,6 | null |
|
|
| PrixUnitaireHTModifie | bit | 1 | null |
|
|
| MontantHT | decimal | 21,2 | null |
|
|
| PeriodeFacturationCode | nvarchar | 4 | null |
|
|
| PeriodeFacturationLibelle | nvarchar | 2147483647 | null |
|
|
| MoisFacturation | smallint | 2 | null |
|
|
| TauxRemise | decimal | 7,2 | null |
|
|
| MontantRemiseHt | decimal | 21,2 | null |
|
|