Table llx facture rec
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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 predefined invoices. The invoice details are in Table llx_facturedet_rec
Contient les factures prédéfinies. les détails de la facture sont dans la Table llx_facturedet_rec
Contiene las facturas predefinidas. Los detalles de la factura se encuentran en la Table llx_facturedet_rec
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| titre | varchar(50) | NO | UNI | title | ||
| entity | int(11) | NO | UNI | 1 | multi company id | |
| fk_soc | int(11) | NO | MUL | ID society (llx_societe->rowid) | ||
| datec | datetime | YES | NULL | creation date | ||
| amount | real | NO | 0 | amount | ||
| remise | real | YES | 0 | discount | ||
| remise_percent | real | YES | 0 | percent discount | ||
| remise_absolute | real | YES | 0 | absolut discount | ||
| tva | real | YES | 0 | VAT | ||
| total | real | YES | 0 | total | ||
| total_ttc | real | YES | 0 | total with tax | ||
| fk_user_author | int(11) | YES | MUL | NULL | ID of user author of invoice (llx_user->rowid) | |
| fk_projet | int(11) | YES | MUL | NULL | ID of related proyect (llx_projet->rowid) | |
| fk_cond_reglement | int(11) | NO | 0 | Id of payment condition (llx_cond_reglement->rowid) | ||
| fk_mode_reglement | int(11) | NO | 0 | Id of payment mode | ||
| date_lim_reglement | date | YES | NULL | date limit for payment | ||
| note | text | YES | NULL | comentary | ||
| note_public | text | YES | NULL | public comentary | ||
| frequency | char(2) | YES | NULL | invoice frequency | ||
| last_gen | varchar(7) | YES | NULL |
Keys
| Key | Type | Fields | ||||
| PRIMARY | PRIMARY | rowid | ||||
| idx_facture_rec_uk_titre | UNI | titre, entity | - | idx_facture_rec_fk_soc | MULTIPLE | fk_soc |
| idx_facture_rec_fk_user_author | MULTIPLE | fk_user_author | ||||
| idx_facture_rec_fk_projet | MULTIPLE | fk_projet |