Table llx expeditiondet batch - Revision history

Eldy: /* Table */

2016-04-11T16:47:45Z

Table

← Older revision		Revision as of 16:47, 11 April 2016
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"

Eldy: /* Content/Contenu/Contenido */

2016-04-11T16:47:14Z

Content/Contenu/Contenido

← Older revision		Revision as of 16:47, 11 April 2016
Line 7:		Line 7:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
	{{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 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~~, DLC et DLUO expédiés~~ pour chaque ligne d’expéditions. Cette table est liée avec la [[Table llx_expeditiondet]]		{{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~~, y el DLC BBD enviado a cada línea~~ de las expediciones. Esta tabla está vinculado con [[Table llx_expeditiondet]]		{{flag sp}} Contiene detalles del número de lote de las expediciones. Esta tabla está vinculado con [[Table llx_expeditiondet]]

	= Structure =		= Structure =

Cgross at 06:39, 5 March 2014

2014-03-05T06:39:43Z

← Older revision		Revision as of 06:39, 5 March 2014
Line 7:		Line 7:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
	{{flag en}} Contains ~~the~~ details of ~~shipments~~. This table is linked to [[Table llx_expeditiondet]]		{{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 ~~DLC/DLUO et~~ N° de lot de chaque ligne ~~d’expédition~~. Cette table est liée avec la [[Table llx_expeditiondet]]		{{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 ~~los~~ detalles de las expediciones. Esta tabla está vinculado con [[Table llx_expeditiondet]]		{{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 =

Cgross: Created page with "Category:Table SQL Category:Expedition Category:Shipment Category:Expediciones {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the details o..."

2014-03-05T06:37:26Z

Created page with "Category:Table SQL Category:Expedition Category:Shipment Category:Expediciones {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the details o..."

New page

[[Category:Table SQL]]
[[Category:Expedition]]
[[Category:Shipment]]
[[Category:Expediciones]]

{{ListOfTables}}

= Content/Contenu/Contenido =
{{flag en}} Contains the details of shipments. This table is linked to [[Table llx_expeditiondet]]

{{flag fr}} Contient les détails des DLC/DLUO et N° de lot de chaque ligne d’expédition. Cette table est liée avec la [[Table llx_expeditiondet]]

{{flag sp}} Contiene los detalles de las expediciones. Esta tabla está vinculado con [[Table llx_expeditiondet]]

= Structure =
== Table ==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| Field
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Null
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Default
|style="background-color: #e9e9ef"| Extra
|style="background-color: #e9e9ef"| Description
|-
| rowid
| int(11)
| NO
| PRI
|
| auto_increment
| technical index
|-
| fk_expeditiondet
| int(11)
| NO
| MUL
|
|
| ID of expedition's line ([[Table llx_expeditiondet|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([[Table llx_product_stock|llx_product_stock]]->rowid)
|} 
== Keys ==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Fields
|-
| PRIMARY
| PRIMARY
| rowid
|-
| ix_fk_expeditiondet
| MULTIPLE
| fk_expeditiondet
|}