Dolibarr ERP CRM Wiki

Table llx commande fournisseur log: Difference between revisions

VisualWikitext
mNo edit summary
 
(7 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Table SQL]]
[[Category:Table SQL]]
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
[[Category:Fournisseur]]
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
[[Category:Supplier]]
[[Category:Proveedores]]


= Contenu =
{{ListOfTables}}


= Content/Contenu/Contenido =
{{flag en}} Contains the log of providers orders.
{{flag fr}} Contient les log détails des commandes fournisseurs.
{{flag sp}} Contiene los logs de los pedidos a proveedores.


= 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>
|-
| rowid
| int(11)
| NO
| PRI
| NULL
| auto_increment
| technical index
{{FieldTms}}
|-
| datelog
| datetime
| NO
|
|
|
| date of log
|-
| fk_commande
| int(11)
| NO
|
|
|
| ID of order ([[Table llx commande|llx commande]]->rowid)
|-
| fk_statut
| int(11)
| NO
|
|
|
| ID status of order
|-
| fk_user
| int(11)
| NO
|
|
|
| ID of user ([[Table llx_user|llx_user]]->rowid)
|-
| comment
| varchar(255)
| YES
|
| NULL
|
| comentary
|}&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
| rowid
|}&nbsp;

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

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 the log of providers orders.

  Contient les log détails des commandes fournisseurs.

  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

 

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