Dolibarr ERP CRM Wiki

Changes

Table llx expedition (view source)

Revision as of 12:40, 10 August 2012

2,464 bytes added ,  12 years ago
→‎Table
Line 6: Line 6:  
{{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 =
−
{|  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 26:  
| rowid  
 
| rowid  
 
| int(11)  
 
| int(11)  
−
| &nbsp;
+
| NO
 
| PRI
 
| PRI
−
| NULL
+
|  
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| 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/11408...26721"