Table llx product price - Revision history

Ssherratt: /* Table */

2018-10-08T12:30:26Z

Table

← Older revision		Revision as of 12:30, 8 October 2018
Line 119:		Line 119:
	\| 1		\| 1
	\|		\|
	\| is the product ~~ready~~ for ~~shell~~?		\| is the product available for sale?
	\|}		\|}

2018-10-08T12:28:07Z

← Older revision		Revision as of 12:28, 8 October 2018
Line 7:		Line 7:

	= Content/Contenu/Contenido =		= Content/Contenu/Contenido =
	{{flag en}} Contains the prices of products		{{flag en}} Contains the current and historical selling prices of products.

	{{flag fr}} Contient les prix rattachés à un produit		{{flag fr}} Contient les prix rattachés à un produit
Line 47:		Line 47:
	\|		\|
	\|		\|
	\| date of this price		\| date of this price change
	\|-		\|-
	\| price_level		\| price_level
Line 79:		Line 79:
	\| NULL		\| NULL
	\|		\|
	\| ~~minium~~ price		\| minimum price
	\|-		\|-
	\| price_min_ttc		\| price_min_ttc
Line 87:		Line 87:
	\| NULL		\| NULL
	\|		\|
	\| ~~minium~~ price with VAT		\| minimum price with VAT
	\|-		\|-
	\| price_base_type		\| price_base_type
Line 95:		Line 95:
	\| HT		\| HT
	\|		\|
	\| type of price (HT or TTC)		\| type of price (HT/ex.tax or TTC/incl.tax)
	\|-		\|-
	\| tva_tx		\| tva_tx
Line 103:		Line 103:
	\|		\|
	\|		\|
	\| ~~TVA~~ rate		\| VAT rate
	\|-		\|-
	\| fk_user_author		\| fk_user_author

2012-08-10T12:48:22Z

Table

← Older revision		Revision as of 12:48, 10 August 2012
Line 31:		Line 31:
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| fk_product		\| fk_product
Line 128:		Line 121:
	\| is the product ready for shell?		\| is the product ready for shell?
	\|}		\|}

	== 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"

2011-07-19T15:42:19Z

Structure

← Older revision		Revision as of 15:42, 19 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 130:		Line 129:
	\|}		\|}
	== Keys ==		== Keys ==
	~~'''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>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>

2009-11-05T10:51:42Z

Keys

← Older revision		Revision as of 10:51, 5 November 2009
Line 130:		Line 130:
	\|}		\|}
	== Keys ==		== Keys ==
	'''Version 1.2 2009/10/23''		'''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>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>

2009-11-05T09:55:11Z

Structure

← Older revision		Revision as of 09:55, 5 November 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			== Table ==
			'''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 25:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 126:		Line 128:
	\|		\|
	\| is the product ready for shell?		\| is the product ready for shell?
	\|}		\|}
			== Keys ==
			'''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"
			\|style="background-color: #e9e9ef"\| <b>Key</b>
			\|style="background-color: #e9e9ef"\| <b>Type</b>
			\|style="background-color: #e9e9ef"\| <b>Fields</b>
			\|-
			\| PRIMARY
			\| PRIMARY
			\| rowid
			\|}

2009-09-01T14:18:35Z

Structure

← Older revision		Revision as of 14:18, 1 September 2009
Line 43:		Line 43:
	\| NO		\| NO
	\|		\|
	\| ~~NULL~~		\|
	\|		\|
	\| ID of product ([[Table llx_product\|llx_product]]->rowid)		\| ID of product ([[Table llx_product\|llx_product]]->rowid)
Line 51:		Line 51:
	\| NO		\| NO
	\|		\|
	\| ~~NULL~~		\|
	\|		\|
	\| date of this price		\| date of this price
Line 64:		Line 64:
	\|-		\|-
	\| price		\| price
	\| double(34,8)		\| double(24,8)
	\| YES		\| YES
	\|		\|
Line 107:		Line 107:
	\| NO		\| NO
	\|		\|
	\| ~~NULL~~		\|
	\|		\|
	\| TVA rate		\| TVA rate

2009-09-01T14:17:05Z

Structure

@@ Line 30: / Line 30: @@
 | auto_increment
 | technical index
 |}

2009-09-01T14:08:12Z

Contenu

← Older revision		Revision as of 14:08, 1 September 2009
Line 6:		Line 6:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =
	~~La table llx_product_price contient les prix rattachés à un produit~~		{{flag en}} Contains the prices of products

	~~Contains the prices of products~~		{{flag fr}} Contient les prix rattachés à un produit

	Contiene los precios relacionados con un producto		{{flag sp}} Contiene los precios relacionados con un producto

	= Structure =		= Structure =

2009-05-07T07:02:10Z

Contenu

← Older revision		Revision as of 07:02, 7 May 2009
Line 7:		Line 7:

	= Contenu =		= Contenu =
			La table llx_product_price contient les prix rattachés à un produit

			Contains the prices of products

			Contiene los precios relacionados con un producto

	= Structure =		= Structure =