Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | ||
|---|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
||
| TitreGroupeActionsClient | nvarchar | 60 | null |
|
|
||
| SocieteDefaut | nvarchar | 2 | ('C') |
|
|
||
| VisibilitePartenaire | bit | 1 | ((1)) |
|
|
||
| AvertModifFicheClient | bit | 1 | ((0)) |
|
|
||
| FicheClientNonModifiable | bit | 1 | ((0)) |
|
|
||
| ClientCourantClientPrincipal | bit | 1 | ((1)) |
|
|
||
| TypeEcritureVisibleInfosComplementaires | bit | 1 | ((1)) |
|
|
||
| TypeCodif | nvarchar | 2 | ('A') |
|
|
||
| CodifAutoObligatoire | bit | 1 | null |
|
|
||
| ReutiliserNumLibres | bit | 1 | null |
|
|
||
| TailleMiniCodeClient | int | 4 | null |
|
|
||
| LibelleSujet1 | nvarchar | 40 | null |
|
|
||
| VisibiliteSujet1 | bit | 1 | ((1)) |
|
|
||
| LibelleSujet2 | nvarchar | 40 | null |
|
|
||
| VisibiliteSujet2 | bit | 1 | ((1)) |
|
|
||
| LibelleSousSujet1 | nvarchar | 40 | null |
|
|
||
| VisibiliteSousSujet1 | bit | 1 | ((1)) |
|
|
||
| NotifCollabCreationEvenement | bit | 1 | ((1)) |
|
|
||
| IsaComptaInterditBaseReseau | bit | 1 | null |
|
|
||
| UtiliserCollaTransfert | bit | 1 | null |
|
|
||
| TypeDemandesTravaux | nvarchar | 2 | null |
|
|
||
| DemandeTravauxReseau | bit | 1 | null |
|
|
||
| AdresseServeurNotification | nvarchar | 200 | null |
|
|
||
| MailServeurNotification | nvarchar | 180 | null |
|
|
||
| TypeCompte | nvarchar | 10 | null |
|
|
||
| Radical | nvarchar | 6 | null |
|
|
||
| CompteCentralisateur | nvarchar | 40 | null |
|
|
||
| CompteUnique | nvarchar | 40 | null |
|
|
||
| CalculAutoNbJoursPresence | bit | 1 | null |
|
|
||
| NotifierChangementExercice | bit | 1 | ((0)) |
|
|
||
| NotifierChangementExerciceEmail | nvarchar | 400 | null |
|
|
||
| SynchroAgenda | bit | 1 | ((0)) |
|
|
||
| TypeMessagerie | nvarchar | 2 | null |
|
|
||
| StockageAutoMailGRC | bit | 1 | null |
|
|
||
| NomCompteGRC | nvarchar | 200 | null |
|
|
||
| AdresseElectroniqueGRC | nvarchar | 180 | null |
|
|
||
| ExpediteurEmailGRC | smallint | 2 | null |
|
|
||
| DelaiReglementPonctuelles | nvarchar | 10 | null |
|
|
||
| ModalitePaiementAcompteId | uniqueidentifier | 16 | null |
|
|
||
| ModalitePaiementSoldeId | uniqueidentifier | 16 | null |
|
|
||
| ModalitePaiementPonctuelleId | uniqueidentifier | 16 | null |
|
|
||
| VisibiliteNoeudBoiteReception | bit | 1 | null |
|
|
||
| DelaiReglementAcompte | nvarchar | 10 | null |
|
|
||
| DelaiReglementSolde | nvarchar | 10 | null |
|
|
||
| ArbreSaisieClient | nvarchar | 2147483647 | null |
|
|
||
| CheminStockageAutorisationPrelevement | nvarchar | 2147483647 | null |
|
|
||
| NotifierNouvelleAffectation | bit | 1 | ((0)) |
|
|