28,936
edits
Changes
m
→Table
Line 6:
Line 6:
| rang
−| int(11)
−| YES
−|
−| 0
−|
−| view order
{{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==
−{| 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
−| 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 invoice ([[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
−| int(10)
+|integer
−| YES
+|NO
−|
+|
−| 0
+|0
−| UNSIGNED
+|
−| view order
+|ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
−|-
−|-
|-
+{{FieldSpecialCode}}
+{{FieldRang}}
{{FieldImportKey}}
{{FieldImportKey}}
|}
|}
−== 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
|}
|}