Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | ||||
|---|---|---|---|---|---|---|---|---|---|
| Code | varchar | 15 | null |
|
|
||||
| TypeDossierCode | varchar | 10 | null |
|
|
||||
| Libelle | nvarchar | 100 | null |
|
|
||||
| DtDebValidite | date | 6 | null |
|
|
||||
| DtFinValidite | date | 6 | null |
|
|
||||
| EstEnvoye | bit | 1 | null |
|
|
||||
| DonneeMtRembt | nvarchar | 200 | null |
|
|
||||
| DonneeMtCreditTVAAnterieur | nvarchar | 200 | null |
|
|
||||
| SeuilPourRembt | decimal | 21,4 | null |
|
|
||||
| DonneeMtAcomptes | nvarchar | 200 | null |
|
|
||||
| AutoriseAcomptes | bit | 1 | null |
|
|
||||
| CodeEtat | nvarchar | 10 | null |
|
|
||||
| ProprieteEtat | nvarchar | 4 | null |
|
|
||||
| TypeEditionEtat | nvarchar | 4 | null |
|
|
||||
| CodeEtatAcompte | nvarchar | 10 | null |
|
|
||||
| ProprieteEtatAcompte | nvarchar | 4 | null |
|
|
||||
| TypeEditionEtatAcompte | nvarchar | 4 | null |
|
|
||||
| Delai1PourDeducAcompte | smallint | 2 | null |
|
|
||||
| Delai2PourDeducAcompte | smallint | 2 | null |
|
|
||||
| CodeInterne | nvarchar | 20 | null |
|
|
||||
| CodeInterneRembt | nvarchar | 20 | null |
|
|
||||
| CodeInterneRembtAcompte | nvarchar | 20 | null |
|
|
||||
| DonneeTVAAntDeduite | nvarchar | 200 | null |
|
|
||||
| DonneeMtSommeAjout | nvarchar | 200 | null |
|
|
||||
| DonneeMtTVAAutreDeduire | nvarchar | 200 | null |
|
|
||||
| DonneeSommeAImputer | nvarchar | 200 | null |
|
|
||||
| DonneeRembtProvisionnel | nvarchar | 200 | null |
|
|
||||
| DonneeTaxeADAR | nvarchar | 200 | null |
|
|
||||
| DonneeAutresTaxesAssimilees | nvarchar | 200 | null |
|
|
||||
| DonneeExcedentsAcomptes | nvarchar | 200 | null |
|
|
||||
| DonneeMontantTVABtoC | nvarchar | 200 | null |
|
|