Table llx expedition

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search


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 list of shipments. The expeditions details are in Table llx_expeditiondet

Fr verysmall.png Contient la liste des expeditions. Les détails de les expeditions sont a Table llx_expeditiondet

Es verysmall.png Contiene la lista de las expediciones. Los detalles de las expediciones se encuentran en Table llx_expeditiondet

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 ref. of shipment
entity int(11) NO UNI 1 multi company id
ref_customer varchar(30) YES NULL ref. customer number
fk_soc int(11) NO MUL ID society (llx_societe->rowid)
date_creation datetime YES NULL creation date
fk_user_author int(11) YES MUL NULL ID of creator user (llx_user->rowid)
date_valid datetime YES NULL date of validation
fk_user_valid int(11) YES MUL NULL ID of validator user (llx_user->rowid)
date_expedition date YES NULL date of expedition
fk_adresse_livraison int(11) YES MUL NULL ID of address (llx_societe_adresse_livraison->rowid)
fk_expedition_methode int(11) YES MUL NULL ID of expedition metod (llx_expedition_methode->rowid)
tracking_number varchar(50) YES NULL tracking number
fk_statut smallint(6) YES 0
height int(11) YES NULL height
width int(11) YES NULL width
size_units int(11) YES NULL size_units
size int(11) YES NULL size
weight_units int(11) YES NULL weight_units
weight int(11) YES NULL weight
note text YES NULL comentary
model_pdf varchar(50) YES NULL Model PDF to print

 

Keys

Type Fields
PRIMARY PRIMARY rowid
idx_expedition_uk_ref UNIQUE ref,entity
idx_expedition_fk_soc MULTIPLE fk_soc
idx_expedition_fk_user_author MULTIPLE fk_user_author
idx_expedition_fk_user_valid MULTIPLE fk_user_valid
idx_expedition_fk_adresse_livraison MULTIPLE fk_adresse_livraison
idx_expedition_fk_expedition_methode MULTIPLE fk_expedition_methode