4,395
edits
Changes
→Table
Line 1:
Line 1:
+
+
+
+
+
[[Category:Table SQL]]
[[Category:Table SQL]]
−[[Category:Taxes and social contributions]]
+[[Category:Taxes et charges sociales]]
+[[Category:Impuestos y cargas sociales]]
{{ListOfTables}}
{{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 =
= 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"
{| 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 15:
Line 24:
|style="background-color: #e9e9ef"| <b>Description</b>
|style="background-color: #e9e9ef"| <b>Description</b>
|-
|-
−| rowid
+| id
| int(11)
| int(11)
−|
+| NO
| PRI
| PRI
−| NULL
+|
| auto_increment
| auto_increment
| technical index
| 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)
+|}
+== 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
+|}