Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | |
|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
|
| Identifiant | uniqueidentifier | 16 | null |
|
|
|
| TypeArrondiChgeId | int | 4 | null |
|
|
|
| TypeCtrlEcartId | int | 4 | null |
|
|
|
| GestionNumeroOrdre | bit | 1 | null |
|
|
|
| GestionGroupe | bit | 1 | null |
|
|
|
| GestionTypeBien | bit | 1 | null |
|
|
|
| GestionTvaNonRecuperable | bit | 1 | null |
|
|
|
| GestionImmo | bit | 1 | null |
|
|
|
| GestionPlafonnementDeductLoyers | bit | 1 | null |
|
|
|
| GestionCoefficientSIG | bit | 1 | null |
|
|
|
| GestionChgeDebutExerciceSit | bit | 1 | null |
|
|
|
| GestionCalculChgeLoyer | bit | 1 | null |
|
|
|
| GestionAss | bit | 1 | null |
|
|
|
| GestionCalculChgeAss | bit | 1 | null |
|
|
|
| GestionPrest | bit | 1 | null |
|
|
|
| GestionCalculChgePrest | bit | 1 | null |
|
|
|
| GestionArrondiChge | bit | 1 | null |
|
|
|
| MontantSignificatifChge | decimal | 21,4 | null |
|
|
|
| CtrlEcartVisa | bit | 1 | null |
|
|
|
| MontantEcartTolere | decimal | 21,4 | null |
|
|
|
| CreationRadicalPC | bit | 1 | null |
|
|
|
| GestionTransfertLiasse | bit | 1 | null |
|
|
|
| ClotureSiNonVise | bit | 1 | null |
|
|
|
| GestionEcritureLoyer | bit | 1 | null |
|
|
|
| GestionAnaEcritureLoyer | bit | 1 | null |
|
|
|
| JournalEcritureLoyerExt | varchar | 2 | null |
|
|
|
| JournalEcritureLoyerSit | varchar | 2 | null |
|
|
|
| GestionODCloture | bit | 1 | null |
|
|
|
| GestionAnaODCloture | bit | 1 | null |
|
|
|
| JournalODClotureExt | varchar | 2 | null |
|
|
|
| JournalODClotureSit | varchar | 2 | null |
|
|
|
| GestionEcritureRetraitement | bit | 1 | null |
|
|
|
| JournalEcritureRetraitement | varchar | 2 | null |
|
|
|
| GestionAnaEcritureRetraitement | bit | 1 | null |
|
|
|
| CptAmort | varchar | 10 | null |
|
|
|
| CptChgeFinanciere | varchar | 10 | null |
|
|
|
| CtrlEcartAss | bit | 1 | null |
|
|
|
| CtrlEcartPrest | bit | 1 | null |
|
|
|
| EstTypeArrondiChgeIdObligatoire | bit | 1 | null |
|
|
|
| EstTypeCtrlEcartIdObligatoire | bit | 1 | null |
|
|
|
| EstGestionNumeroOrdreObligatoire | bit | 1 | null |
|
|
|
| EstGestionGroupeObligatoire | bit | 1 | null |
|
|
|
| EstGestionTypeBienObligatoire | bit | 1 | null |
|
|
|
| EstGestionTvaNonRecuperableObligatoire | bit | 1 | null |
|
|
|
| EstGestionImmoObligatoire | bit | 1 | null |
|
|
|
| EstGestionPlafonnementDeductLoyersObligatoire | bit | 1 | null |
|
|
|
| EstGestionCoefficientSIGObligatoire | bit | 1 | null |
|
|
|
| EstListeRadicalNonControleObligatoire | bit | 1 | null |
|
|
|
| EstGestionChgeDebutExerciceSitObligatoire | bit | 1 | null |
|
|
|
| EstGestionCalculChgeLoyerObligatoire | bit | 1 | null |
|
|
|
| EstGestionAssObligatoire | bit | 1 | null |
|
|
|
| EstGestionCalculChgeAssObligatoire | bit | 1 | null |
|
|
|
| EstGestionPrestObligatoire | bit | 1 | null |
|
|
|
| EstGestionCalculChgePrestObligatoire | bit | 1 | null |
|
|
|
| EstGestionArrondiChgeObligatoire | bit | 1 | null |
|
|
|
| EstMontantSignificatifChgeObligatoire | bit | 1 | null |
|
|
|
| EstCtrlEcartVisaObligatoire | bit | 1 | null |
|
|
|
| EstMontantEcartTolereObligatoire | bit | 1 | null |
|
|
|
| EstCreationRadicalPCObligatoire | bit | 1 | null |
|
|
|
| EstGestionTransfertLiasseObligatoire | bit | 1 | null |
|
|
|
| EstClotureSiNonViseObligatoire | bit | 1 | null |
|
|
|
| EstGestionEcritureLoyerObligatoire | bit | 1 | null |
|
|
|
| EstGestionAnaEcritureLoyerObligatoire | bit | 1 | null |
|
|
|
| EstJournalEcritureLoyerExtObligatoire | bit | 1 | null |
|
|
|
| EstJournalEcritureLoyerSitObligatoire | bit | 1 | null |
|
|
|
| EstLibelleEnteteEcritureLoyerObligatoire | bit | 1 | null |
|
|
|
| EstLibelleMvtEcritureLoyerObligatoire | bit | 1 | null |
|
|
|
| EstGestionODClotureObligatoire | bit | 1 | null |
|
|
|
| EstGestionAnaODClotureObligatoire | bit | 1 | null |
|
|
|
| EstJournalODClotureExtObligatoire | bit | 1 | null |
|
|
|
| EstJournalODClotureSitObligatoire | bit | 1 | null |
|
|
|
| EstLibelleEnteteODClotureObligatoire | bit | 1 | null |
|
|
|
| EstLibelleMvtODClotureObligatoire | bit | 1 | null |
|
|
|
| EstGestionEcritureRetraitementObligatoire | bit | 1 | null |
|
|
|
| EstJournalEcritureRetraitementObligatoire | bit | 1 | null |
|
|
|
| EstGestionAnaEcritureRetraitementObligatoire | bit | 1 | null |
|
|
|
| EstLibelleEnteteEcritureRetraitementObligatoire | bit | 1 | null |
|
|
|
| EstLibelleMvtEcritureRetraitementObligatoire | bit | 1 | null |
|
|
|
| EstCptAmortObligatoire | bit | 1 | null |
|
|
|
| EstCptChgeFinanciereObligatoire | bit | 1 | null |
|
|
|
| EstCtrlEcartAssObligatoire | bit | 1 | null |
|
|
|
| EstCtrlEcartPrestObligatoire | bit | 1 | null |
|
|
|
| EstListeRadicalExcluComptaObligatoire | bit | 1 | null |
|
|
|
| ListeRadicalNonControle | nvarchar | 2147483647 | null |
|
|
|
| LibelleEnteteEcritureLoyer | nvarchar | 2147483647 | null |
|
|
|
| LibelleMvtEcritureLoyer | nvarchar | 2147483647 | null |
|
|
|
| LibelleEnteteODCloture | nvarchar | 2147483647 | null |
|
|
|
| LibelleMvtODCloture | nvarchar | 2147483647 | null |
|
|
|
| LibelleEnteteEcritureRetraitement | nvarchar | 2147483647 | null |
|
|
|
| LibelleMvtEcritureRetraitement | nvarchar | 2147483647 | null |
|
|
|
| ListeRadicalExcluCompta | nvarchar | 2147483647 | null |
|
|