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 |
|
|
|||
| MotDePasseMessagerie | nvarchar | 60 | 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 |
|
|
|||
| Signature | nvarchar | 2147483647 | null |
|
|
|||
| NomFichierBancaireGenere | nvarchar | 2147483647 | null |
|
|
|||
| AccesGestion | bit | 1 | ((0)) |
|
|
|||
| OuvertureAutoCockpit | bit | 1 | ((1)) |
|
|
|||
| AfficheInfoPostMigration | bit | 1 | null |
|
|
|||
| TypeUtilisationCoach | smallint | 2 | null |
|
|
|||
| OuvertureAutoChat | bit | 1 | ((1)) |
|
|
|||
| SuppressionSuiteTransfertGRC | bit | 1 | ((0)) |
|
|
|||
| RoleAmiCompta | smallint | 2 | ((0)) |
|
|
|||
| TypeAuthentificationMessagerie | int | 4 | ((0)) |
|
|
|||
| MotDePasseMessagerieChiffre | varbinary | 2147483647 | null |
|
|