Difference between revisions of "Table llx c chargesociales"

Latest revision as of 11:42, 26 October 2009

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the social contributions types

Contient les types des charges sociales

Contiene los tipos de cargas sociales

Structure

Table

Version 1.2 2009/10/25

Field	Type	Null	Key	Default	Extra	Description
id	int(11)	NO	PRI		auto_increment	technical index
libelle	varchar(80)	YES		NULL		label of social contribution
deductible	smallint(6)	NO		0		is the social contribution deductible?
active	tinyint(4)	NO		1		is the social contribution active?
code	varchar(12)	NO				code
fk_pays	int(11)	NO		1		ID of country (llx_c_pays->rowid)

Keys

Version 1.1 2009/10/07

Key	Type	Fields
PRIMARY	PRIMARY	id

@@ Line 1: / Line 1: @@
 [[Category:Table SQL]]
+[[Category:Taxes and social contributions]]
+[[Category:Taxes et charges sociales]]
+[[Category:Impuestos y cargas sociales]]
 {{ListOfTables}}
-= Content/Contenu =
+= Content/Contenu/Contenido =
+{{flag en}} Contains the social contributions types
+{{flag fr}} Contient les types des charges sociales
+{{flag sp}} Contiene los tipos de cargas sociales
 = Structure =
+== Table ==
+'''Version 1.2 2009/10/25'''
 {|  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>
@@ Line 15: / Line 24: @@
   |style="background-color: #e9e9ef"| <b>Description</b>
 |-
-| rowid
+| id
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
-|}
+|-
+| libelle
+| varchar(80)
+| YES
+|
+| NULL
+|
+| label of social contribution
+|-
+| deductible
+| smallint(6)
+| NO
+|
+| 0
+|
+| is the social contribution deductible?
+|-
+| active
+| tinyint(4)
+| NO
+|
+| 1
+|
+| is the social contribution active?
+|-
+| code
+| varchar(12)
+| NO
+|
+|
+|
+| code
+|-
+| fk_pays
+| int(11)
+| NO
+|
+| 1
+|
+| ID of country ([[Table llx_c_pays|llx_c_pays]]->rowid)
+|}&nbsp;
+== 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
+| id
+|}&nbsp;