Table llx facture fourn det
Jump to navigation
Jump to search
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 providers invoices. This table is linked to Table llx facture fourn
Contient les lignes des factures fournisseurs. Cette table est liée avec la Table llx facture fourn
Contiene las líneas de las facturas de proveedores. Esta tabla está vinculada con la Table llx facture fourn
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| fk_facture_fourn | int(11) | NO | MUL | ID of provider invoice (llx_facture_fourn->rowid) | ||
| fk_product | int(11) | YES | NULL | ID of product (llx_product->rowid) | ||
| ref | varchar(50) | YES | NULL | supplier ref. of product | ||
| label | varchar(255) | YES | NULL | label of product | ||
| description | text | YES | NULL | description of supplier invoice line | ||
| pu_ht | double(24,8) | YES | NULL | unit price excluding tax | ||
| pu_ttc | double(24,8) | YES | NULL | unit price with tax | ||
| qty | real | YES | NULL | quantity of product | ||
| tva_taux | double(24,8) | YES | 0.00000000 | tax | ||
| 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 | int(11) | YES | 0 | type of product | ||
| date_start | datetime | YES | NULL | start date if service | ||
| date_end | datetime | YES | NULL | end date if service | ||
| 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 |
| idx_facture_fourn_det_fk_facture | MULTIPLE | fk_facture_fourn |