Table llx commande fournisseurdet - Revision history

Eldy at 11:18, 25 July 2024

2024-07-25T11:18:23Z

← Older revision		Revision as of 11:18, 25 July 2024
Line 138:		Line 138:
	\| end date if service		\| end date if service
	\|-		\|-
	~~\| info_bits~~		{{FieldInfoBits}}
	~~\| int(11)~~		}
	~~\| YES~~
	\|
	~~\| 0~~
	\|
	~~\| TVA NPR or not~~
	\|}~~ ~~

	== Keys ==		== Keys ==

Eldy: /* Tables */

2013-09-14T08:58:58Z

Tables

@@ Line 112: / Line 112: @@
+|
 | unit price before
-|-
+{{FieldTotalFields}}
 |-
 | product_type
@@ Line 169: / Line 146: @@
 | TVA NPR or not
 |}&nbsp;
 == Keys ==
 {|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"

Simnandez: /* Structure */

2011-07-19T14:33:52Z

Structure

← Older revision		Revision as of 14:33, 19 July 2011
Line 16:		Line 16:
	= Structure =		= Structure =
	== Tables ==		== Tables ==
	~~'''Version 1.2 2009/12/21'''~~		{\| 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 171:		Line 170:
	\|}		\|}
	== 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>

Klaitos: Petite faute de frappe corrigée

2011-07-07T10:00:53Z

Petite faute de frappe corrigée

← Older revision		Revision as of 10:00, 7 July 2011
Line 10:		Line 10:
	{{flag en}} Contains details of providers orders. This table is linked to [[Table llx_commande_fournisseur]]		{{flag en}} Contains details of providers orders. This table is linked to [[Table llx_commande_fournisseur]]

	{{flag fr}} Contient les détails des commandes ~~fournisserus~~, cette table est liée avec la [[Table llx_commande_fournisseur]]		{{flag fr}} Contient les détails des commandes fournisseurs, cette table est liée avec la [[Table llx_commande_fournisseur]]

	{{flag sp}} Contiene los detalles de los pedidos a proveedores, esta tabla esta vinculada con [[Table llx_commande_fournisseur]]		{{flag sp}} Contiene los detalles de los pedidos a proveedores, esta tabla esta vinculada con [[Table llx_commande_fournisseur]]

Simnandez at 16:09, 21 December 2009

2009-12-21T16:09:45Z

← Older revision		Revision as of 16:09, 21 December 2009
Line 16:		Line 16:
	= Structure =		= Structure =
	== Tables ==		== Tables ==
	'''Version 1.1 2009/10/07'''		'''Version 1.2 2009/12/21'''
	{\| 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>

Simnandez: /* Structure */

2009-10-20T07:37:09Z

Structure

← Older revision		Revision as of 07:37, 20 October 2009
Line 15:		Line 15:

	= Structure =		= Structure =
			== Tables ==
			'''Version 1.1 2009/10/07'''
	{\| 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 26:		Line 28:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 34:		Line 36:
	\| fk_commande		\| fk_commande
	\| int(11)		\| int(11)
	\| ~~YES~~		\| NO
			\|
	\|		\|
	~~\| NULL~~
	\|		\|
	\| ID of order ([[Table llx commande\|llx commande]]->rowid)		\| ID of order ([[Table llx commande\|llx commande]]->rowid)
Line 76:		Line 78:
	\| YES		\| YES
	\|		\|
	\| ~~NULL~~		\| 0.000
	\|		\|
	\| VAT taxes		\| VAT taxes
	\|-		\|-
	\| qty		\| qty
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 89:		Line 91:
	\|-		\|-
	\| remise_percent		\| remise_percent
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 97:		Line 99:
	\|-		\|-
	\| remise		\| remise
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
Line 108:		Line 110:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| unit price before		\| unit price before
Line 116:		Line 118:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total excluding tax		\| total excluding tax
Line 124:		Line 126:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total tax		\| total tax
Line 132:		Line 134:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|		\|
	\| total with tax		\| total with tax
Line 167:		Line 169:
	\|		\|
	\| TVA NPR or not		\| TVA NPR or not
	\|}		\|}
			== Keys ==
			'''Version 1.1 2009/10/07'''
			{\| 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
			\|}

Eldy: /* Structure */

