Table llx stock mouvement
Jump to navigation
Jump to search
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains the stock movements attached to a warehouse.
Contient les mouvements de stock rattachés à un entrepôt
Contiene los movimientos de stock relacionados a un almacén.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| datem | datetime | YES | NULL | creation date (should be datec?) | ||
| fk_product | int(11) | NO | MUL | ID of product (llx_product->rowid) | ||
| fk_entrepot | int(11) | NO | MUL | ID of warehouse (llx_entrepot->rowid) | ||
| value | int(11) | YES | NULL | value attributed to stock | ||
| price | float(13,4) | YES | 0.0000 | price | ||
| type_mouvement | smallint(6) | YES | NULL | type of movement (manual entry = 0, manual exit = 1, automatic exit = 2, automatic entry = 3) | ||
| fk_user_author | int(11) | YES | NULL | User ID author of this recording (llx_user->rowid) | ||
| label | varchar(128) | YES | NULL | label of movement | ||
| inventorycode | varchar(128) | YES | NULL | code used to group different movement line into one operation (may be an inventory, a mass picking) | ||
| fk_origin | integer | YES | NULL | Id of record into table of element that is the origin of movement (to know which table, see field origintype) | ||
| origintype | varchar(32) | YES | NULL | type of object that is the origin of movement (to know which record, see field fk_origin) |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_stock_mouvement_fk_product | MULTIPLE | fk_product |
| idx_stock_mouvement_fk_entrepot | MULTIPLE | fk_entrepot |