Table llx commande

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


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 customer orders. The order details are in Table llx_commandedet

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

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

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
ref varchar(30) YES UNI order number
entity int(11) NO 1 See page Field Multi company id. (llx_entity->rowid)
ref_ext varchar(30) NO See page Field ref_ext.
ref_client varchar(30) YES NULL costumer order number
fk_soc int(11) NO MUL ID society (llx_societe->rowid)
fk_projet int(11) YES 0 ID of proyect (llx_projet->rowid)
tms timestamp NO Current date Date of last modification. See page Field Tms.
date_creation datetime YES NULL creation date
date_valid datetime YES NULL validation date
date_cloture datetime YES NULL closed date
date_comande date YES NULL order date
fk_user_author int(11) YES NULL ID creator user (llx_user->rowid)
fk_user_valid int(11) YES NULL ID validator user (llx_user->rowid)
fk_user_cloture int(11) YES NULL ID closer user (llx_user->rowid)
source smallint(6) YES NULL order source
fk_statut smallint(6) YES 0 ID of status
amount_ht real YES 0 amount without tax
remise_percent real YES 0 discount percentage
remise real YES 0 discount amount
tva double(24,8) YES 0.00000000 VAT
localtax1 double(24,8) YES 0.00000000 Special VAT rate 1 (spain)
localtax2 double(24,8) YES 0.00000000 Special VAT rate 2 (spain)
total_ht double(24,8) YES 0.00000000 total without tax
total_ttc double(24,8) YES 0.00000000 total
note text YES NULL comentary
note_public text YES NULL public comentary
model_pdf varchar(50) YES NULL Model PDF to print
facture tinyint YES 0 flag order invoiced
fk_cond_reglement int(11) YES NULL ID conditions of payment (llx_cond_reglement->rowid)
fk_mode_reglement int(11) YES NULL ID mode of payment
date_livraison date YES NULL delivery date
fk_livraison int(11) YES NULL delivery address
import_key varchar(14) YES NULL Code used to save the import id. See page Field Import key.

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
uk_commande_ref UNIQUE ref,entity
idx_commande_fk_soc MULTIPLE fk_soc