Difference between revisions of "Table llx expeditiondet batch"
Jump to navigation
Jump to search
m (→Table) |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
= Content/Contenu/Contenido = | = Content/Contenu/Contenido = | ||
| − | {{flag en}} Contains details of the batch number | + | {{flag en}} Contains details of the batch number for each shipping line. This table is linked to [[Table llx_expeditiondet]] |
| − | {{flag fr}} Contient les détails des N° de lot | + | {{flag fr}} Contient les détails des N° de lot pour chaque ligne d’expéditions. Cette table est liée avec la [[Table llx_expeditiondet]] |
| − | {{flag sp}} Contiene detalles del número de lote | + | {{flag sp}} Contiene detalles del número de lote de las expediciones. Esta tabla está vinculado con [[Table llx_expeditiondet]] |
= Structure = | = Structure = | ||
| Line 46: | Line 46: | ||
| NULL | | NULL | ||
| | | | ||
| − | | eat-by date | + | | eat-by date. This field will be stored into llx_product_lot |
|- | |- | ||
| sellby | | sellby | ||
| Line 54: | Line 54: | ||
| NULL | | NULL | ||
| | | | ||
| − | | sell-by date | + | | sell-by date. This field will be stored into llx_product_lot |
|- | |- | ||
| batch | | batch | ||
| Line 80: | Line 80: | ||
| ID of stock record in warehouse where product come from([[Table llx_product_stock|llx_product_stock]]->rowid) | | ID of stock record in warehouse where product come from([[Table llx_product_stock|llx_product_stock]]->rowid) | ||
|} | |} | ||
| + | |||
== Keys == | == Keys == | ||
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
Latest revision as of 16:47, 11 April 2016
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 |