Table llx facturedet: Difference between revisions

Jump to navigation Jump to search

Table llx facturedet (view source)

Revision as of 14:34, 18 April 2023

148 bytes removed ,  3 years ago
m
fill in the description of fk_code_ventilation
VisualWikitext
m (fill in the description of fk_code_ventilation)
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]].


{{Flag fr}} Contient les lignes des factures clients, cette table est liée avec la [[Table llx_facture]].
{{Flag fr}}
Contient les lignes des factures clients, cette table est liée avec la [[Table llx_facture]].


{{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==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
  |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
| integer
|integer
| NO
|NO
| PRI
|PRI
|  
|
| auto_increment  
|auto_increment
| technical index
|technical index
|-
|-
| fk_facture  
|fk_facture
| integer  
|integer
| NO
|NO
| MUL  
|MUL
| 0
|0
|  
|
| ID of invoice ([[Table llx_facture|Table llx_facture]]->rowid)
|ID of invoice ([[Table llx_facture|Table llx_facture]]->rowid)
|-
|-
| fk_product  
|fk_product
| integer  
|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_tx  
|tva_tx
| double(24,8)
|double(24,8)
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| line VAT taxes
|line VAT taxes
|-
|-
| localtax1_tx
|localtax1_tx
| double(24,8)
|double(24,8)
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| localtax1_tx
|localtax1_tx
|-
|-
| localtax1_type
|localtax1_type
| integer
|integer
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| localtax_type
|localtax_type
|-
|-
| localtax2_tx
|localtax2_tx
| double(24,8)
|double(24,8)
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| localtax2_tx
|localtax2_tx
|-
|-
| localtax2_type
|localtax2_type
| integer
|integer
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| localtax2_type
|localtax2_type
|-
|-
| qty  
|qty
| real
|real
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| quantity of the product or service
|quantity of the product or service
|-
|-
| remise_percent  
|remise_percent
| double(24,8)  
|double(24,8)
| YES  
|YES
|  
|
| 0  
|0
|  
|
| discount percentage
|discount percentage
|-
|-
| remise  
|remise
| double(24,8)  
|double(24,8)
| YES  
|YES
|  
|
| 0  
|0
|  
|
| discount amount
|discount amount
|-
|-
| fk_remise_except  
|fk_remise_except
| integer
|integer
| YES  
|YES
| UNI
|UNI
| NULL  
|NULL
|  
|
| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
|ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
|-
|-
| subprice  
|subprice
| double(24,8)  
|double(24,8)
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| price before discount
|price before discount
|-
|-
| price  
|price
| double(24,8)  
|double(24,8)
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| deprecated
|deprecated
{{FieldTotalFields}}
{{FieldTotalFields}}
|-
|-
| product_type
|product_type
| integer
|integer
| YES  
|YES
|  
|
| 0
|0
|  
|
| Type of product
|Type of product
|-
|-
| date_start  
|date_start
| datetime  
|datetime
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| start date if service
|start date if service
|-
|-
| date_end  
|date_end
| datetime  
|datetime
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| end date if service
|end date if service
|-
|-
| info_bits  
|info_bits
| integer
|integer
| YES  
|YES
|  
|
| 0
|0
|  
|
| TVA NPR or not
|TVA NPR or not
|-
|-
| buy_price_ht
|buy_price_ht
| double(24,8)  
|double(24,8)
| YES  
|YES
|  
|
| 0
|0
|  
|
| TVA NPR or not
|TVA NPR or not
|-
|-
| fk_code_ventilation  
|fk_code_ventilation
| integer
|integer
| NO
|NO
|  
|
| 0  
|0
|  
|
|  
|ID of accounting code ([[Table llx accounting account|llx_accounting_account]]->rowid)
|-
|-
| fk_export_compta  
|fk_export_compta
| integer
|integer
| NO
|NO
|  
|
| 0  
|0
|  
|
| ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
|ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
|-
|-
{{FieldSpecialCode}}
{{FieldSpecialCode}}
Line 206: Line 209:
|}&nbsp;
|}&nbsp;


== Keys ==
==Keys==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| 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
| UNIQUE
|UNIQUE
| fk_remise_except
|fk_remise_except
|-  
|-  
| idx_facturedet_fk_facture  
|idx_facturedet_fk_facture
| MULTIPLE
|MULTIPLE
| fk_facture  
|fk_facture
|}&nbsp;
|}&nbsp;
Elsp1991
1

edit

Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/56333"

Navigation menu