Difference between revisions of "Table llx expeditiondet batch"
(Created page with "Category:Table SQL Category:Expedition Category:Shipment Category:Expediciones {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the details o...") |
|||
| Line 7: | Line 7: | ||
= Content/Contenu/Contenido = | = Content/Contenu/Contenido = | ||
| − | {{flag en}} Contains | + | {{flag en}} Contains details of the batch number, eat-by and sell-by date shipped for each shipping line. This table is linked to [[Table llx_expeditiondet]] |
| − | {{flag fr}} Contient les détails des | + | {{flag fr}} Contient les détails des N° de lot, DLC et DLUO expédiés pour chaque ligne d’expéditions. Cette table est liée avec la [[Table llx_expeditiondet]] |
| − | {{flag sp}} Contiene | + | {{flag sp}} Contiene detalles del número de lote, y el DLC BBD enviado a cada línea de las expediciones. Esta tabla está vinculado con [[Table llx_expeditiondet]] |
= Structure = | = Structure = | ||
Revision as of 06:39, 5 March 2014
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, eat-by and sell-by date shipped for each shipping line. This table is linked to Table llx_expeditiondet
Contient les détails des N° de lot, DLC et DLUO expédiés pour chaque ligne d’expéditions. Cette table est liée avec la Table llx_expeditiondet
Contiene detalles del número de lote, y el DLC BBD enviado a cada línea 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 | ||
| sellby | datetime | YES | NULL | sell-by date | ||
| 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 |