Dolibarr ERP CRM Wiki

Table llx actioncomm: Difference between revisions

VisualWikitext
 
(24 intermediate revisions by 2 users not shown)
Line 6: Line 6:
{{ListOfTables}}
{{ListOfTables}}


= Contenu =
= Content/Contenu/Contenido =


Cette table contient la liste des actions commerciales
{{flag en}} Contains all the commercial actions (looks unused in many cases)


This table contains all the commercial actions (looks unused in many cases)
{{flag fr}} Contient la liste des actions commerciales


Esta tabla contiene la lista de acciones comerciales
{{flag sp}} Contiene la lista de acciones comerciales


= Structure =
= Structure =
== 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>Type</b>
|style="background-color: #e9e9ef"| <b>Null</b>
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Default</b>
|style="background-color: #e9e9ef"| <b>Extra</b>
|style="background-color: #e9e9ef"| <b>Description</b>
|-
| 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
{{FieldTms}}
|-
| fk_action
| int(11)
| YES
|
| NULL
|
| ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
|-
| label
| varchar(50)
| NO
|
|
|
| label of action
|-
| fk_proyect
| int(11)
| YES
|
| NULL
|
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
| fk_soc
| int(11)
| YES
| MUL
| NULL
|
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
| fk_contact
| int(11)
| YES
| MUL
| NULL
|
| ID of contact ([[Table llx_socpeople|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) ([[Table llx_user|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 ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_mod
| int(11)
| YES
|
| NULL
|
| ID of last user which modify the record ([[Table llx_user|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
|}&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
|}&nbsp;

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"