Table llx c payment term - Revision history

Ssherratt: /* Table */

2018-09-13T15:37:22Z

Table

← Older revision		Revision as of 15:37, 13 September 2018
Line 38:		Line 38:
	\| NULL		\| NULL
	\|		\|
	\| ~~intern~~ code to ~~search~~ the translations		\| internal code used to refer to the translations
	\|-		\|-
	\| sortorder		\| sortorder
Line 62:		Line 62:
	\| NULL		\| NULL
	\|		\|
	\| label (name) shown on screen (~~although caught in the language files, so it is~~ used only if no translation is found)		\| label (name) shown on screen (this label will be used only if no translation is found in the language file)
	\|-		\|-
	\| libelle_facture		\| libelle_facture
Line 70:		Line 70:
	\| NULL		\| NULL
	\|		\|
	\| label (name) shown on PDF documents (~~although caught in the language files, so it is~~ used only if no translation is found)		\| label (name) shown on PDF documents (this label will be used only if no translation is found in the language file)
	\|-		\|-
	\| fdm		\| fdm

Eldy: /* Structure */

2011-07-19T10:19:37Z

Structure

← Older revision		Revision as of 10:19, 19 July 2011
Line 15:		Line 15:
	= Structure =		= Structure =
	== Table ==		== Table ==
	~~'''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>Field</b>		\|style="background-color: #e9e9ef"\| <b>Field</b>
	\|style="background-color: #e9e9ef"\| <b>Type</b>		\|style="background-color: #e9e9ef"\| <b>Type</b>
Line 99:		Line 98:

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

2010-09-05T23:35:11Z

Table

← Older revision		Revision as of 23:35, 5 September 2010
Line 63:		Line 63:
	\| NULL		\| NULL
	\|		\|
	\| label (name) shown on screen (although caught in the language files, so it is used only no translation ~~are~~ found)		\| label (name) shown on screen (although caught in the language files, so it is used only if no translation is found)
	\|-		\|-
	\| libelle_facture		\| libelle_facture
Line 71:		Line 71:
	\| NULL		\| NULL
	\|		\|
	\| label (name) shown on PDF documents (although caught in the language files, so it is used only if no translation ~~are~~ found)		\| label (name) shown on PDF documents (although caught in the language files, so it is used only if no translation is found)
	\|-		\|-
	\| fdm		\| fdm
Line 97:		Line 97:
	\| if end of month is used, you can also add an offset for days from the start of month for the due date		\| if end of month is used, you can also add an offset for days from the start of month for the due date
	\|}		\|}

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

Eldy: moved Table llx c payment mode to Table llx c payment term

2010-09-05T23:34:20Z

moved Table llx c payment mode to Table llx c payment term

← Older revision

Revision as of 23:34, 5 September 2010

Eldy: moved Table llx cond reglement to Table llx c payment mode

2010-09-05T23:25:43Z

moved Table llx cond reglement to Table llx c payment mode

← Older revision

Revision as of 23:25, 5 September 2010

Simnandez: /* Structure */

2009-10-20T08:13:59Z

Structure

← Older revision		Revision as of 08:13, 20 October 2009
Line 14:		Line 14:

	= Structure =		= Structure =
			== 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 25:		Line 27:
	\| rowid		\| rowid
	\| int(11)		\| int(11)
	\| ~~ ~~		\| NO
	\| PRI		\| PRI
	\| ~~NULL~~		\|
	\| auto_increment		\| auto_increment
	\| technical index		\| technical index
Line 53:		Line 55:
	\| 1		\| 1
	\|		\|
	\| 1=~~actif~~, 0=~~inactif~~		\| is the payment condition active (1=yes, 0=no)?
	\|-		\|-
	\| libelle		\| libelle
Line 94:		Line 96:
	\|		\|
	\| if end of month is used, you can also add an offset for days from the start of month for the due date		\| if end of month is used, you can also add an offset for days from the start of month for the due date
	\|}		\|}
			== 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
			\|}

Simnandez at 07:32, 8 June 2009

2009-06-08T07:32:24Z

← Older revision		Revision as of 07:32, 8 June 2009
Line 1:		Line 1:
	[[Category:Table SQL]]		[[Category:Table SQL]]
			[[Category:Invoices]]
			[[Category:Facture]]
			[[Category:Facturas]]
	{{ListOfTables}}		{{ListOfTables}}

Simnandez: /* Contenu */

2009-06-05T10:10:51Z

Contenu

← Older revision		Revision as of 10:10, 5 June 2009
Line 2:		Line 2:
	{{ListOfTables}}		{{ListOfTables}}

	= Contenu =		= Content/Contenu/Contenido =

	{{flag fr}} ~~La table '''llx_cond_reglement''' contient les~~ conditions ~~de règlement de factures les plus courantes~~: 30 ~~jours fin de mois~~, 60 ~~jours fin de mois~~, ~~à réception~~, proforma, etc.		{{flag en}} Contains the most current payment conditions for invoices: 30 days end of month, 60 days end of month, upon receipt, proforma, etc.

	{{flag en}} ~~Contains the most current payment~~ conditions ~~for invoices~~: 30 ~~days end of month~~, 60 ~~days end of month~~, ~~upon receipt~~, proforma, etc.		{{flag fr}} Contient les conditions de règlement de factures les plus courantes: 30 jours fin de mois, 60 jours fin de mois, à réception, proforma, etc.

	{{flag sp}} Contiene las condiciones de pago para las facturas más comunes: 30 días a fin de mes, 60 días a fin de mes, a la recepción, proforma, etc.		{{flag sp}} Contiene las condiciones de pago para las facturas más comunes: 30 días a fin de mes, 60 días a fin de mes, a la recepción, proforma, etc.

	= Structure =		= Structure =

Eldy: /* Structure */

2009-05-12T12:01:39Z

Structure

← Older revision		Revision as of 12:01, 12 May 2009
Line 92:		Line 92:
	\| if end of month is used, you can also add an offset for days from the start of month for the due date		\| if end of month is used, you can also add an offset for days from the start of month for the due date
	\|}		\|}
	~~</pre>~~

Eldy: /* Structure */

2009-05-12T12:01:27Z

Structure

← Older revision		Revision as of 12:01, 12 May 2009
Line 82:		Line 82:
	\| NULL		\| NULL
	\|		\|
	\| number of days		\| number of days after invoice for due date
	\|-		\|-
	\| decalage		\| decalage
Line 90:		Line 90:
	\| NULL		\| NULL
	\|		\|
	\| ?		\| if end of month is used, you can also add an offset for days from the start of month for the due date
	\|}		\|}
	</pre>		</pre>