Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | |
|---|---|---|---|---|---|---|
| Id | uniqueidentifier | 16 | null |
|
|
|
| DomaineId | int | 4 | null |
|
|
|
| ArticleId | uniqueidentifier | 16 | null |
|
|
|
| CodeArticle | nvarchar | 20 | null |
|
|
|
| LibelleCourt | nvarchar | 120 | null |
|
|
|
| ClientId | uniqueidentifier | 16 | null |
|
|
|
| CodeClient | nvarchar | 20 | null |
|
|
|
| ClientNomComplet | nvarchar | 182 | null |
|
|
|
| CollaborateurCreationId | uniqueidentifier | 16 | null |
|
|
|
| CollaborateurCreationNomComplet | nvarchar | 164 | null |
|
|
|
| CollaborateurId | uniqueidentifier | 16 | null |
|
|
|
| CollaborateurNomComplet | nvarchar | 164 | null |
|
|
|
| CollaborateurModificationId | uniqueidentifier | 16 | null |
|
|
|
| CollaborateurModificationNomComplet | nvarchar | 164 | null |
|
|
|
| Date | datetime2 | 16,7 | null |
|
|
|
| DateCreation | datetime2 | 16,7 | null |
|
|
|
| DateModification | datetime2 | 16,7 | null |
|
|
|
| LibelleLongId | int | 4 | null |
|
|
|
| LibelleLong | nvarchar | 2147483647 | null |
|
|
|
| SocieteId | uniqueidentifier | 16 | null |
|
|
|
| Denomination | nvarchar | 182 | null |
|
|
|
| PeriodeId | uniqueidentifier | 16 | null |
|
|
|
| FactureId | uniqueidentifier | 16 | null |
|
|
|
| InformationsDossierApplicationId | nvarchar | 10 | null |
|
|
|
| Mission | int | 4 | null |
|
|
|
| ModeInterventionCode | nvarchar | 10 | null |
|
|
|
| PrixUnitaireRevient | decimal | 22,5 | null |
|
|
|
| PUModifieRevient | bit | 1 | null |
|
|
|
| MontantHTRevient | decimal | 19,2 | null |
|
|
|
| MontantTTCRevient | decimal | 19,2 | null |
|
|
|
| MontantTvaRevient | decimal | 19,2 | null |
|
|
|
| MontantHTRevientPlafond | decimal | 21,4 | null |
|
|
|
| MontantTTCRevientPlafond | decimal | 21,4 | null |
|
|
|
| MontantTvaRevientPlafond | decimal | 21,4 | null |
|
|
|
| PrixUnitaireVente | decimal | 22,5 | null |
|
|
|
| PrixUnitaireVenteModifie | bit | 1 | null |
|
|
|
| MontantHTVente | decimal | 19,2 | null |
|
|
|
| Heures | decimal | 19,2 | null |
|
|
|
| Quantite | decimal | 19,2 | null |
|
|
|
| Unite | nvarchar | 4 | null |
|
|
|
| ChargePrevue | int | 4 | null |
|
|
|
| ReleveFraisId | uniqueidentifier | 16 | null |
|
|
|
| BordereauFraisId | uniqueidentifier | 16 | null |
|
|
|
| EstPrefacture | int | 4 | null |
|
|
|
| EstModifiable | int | 4 | null |
|
|