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 |
|
|