2009-07-04T11:56:53Z

Structure

← Older revision		Revision as of 11:56, 4 July 2009
Line 54:		Line 54:
	\| NULL		\| NULL
	\|		\|
	\| ref. of product		\| supplier ref. of product
	\|-		\|-
	\| label		\| label

Simnandez: /* Contenu */

2009-06-03T17:15:13Z

Contenu

← Older revision		Revision as of 17:15, 3 June 2009
Line 6:		Line 6:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =

	{{flag fr}} ~~Contient le détail des lignes de commandes fournisseurs~~.		{{flag en}} Contains details of providers orders. This table is linked to [[Table llx_commande_fournisseur]]

	{{flag en}} ~~Contains the details of provider orders lines.~~		{{flag fr}} Contient les détails des commandes fournisserus, cette table est liée avec la [[Table llx_commande_fournisseur]]

	{{flag sp}} Contiene los detalles ~~de las líneas~~ de los pedidos a proveedores.		{{flag sp}} Contiene los detalles de los pedidos a proveedores, esta tabla esta vinculada con [[Table llx_commande_fournisseur]]

	= Structure =		= Structure =

Simnandez: /* Structure */

2009-06-03T17:09:41Z

Structure

← Older revision		Revision as of 17:09, 3 June 2009
Line 32:		Line 32:
	\| technical index		\| technical index
	\|-		\|-
			\| fk_commande
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| ID of order ([[Table llx commande\|llx commande]]->rowid)
			\|-
			\| fk_product
			\| int(11)
			\| YES
			\|
			\| NULL
			\|
			\| ID of product ([[Table llx_product\|llx_product]]->rowid)
			\|-
			\| ref
			\| varchar(50)
			\| YES
			\|
			\| NULL
			\|
			\| ref. of product
			\|-
			\| label
			\| varchar(255)
			\| YES
			\|
			\| NULL
			\|
			\| label of product
			\|-
			\| description
			\| text
			\| YES
			\|
			\| NULL
			\|
			\| product description
			\|-
			\| tva_tx
			\| double(6,3)
			\| YES
			\|
			\| NULL
			\|
			\| VAT taxes
			\|-
			\| qty
			\| double
			\| YES
			\|
			\| NULL
			\|
			\| Quantity of product
			\|-
			\| remise_percent
			\| double
			\| YES
			\|
			\| 0
			\|
			\| discount percentage
			\|-
			\| remise
			\| double
			\| YES
			\|
			\| 0
			\|
			\| discount amount
			\|-
			\| subprice
			\| double(24,8)
			\| YES
			\|
			\| 0.00
			\|
			\| unit price before
			\|-
			\| total_ht
			\| double(24,8)
			\| YES
			\|
			\| 0.00
			\|
			\| total excluding tax
			\|-
			\| total_tva
			\| double(24,8)
			\| YES
			\|
			\| 0.00
			\|
			\| total tax
			\|-
			\| total_ttc
			\| double(24,8)
			\| YES
			\|
			\| 0.00
			\|
			\| total with tax
			\|-
			\| product_type
			\| int(11)
			\| YES
			\|
			\| 0
			\|
			\| type of product
			\|-
			\| date_start
			\| datetime
			\| YES
			\|
			\| NULL
			\|
			\| start date if service
			\|-
			\| date_end
			\| datetime
			\| YES
			\|
			\| NULL
			\|
			\| end date if service
			\|-
			\| info_bits
			\| int(11)
			\| YES
			\|
			\| 0
			\|
			\| TVA NPR or not
			\|}

Simnandez: /* Structure */

2009-05-12T08:49:37Z

Structure

← Older revision		Revision as of 08:49, 12 May 2009
Line 15:		Line 15:

	= Structure =		= Structure =
			{\| 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>Type</b>
			\|style="background-color: #e9e9ef"\| <b>Null</b>
			\|style="background-color: #e9e9ef"\| <b>Key</b>
			\|style="background-color: #e9e9ef"\| <b>Default</b>
			\|style="background-color: #e9e9ef"\| <b>Extra</b>
			\|style="background-color: #e9e9ef"\| <b>Description</b>
			\|-
			\| rowid
			\| int(11)
			\|
			\| PRI
			\| NULL
			\| auto_increment
			\| technical index
			\|-