Table llx accounting system - Revision history

Udo.tamm: Udo.tamm moved page Table llx accountingsystem to Table llx accounting system

2022-03-31T22:25:43Z

Udo.tamm moved page Table llx accountingsystem to Table llx accounting system

← Older revision

Revision as of 22:25, 31 March 2022

Eldy: /* Table */

2012-08-09T16:55:12Z

Table

← Older revision		Revision as of 16:55, 9 August 2012
Line 61:		Line 61:
	\|		\|
	\| author		\| author
	\|-		{{FieldTms}}
	~~\| tms~~
	~~\| timestamp~~
	~~\| NO~~
	\|
	~~\| CURRENT_TIMESTAMP~~
	\|
	~~\| last update date~~
	\|-		\|-
	\| active		\| active

Eldy: /* Keys */

2011-07-19T01:50:53Z

Keys

← Older revision		Revision as of 01:50, 19 July 2011
Line 80:		Line 80:

	==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" cellpadding="1" cellspacing="0" class="dolbox"
	\|style="background-color: #e9e9ef"\| <b>Key</b>		\|style="background-color: #e9e9ef"\| <b>Key</b>

Eldy: /* Structure */

2011-07-19T01:50:44Z

Structure

← Older revision		Revision as of 01:50, 19 July 2011
Line 13:		Line 13:
	= 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 82:		Line 81:
	==Keys==		==Keys==
	'''Version 1.1 2009/10/07'''		'''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" cellpadding="1" cellspacing="0" class="dolbox"
	\|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>

Simnandez: Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the accounting system of each country. {{flag fr}} Contient les systèmes comptable...'

2009-11-18T22:02:06Z

Created page with 'Category:Table SQL {{ListOfTables}} = Content/Contenu/Contenido = {{flag en}} Contains the accounting system of each country. {{flag fr}} Contient les systèmes comptable...'

New page

[[Category:Table SQL]]

{{ListOfTables}}

= Content/Contenu/Contenido =

{{flag en}} Contains the accounting system of each country.

{{flag fr}} Contient les systèmes comptables de chaque pays.

{{flag sp}} Contiene los sistemas contables de cada país.

= 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"
|style="background-color: #e9e9ef"| Field
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Null
|style="background-color: #e9e9ef"| Key
|style="background-color: #e9e9ef"| Default
|style="background-color: #e9e9ef"| Extra
|style="background-color: #e9e9ef"| Description
|-
| pcg_version
| varchar(12)
| NO
| PRI
|
|
| ID of accounting system
|-
| fk_pays
| int(11)
| NO
|
|
|
| ID of country ([[Table llx_c_pays|llx_c_pays]]->row_id)
|-
| label
| varchar(128)
| NO
|
|
|
| label of accounting system
|-
| datec
| varchar(12)
| NO
|
|
|
| creation date
|-
| fk_author
| varchar(20)
| YES
|
| NULL
|
| author
|-
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| last update date
|-
| active
| smallint(6)
| YES
|
| 0
|
| is the account system active?
|} 

==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"| Key
|style="background-color: #e9e9ef"| Type
|style="background-color: #e9e9ef"| Fields
|-
| PRIMARY
| PRIMARY
| pcg_version
|}