Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents | |
|---|---|---|---|---|---|---|
| DomaineId | int | 4 | null |
|
|
|
| TiersId | uniqueidentifier | 16 | null |
|
|
|
| TypeEntreprise | nvarchar | 4 | null |
|
|
|
| Code | nvarchar | 20 | null |
|
|
|
| CollaborateurResponsableId | uniqueidentifier | 16 | null |
|
|
|
| VisibleDansLesListes | bit | 1 | null |
|
|
|
| NomCommercial | nvarchar | 160 | null |
|
|
|
| AdresseSiegeSocialPourEntreprise_CodePostal | nvarchar | 18 | null |
|
|
|
| AdresseSiegeSocialPourEntreprise_Commune | nvarchar | 110 | null |
|
|
|
| AdresseCorrespondancePourEntreprise_CodePostal | nvarchar | 18 | null |
|
|
|
| AdresseCorrespondancePourEntreprise_Commune | nvarchar | 110 | null |
|
|
|
| AdressePersonnePhysique_CodePostal | nvarchar | 18 | null |
|
|
|
| AdressePersonnePhysique_Commune | nvarchar | 110 | null |
|
|
|
| CategorieRevenuId | nvarchar | 10 | null |
|
|
|
| RegimeFiscalId | smallint | 2 | null |
|
|
|
| GroupeCodeClassification_Id | uniqueidentifier | 16 | null |
|
|
|
| GroupeCodeClassification_Code | nvarchar | 20 | null |
|
|
|
| SecteurCodeClassification_Id | uniqueidentifier | 16 | null |
|
|
|
| SecteurCodeClassification_Code | nvarchar | 20 | null |
|
|
|
| Site_Id | uniqueidentifier | 16 | null |
|
|
|
| Site_Code | nvarchar | 20 | null |
|
|
|
| EstTenuSurIsacompta | bit | 1 | null |
|
|
|
| EstTransferablePosteServeur | bit | 1 | null |
|
|
|
| LibelleDossierIsacompta | nvarchar | 200 | null |
|
|
|
| RelevesCaisse | bit | 1 | null |
|
|
|
| QualificationRelevesBancaires | bit | 1 | null |
|
|
|
| NomUsage | nvarchar | 80 | null |
|
|
|
| Nom | nvarchar | 80 | null |
|
|
|
| Denomination | nvarchar | 160 | null |
|
|
|
| EntrepriseDescription_Prenom | nvarchar | 60 | null |
|
|
|
| PersonnePhysique_Prenom | nvarchar | 60 | null |
|
|
|
| NomNaissance | nvarchar | 80 | null |
|
|
|
| DossierPresent | bit | 1 | null |
|
|
|
| ZCaisseMobile | bit | 1 | null |
|
|
|
| RelevesBancairesMobile | bit | 1 | null |
|
|
|
| ConsultTableauBordMobile | bit | 1 | null |
|
|
|
| AchatsVentesMobile | bit | 1 | null |
|
|
|
| DeclarationsTVAMobile | bit | 1 | null |
|
|
|
| ReglementsFournisseurMobile | bit | 1 | null |
|
|
|
| ImportParamMobile | bit | 1 | null |
|
|
|
| AnalytiqueMobile | bit | 1 | null |
|
|
|
| ZCaisseWindows | bit | 1 | null |
|
|
|
| RelevesBancairesWindows | bit | 1 | null |
|
|
|
| ConsultTableauBordWindows | bit | 1 | null |
|
|
|
| AchatsVentesWindows | bit | 1 | null |
|
|
|
| DeclarationsTVAWindows | bit | 1 | null |
|
|
|
| ReglementsFournisseurWindows | bit | 1 | null |
|
|
|
| ImportParamWindows | bit | 1 | null |
|
|
|
| AnalytiqueWindows | bit | 1 | null |
|
|