Table llx entrepot: Difference between revisions

 
(4 intermediate revisions by one other user not shown)
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;