Difference between revisions of "Table llx livraison"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
 
(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


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 lignes de détails des 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

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