Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents |
|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
| Societe | nvarchar | 20 | null |
|
|
| SocieteLibelle | nvarchar | 182 | null |
|
|
| Exercice | int | 4 | null |
|
|
| EcriturePiece | nvarchar | 16 | null |
|
|
| EcritureDate | date | 6 | null |
|
|
| EcritureLibelle | nvarchar | 60 | null |
|
|
| EcritureMontantCredit | decimal | 21,4 | null |
|
|
| EcritureMontantDebit | decimal | 21,4 | null |
|
|
| Collaborateur | nvarchar | 20 | null |
|
|
| DateCreation | datetime2 | 16,7 | null |
|
|
| DateModification | datetime2 | 16,7 | null |
|
|
| DateValidation | date | 6 | null |
|
|
| MouvementNr | nvarchar | 16 | null |
|
|
| MouvementLibelle | nvarchar | 60 | null |
|
|
| Compte | nvarchar | 24 | null |
|
|
| CompteLibelle | nvarchar | 60 | null |
|
|
| CompteContrepartie | nvarchar | 24 | null |
|
|
| CompteContrepartieLibelle | nvarchar | 60 | null |
|
|
| TVA | nvarchar | 4 | null |
|
|
| TVALibelle | nvarchar | 60 | null |
|
|
| TVATaux | decimal | 10,5 | null |
|
|
| MontantCredit | decimal | 21,4 | null |
|
|
| MontantDebit | decimal | 21,4 | null |
|
|
| MontantHT | decimal | 21,4 | null |
|
|
| Quantite1 | decimal | 21,7 | null |
|
|
| Quantite2 | decimal | 21,7 | null |
|
|
| Date1 | date | 6 | null |
|
|
| Date2 | date | 6 | null |
|
|
| DeclarationTVA | int | 4 | null |
|
|
| Encaissement | int | 4 | null |
|
|
| Journal | nvarchar | 10 | null |
|
|
| JournalLibelle | nvarchar | 60 | null |
|
|
| JournalType | nvarchar | 2147483647 | null |
|
|
| Lettrage | nvarchar | 12 | null |
|
|