Table llx livraison: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
mNo edit summary
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
[[Category:Table SQL]]
[[Category:Table SQL]]
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
{{ListOfTables}}
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]


= 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 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]]


= Structure =
= Structure =
== 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>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)
| NO
| PRI
|
| auto_increment
| technical index
{{FieldTms}}
|-
| 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 ([[Table llx_societe|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 ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_valid
| int(11)
| YES
| MUL
| NULL
|
| ID of validator user of delivery ([[Table llx_user|llx_user]]->rowid)
|-
| date_delivery
| date
| YES
|
| NULL
|
| date of delivery
|-
| fk_adresse_livraison
| int(11)
| YES
| MUL
| 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.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
|}&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

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

 

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