Difference between revisions of "Table llx entrepot"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
m
 
(9 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
[[Category:Stock]][[Category:Table SQL]]
+
[[Category:Stock]]
−
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
+
[[Category:Table SQL]]
−
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
+
{{ListOfTables}}
  
−
= Contenu =
+
= Content/Contenu/Contenido =
  
 +
{{flag en}} Contains the list of warehouses and related localisation information.
  
−
La table '''llx_entrepot''' contient la liste des entrepôts et des informations de localisation les concernant
+
{{flag fr}} Contient la liste des entrepôts et des informations de localisation les concernant
  
−
Contains the list of warehouses and related localisation information.
+
{{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)
 +
|}&nbsp;
  
−
 
+
== Keys ==
−
<pre>
+
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
+----------------+--------------+------+-----+-------------------+----------------+
+
|style="background-color: #e9e9ef"| <b>Key</b>
−
| Field          | Type        | Null | Key | Default          | Extra          |
+
  |style="background-color: #e9e9ef"| <b>Type</b>
−
+----------------+--------------+------+-----+-------------------+----------------+
+
  |style="background-color: #e9e9ef"| <b>Fields</b>
−
| rowid          | int(11)      |      | PRI | NULL              | auto_increment |
+
|-
−
| datec          | datetime    | YES |     | NULL              |                |
+
| PRIMARY
−
| tms            | timestamp    | YES |     | CURRENT_TIMESTAMP |                |
+
| 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              |                |
+
|}&nbsp;
−
| fk_pays        | int(11)      | YES  |    | 0                |                |
 
−
| statut        | tinyint(4)  | YES  |    | 1                |                |
 
−
| fk_user_author | int(11)      | YES  |    | NULL              |                |
 
−
+----------------+--------------+------+-----+-------------------+----------------+
 
−
</pre>
 

Latest revision as of 12:39, 10 August 2012


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains the list of warehouses and related localisation information.

Fr verysmall.png Contient la liste des entrepôts et des informations de localisation les concernant

Es verysmall.png Contiene la lista de almacenes e información concerniente a sus localizaciones

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
datec datetime YES NULL creation date
tms timestamp NO Current date Date of last modification. See page Field Tms.
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 (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 (llx_user->rowid)

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
uk_entrepot_label UNIQUE label,entity

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_entrepot&oldid=26719"