29,030
edits
Changes
→Table
Line 3:
Line 3:
La table '''llx_entrepot''' contient la liste des entrepôts et des informations de localisation les concernant+Contains the list of warehouses and related localisation information.+ +<pre>++----------------+--------------+------+-----+-------------------+----------------++| Field | Type | Null | Key | Default | Extra |++----------------+--------------+------+-----+-------------------+----------------++| rowid | int(11) | | PRI | NULL | auto_increment |+| datec | datetime | YES | | NULL | |+| tms | timestamp | YES | | CURRENT_TIMESTAMP | |++----------------+--------------+------+-----+-------------------+----------------+
−</pre>
{{ListOfTables}}
{{ListOfTables}}
−= Contenu =
+= Content/Contenu/Contenido =
+{{flag en}} Contains the list of warehouses and related localisation information.
−{{flag fr}} Contient la liste des entrepôts et des informations de localisation les concernant
−{{flag sp}} Contiene la lista de almacenes e información concerniente a sus localizaciones
= 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
+|-
+| 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
−| label | varchar(255) | | UNI | | |
+| rowid
−| description | text | YES | | NULL | |
+|-
−| lieu | varchar(64) | YES | | NULL | |
+| uk_entrepot_label
−| address | varchar(255) | YES | | NULL | |
+| UNIQUE
−| cp | varchar(10) | YES | | NULL | |
+| label,entity
−| ville | varchar(50) | YES | | NULL | |
+|}
−| fk_pays | int(11) | YES | | 0 | |
−| statut | tinyint(4) | YES | | 1 | |
−| fk_user_author | int(11) | YES | | NULL | |
−