Difference between revisions of "Table llx c stcomm"
| Line 11: | Line 11: | ||
= Structure = | = Structure = | ||
| + | '''Version 1.6 2007/12/02''' | ||
| + | |||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | ||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| Line 22: | Line 24: | ||
| id | | id | ||
| int(11) | | int(11) | ||
| − | | | + | | NO |
| PRI | | PRI | ||
| | | | ||
| Line 30: | Line 32: | ||
| code | | code | ||
| varchar(12) | | varchar(12) | ||
| − | | | + | | NO |
| − | | | + | | UNI |
| | | | ||
| | | | ||
| Line 46: | Line 48: | ||
| active | | active | ||
| tinyint(4) | | tinyint(4) | ||
| − | | | + | | NO |
| | | | ||
| 1 | | 1 | ||
| | | | ||
| is the status active? | | is the status active? | ||
| − | |} | + | |} |
Revision as of 08:20, 8 October 2009
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
This table contains the commercial contact status of each third party of type Prospect. i.e. "do not contact", "contact pending", "to contact asap",...
Contient les statuts de contact de chaque tiers de type Prospet . Par exemple "ne pas contacter", "contact en cours", "à contacter au plus tôt", ...
Contiene los estados de contacto de cada tercero de tipo Cliente potencial. Por ejemplo "no contactar", "contacto en curso", "a contactar",...
Structure
Version 1.6 2007/12/02
| Field | Type | Null | Key | Default | Extra | Description |
| id | int(11) | NO | PRI | technical index | ||
| code | varchar(12) | NO | UNI | code of status | ||
| libelle | varchar(30) | YES | NULL | label of status | ||
| active | tinyint(4) | NO | 1 | is the status active? |