Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents |
|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
| Nr | nvarchar | 22 | null |
|
|
| TypDoc | varchar | 2 | null |
|
|
| Socie | nvarchar | 20 | null |
|
|
| Clien | nvarchar | 20 | null |
|
|
| ClientNomComplet | nvarchar | 240 | null |
|
|
| Exo | int | 4 | null |
|
|
| Colla | nvarchar | 20 | null |
|
|
| VALIDATION | varchar | 1 | null |
|
|
| ExoC | int | 4 | null |
|
|
| Dt | datetime2 | 16,7 | null |
|
|
| Ref | nvarchar | 240 | null |
|
|
| Accepte | nvarchar | 2 | null |
|
|
| Clot | nvarchar | 2 | null |
|
|
| SolNr | nvarchar | 22 | null |
|
|
| Adres | uniqueidentifier | 16 | null |
|
|
| SolTypDoc | nvarchar | 4 | null |
|
|
| TypFac | nvarchar | 2 | null |
|
|
| DevT1C | nvarchar | 2147483647 | null |
|
|
| MtHt | decimal | 40,2 | null |
|
|
| DevT1 | nvarchar | 20 | null |
|
|
| DevT2 | nvarchar | 20 | null |
|
|
| DelRg | nvarchar | 20 | null |
|
|
| RmqInt | nvarchar | 2147483647 | null |
|
|
| DelRg2 | nvarchar | 20 | null |
|
|
| DtClot | datetime2 | 16,7 | null |
|
|
| DtDerniereModif | datetime2 | 16,7 | null |
|
|
| Guid | uniqueidentifier | 16 | null |
|
|
| STva | nvarchar | 2 | null |
|
|
| PaysTx | varchar | 3 | null |
|
|
| TxEsc | decimal | 21,4 | null |
|
|
| DtEsc | datetime2 | 16,7 | null |
|
|
| MtEscAcc | decimal | 21,4 | null |
|
|
| MtTtcEsc | decimal | 40,6 | null |
|
|
| ArticRmqClient | nvarchar | 20 | null |
|
|
| RmqClient | int | 4 | null |
|
|
| MtHTInit | decimal | 19,2 | null |
|
|
| MtTtc | decimal | 40,2 | null |
|
|
| MtRdu | decimal | 40,4 | null |
|
|
| AgiosRec | decimal | 21,4 | null |
|
|
| AgiosFac | decimal | 40,2 | null |
|
|
| MtPro | decimal | 21,4 | null |
|
|
| Edition | varchar | 1 | null |
|
|
| FacSolde | nvarchar | 2 | null |
|
|
| Courrier | int | 4 | null |
|
|
| Recouv | nvarchar | 4 | null |
|
|
| DecAna | nvarchar | 20 | null |
|
|
| NrContrat | nvarchar | 20 | null |
|
|
| DtContrat | datetime2 | 16,7 | null |
|
|
| Sup | nvarchar | 2 | null |
|
|
| ModCompl | nvarchar | 2 | null |
|
|
| Carev | nvarchar | 100 | null |
|
|
| AucunModeleCompl | nvarchar | 2 | null |
|
|
| IdMvt | uniqueidentifier | 16 | null |
|
|
| varchar | 1 | null |
|
|
|
| CoeffMn | decimal | 21,4 | null |
|
|
| CoeffEu | decimal | 21,4 | null |
|
|
| Devise | varchar | 3 | null |
|
|