Table llx commande: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
Line 33: Line 33:
| tms  
| tms  
| timestamp
| timestamp
|  
| NO
|  
|  
| CURRENT_TIMESTAMP
| CURRENT_TIMESTAMP
Line 41: Line 41:
| fk_soc  
| fk_soc  
| int(11)
| int(11)
|  
| NO
|  
|  
|  
|  
Line 47: Line 47:
| 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)
Line 66: Line 57:
| ref
| ref
| varchar(30)
| varchar(30)
| YES
|  
|  
|  
|  
|  
|  
|  
| order number
|
|-  
|-  
| entity
| entity
Line 79: Line 70:
|  
|  
| multi company id
| multi company id
|-
| ref_client
| varchar(30)
| YES
|
| NULL
|
| costumer order number
|-
|-
| date_creation
| date_creation
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| creation date
| creation date
Line 90: Line 89:
| date_valid
| date_valid
| datetime
| datetime
| YES
|  
|  
|  
| NULL
|
|  
|  
| validation date
| validation date
Line 98: Line 97:
| 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 113:
| 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 121:
| 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 129:
| 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 137:
| source
| source
| smallint(6)
| smallint(6)
| YES
|  
|  
| NULL
|  
|  
|  
| order source
|
|
|-
|-
| fk_statut
| fk_statut
| smallint(6)
| smallint(6)
|  
| YES
|  
|  
| 0
| 0
Line 154: Line 153:
| amount_ht
| amount_ht
| double
| double
|  
| YES
|  
|  
| 0
| 0
Line 162: Line 161:
| remise_percent
| remise_percent
| double
| double
|  
| YES
|  
|  
| 0
| 0
Line 170: Line 169:
| remise
| remise
| double
| double
|  
| YES
|  
|  
| 0
| 0
Line 178: Line 177:
| tva
| tva
| double(24,8)
| double(24,8)
| YES
|  
|  
|
| 0.00
| 0
|  
|  
|  
|  
Line 186: Line 185:
| total_ht
| total_ht
| double(24,8)
| double(24,8)
| YES
|  
|  
|
| 0.00
| 0
|  
|  
|  
|  
Line 194: Line 193:
| total_ttc
| total_ttc
| double(24,8)
| double(24,8)
| YES
|  
|  
|
| 0.00
| 0
|  
|  
|  
|  
Line 202: Line 201:
| 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
| facture
| tinyint
| tinyint
|  
| YES
|  
|  
| 0
| 0
Line 226: Line 233:
| fk_cond_reglement
| fk_cond_reglement
| int(11)
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
|  
|  
| ID of conditions of payment
| ID conditions of payment
|-
|-
| fk_mode_reglement
| fk_mode_reglement
| int(11)
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
|  
|  
| ID of mode of payment
| ID mode of payment
|-
|-
| date_livraison
| date_livraison
| date
| date
|  
| YES
|  
|  
|  
|  
Line 250: Line 257:
| fk_livraison
| fk_livraison
| int(11)
| int(11)
|  
| YES
|  
|  
| NULL
| NULL
Line 258: Line 265:
| import_key
| import_key
| varchar(14)
| varchar(14)
|  
| YES
|  
|  
| NULL
| NULL

Revision as of 15:00, 2 June 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


Content/Contenu/Contenido

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 NO CURRENT_TIMESTAMP last update date
fk_soc int(11) NO ID society (llx_societe->rowid)
fk_projet int(11) 0 ID of proyect (llx_projet->rowid)
ref varchar(30) YES order number
entity int(11)   1 multi company id
ref_client varchar(30) YES NULL costumer order number
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
amount_ht double YES 0
remise_percent double YES 0
remise double YES 0
tva double(24,8) YES 0.00
total_ht double(24,8) YES 0.00
total_ttc double(24,8) YES 0.00
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
fk_mode_reglement int(11) YES NULL ID mode of payment
date_livraison date YES delivery date
fk_livraison int(11) YES NULL delivery address
import_key varchar(14) YES NULL import key
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_commande&oldid=12432"