Difference between revisions of "Table llx livraison"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 2: Line 2:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
−
= Contenu =
+
= Content/Contenu/Contenido =
 +
{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]
  
 +
{{flag fr}} Contient les bons de livraison. les détails de les bons de livraison sont dans la [[Table llx_livraisondet]]
 +
 +
{{flag sp}} Contiene las notas de entrega. Los detalles de las entregas se encuentran en la [[Table llx_livraisondet]]
  
 
= 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
 +
|
 +
|
 +
| CURRENT_TIMESTAMP
 +
|
 +
| last update date
 +
|-
 +
| ref
 +
| varchar(30)
 +
| NO
 +
|
 +
| NULL
 +
|
 +
| delivery number
 +
|-
 +
| entity
 +
| int(11)
 +
| &nbsp;
 +
|
 +
| 1
 +
|
 +
| multi company id
 +
|-
 +
| ref_client
 +
| varchar(30)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| customer number
 +
|-
 +
| fk_soc
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of society affected ([[Table llx_societe|llx_societe]]->rowid)
 +
|-
 +
| fk_expedition
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of related expedition([[Table llx_expedition|llx_expedition]]->rowid)
 +
 +
 +
|-
 +
| date_creation
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of creation
 +
|-
 +
| fk_user_author
 +
| int(11)
 +
|
 +
|
 +
|
 +
|
 +
| ID of user made the delivery ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_valid
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of validator user of delivery ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| date_livraison
 +
| date
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of delivery
 +
|-
 +
| fk_adresse_livraison
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of delivery adress ([[Table llx_societe_adresse_livraison|llx_societe_adresse_livraison]]->rowid) 
 +
|-
 +
| statut
 +
| smallint(6)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| status of delivery
 +
|-
 +
| total_ht
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total excluding tax
 +
|-
 +
| note
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| comentary
 +
|-
 +
| note_public
 +
| text
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| public comentary
 +
|-
 +
| model_pdf
 +
| varchar(50)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| Model PDF to print
 +
|}

Revision as of 09:54, 21 July 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

En verysmall.png Contains the delivery notes. The delivery notes details are in Table llx_livraisondet

Fr verysmall.png Contient les bons de livraison. les détails de les bons de livraison sont dans la Table llx_livraisondet

Es verysmall.png Contiene las notas de entrega. Los detalles de las entregas se encuentran en la Table llx_livraisondet

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp CURRENT_TIMESTAMP last update date
ref varchar(30) NO NULL delivery number
entity int(11)   1 multi company id
ref_client varchar(30) YES NULL customer number
fk_soc int(11) YES NULL ID of society affected (llx_societe->rowid)
fk_expedition int(11) YES NULL ID of related expedition(llx_expedition->rowid)


date_creation datetime YES NULL date of creation
fk_user_author int(11) ID of user made the delivery (llx_user->rowid)
fk_user_valid int(11) YES NULL ID of validator user of delivery (llx_user->rowid)
date_livraison date YES NULL date of delivery
fk_adresse_livraison int(11) YES NULL ID of delivery adress (llx_societe_adresse_livraison->rowid)
statut smallint(6) YES 0 status of delivery
total_ht double(24,8) YES 0.00 total excluding tax
note text YES NULL comentary
note_public text YES NULL public comentary
model_pdf varchar(50) YES NULL Model PDF to print
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_livraison&oldid=13155"