Changes

Line 12: Line 12:     
= 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 23: Line 24:  
| rowid  
 
| rowid  
 
| int(11)  
 
| int(11)  
| &nbsp;
+
| NO
 
| PRI
 
| PRI
| NULL
+
|  
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
Line 35: Line 36:  
| NULL  
 
| NULL  
 
|
 
|
|
+
| creation date
|-
+
{{FieldTms}}
| tms
  −
| timestamp
  −
| YES
  −
|
  −
| CURRENT_TIMESTAMP
  −
|
  −
|
   
|-
 
|-
 
| label  
 
| label  
 
| varchar(255)  
 
| varchar(255)  
|
+
| NO
 
| UNI  
 
| UNI  
 
|
 
|
 
|
 
|
|
+
| label of warehouse
 +
|-
 +
| entity
 +
| int(11)
 +
| NO
 +
| UNI
 +
| 1
 +
|
 +
| multi company id
 
|-
 
|-
 
| description  
 
| description  
Line 59: Line 61:  
| NULL
 
| NULL
 
|
 
|
|
+
| description of warehouse
 
|-
 
|-
 
| lieu  
 
| lieu  
Line 67: Line 69:  
| NULL  
 
| NULL  
 
|  
 
|  
|
+
| brief explanation of warehouse situation
 
|-
 
|-
 
| address  
 
| address  
Line 75: Line 77:  
| NULL  
 
| NULL  
 
|
 
|
|
+
| address of warehouse
 
|-
 
|-
 
| cp  
 
| cp  
Line 83: Line 85:  
| NULL  
 
| NULL  
 
|
 
|
|
+
| postal code of warehouse
 
|-
 
|-
 
| ville  
 
| ville  
Line 91: Line 93:  
| NULL  
 
| NULL  
 
|
 
|
|
+
| city of warehouse
 
|-
 
|-
 
| fk_pays  
 
| fk_pays  
Line 99: Line 101:  
| 0
 
| 0
 
|
 
|
|
+
| ID country of warehouse ([[Table llx_c_pays|llx_c_pays]]->rowid)
 
|-
 
|-
 
| statut  
 
| statut  
Line 107: Line 109:  
| 1  
 
| 1  
 
|
 
|
|
+
| is the warehouse open (1=open, 0=closed)?
 +
|-
 +
| valo_pmp
 +
| float(12,4)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| stock warehouse valorisation in PMP
 
|-
 
|-
 
| fk_user_author  
 
| fk_user_author  
Line 115: Line 125:  
| NULL  
 
| NULL  
 
|  
 
|  
|
+
| ID of creator user ([[Table llx_user|llx_user]]->rowid)
|}
+
|}&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
 +
|-
 +
| uk_entrepot_label
 +
| UNIQUE
 +
| label,entity
 +
|}&nbsp;