Dolibarr ERP CRM Wiki

Table llx commande: Difference between revisions

VisualWikitext
 
(12 intermediate revisions by 2 users not shown)
Line 6: Line 6:


= Content/Contenu/Contenido =
= Content/Contenu/Contenido =
{{flag en}} Contains customer orders. The order details are in [[Table llx_commandedet]]


{{flag fr}} 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]]
{{flag en}} Contains customer orders. The order details are in [[Table llx_commandedet]]


{{flag sp}} 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"
== 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>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 25: Line 26:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
|-
| tms
| ref
| timestamp
| varchar(30)
| YES
| UNI
|  
|  
|  
|  
| CURRENT_TIMESTAMP
| order number
{{FieldEntity}}
{{FieldRefExt}}
|-
| ref_client
| varchar(30)
| YES
|  
|  
| last update date
| NULL
|
| costumer order number
|-
|-
| fk_soc  
| fk_soc  
| int(11)
| int(11)
|  
| NO
|  
| MUL
|  
|  
|  
|  
| ID society ([[Table llx_societe|llx_societe]]->rowid)
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| fk_soc_contact
| int(11)
|
|
|
|
| ID contact of society ([[Table llx_socpeople|llx_socpeople]]->rowid)
|-
| fk_projet
| fk_projet
| int(11)
| int(11)
|  
| YES
|  
|  
| 0
| 0
|  
|  
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
{{FieldTms}}
| ref
| varchar(30)
|
|
|
|
|
|-
| entity
| int(11)
| &nbsp;
|
| 1
|
| multi company id
|-
|-
| date_creation
| date_creation
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| creation date
| creation date
Line 90: Line 77:
| date_valid
| date_valid
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| validation date
| validation date
Line 98: Line 85:
| date_cloture
| date_cloture
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| closed date
| closed date
|-
|-
| date_comande
| date_comande
| datetime
| date
|
| YES
|  
|  
|  
| NULL
|  
|  
| order date
| order date
Line 114: Line 101:
| fk_user_author
| fk_user_author
| int(11)
| int(11)
| YES
|  
|  
|  
| NULL
|
|  
|  
| ID creator user ([[Table llx_user|llx_user]]->rowid)
| ID creator user ([[Table llx_user|llx_user]]->rowid)
Line 122: Line 109:
| fk_user_valid
| fk_user_valid
| int(11)
| int(11)
| YES
|  
|  
|  
| NULL
|
|  
|  
| ID validator user ([[Table llx_user|llx_user]]->rowid)
| ID validator user ([[Table llx_user|llx_user]]->rowid)
Line 130: Line 117:
| fk_user_cloture
| fk_user_cloture
| int(11)
| int(11)
| YES
|  
|  
|  
| NULL
|
|  
|  
| ID closer user ([[Table llx_user|llx_user]]->rowid)
| ID closer user ([[Table llx_user|llx_user]]->rowid)
Line 138: Line 125:
| source
| source
| smallint(6)
| smallint(6)
| YES
|  
|  
| NULL
|  
|  
|  
| order source
|
|
|-
|-
| fk_statut
| fk_statut
| smallint(6)
| smallint(6)
|  
| YES
|  
|  
| 0
| 0
|  
|  
|  
| ID of status
|-
|-
| amount_ht
| amount_ht
| double
| real
|  
| YES
|  
|  
| 0
| 0
|  
|  
|  
| amount without tax
|-
|-
| remise_percent
| remise_percent
| double
| real
|  
| YES
|  
|  
| 0
| 0
|  
|  
|  
| discount percentage
|-
|-
| remise
| remise
| double
| real
|  
| YES
|  
|  
| 0
| 0
|  
|  
|  
| discount amount
|-
|-
| tva
| tva
| double(24,8)
| double(24,8)
| YES
|  
|  
| 0.00000000
|  
|  
| 0
| VAT
|
{{FieldLocalTaxX}}
|
|-
|-
| total_ht
| total_ht
| double(24,8)
| double(24,8)
| YES
|  
|  
| 0.00000000
|  
|  
| 0
| total without tax
|
|
|-
|-
| total_ttc
| total_ttc
| double(24,8)
| double(24,8)
| YES
|  
|  
| 0.00000000
|  
|  
| 0
| total
|
|
|-
|-
| note
| note
| text
| text
| YES
|  
|  
| NULL
|  
|  
| 0
| comentary
|-
| note_public
| text
| YES
|  
|  
| NULL
|  
|  
| public comentary
|-
|-
| model_pdf
| model_pdf
| varchar(50)
| 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 ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
|-
| fk_mode_reglement
| int(11)
| YES
|  
|  
| NULL
|  
|  
| ID mode of payment
|-
|-
| facture
| date_livraison
| tinyint
| date
| YES
|
| NULL
|  
|  
| delivery date
|-
| fk_livraison
| int(11)
| YES
|  
|  
| 0
| NULL
|  
|  
| flag order invoiced
| delivery address
|}
{{FieldImportKey}}
|}&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
|-
| uk_commande_ref
| UNIQUE
| ref,entity
|-
| idx_commande_fk_soc
| MULTIPLE
| fk_soc
|}&nbsp;

Latest revision as of 10:32, 19 July 2011


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

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

  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

 

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