Table llx commande: Difference between revisions

Jump to navigation Jump to search

Table llx commande (view source)

Revision as of 16:14, 12 May 2009

609 bytes removed ,  17 years ago
no edit summary
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
|}
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/11447"

Navigation menu