Table llx commande: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
No edit summary
No edit summary
Line 7: Line 7:
= Contenu =
= Contenu =


Table principales des commandes clients, les détails de la commande sont dans la [[Table llx_commandedet]]
{{flag fr}} Table principales des commandes clients, les détails de la commande sont dans la [[Table llx_commandedet]]


Contains customer orders. The order details are in [[Table llx_commandedet]]
{{flag en}} Contains customer orders. The order details are in [[Table llx_commandedet]]


Tabla principal de los pedidos de clientes, los detalles de pedidos están en [[Table llx_commandedet]]
{{flag sp}} Tabla principal de los pedidos de clientes, los detalles de pedidos están en [[Table llx_commandedet]]


= 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"
|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)
| &nbsp;
| PRI
| NULL
| auto_increment
| technical index
|-
| tms
| timestamp
|
|
|
|
|
|-


<pre>
| fk_soc
-- ===================================================================
| int(11)
-- Copyright (C) 2003 Rodolphe Quiedeville <rodolphe@quiedeville.org>
|
--
|
-- This program is free software; you can redistribute it and/or modify
|
-- it under the terms of the GNU General Public License as published by
|
-- the Free Software Foundation; either version 2 of the License, or
| ID society
-- (at your option) any later version.
|-
--
| fk_soc_contact
-- This program is distributed in the hope that it will be useful,
| int(11)
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
|
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
|
-- GNU General Public License for more details.
|
--
|
-- You should have received a copy of the GNU General Public License
| ID contact of society
-- along with this program; if not, write to the Free Software
|-
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
--
-- $Id: llx_commande.sql,v 1.4 2004/10/09 10:47:16 opensides Exp $
-- $Source: /cvsroot/dolibarr/dolibarr/mysql/tables/llx_commande.sql,v $
--
-- ===================================================================


create table llx_commande
| fk_projet
(
| int(11)
  rowid            integer AUTO_INCREMENT PRIMARY KEY,
|
  tms              timestamp,
|
  fk_soc          integer,
| 0
  fk_soc_contact  integer,
|
  fk_projet        integer DEFAULT 0,    -- projet auquel est rattache la commande
| ID Proyect
  ref             varchar(30) NOT NULL,  -- propal number
|-
  date_creation   datetime,              -- date de creation
| ref
  date_valid       datetime,              -- date de validation
| varchar(30)
  date_cloture     datetime,              -- date de cloture
|
  date_commande    date,                  -- date de la commande
|
  fk_user_author   integer,              -- createur de la commande
|
  fk_user_valid   integer,              -- valideur de la commande
|
  fk_user_cloture integer,              -- cloture de la propale signee ou non signee
|
  source           smallint NOT NULL,
|-
  fk_statut       smallint default 0,
| date_creation
  amount_ht       real     default 0,
| datetime
  remise_percent   real     default 0,
|
  remise           real     default 0,
|
  tva             real     default 0,
|
  total_ht         real     default 0,
|
  total_ttc       real     default 0,
| creation date
  note             text,
|-
  model_pdf       varchar(50),
| date_valid
  facture         tinyint default 0,    -- flag indiquant si cette commande a été facturée
| datetime
  UNIQUE INDEX (ref)
|
)type=innodb;
|
 
|
</pre>
|
| validation date
|-
| date_cloture
| datetime
|
|
|
|
| closed date
|-
| date_comande
| datetime
|
|
|
|
| order date
|-
| fk_user_author
| int(11)
|
|
|
|
| ID creator user
|-
| fk_user_valid
| int(11)
|
|
|
|
| ID validator user
|-
| fk_user_cloture
| int(11)
|
|
|
|
| ID closer user
|-
| source
| smallint
|
|
|
|
|
|-
| fk_statut
| smallint
|
|
| 0
|
|
|-
| amount_ht
| real
|
|
| 0
|
|
|-
| remise_percent
| real
|
|
| 0
|
|
|-
| remise
| real
|
|
| 0
|
|
|-
| tva
| real
|
|
| 0
|
|
|-
| total_ht
| real
|
|
| 0
|
|
|-
| total_ttc
| real
|
|
| 0
|
|
|-
| note
| text
|
|
| 0
|
|
|-
| model_pdf
| varchar(50)
|
|
|
|
|
|-
| facture
| tinyint
|
|
| 0
|
| flag order invoiced
|}

Revision as of 16:14, 12 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

Fr verysmall.png Table principales des commandes clients, les détails de la commande sont dans la Table llx_commandedet

En verysmall.png Contains customer orders. The order details are in Table llx_commandedet

Es verysmall.png Tabla principal de los pedidos de clientes, los detalles de pedidos están en Table llx_commandedet

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp
fk_soc int(11) ID society
fk_soc_contact int(11) ID contact of society
fk_projet int(11) 0 ID Proyect
ref varchar(30)
date_creation datetime creation date
date_valid datetime validation date
date_cloture datetime closed date
date_comande datetime order date
fk_user_author int(11) ID creator user
fk_user_valid int(11) ID validator user
fk_user_cloture int(11) ID closer user
source smallint
fk_statut smallint 0
amount_ht real 0
remise_percent real 0
remise real 0
tva real 0
total_ht real 0
total_ttc real 0
note text 0
model_pdf varchar(50)
facture tinyint 0 flag order invoiced
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_commande&oldid=11447"