Colonnes
| Colonne | Type | Taille | Default | Enfants | Parents |
|---|---|---|---|---|---|
| Domaine | int | 4 | null |
|
|
| PartenaireId | uniqueidentifier | 16 | null |
|
|
| PartenaireCode | nvarchar | 20 | null |
|
|
| PartenaireType | nvarchar | 10 | null |
|
|
| PartenaireTypeLibelle | nvarchar | 100 | null |
|
|
| NatureLibelle | nvarchar | 46 | null |
|
|
| TitreCode | nvarchar | 10 | null |
|
|
| TitreLibelle | nvarchar | 60 | null |
|
|
| TitreListe | nvarchar | 20 | null |
|
|
| NomDenomination | nvarchar | 160 | null |
|
|
| Prenom | nvarchar | 60 | null |
|
|
| NomCommercial | nvarchar | 160 | null |
|
|
| FormeJuridiqueCode | nvarchar | 20 | null |
|
|
| FormeJuridiqueLibelle | nvarchar | 300 | null |
|
|
| Adresse | uniqueidentifier | 16 | null |
|
|
| TelephoneFixe | nvarchar | 30 | null |
|
|
| TelephonePortable | nvarchar | 30 | null |
|
|
| Fax | nvarchar | 30 | null |
|
|
| nvarchar | 180 | null |
|
|
|
| SiteWeb | nvarchar | 200 | null |
|
|
| NrSIRET | nvarchar | 50 | null |
|
|
| CodeBanque | nvarchar | 10 | null |
|
|
| VisaFiscal | bit | 1 | null |
|
|
| AgrementEDINr | nvarchar | 20 | null |
|
|
| AgrementOGANr | nvarchar | 20 | null |
|
|
| AgrementOGADate | date | 6 | null |
|
|
| Profession | nvarchar | 70 | null |
|
|
| DAS2 | bit | 1 | null |
|
|
| Intervenant | nvarchar | 70 | null |
|
|
| VisibleDansLesListes | bit | 1 | null |
|
|