Table llx expedition: Difference between revisions

No edit summary
 
(5 intermediate revisions by one other user not shown)
Line 7: Line 7:


= Content/Contenu/Contenido =
= Content/Contenu/Contenido =
{{flag en}} Contains the list of shipments
{{flag en}} Contains the list of shipments. The expeditions details are in [[Table llx_expeditiondet]]


{{flag fr}} Contient la liste des expeditions
{{flag fr}} Contient la liste des expeditions. Les détails de les expeditions sont a [[Table llx_expeditiondet]]


{{flag sp}} Contiene la lista de las expedicioens
{{flag sp}} Contiene la lista de las expediciones. Los detalles de las expediciones se encuentran en [[Table llx_expeditiondet]]


= 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 25: Line 26:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
{{FieldTms}}
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| last update date
|-  
|-  
| ref
| ref
| varchar(30)
| varchar(30)
| NO
| NO
|  
| UNI
|  
|  
|  
|  
Line 50: Line 44:
| int(11)  
| int(11)  
| NO
| NO
|  
| UNI
| 1
| 1
|  
|  
| multi company id
| multi company id
|-
| ref_customer
| varchar(30)
| YES
|
| NULL
|
| ref. customer number
|-
|-
| fk_soc
| fk_soc
| int(11)  
| int(11)  
| NO
| NO
|
| MUL
|   
|   
|  
|  
Line 74: Line 76:
| int(11)
| int(11)
| YES
| YES
|  
| MUL
| NULL
| NULL
|  
|  
Line 89: Line 91:
| fk_user_valid
| fk_user_valid
| int(11)
| int(11)
| YES
| MUL
| NULL
|
| ID of validator user ([[Table llx_user|llx_user]]->rowid)
|-
| date_expedition
| date
| YES
| YES
|  
|  
| NULL
| NULL
|  
|  
| ID of validator user ([[Table llx_user|llx_user]]->rowid)
| date of expedition
|-
|-
| fk_adresse_livraison
| fk_adresse_livraison
| int(11)
| int(11)
| YES
| YES
|  
| MUL
| NULL
| NULL
|  
|  
Line 106: Line 116:
| int(11)
| int(11)
| YES
| YES
|  
| MUL
| NULL
| NULL
|  
|  
Line 128: Line 138:
|-
|-
| height
| height
| int(6)
| int(11)
| YES
| YES
|  
|  
Line 136: Line 146:
|-
|-
| width
| width
| int(6)
| int(11)
| YES
| YES
|  
|  
Line 144: Line 154:
|-
|-
| size_units  
| size_units  
| int(6)
| int(11)
| YES
| YES
|  
|  
Line 152: Line 162:
|-
|-
| size  
| size  
| int(6)
| int(11)
| YES
| YES
|  
|  
Line 160: Line 170:
|-
|-
| weight_units
| weight_units
| int(6)
| int(11)
| YES
| YES
|  
|  
Line 168: Line 178:
|-
|-
| weight
| weight
| int(6)
| int(11)
| YES
| YES
|  
|  
Line 190: Line 200:
|  
|  
| 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>Type</b>
|style="background-color: #e9e9ef"| <b>Fields</b>
|-
| 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
|}&nbsp;

Latest revision as of 12:40, 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

  Contains the list of shipments. The expeditions details are in Table llx_expeditiondet

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

  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