Dolibarr ERP CRM Wiki

Changes

Table llx expedition (view source)

Revision as of 12:40, 10 August 2012

3,171 bytes added ,  12 years ago
→‎Table
Line 1: Line 1:  
[[Category:Table SQL]]
 
[[Category:Table SQL]]
 
[[Category:Expedition]]
 
[[Category:Expedition]]
 +
[[Category:Shipment]]
 +
[[Category:Expediciones]]
 +
 
{{ListOfTables}}
 
{{ListOfTables}}
   −
= Contenu =
+
= Content/Contenu/Contenido =
 +
{{flag en}} Contains the list of shipments. The expeditions details are in [[Table llx_expeditiondet]]
    +
{{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 expediciones. Los detalles de las expediciones se encuentran en [[Table llx_expeditiondet]]
    
= 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
 +
|
 +
|
 +
| 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 ([[Table llx_societe|llx_societe]]->rowid)
 +
|-
 +
| date_creation
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| creation date
 +
|-
 +
| fk_user_author
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| date_valid
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of validation
 +
|-
 +
| fk_user_valid
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID of validator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| date_expedition
 +
| date
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of expedition
 +
|-
 +
| fk_adresse_livraison
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID of address ([[Table llx_societe_adresse_livraison|llx_societe_adresse_livraison]]->rowid)
 +
|-
 +
| fk_expedition_methode
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID of expedition metod ([[Table llx_expedition_methode|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
 +
|}&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;
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/9357...26721"