Difference between revisions of "Table llx export compta"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
m
Line 6: Line 6:
  
 
= 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"
−
<pre>
+
|style="background-color: #e9e9ef"| <b>Field</b>
−
-- ===================================================================
+
|style="background-color: #e9e9ef"| <b>Type</b>
−
-- Copyright (C) 2004 Rodolphe Quiedeville <rodolphe@quiedeville.org>
+
|style="background-color: #e9e9ef"| <b>Null</b>
−
--
+
  |style="background-color: #e9e9ef"| <b>Key</b>
−
-- This program is free software; you can redistribute it and/or modify
+
|style="background-color: #e9e9ef"| <b>Default</b>
−
-- it under the terms of the GNU General Public License as published by
+
|style="background-color: #e9e9ef"| <b>Extra</b>
−
-- the Free Software Foundation; either version 2 of the License, or
+
|style="background-color: #e9e9ef"| <b>Description</b>
−
-- (at your option) any later version.
+
|-  
−
--
+
| rowid
−
-- This program is distributed in the hope that it will be useful,
+
| int(11)
−
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
+
| &nbsp;
−
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+
| PRI
−
-- GNU General Public License for more details.
+
| NULL
−
--
+
| auto_increment
−
-- You should have received a copy of the GNU General Public License
+
| technical index
−
-- along with this program; if not, write to the Free Software
+
|-
−
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+
| ref  
−
--
+
| varchar(12)  
−
-- $Id: llx_export_compta.sql,v 1.2 2005/01/03 09:58:09 rodolphe Exp $
+
|
−
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_export_compta.sql,v $
+
|
−
-- ===================================================================
+
| NULL
−
--
+
|
−
-- $Revision: 1.2 $
+
|
−
 
+
|-
−
create table llx_export_compta
+
| date_export
−
(
+
| datetime
−
  rowid            integer AUTO_INCREMENT PRIMARY KEY,
+
|
−
  ref             varchar(12) NOT NULL,
+
|
−
  date_export     datetime NOT NULL,        -- date de creation
+
| NULL
−
  fk_user         integer NOT NULL,
+
|
−
  note             text
+
|
−
 
+
|-
−
)type=innodb;
+
| fk_user  
−
</pre>
+
| int(11)
 +
|
 +
|
 +
| NULL
 +
|
 +
|
 +
|-
 +
| note
 +
| text
 +
|
 +
|
 +
| NULL
 +
|
 +
|
 +
|}

Revision as of 14:38, 11 May 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


Contenu

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
ref varchar(12) NULL
date_export datetime NULL
fk_user int(11) NULL
note text NULL
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_export_compta&oldid=11405"