Table llx expeditiondet batch
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 details of the batch number for each shipping line. This table is linked to Table llx_expeditiondet
Contient les détails des N° de lot pour chaque ligne d’expéditions. Cette table est liée avec la Table llx_expeditiondet
Contiene detalles del número de lote de las expediciones. Esta tabla está vinculado con Table llx_expeditiondet
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| fk_expeditiondet | int(11) | NO | MUL | ID of expedition's line (llx_expeditiondet->rowid) | ||
| eatby | datetime | YES | NULL | eat-by date. This field will be stored into llx_product_lot | ||
| sellby | datetime | YES | NULL | sell-by date. This field will be stored into llx_product_lot | ||
| batch | varchar (30) | YES | NULL | batch number | ||
| qty | double | NO | 0 | Quantity sent | ||
| fk_origin_stock | int(11) | NO | MUL | ID of stock record in warehouse where product come from(llx_product_stock->rowid) |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| ix_fk_expeditiondet | MULTIPLE | fk_expeditiondet |