Table llx actioncomm: Difference between revisions
Jump to navigation
Jump to search
| Line 86: | Line 86: | ||
| | | | ||
| | | | ||
| ID of action (llx_c_actioncomm->id) | | ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id) | ||
|- | |- | ||
| label | | label | ||
| Line 102: | Line 102: | ||
| | | | ||
| | | | ||
| ID of proyect (llx_projet->rowid) | | ID of proyect ([[Table llx_projet|llx_projet]]->rowid) | ||
|- | |- | ||
| fk_soc | | fk_soc | ||
| Line 110: | Line 110: | ||
| | | | ||
| | | | ||
| ID of society (llx_societe->rowid) | | ID of society ([[Table llx_societe|llx_societe]]->rowid) | ||
|- | |- | ||
| fk_contact | | fk_contact | ||
| Line 118: | Line 118: | ||
| | | | ||
| | | | ||
| ID of contact (llx_socpeople->rowid) | | ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid) | ||
|- | |- | ||
| fk_parent | | fk_parent | ||
| Line 126: | Line 126: | ||
| 0 | | 0 | ||
| | | | ||
| ID of parent | | ID of parent | ||
|- | |- | ||
| fk_user_action | | fk_user_action | ||
| Line 134: | Line 134: | ||
| | | | ||
| | | | ||
| ID of user must perform the action (llx_user->rowid) | | ID of user must perform the action ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_user_done | | fk_user_done | ||
| Line 142: | Line 142: | ||
| | | | ||
| | | | ||
| ID of user who perform the action (llx_user->rowid) | | ID of user who perform the action ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_user_author | | fk_user_author | ||
| Line 150: | Line 150: | ||
| | | | ||
| | | | ||
| ID of user author of the action (llx_user->rowid) | | ID of user author of the action ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_user_mod | | fk_user_mod | ||
| Line 158: | Line 158: | ||
| | | | ||
| | | | ||
| ID of last user which modify the action (llx_user->rowid) | | ID of last user which modify the action ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| priority | | priority | ||
Revision as of 07:17, 14 May 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
Contenu
This table contains all the commercial actions (looks unused in many cases)
Cette table contient la liste des actions commerciales
Esta tabla contiene la lista de acciones comerciales
Structure
| Field | Type | Null | Key | Default | Extra | Description |
| id | int(11) | PRI | NULL | auto_increment | technical index | |
| datec | datetime | YES | creation date | |||
| datep | datetime | YES | planned start date | |||
| datep2 | datetime | YES | deprecated | |||
| datea | datetime | YES | real start date | |||
| datea2 | datetime | YES | deprecated | |||
| tms | timestamp | CURRENT_TIMESTAMP | last update date | |||
| fk_action | int(11) | YES | ID of action (llx_c_actioncomm->id) | |||
| label | varchar(50) | label of action | ||||
| fk_proyect | int(11) | YES | ID of proyect (llx_projet->rowid) | |||
| fk_soc | int(11) | YES | ID of society (llx_societe->rowid) | |||
| fk_contact | int(11) | YES | ID of contact (llx_socpeople->rowid) | |||
| fk_parent | int(11) | 0 | ID of parent | |||
| fk_user_action | int(11) | YES | ID of user must perform the action (llx_user->rowid) | |||
| fk_user_done | int(11) | YES | ID of user who perform the action (llx_user->rowid) | |||
| fk_user_author | int(11) | YES | ID of user author of the action (llx_user->rowid) | |||
| fk_user_mod | int(11) | YES | ID of last user which modify the action (llx_user->rowid) | |||
| priority | smallint(6) | YES | priority of action | |||
| punctual | smallint(6) | 1 | ||||
| percent | smallint(6) | 0 | percentage realised of action | |||
| location | varchar(128) | YES | ||||
| durationp | double | YES | planned duration | |||
| durationa | double | YES | deprecated | |||
| note | text | YES | ||||
| propalrowid | int(11) | YES | ||||
| fk_commande | int(11) | YES | ||||
| fk_facture | int(11) | YES |