Table llx commande - Revision history

Eldy: /* Structure */

2011-07-19T10:32:20Z

Structure

← Older revision		Revision as of 10:32, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	{\| 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" cellpadding="1" cellspacing="0" class="dolbox"
	\|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 255:		Line 255:

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

Eldy: /* Table */

2011-07-13T15:34:12Z

Table

← Older revision		Revision as of 15:34, 13 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''Version 1.2 2010/01/13'''~~
	{\| 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 171:		Line 170:
	\|		\|
	\| VAT		\| VAT
			{{FieldLocalTaxX}}
	\|-		\|-
	\| total_ht		\| total_ht

Eldy: /* Table */

2011-05-31T14:16:09Z

Table

← Older revision		Revision as of 14:16, 31 May 2011
Line 66:		Line 66:
	\|		\|
	\| ID of proyect ([[Table llx_projet\|llx_projet]]->rowid)		\| ID of proyect ([[Table llx_projet\|llx_projet]]->rowid)
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| date_creation		\| date_creation
Line 258:		Line 251:
	\|		\|
	\| delivery address		\| delivery address
	\|-		{{FieldImportKey}}
	~~\| import_key~~
	~~\| varchar(14)~~
	~~\| YES~~
	\|
	~~\| NULL~~
	\|
	~~\| import key~~
	\|}		\|}

Eldy: /* Table */

2011-05-30T07:53:18Z

Table

← Older revision		Revision as of 07:53, 30 May 2011
Line 33:		Line 33:
	\| technical index		\| technical index
	\|-		\|-
	\| ~~tms~~		\| ref
	\| ~~timestamp~~		\| varchar(30)
	\| NO		\| YES
			\| UNI
			\|
			\|
			\| order number
			{{FieldEntity}}
			{{FieldRefExt}}
			\|-
			\| ref_client
			\| varchar(30)
			\| YES
	\|		\|
	\| ~~CURRENT_TIMESTAMP~~		\| NULL
	\|		\|
	\| ~~last update date~~		\| costumer order number
	\|-		\|-
	\| fk_soc		\| fk_soc
Line 57:		Line 67:
	\| ID of proyect ([[Table llx_projet\|llx_projet]]->rowid)		\| ID of proyect ([[Table llx_projet\|llx_projet]]->rowid)
	\|-		\|-
	\| ~~ref~~		\| tms
	\| ~~varchar(30)~~		\| timestamp
	\| ~~YES~~		\| NO
	~~\| UNI~~
	\|		\|
			\| CURRENT_TIMESTAMP
	\|		\|
	\| ~~order number~~		\| last update date
	~~{{FieldEntity}}~~
	~~{{FieldRefExt}}~~
	\|-
	~~\| ref_client~~
	~~\| varchar(30)~~
	~~\| YES~~
	\|
	~~\| NULL~~
	\|
	~~\| costumer order number~~
	\|-		\|-
	\| date_creation		\| date_creation

Eldy: /* Table */

2011-05-30T07:51:33Z

Table

← Older revision		Revision as of 07:51, 30 May 2011
Line 64:		Line 64:
	\|		\|
	\| order number		\| order number
	\|-		{{FieldEntity}}
	~~\| entity~~		{{FieldRefExt}}
	~~\| int(11)~~
	~~\| NO~~
	~~\| UNI~~
	~~\| 1~~
	\|
	~~\| multi company id~~
	\|-		\|-
	\| ref_client		\| ref_client

Simnandez: /* Table */

2010-01-14T16:23:57Z

Table

← Older revision		Revision as of 16:23, 14 January 2010
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	'''Version 1.~~1 2009~~/10/07'''		'''Version 1.2 2010/01/13'''
	{\| 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 273:		Line 273:
	\| import key		\| import key
	\|}		\|}

	== Keys ==		== Keys ==
	'''Version 1.1 2009/10/07'''		'''Version 1.1 2009/10/07'''

Simnandez: /* Structure */

2009-10-20T07:03:42Z

Structure

← Older revision		Revision as of 07:03, 20 October 2009
Line 14:		Line 14:

	= Structure =		= Structure =
	'''Version 1.19 2009/04/29'''		== Table ==
			'''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 29:		Line 29:
	\| NO		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 253:		Line 253:
	\| YES		\| YES
	\|		\|
	\|		\| NULL
	\|		\|
	\| delivery date		\| delivery date
Line 272:		Line 272:
	\|		\|
	\| import key		\| import key
			\|}
			== 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
			\|-
			\| uk_commande_ref
			\| UNIQUE
			\| ref,entity
			\|-
			\| idx_commande_fk_soc
			\| MULTIPLE
			\| fk_soc
	\|}		\|}

Simnandez: /* Structure */

2009-10-08T15:32:23Z

Structure

← Older revision		Revision as of 15:32, 8 October 2009
Line 44:		Line 44:
	\| int(11)		\| int(11)
	\| NO		\| NO
	\|		\| MUL
	\|		\|
	\|		\|
Line 60:		Line 60:
	\| varchar(30)		\| varchar(30)
	\| YES		\| YES
	\|		\| UNI
	\|		\|
	\|		\|
Line 68:		Line 68:
	\| int(11)		\| int(11)
	\| NO		\| NO
	\|		\| UNI
	\| 1		\| 1
	\|		\|

Simnandez: /* Structure */

2009-10-08T15:30:40Z

Structure

← Older revision		Revision as of 15:30, 8 October 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			'''Version 1.19 2009/04/29'''

	{\| 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		\| NULL
Line 49:		Line 51:
	\| fk_projet		\| fk_projet
	\| int(11)		\| int(11)
	\|		\| YES
	\|		\|
	\| 0		\| 0
Line 65:		Line 67:
	\| entity		\| entity
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\|		\|
	\| 1		\| 1
Line 149:		Line 151:
	\| 0		\| 0
	\|		\|
	\|		\| ID of status
	\|-		\|-
	\| amount_ht		\| amount_ht
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
	\| 0		\| 0
	\|		\|
	\|		\| amount without tax
	\|-		\|-
	\| remise_percent		\| remise_percent
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
	\| 0		\| 0
	\|		\|
	\|		\| discount percentage
	\|-		\|-
	\| remise		\| remise
	\| ~~double~~		\| real
	\| YES		\| YES
	\|		\|
	\| 0		\| 0
	\|		\|
	\|		\| discount amount
	\|-		\|-
	\| tva		\| tva
Line 179:		Line 181:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|
	\|		\|
			\| VAT
	\|-		\|-
	\| total_ht		\| total_ht
Line 187:		Line 189:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|
	\|		\|
			\| total without tax
	\|-		\|-
	\| total_ttc		\| total_ttc
Line 195:		Line 197:
	\| YES		\| YES
	\|		\|
	\| 0.00		\| 0.00000000
	\|
	\|		\|
			\| total
	\|-		\|-
	\| note		\| note
Line 270:		Line 272:
	\|		\|
	\| import key		\| import key
	\|}		\|}

Simnandez: /* Structure */

2009-06-05T10:13:34Z

Structure

← Older revision		Revision as of 10:13, 5 June 2009
Line 237:		Line 237:
	\| NULL		\| NULL
	\|		\|
	\| ID conditions of payment		\| ID conditions of payment ([[Table llx_cond_reglement\|llx_cond_reglement]]->rowid)
	\|-		\|-
	\| fk_mode_reglement		\| fk_mode_reglement