Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | ||||
|---|---|---|---|---|---|---|---|---|---|
| CollaborateurPersonnePhysiqueTiersId | uniqueidentifier | 16 | null |
|
|||||
| AdressePersonelleId | uniqueidentifier | 16 | null |
|
|
||||
| DomaineId | int | 4 | null |
|
|||||
| CoordonneesPersonelleId | uniqueidentifier | 16 | null |
|
|
||||
| VisibleDansLesListes | bit | 1 | null |
|
|
||||
| DateModification | datetime2 | 16,7 | null |
|
|
||||
| TypeFichierBancaireGenere | nvarchar | 10 | null |
|
|
||||
| OuvertureAutoTbEcTec | bit | 1 | null |
|
|
||||
| OuvertureAutoAgenda | bit | 1 | null |
|
|
||||
| OuvertureAutoPortefeuille | bit | 1 | null |
|
|
||||
| OuvertureAgendaTypeAgenda | nvarchar | 2 | null |
|
|
||||
| OuverturePortefeuilleReceptionAutoDossierWT | bit | 1 | null |
|
|
||||
| OuverturePortefeuilleModeReceptionTransfert | nvarchar | 2 | null |
|
|
||||
| TypeAdresse | nvarchar | 2 | null |
|
|
||||
| UtilisationMessagerie | bit | 1 | null |
|
|
||||
| Protocole | nvarchar | 10 | null |
|
|
||||
| ServeurMessagerie | nvarchar | 500 | null |
|
|
||||
| PortMessagerie | int | 4 | null |
|
|
||||
| SSLActif | bit | 1 | null |
|
|
||||
| UtilisateurMessagerie | nvarchar | 500 | null |
|
|
||||
| EmailARecuperer | nvarchar | 2 | null |
|
|
||||
| LaisserOriginal | bit | 1 | null |
|
|
||||
| TransfertAutoVersGRC | bit | 1 | null |
|
|
||||
| UniquementMailsRecents | bit | 1 | null |
|
|
||||
| UtilisationSynchroAgenda | bit | 1 | null |
|
|
||||
| TypeMessagerie | nvarchar | 2 | null |
|
|
||||
| SynchroAgendaAuto | bit | 1 | null |
|
|
||||
| CompteMessagerieCourant | nvarchar | 200 | null |
|
|
||||
| Compte | nvarchar | 40 | null |
|
|
||||
| ActiviteAnalytique | nvarchar | 12 | null |
|
|
||||
| GestionDateArrete | bit | 1 | null |
|
|
||||
| NbJoursDateArrete | int | 4 | null |
|
|
||||
| PassageOutreDateArrete | bit | 1 | null |
|
|
||||
| VisibiliteDossier | nvarchar | 2 | null |
|
|
||||
| MasquerDossiersNonRattacheesSocieteEntree | bit | 1 | null |
|
|
||||
| Niveau | nvarchar | 2 | null |
|
|
||||
| NiveauIsarevise | smallint | 2 | null |
|
|
||||
| VersionSEPAFichierBancaireGenere | nvarchar | 30 | null |
|
|
||||
| AutorisationCreationAction | bit | 1 | null |
|
|
||||
| OuvertureAutoMessagerie | bit | 1 | null |
|
|
||||
| OuvertureAutoCharges | bit | 1 | null |
|
|
||||
| AccesGestion | bit | 1 | ((0)) |
|
|
||||
| AfficheInfoPostMigration | bit | 1 | null |
|
|
||||
| OuvertureAutoCockpit | bit | 1 | ((1)) |
|
|
||||
| TypeUtilisationCoach | smallint | 2 | null |
|
|
||||
| OuvertureAutoChat | bit | 1 | ((1)) |
|
|
||||
| SuppressionSuiteTransfertGRC | bit | 1 | ((0)) |
|
|
||||
| RoleAmiCompta | smallint | 2 | ((0)) |
|
|
||||
| TypeAuthentificationMessagerie | int | 4 | ((0)) |
|
|
||||
| OuvertureChargeSortieDossierCO | bit | 1 | ((0)) |
|
|
||||
| ArticleSortieDossierCO | uniqueidentifier | 16 | null |
|
|
||||
| Signature | nvarchar | 2147483647 | null |
|
|
||||
| NomFichierBancaireGenere | nvarchar | 2147483647 | null |
|
|
||||
| MotDePasseMessagerieChiffre | varbinary | 2147483647 | null |
|
|