Difference between revisions of "Table llx facturedet"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Tag: 2017 source edit
 
(21 intermediate revisions by 3 users not shown)
Line 6: Line 6:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
−
= Content/Contenu/Contenido =
+
=Content/Contenu/Contenido=
 
{{Flag en}} Contains the lines of customer invoices, this table is linked with [[Table llx_facture]].
 
{{Flag en}} Contains the lines of customer invoices, this table is linked with [[Table llx_facture]].
  
Line 13: Line 13:
 
{{Flag sp}} Contiene las líneas de las facturas a clientes, esta tabla está vinculada con [[Table llx_facture]].
 
{{Flag sp}} Contiene las líneas de las facturas a clientes, esta tabla está vinculada con [[Table llx_facture]].
  
−
= Structure =
+
=Structure=
−
== Table ==
+
==Table==
−
'''Version 1.1 2009/10/07'''
+
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
−
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0"  style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+
  | 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>
+
  | style="background-color: #e9e9ef" |<b>Null</b>
−
  |style="background-color: #e9e9ef"| <b>Null</b>
+
  | style="background-color: #e9e9ef" |<b>Key</b>
−
  |style="background-color: #e9e9ef"| <b>Key</b>
+
  | style="background-color: #e9e9ef" |<b>Default</b>
−
  |style="background-color: #e9e9ef"| <b>Default</b>
+
  | style="background-color: #e9e9ef" |<b>Extra</b>
−
  |style="background-color: #e9e9ef"| <b>Extra</b>
+
  | style="background-color: #e9e9ef" |<b>Description</b>
−
  |style="background-color: #e9e9ef"| <b>Description</b>
 
 
|-  
 
|-  
−
| rowid  
+
|rowid
−
| int(11)
+
|integer
−
| NO
+
|NO
−
| PRI
+
|PRI
−
|  
+
|
−
| auto_increment  
+
|auto_increment
−
| technical index
+
|technical index
 
|-
 
|-
−
| fk_facture  
+
|fk_facture
−
| int(11)
+
|integer
−
| NO
+
|NO
−
| MUL  
+
|MUL
−
| 0
+
|0
−
|  
+
|
−
| ID of facture ([[Table llx_facture|Table llx_facture]]->rowid)
+
|ID of invoice ([[Table llx_facture|Table llx_facture]]->rowid)
 
|-
 
|-
−
| fk_product  
+
|fk_product
−
| int(11)
+
|integer
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| ID of product ([[Table llx_product|Table llx_product]]->rowid)
+
|ID of product ([[Table llx_product|Table llx_product]]->rowid)
 
|-
 
|-
−
| description  
+
|description
−
| text  
+
|text
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| description of customer invoice line
+
|description of customer invoice line
 
|-
 
|-
−
| tva_taux
+
|tva_tx
−
| real
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| line VAT taxes
+
|line VAT taxes
 
|-
 
|-
−
| qty
+
|localtax1_tx
−
| real
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| quantity of the product or service
+
|localtax1_tx
 
|-
 
|-
−
| remise_percent
+
|localtax1_type
−
| real
+
|integer
−
| YES  
+
|YES
−
|  
+
|
−
| 0
+
|NULL
−
|  
+
|
−
| discount percentage
+
|localtax_type
 
|-
 
|-
−
| remise
+
|localtax2_tx
−
| real
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| 0
+
|NULL
−
|  
+
|
−
| discount amount
+
|localtax2_tx
 
|-
 
|-
−
| fk_remise_except
+
|localtax2_type
−
| int(11)
+
|integer
−
| YES  
+
|YES
−
| UNI
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
+
|localtax2_type
 
|-
 
|-
−
| subprice
+
|qty
−
| real  
+
|real
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| price before discount
+
|quantity of the product or service
 
|-
 
|-
−
| price
+
|remise_percent
−
| real
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| NULL
+
|0
−
|  
+
|
−
| final price
+
|discount percentage
 
|-
 
|-
−
| total_ht
+
|remise
−
| real
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| NULL
+
|0
−
|  
+
|
−
| total excluding taxex
+
|discount amount
 
|-
 
|-
−
| total_tva
+
|fk_remise_except
−
| real
+
|integer
−
| YES  
+
|YES
−
|  
+
|UNI
−
| NULL  
+
|NULL
−
|  
+
|
−
| total tax
+
|ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
 
|-
 
|-
−
| total_ttc
+
|subprice
−
| real
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| total with tax
+
|price before discount
 
