Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | |
|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
|
| Id | uniqueidentifier | 16 | null |
|
|
|
| MissionNumeroInt | int | 4 | null |
|
|
|
| MissionNumero | nvarchar | 16 | null |
|
|
|
| NumeroAcompte | smallint | 2 | null |
|
|
|
| TypeFactureCode | varchar | 1 | null |
|
|
|
| TypeFactureLibelle | varchar | 7 | 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 |
|
|
|
| BaseCalculFacturesCode | nvarchar | 4 | null |
|
|
|
| BaseCalculFacturesLibelle | nvarchar | 2147483647 | null |
|
|
|
| ContenuFacturesCode | nvarchar | 4 | null |
|
|
|
| ContenuFacturesLibelle | nvarchar | 2147483647 | null |
|
|
|
| Libelle | nvarchar | 2147483647 | null |
|
|
|
| Taux | decimal | 17,6 | null |
|
|
|
| DateFacturePrevue | datetime2 | 16,7 | null |
|
|
|
| MontantHT | decimal | 21,2 | null |
|
|
|
| DateEcheancePrevue | datetime2 | 16,7 | null |
|
|
|
| FacturationRealisation | bit | 1 | null |
|
|
|
| Bloquee | bit | 1 | null |
|
|
|
| DejaFacturee | bit | 1 | null |
|
|
|
| FactureId | uniqueidentifier | 16 | null |
|
|
|
| FactureRealiseeDate | datetime2 | 16,7 | null |
|
|
|
| FactureRealiseeNumero | nvarchar | 22 | null |
|
|