Table llx entrepot

From Dolibarr ERP CRM Wiki
Revision as of 02:19, 29 December 2008 by Eldy (talk | contribs)
Jump to navigation Jump to search
 La documentation relative aux autres tables est disponible sur la page Liste des tables
 The documentation related to other tables is available on the tables list page: Liste des tables

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.

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              |                |
+----------------+--------------+------+-----+-------------------+----------------+