Table llx facturedet
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 lines of customer invoices, this table is linked with Table llx_facture.
Contient les lignes des factures clients, cette table est liée avec la Table llx_facture.
Contiene las líneas de las facturas a clientes, esta tabla está vinculada con Table llx_facture.
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | integer | NO | PRI | auto_increment | technical index | |
| fk_facture | integer | NO | MUL | 0 | ID of invoice (Table llx_facture->rowid) | |
| fk_product | integer | YES | NULL | ID of product (Table llx_product->rowid) | ||
| description | text | YES | NULL | description of customer invoice line | ||
| tva_tx | double(24,8) | YES | NULL | line VAT taxes | ||
| localtax1_tx | double(24,8) | YES | NULL | localtax1_tx | ||
| localtax1_type | integer | YES | NULL | localtax_type | ||
| localtax2_tx | double(24,8) | YES | NULL | localtax2_tx | ||
| localtax2_type | integer | YES | NULL | localtax2_type | ||
| qty | real | YES | NULL | quantity of the product or service | ||
| remise_percent | double(24,8) | YES | 0 | discount percentage | ||
| remise | double(24,8) | YES | 0 | discount amount | ||
| fk_remise_except | integer | YES | UNI | NULL | ID of discount (llx_societe_remise_except->rowid) | |
| subprice | double(24,8) | YES | NULL | price before discount | ||
| price | double(24,8) | YES | NULL | deprecated | ||
| total_ht | double(24,8) | YES | NULL | total excluding taxes | ||
| total_tva | double(24,8) | YES | NULL | total tax | ||
| total_localtax1 | double(24,8) | YES | NULL | total local tax 1 | ||
| total_localtax2 | double(24,8) | YES | NULL | total local tax 2 | ||
| total_ttc | double(24,8) | YES | NULL | Total including discount and taxes (vat + localtax1 + localtax2) | ||
| product_type | integer | YES | 0 | Type of product | ||
| date_start | datetime | YES | NULL | start date if service | ||
| date_end | datetime | YES | NULL | end date if service | ||
| info_bits | integer | YES | 0 | TVA NPR or not | ||
| buy_price_ht | double(24,8) | YES | 0 | TVA NPR or not | ||
| fk_code_ventilation | integer | NO | 0 | ID of accounting code (llx_accounting_account->rowid) | ||
| fk_export_compta | integer | NO | 0 | ID of acountacy export (llx_export_compta->rowid) | ||
| special_code | integer | YES | 0 | 0=default, 1=seems not used, 2=used by WEEE module to define line as a WEEE line, 3=option line (price not included in total), 4=Sent for cooking (POS modules for restaurant) | ||
| rang | integer | YES | 0 | Position of line. Lower value are line top, higher value are bottom. | ||
| import_key | varchar(14) | YES | NULL | Code used to save the import id. See page Field Import key. |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_fk_remise_except | UNIQUE | fk_remise_except |
| idx_facturedet_fk_facture | MULTIPLE | fk_facture |