Dolibarr ERP CRM Wiki

Table llx livraison: Difference between revisions

VisualWikitext
No edit summary
 
(7 intermediate revisions by 3 users not shown)
Line 5: Line 5:
{{flag en}} Contains the delivery notes. The delivery notes details are in [[Table llx_livraisondet]]
{{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 fr}} Contient les bons de livraison. Les lignes de détails des 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]]
{{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"
== 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 21: Line 22:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
{{FieldTms}}
| tms
| timestamp
|
|
| CURRENT_TIMESTAMP
|
| last update date
|-
|-
| ref
| ref
| varchar(30)
| varchar(30)
| NO
| NO
|  
| UNI
| NULL
| NULL
|  
|  
Line 45: Line 39:
| entity
| entity
| int(11)  
| int(11)  
| &nbsp;
| NO
|  
| UNI
| 1
| 1
|  
|  
| multi company id
| multi company id
|-
|-
| ref_client
| ref_costumer
| varchar(30)
| varchar(30)
| YES
| YES
Line 62: Line 56:
| int(11)
| int(11)
| YES
| YES
|  
| MUL
| NULL
| NULL
|  
|  
| ID of society affected ([[Table llx_societe|llx_societe]]->rowid)
| 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
| date_creation
Line 87: Line 71:
| fk_user_author
| fk_user_author
| int(11)
| int(11)
|  
| YES
|  
| MUL
|  
| NULL
|  
|  
| ID of user made the delivery ([[Table llx_user|llx_user]]->rowid)
| ID of user made the delivery ([[Table llx_user|llx_user]]->rowid)
Line 96: Line 80:
| int(11)
| int(11)
| YES
| YES
|  
| MUL
| NULL
| NULL
|  
|  
| ID of validator user of delivery ([[Table llx_user|llx_user]]->rowid)
| ID of validator user of delivery ([[Table llx_user|llx_user]]->rowid)
|-
|-
| date_livraison
| date_delivery
| date
| date
| YES
| YES
Line 112: Line 96:
| int(11)
| int(11)
| YES
| YES
|  
| MUL
| NULL
| NULL
|  
|  
Line 129: Line 113:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|  
|  
| total excluding tax
| total excluding tax
Line 156: Line 140:
|  
|  
| Model PDF to print
| Model PDF to print
|}
|}&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
|-
| idx_livraison_uk_ref
| UNIQUE
| ref,entity
|-
| idx_livraison_fk_soc
| MULTIPLE
| fk_soc
|-
| idx_livraison_fk_user_author
| MULTIPLE
| fk_user_author
|-
| idx_livraison_fk_user_valid
| MULTIPLE
| fk_user_valid
|-
| idx_livraison_fk_adresse_livraison
| MULTIPLE
| fk_adresse_livraison
|}&nbsp;

Latest revision as of 12:43, 10 August 2012


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 the delivery notes. The delivery notes details are in Table llx_livraisondet

  Contient les bons de livraison. Les lignes de détails des bons de livraison sont dans la Table llx_livraisondet

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

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
tms timestamp NO Current date Date of last modification. See page Field Tms.
ref varchar(30) NO UNI NULL delivery number
entity int(11) NO UNI 1 multi company id
ref_costumer varchar(30) YES NULL customer number
fk_soc int(11) YES MUL NULL ID of society affected (llx_societe->rowid)
date_creation datetime YES NULL date of creation
fk_user_author int(11) YES MUL NULL ID of user made the delivery (llx_user->rowid)
fk_user_valid int(11) YES MUL NULL ID of validator user of delivery (llx_user->rowid)
date_delivery date YES NULL date of delivery
fk_adresse_livraison int(11) YES MUL 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.00000000 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

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
idx_livraison_uk_ref UNIQUE ref,entity
idx_livraison_fk_soc MULTIPLE fk_soc
idx_livraison_fk_user_author MULTIPLE fk_user_author
idx_livraison_fk_user_valid MULTIPLE fk_user_valid
idx_livraison_fk_adresse_livraison MULTIPLE fk_adresse_livraison

 

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