Table llx actioncomm: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
Line 15: Line 15:


= Structure =
= Structure =
'''Version 1.14 2008/09/09'''
'''Version 1.1 2009/10/07'''


{|  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"
Line 38: Line 38:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| creation date  
| creation date  
Line 46: Line 46:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| planned start date
| planned start date
Line 54: Line 54:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| deprecated
| deprecated
Line 62: Line 62:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| real start date
| real start date
Line 70: Line 70:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| deprecated
| deprecated
Line 86: Line 86:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
| ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
Line 102: Line 102:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
Line 110: Line 110:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
Line 118: Line 118:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
Line 134: Line 134:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of user must perform the action ([[Table llx_user|llx_user]]->rowid)
| ID of user must perform the action ([[Table llx_user|llx_user]]->rowid)
Line 142: Line 142:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of user who perform the action ([[Table llx_user|llx_user]]->rowid)
| ID of user who perform the action ([[Table llx_user|llx_user]]->rowid)
Line 150: Line 150:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of user author of the action ([[Table llx_user|llx_user]]->rowid)
| ID of user author of the action ([[Table llx_user|llx_user]]->rowid)
Line 158: Line 158:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of last user which modify the action ([[Table llx_user|llx_user]]->rowid)
| ID of last user which modify the action ([[Table llx_user|llx_user]]->rowid)
Line 166: Line 166:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| priority of action
| priority of action
Line 190: Line 190:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
|  
|  
|-
|-
| durationp
| durationp
| double
| real
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| planned duration
| planned duration
|-
|-
| durationa
| durationa
| double
| real
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| deprecated
| deprecated
Line 214: Line 214:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| comentary
| comentary
Line 222: Line 222:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of propal ([[Table llx_propal|llx_propal]]->rowid)
| ID of propal ([[Table llx_propal|llx_propal]]->rowid)
Line 230: Line 230:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of order ([[Table llx_commande|llx_commande]]->rowid)
| ID of order ([[Table llx_commande|llx_commande]]->rowid)
Line 238: Line 238:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
|} 
|} 

Revision as of 15:22, 13 October 2009


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains all the commercial actions (looks unused in many cases)

Fr verysmall.png Contient la liste des actions commerciales

Es verysmall.png Contiene la lista de acciones comerciales

Structure

Version 1.1 2009/10/07

Field Type Null Key Default Extra Description
id int(11) NO PRI NULL auto_increment technical index
datec datetime YES NULL creation date
datep datetime YES NULL planned start date
datep2 datetime YES NULL deprecated
datea datetime YES MUL NULL real start date
datea2 datetime YES NULL deprecated
tms timestamp NO CURRENT_TIMESTAMP last update date
fk_action int(11) YES NULL ID of action (llx_c_actioncomm->id)
label varchar(50) NO label of action
fk_proyect int(11) YES NULL ID of proyect (llx_projet->rowid)
fk_soc int(11) YES MUL NULL ID of society (llx_societe->rowid)
fk_contact int(11) YES MUL NULL ID of contact (llx_socpeople->rowid)
fk_parent int(11) NO 0 ID of parent
fk_user_action int(11) YES NULL ID of user must perform the action (llx_user->rowid)
fk_user_done int(11) YES NULL ID of user who perform the action (llx_user->rowid)
fk_user_author int(11) YES NULL ID of user author of the action (llx_user->rowid)
fk_user_mod int(11) YES NULL ID of last user which modify the action (llx_user->rowid)
priority smallint(6) YES NULL priority of action
punctual smallint(6) NO 1
percent smallint(6) NO 0 percentage realised of action
location varchar(128) YES NULL
durationp real YES NULL planned duration
durationa real YES NULL deprecated
note text YES NULL comentary
propalrowid int(11) YES NULL ID of propal (llx_propal->rowid)
fk_commande int(11) YES NULL ID of order (llx_commande->rowid)
fk_facture int(11) YES MUL NULL ID of invoice (llx_facture->rowid)

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_actioncomm&oldid=16185"