Table llx commandedet - Revision history

Eldy: /* Table */

2024-07-25T11:18:46Z

Table

2024-07-25T09:50:39Z

Structure

← Older revision		Revision as of 09:50, 25 July 2024
Line 169:		Line 169:
	\| mark rate (margin on selling price)		\| mark rate (margin on selling price)
	\|-		\|-
	~~\| special_code~~		{{FieldSpecialCode}}
	~~\| int(10)~~
	~~\| YES~~
	\|
	~~\| 0~~
	~~\| UNSIGNED~~
	\| code for special lines: used for shipping (=1), ecotaxes (=2), product/service optional offers (=3), line for takepos sent to printer(=4), module id for custom need (>=5). Default=0. Value is an additionnal information and has no effect, except value 3 that means "do not take into account amount, it is an option".
	\|-		\|-
	\| rang		\| rang

2024-07-25T09:46:30Z

Table

← Older revision		Revision as of 09:46, 25 July 2024
Line 175:		Line 175:
	\| 0		\| 0
	\| UNSIGNED		\| UNSIGNED
	\| code for special lines: used for shipping (=1), ecotaxes (=2), product/service optional offers (=3), line for takepos sent to printer(=4), module id for custom need (>=5). Default=0.		\| code for special lines: used for shipping (=1), ecotaxes (=2), product/service optional offers (=3), line for takepos sent to printer(=4), module id for custom need (>=5). Default=0. Value is an additionnal information and has no effect, except value 3 that means "do not take into account amount, it is an option".
	Value is information and has no effect, except value 3 that means "do not take into account amount, it is an option".
	\|-		\|-
	\| rang		\| rang

2024-07-25T09:04:14Z

Table

← Older revision		Revision as of 09:04, 25 July 2024
Line 175:		Line 175:
	\| 0		\| 0
	\| UNSIGNED		\| UNSIGNED
	\| code for special lines: used for shipping (=1), ecotaxes (=2), product/service optional offers (=3), line for takepos sent to printer(=4), module id for custom need (>=5). Default=0		\| code for special lines: used for shipping (=1), ecotaxes (=2), product/service optional offers (=3), line for takepos sent to printer(=4), module id for custom need (>=5). Default=0.
			Value is information and has no effect, except value 3 that means "do not take into account amount, it is an option".
	\|-		\|-
	\| rang		\| rang

2024-07-25T08:53:33Z

Table

← Older revision		Revision as of 08:53, 25 July 2024
Line 175:		Line 175:
	\| 0		\| 0
	\| UNSIGNED		\| UNSIGNED
	\| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). ~~Otherwise~~=0		\| code for special lines: used for shipping (=1), ecotaxes (=2), product/service optional offers (=3), line for takepos sent to printer(=4), module id for custom need (>=5). Default=0
	\|-		\|-
	\| rang		\| rang

2018-04-23T16:31:26Z

Add fk_parent_line field in commande table

← Older revision		Revision as of 16:31, 23 April 2018
Line 34:		Line 34:
	\| fk_commande		\| fk_commande
	\| int(11)		\| int(11)
	\| ~~YES~~		\| NO
	\| MUL		\| MUL
	\| ~~NULL~~		\|
	\|		\|
	\| ID of order ([[Table llx commande\|llx commande]]->rowid)		\| ID of order ([[Table llx commande\|llx commande]]->rowid)
	\|-		\|-
			\| fk_parent_line
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| Since ?
			\|-
	\| fk_product		\| fk_product
	\| int(11)		\| int(11)

2013-09-14T08:52:52Z

@@ Line 111: / Line 111: @@
+|
 | price before discount
-|-
+{{FieldTotalFields}}
 |-
 | product_type

2012-08-08T12:44:46Z

Table

2011-07-21T23:13:08Z

Structure

← Older revision		Revision as of 23:13, 21 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.2 2009/10/23'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 211:		Line 210:

	== Keys ==		== Keys ==
	~~'''Version 1.1 2009/10/07'''~~		{\| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
	{\| align="left" width="100%" border="0~~" rules="all~~" cellpadding="1" cellspacing="0" ~~style~~="~~margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5~~"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

2009-10-24T09:44:08Z

Table

← Older revision		Revision as of 09:44, 24 October 2009
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''Version 1.1 2009/10/07'''		'''Version 1.2 2009/10/23'''
	{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"		{\| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
	\|style="background-color: #e9e9ef"\| <b>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
Line 186:		Line 186:
	\|-		\|-
	\| special_code		\| special_code
	\| ~~tinyint~~(4)		\| int(10)
	\| YES		\| YES
	\|		\|
	\| 0		\| 0
	\|		\| UNSIGNED
	\| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0		\| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
	\|-		\|-