4,395
edits
Table llx stock mouvement: Difference between revisions
Jump to navigation
Jump to search
→Structure
| Line 35: | Line 35: | ||
| CURRENT_TIMESTAMP | | CURRENT_TIMESTAMP | ||
| | | | ||
| date | | date of last modification | ||
|- | |- | ||
| datem | | datem | ||
| Line 43: | Line 43: | ||
| NULL | | NULL | ||
| | | | ||
| date | | creation date (should be datec?) | ||
|- | |- | ||
| fk_product | | fk_product | ||
| Line 51: | Line 51: | ||
| | | | ||
| | | | ||
| | | ID of product | ||
|- | |- | ||
| fk_entrepot | | fk_entrepot | ||
| Line 59: | Line 59: | ||
| | | | ||
| | | | ||
| | | ID of warehouse | ||
|- | |- | ||
| value | | value | ||
| Line 67: | Line 67: | ||
| NULL | | NULL | ||
| | | | ||
| | | value attributed to stock | ||
|- | |- | ||
| price | | price | ||
| Line 75: | Line 75: | ||
| 0.0000 | | 0.0000 | ||
| | | | ||
| | | price | ||
|- | |- | ||
| type_mouvement | | type_mouvement | ||
| Line 83: | Line 83: | ||
| NULL | | NULL | ||
| | | | ||
| type | | type of movement [1] | ||
|- | |- | ||
| fk_user_author | | fk_user_author | ||
| Line 91: | Line 91: | ||
| NULL | | NULL | ||
| | | | ||
| | | User ID author of this recording | ||
|} | |} | ||
[1] mouvement manuel = 0, sortie = 2, entrée = 3, cfr product/stock/mouvementstock.class.php::livraison | [1] mouvement manuel = 0, sortie = 2, entrée = 3, cfr product/stock/mouvementstock.class.php::livraison | ||