|-
 
|-
−
| product_type
+
|price
−
| int(11)  
+
|double(24,8)
−
| YES  
+
|YES
−
|  
+
|
−
| 0 
+
|NULL
−
|  
+
|
−
| Type of product
+
|deprecated
 +
{{FieldTotalFields}}
 
|-
 
|-
−
| date_start
+
|product_type
−
| datetime
+
|integer
−
| YES  
+
|YES
−
|  
+
|
−
| NULL
+
|0
−
|  
+
|
−
| start date if service
+
|Type of product
 
|-
 
|-
−
| date_end
+
|date_start
−
| datetime  
+
|datetime
−
| YES  
+
|YES
−
|  
+
|
−
| NULL  
+
|NULL
−
|  
+
|
−
| end date if service
+
|start date if service
 
|-
 
|-
−
| info_bits
+
|date_end
−
| int(11)
+
|datetime
−
| YES  
+
|YES
−
|  
+
|
−
| 0 
+
|NULL
−
|  
+
|
−
| TVA NPR or not
+
|end date if service
 +
{{FieldInfoBits}}
 
|-
 
|-
−
| fk_code_ventilation
+
|buy_price_ht
−
| int(11)  
+
|double(24,8)
−
| NO
+
|YES
−
|  
+
|
−
| 0  
+
|0
−
|  
+
|
−
|  
+
|The buying price (for VAT calculation)
 
|-
 
|-
−
| fk_export_compta
+
|fk_code_ventilation
−
| int(11)
+
|integer
−
| NO
+
|NO
−
|  
+
|
−
| 0  
+
|0
−
|  
+
|
−
| ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
+
|ID of accounting code ([[Table llx accounting account|llx_accounting_account]]->rowid)
 
|-
 
|-
−
| special_code
+
|fk_export_compta
−
| tinyint(4)
+
|integer
−
| YES
+
|NO
−
|  
+
|
−
| 0  
+
|0
−
| UNSIGNED
+
|
−
| view order
+
|ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
 
|-
 
|-
−
| rang
+
{{FieldSpecialCode}}
−
| int(11)
+
{{FieldRang}}
−
| YES
+
{{FieldImportKey}}
−
|
 
−
| 0
 
−
|
 
−
| view order
 
−
|-
 
−
| import_key
 
−
| varchar(14)
 
−
| YES
 
−
|
 
−
| NULL
 
−
|
 
−
| import key
 
 
|}&nbsp;
 
|}&nbsp;
−
== Keys ==
+
 
−
'''Version 1.1 2009/10/07'''
+
==Keys==
−
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0"  style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
−
  |style="background-color: #e9e9ef"| <b>Key</b>
+
  | style="background-color: #e9e9ef" |<b>Key</b>
−
  |style="background-color: #e9e9ef"| <b>Type</b>
+
  | style="background-color: #e9e9ef" |<b>Type</b>
−
  |style="background-color: #e9e9ef"| <b>Fields</b>
+
  | style="background-color: #e9e9ef" |<b>Fields</b>
 
|-  
 
|-  
−
| PRIMARY
+
|PRIMARY
−
| PRIMARY
+
|PRIMARY
−
| rowid
+
|rowid
 
|-  
 
|-  
−
| uk_fk_remise_except  
+
|uk_fk_remise_except
−
| UNI
+
|UNIQUE
−
| fk_remise_except
+
|fk_remise_except
 
|-  
 
|-  
−
| idx_facturedet_fk_facture  
+
|idx_facturedet_fk_facture
−
| MULTIPLE
+
|MULTIPLE
−
| fk_facture  
+
|fk_facture
 
|}&nbsp;
 
|}&nbsp;

Latest revision as of 11:22, 25 July 2024


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains the lines of customer invoices, this table is linked with Table llx_facture.

Fr verysmall.png Contient les lignes des factures clients, cette table est liée avec la Table llx_facture.

Es verysmall.png 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 0 TVA NPR or NOT
buy_price_ht double(24,8) YES 0 The buying price (for VAT calculation)
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 no more used (or may be used to set line as transport/shipping fee), 2=used by WEEE module to define line as a WEEE line, 3=option line (price must not included in total), 4=Sent for cooking (POS modules for restaurant), Module ID (>= 5)=value for a custom need. Value is an additional information and has no effect, except value 3 that means "do not take into account amount, it is an option" (so price must not be included in total, qty in this case should be also 0).
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

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_facturedet&oldid=60996"