Difference between revisions of "Table llx paiementfourn facturefourn"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 14: | Line 14: | ||
= Structure = | = Structure = | ||
| − | {| align="left" width="100%" border="0 | + | == Table == |
| + | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
|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 25: | Line 26: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| − | | | + | | NO |
| PRI | | PRI | ||
| − | | | + | | |
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
| Line 34: | Line 35: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| − | | | + | | UNI |
| NULL | | NULL | ||
| | | | ||
| Line 42: | Line 43: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| − | | | + | | UNI |
| NULL | | NULL | ||
| | | | ||
| Line 54: | Line 55: | ||
| | | | ||
| amount of payment | | amount of payment | ||
| − | |} | + | |} |
| + | == Keys == | ||
| + | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
| + | |style="background-color: #e9e9ef"| <b>Key</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Fields</b> | ||
| + | |- | ||
| + | | PRIMARY | ||
| + | | PRIMARY | ||
| + | | rowid | ||
| + | |- | ||
| + | | uk_paiementfourn_facturefourn | ||
| + | | UNIQUE | ||
| + | | fk_paiementfourn,fk_facturefourn | ||
| + | |- | ||
| + | | idx_paiementfourn_facturefourn_fk_facturefourn | ||
| + | | MULTIPLE | ||
| + | | fk_facturefourn | ||
| + | |- | ||
| + | | idx_paiementfourn_facturefourn_fk_paiementfourn | ||
| + | | MULTIPLE | ||
| + | | fk_paiementfourn | ||
| + | |} | ||
Latest revision as of 15:36, 19 July 2011
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
Establishes the link between payments isued and the corresponding supplier invoices.
Etablit le lien entre les paiements émis et les factures fournisseur correspondantes.
Establece el enlace entre los pagos emitidos y las facturas de proveedor correspondientes.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| fk_paimentfourn | int(11) | YES | UNI | NULL | (llx_paiementfourn->rowid) | |
| fk_facturefourn | int(11) | YES | UNI | NULL | (llx_facture_fourn->rowid) | |
| amount | double | YES | 0 | amount of payment |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_paiementfourn_facturefourn | UNIQUE | fk_paiementfourn,fk_facturefourn |
| idx_paiementfourn_facturefourn_fk_facturefourn | MULTIPLE | fk_facturefourn |
| idx_paiementfourn_facturefourn_fk_paiementfourn | MULTIPLE | fk_paiementfourn |