28,936
edits
Changes
m
→Table
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==
−{| 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>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
−| PRI
+|PRI
−| NULL
+|
−| auto_increment
+|auto_increment
−| technical index
+|technical index
+|-
+|fk_facture
+|integer
+|NO
+|MUL
+|0
+|
+|ID of invoice ([[Table llx_facture|Table llx_facture]]->rowid)
+|-
+|fk_product
+|integer
+|YES
+|
+|NULL
+|
+|ID of product ([[Table llx_product|Table llx_product]]->rowid)
|-
|-
−| fk_facture
+|description
−| int(11)
+|text
−|
+|YES
−| MUL
+|
−| 0
+|NULL
−|
+|
−| ID of facture ([[Table llx_facture|Table llx_facture]]->rowid)
+|description of customer invoice line
|-
|-
−| fk_product
+|tva_tx
−| int(11)
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of product ([[Table llx_product|Table llx_product]]->rowid)
+|line VAT taxes
|-
|-
−| description
+|localtax1_tx
−| text
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| description of customer invoice line
+|localtax1_tx
|-
|-
−| tva_taux
+|localtax1_type
−| double
+|integer
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| line VAT taxes
+|localtax_type
|-
|-
−| qty
+|localtax2_tx
−| double
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| quantity of the product or service
+|localtax2_tx
|-
|-
−| remise_percent
+|localtax2_type
−| double
+|integer
−| YES
+|YES
−|
+|
−| 0
+|NULL
−|
+|
−| discount percentage
+|localtax2_type
|-
|-
−| remise
+|qty
−| double
+|real
−| YES
+|YES
−|
+|
−| 0
+|NULL
−|
+|
−| discount amount
+|quantity of the product or service
|-
|-
−| fk_remise_except
+|remise_percent
−| int(11)
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|0
−|
+|
−| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
+|discount percentage
|-
|-
−| subprice
+|remise
−| double
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|0
−|
+|
−| price before discount
+|discount amount
|-
|-
−| price
+|fk_remise_except
−| double
+|integer
−| YES
+|YES
−|
+|UNI
−| NULL
+|NULL
−|
+|
−| final price
+|ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
|-
|-
−| total_ht
+|subprice
−| double
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| total excluding taxex
+|price before discount
|-
|-
−| total_tva
+|price
−| double
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| total tax
+|deprecated
+{{FieldTotalFields}}
|-
|-
−| total_ttc
+|product_type
−| double
+|integer
−| YES
+|YES
−|
+|
−| NULL
+|0
−|
+|
−| total with tax
+|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
+{{FieldInfoBits}}
|-
|-
−| info_bits
+|buy_price_ht
−| int(11)
+|double(24,8)
−| YES
+|YES
−|
+|
−| 0
+|0
−|
+|
−| TVA NPR or not
+|The buying price (for VAT calculation)
|-
|-
−| fk_code_ventilation
+|fk_code_ventilation
−| int(11)
+|integer
−|
+|NO
−|
+|
−| 0
+|0
−|
+|
−|
+|ID of accounting code ([[Table llx accounting account|llx_accounting_account]]->rowid)
|-
|-
−| fk_export_compta
+|fk_export_compta
−| int(11)
+|integer
−|
+|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)
|-
|-
−| rang
+{{FieldSpecialCode}}
−| int(11)
+{{FieldRang}}
−| YES
+{{FieldImportKey}}
−|
+|}
−| 0
+|
+==Keys==
−| view order
+{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
−|}
+ | style="background-color: #e9e9ef" |<b>Key</b>
+ | style="background-color: #e9e9ef" |<b>Type</b>
+ | style="background-color: #e9e9ef" |<b>Fields</b>
+|-
+|PRIMARY
+|PRIMARY
+|rowid
+|-
+|uk_fk_remise_except
+|UNIQUE
+|fk_remise_except
+|-
+|idx_facturedet_fk_facture
+|MULTIPLE
+|fk_facture
+|}