Difference between revisions of "Table llx commande fournisseur log"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
 
Line 32: Line 32:
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
|-
+
{{FieldTms}}
| tms
 
| timestamp
 
| NO
 
|
 
| CURRENT_TIMESTAMP
 
|
 
| last update date
 
 
|-
 
|-
 
| datelog
 
| datelog
Line 81: Line 74:
 
| comentary
 
| comentary
 
|} 
 
|} 
 +
 
== Keys ==
 
== Keys ==
 
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"

Latest revision as of 12:34, 10 August 2012


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


Content/Contenu/Contenido

En verysmall.png Contains the log of providers orders.

Fr verysmall.png Contient les log détails des commandes fournisseurs.

Es verysmall.png Contiene los logs de los pedidos a proveedores.

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI NULL auto_increment technical index
tms timestamp NO Current date Date of last modification. See page Field Tms.
datelog datetime NO date of log
fk_commande int(11) NO ID of order (llx commande->rowid)
fk_statut int(11) NO ID status of order
fk_user int(11) NO ID of user (llx_user->rowid)
comment varchar(255) YES NULL comentary

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid