4,395
edits
Table llx element element: Difference between revisions
Jump to navigation
Jump to search
→Contenu
m (→Contenu) |
|||
| Line 5: | Line 5: | ||
{{ListOfTables}} | {{ListOfTables}} | ||
= Contenu = | = Content/Contenu/Contenido = | ||
{{flag en}} This table allows to save the links between entities. | |||
For example when a contract must be linked to a intervention card, we use this table. | |||
Historically, the links were stored in a table dedicated to each couple. In version 2.5 and above, the links should be stored in this table. | |||
This table contains 4 columns to create the links. | |||
* The id of the source object | |||
* The type of the source (field sourcetype). The value to set is a code that indicates the nature of the entity. | |||
* The id of the destination object | |||
* The type of the destination object (field targettype). The value to set is a code that indicates the nature of the entity. | |||
Here is the list of types to use for define the entity to its related id. | |||
* "user" : In this case the id field must be an id of the table llx_user | |||
* "intervention" : In this case the id field must be an id of the table llx_fichinter | |||
* "invoice" : In this case the id field must be an id of the table llx_facture | |||
* "supplier_invoice" : In this case the id field must be an id of the table llx_facture_fournisseur | |||
* "contract" : In this case the id field must be an id of the table llx_contrat. | |||
* "order" : In this case the id field must be an id of the table llx_commande | |||
* "supplier_order" : In this case the id field must be an id of the table llx_commande_fournisseur | |||
* "member" : In this case the id field must be an id of the table llx_adherent | |||
* "propal" : In this case the id field must be an id of the table llx_propal | |||
* "sending" : In this case the id field must be an id of the table llx_expedition | |||
* "delivery" : In this case the id field must be an id of the table llx_livraison | |||
This allows to use 1 single table for any type of links instead of 2<sup>n</sup> tables (where n is the number of managed entities in Dolibarr). | |||
{{flag fr}} Cette table permet de sauvegarder les liens entre entités. | {{flag fr}} Cette table permet de sauvegarder les liens entre entités. | ||