Table llx c paiement: Difference between revisions
| Line 11: | Line 11: | ||
= Structure = | = Structure = | ||
'''Version 1. | == 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 61: | Line 61: | ||
| | | | ||
| is the payment active? | | is the payment 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"| <b>Key</b> | |||
|style="background-color: #e9e9ef"| <b>Type</b> | |||
|style="background-color: #e9e9ef"| <b>Fields</b> | |||
|- | |||
| PRIMARY | |||
| PRIMARY | |||
| id | |||
|- | |||
| code | |||
| UNIQUE | |||
| code | |||
|} | |} | ||
Revision as of 15:27, 19 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
Content/Contenu/Contenido
Contains the list of possible payment types, depending on your Dolibarr configuration. Used to generate drop-down lists, and to filter down lists of results.
Contient la liste des types de paiements disponibles selon votre configuration du système. Utilisée pour générer des listes déroulantes et pour filtrer des listes de résultats.
contiene la lista de los tipos de pago disponibles dependiendo de la configuración de su Dolibarr. Usada para generar las listas desplegables y filtrar los listado resultantes.
Structure
Table
Version 1.1 2009/10/07
| Field | Type | Null | Key | Default | Extra | Description |
| id | int(11) | NO | PRI | id of payment | ||
| code | varchar(6) | NO | UNI | code of payment | ||
| libelle | varchar(30) | YES | NULL | label of payment | ||
| type | smallint(6) | YES | NULL | type of payment | ||
| active | tinyint(4) | NO | 1 | is the payment active? |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| PRIMARY | PRIMARY | id |
| code | UNIQUE | code |