Table llx expeditiondet batch
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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 |