Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | |
|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
|
| Id | uniqueidentifier | 16 | null |
|
|
|
| FactureId | uniqueidentifier | 16 | null |
|
|
|
| ArticleId | uniqueidentifier | 16 | null |
|
|
|
| NrLigne | smallint | 2 | null |
|
|
|
| ArticleLibelleLongId | int | 4 | null |
|
|
|
| TypeOriginePrestationId | nvarchar | 4 | null |
|
|
|
| TypeComplementFactureId | int | 4 | null |
|
|
|
| CollaborateurId | uniqueidentifier | 16 | null |
|
|
|
| Quantite | decimal | 14,6 | null |
|
|
|
| PrixUnitaireHT | decimal | 23,6 | null |
|
|
|
| MontantHT | decimal | 21,2 | null |
|
|
|
| PUPersonnalise | bit | 1 | null |
|
|
|
| NumeroCompteVente | nvarchar | 24 | null |
|
|
|
| CodeTVA | nvarchar | 4 | null |
|
|
|
| TauxTVA | decimal | 10,5 | null |
|
|
|
| NrMission | int | 4 | null |
|
|
|
| PeriodeId | uniqueidentifier | 16 | null |
|
|
|
| TypePeriodeCode | nvarchar | 20 | null |
|
|
|
| LibelleLongFlux | nvarchar | 2147483647 | null |
|
|
|
| NonModifiable | bit | 1 | null |
|
|
|
| NonVisible | bit | 1 | null |
|
|
|
| ModeFacturationPrestationId | nvarchar | 4 | null |
|
|
|
| Unite | nvarchar | 4 | null |
|
|
|
| ModeleMissionId | uniqueidentifier | 16 | null |
|
|
|
| TauxRemise | decimal | 7,2 | null |
|
|