29,030
edits
Changes
Jump to navigation
Jump to search
→Table
Line 1:
Line 1:
−La table '''llx_entrepot''' contient la liste des entrepôts et des informations de localisation les concernant++----------------+--------------+------+-----+-------------------+----------------++
−+----------------+--------------+------+-----+-------------------+----------------++
−
−+----------------+--------------+------+-----+-------------------+----------------++</pre>+
+
[[Catégorie:Stock]][[Catégorie:Table SQL]]
+[[Category:Stock]]
+[[Category:Table SQL]]
+{{ListOfTables}}
−= Content/Contenu/Contenido =
−<pre>
+{{flag en}} Contains the list of warehouses and related localisation information.
−| Field | Type | Null | Key | Default | Extra |
+{{flag fr}} Contient la liste des entrepôts et des informations de localisation les concernant
−| rowid | int(11) | | PRI | NULL | auto_increment |
+{{flag sp}} Contiene la lista de almacenes e información concerniente a sus localizaciones
−| datec | datetime | YES | | NULL | |
+| tms | timestamp | YES | | CURRENT_TIMESTAMP | |
+= Structure =
−| label | varchar(255) | | UNI | | |
+== Table ==
−| description | text | YES | | NULL | |
+{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−| lieu | varchar(64) | YES | | NULL | |
+ |style="background-color: #e9e9ef"| <b>Field</b>
−| address | varchar(255) | YES | | NULL | |
+ |style="background-color: #e9e9ef"| <b>Type</b>
−| cp | varchar(10) | YES | | NULL | |
+ |style="background-color: #e9e9ef"| <b>Null</b>
−| ville | varchar(50) | YES | | NULL | |
+ |style="background-color: #e9e9ef"| <b>Key</b>
−| fk_pays | int(11) | YES | | 0 | |
+ |style="background-color: #e9e9ef"| <b>Default</b>
−| statut | tinyint(4) | YES | | 1 | |
+ |style="background-color: #e9e9ef"| <b>Extra</b>
−| fk_user_author | int(11) | YES | | NULL | |
+ |style="background-color: #e9e9ef"| <b>Description</b>
−|-
−| rowid
+| int(11)
+| NO
+| PRI
+|
+| auto_increment
+| technical index
+|-
+| datec
+| datetime
+| YES
+|
+| NULL
+|
+| creation date
+{{FieldTms}}
+|-
+| label
+| varchar(255)
+| NO
+| UNI
+|
+|
+| label of warehouse
+|-
+| entity
+| int(11)
+| NO
+| UNI
+| 1
+|
+| multi company id
+|-
+| description
+| text
+| YES
+|
+| NULL
+|
+| description of warehouse
+|-
+| lieu
+| varchar(64)
+| YES
+|
+| NULL
+|
+| brief explanation of warehouse situation
+|-
+| address
+| varchar(255)
+| YES
+|
+| NULL
+|
+| address of warehouse
+|-
+| cp
+| varchar(10)
+| YES
+|
+| NULL
+|
+| postal code of warehouse
+|-
+| ville
+| varchar(50)
+| YES
+|
+| NULL
+|
+| city of warehouse
+|-
+| fk_pays
+| int(11)
+| YES
+|
+| 0
+|
+| ID country of warehouse ([[Table llx_c_pays|llx_c_pays]]->rowid)
+|-
+| statut
+| tinyint(4)
+| YES
+|
+| 1
+|
+| is the warehouse open (1=open, 0=closed)?
+|-
+| valo_pmp
+| float(12,4)
+| YES
+|
+| NULL
+|
+| stock warehouse valorisation in PMP
+|-
+| fk_user_author
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of creator user ([[Table llx_user|llx_user]]->rowid)
+|}
+== 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
+|}