Dolibarr ERP CRM Wiki

Table llx actioncomm: Difference between revisions

VisualWikitext
 
(13 intermediate revisions by 2 users not shown)
Line 15: Line 15:


= Structure =
= Structure =
{|  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"
== Table ==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 28: Line 29:
| NO
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
Line 36: Line 37:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| creation date  
| creation date  
Line 44: Line 45:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| planned start date
| planned start date
Line 52: Line 53:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| deprecated
| deprecated
Line 60: Line 61:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| real start date
| real start date
Line 68: Line 69:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| deprecated
| deprecated
|-
{{FieldTms}}
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| last update date
|-  
|-  
| fk_action
| fk_action
Line 84: Line 78:
| 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 100: Line 94:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
Line 108: Line 102:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
Line 116: Line 110:
| YES
| YES
| MUL
| MUL
|  
| NULL
|  
|  
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
Line 132: Line 126:
| YES
| YES
|  
|  
| NULL
|  
|  
|
| ID of user that own action (assigned to) ([[Table llx_user|llx_user]]->rowid)
| ID of user must perform the action ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_done
| fk_user_done
Line 140: Line 134:
| YES
| YES
|  
|  
| NULL
|  
|  
|  
| Deprecated. Not filled/used.
| ID of user who perform the action ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_author
| fk_user_author
Line 148: Line 142:
| YES
| YES
|  
|  
| NULL
|  
|  
|
| ID of user author who created record ([[Table llx_user|llx_user]]->rowid)
| ID of user author of the action ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_mod
| fk_user_mod
Line 156: Line 150:
| YES
| YES
|  
|  
| NULL
|  
|  
| ID of last user which modify the record ([[Table llx_user|llx_user]]->rowid)
|-
| fulldayevent
| smallint(6)
| YES
|
| NULL
|  
|  
| ID of last user which modify the action ([[Table llx_user|llx_user]]->rowid)
| Event on full day
|-
| transparency
| int(11)
| YES
|
| NULL
|
| transparency (1= busy, 0=no busy)
|-
|-
| priority
| priority
Line 164: Line 174:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| priority of action
| priority of action
Line 188: Line 198:
| YES
| YES
|  
|  
|  
| NULL
|  
|  
|  
|  
|-
|-
| durationp
| durationp
| double
| real
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| planned duration
| planned duration
|-
|-
| durationa
| durationa
| double
| real
| YES
| YES
|  
|  
|  
| NULL
|  
|  
| deprecated
| deprecated
Line 212: Line 222:
| YES
| YES
|  
|  
| NULL
|  
|  
|  
| comment
| comentary
|-
|-
| propalrowid
| fk_element
| int(11)
| int(11)
| YES
| YES
|  
|  
| NULL
|  
|  
|
| ID of element
| ID of propal ([[Table llx_propal|llx_propal]]->rowid)
|-
|-
| fk_commande
| element_type
| int(11)
| varchar(16)
| YES
| YES
|  
|  
| NULL
|  
|  
|  
| Type of element
| ID of order ([[Table llx_commande|llx_commande]]->rowid)
|}&nbsp;
|-
 
==Keys==
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Type</b>
|style="background-color: #e9e9ef"| <b>Fields</b>
|-  
| PRIMARY
| PRIMARY
| id
|-
| idx_actioncomm_datea
| MULTIPLE
| datea
|-
| idx_actioncomm_fk_soc
| MULTIPLE
| fk_soc
|-
| idx_actioncomm_fk_contact
| MULTIPLE
| fk_contact
|-
| idx_actioncomm_fk_facture
| MULTIPLE
| fk_facture
| fk_facture
| int(11)
|}&nbsp;
| YES
| MUL
|
|
| ID of invoice ([[Table llx_facture|llx_facture]]->rowid)
|}

Latest revision as of 21:12, 3 August 2014


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

  Contains all the commercial actions (looks unused in many cases)

  Contient la liste des actions commerciales

  Contiene la lista de acciones comerciales

Structure

Table

Field Type Null Key Default Extra Description
id int(11) NO PRI 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 date Date of last modification. See page Field Tms.
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 that own action (assigned to) (llx_user->rowid)
fk_user_done int(11) YES NULL Deprecated. Not filled/used.
fk_user_author int(11) YES NULL ID of user author who created record (llx_user->rowid)
fk_user_mod int(11) YES NULL ID of last user which modify the record (llx_user->rowid)
fulldayevent smallint(6) YES NULL Event on full day
transparency int(11) YES NULL transparency (1= busy, 0=no busy)
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 comment
fk_element int(11) YES NULL ID of element
element_type varchar(16) YES NULL Type of element

 

Keys

Key Type Fields
PRIMARY PRIMARY id
idx_actioncomm_datea MULTIPLE datea
idx_actioncomm_fk_soc MULTIPLE fk_soc
idx_actioncomm_fk_contact MULTIPLE fk_contact
idx_actioncomm_fk_facture MULTIPLE fk_facture

 

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