Difference between revisions of "Table llx entrepot"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
m
Line 9: Line 9:
  
 
Contains the list of warehouses and related localisation information.
 
Contains the list of warehouses and related localisation information.
 +
 +
Contiene la lista de almacenes e información concerniente a sus localizaciones
  
 
= Structure =
 
= Structure =

Revision as of 11:10, 23 March 2009


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


Contenu

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.

Contiene la lista de almacenes e información concerniente a sus localizaciones

Structure

+----------------+--------------+------+-----+-------------------+----------------+
| Field          | Type         | Null | Key | Default           | Extra          |
+----------------+--------------+------+-----+-------------------+----------------+
| rowid          | int(11)      |      | PRI | NULL              | auto_increment |
| datec          | datetime     | YES  |     | NULL              |                |
| tms            | timestamp    | YES  |     | CURRENT_TIMESTAMP |                |
| label          | varchar(255) |      | UNI |                   |                |
| description    | text         | YES  |     | NULL              |                |
| lieu           | varchar(64)  | YES  |     | NULL              |                |
| address        | varchar(255) | YES  |     | NULL              |                |
| cp             | varchar(10)  | YES  |     | NULL              |                |
| ville          | varchar(50)  | YES  |     | NULL              |                |
| fk_pays        | int(11)      | YES  |     | 0                 |                |
| statut         | tinyint(4)   | YES  |     | 1                 |                |
| fk_user_author | int(11)      | YES  |     | NULL              |                |
+----------------+--------------+------+-----+-------------------+----------------+