4,395
edits
Table llx stock mouvement: Difference between revisions
Jump to navigation
Jump to search
→Structure
| Line 12: | Line 12: | ||
= Structure = | = Structure = | ||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | |||
|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> | |||
| rowid | |style="background-color: #e9e9ef"| <b>Default</b> | ||
| tms | |style="background-color: #e9e9ef"| <b>Extra</b> | ||
| datem | |style="background-color: #e9e9ef"| <b>Description</b> | ||
| fk_product | |- | ||
| fk_entrepot | | rowid | ||
| value | | int(11) | ||
| price | | | ||
| type_mouvement | smallint(6) | YES | | PRI | ||
| fk_user_author | int(11) | | NULL | ||
| auto_increment | |||
| index technique | |||
|- | |||
| tms | |||
| timestamp | |||
| NO | |||
| | |||
| CURRENT_TIMESTAMP | |||
| | |||
| date de dernière modification | |||
|- | |||
| datem | |||
| datetime | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| date de création ( devrait être datec?) | |||
|- | |||
| fk_product | |||
| int(11) | |||
| NO | |||
| MUL | |||
| | |||
| | |||
| produit défini dans llx_product | |||
|- | |||
| fk_entrepot | |||
| int(11) | |||
| NO | |||
| MUL | |||
| | |||
| | |||
| entrepôt défini dans llx_entrepot | |||
|- | |||
| value | |||
| int(11) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| valeur attribué au stock | |||
|- | |||
| price | |||
| float(13,4) | |||
| YES | |||
| | |||
| 0.0000 | |||
| | |||
| prix | |||
|- | |||
| type_mouvement | |||
| smallint(6) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| type de mouvement [1] | |||
|- | |||
| fk_user_author | |||
| int(11) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| utilisateur auteur de cet enregistrement | |||
|} | |||
[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 | ||