28,936
edits
Changes
m
→Table
Line 6:
Line 6:
| fk_code_ventilation +| integer+| NO+| +| 0 +| +| +|-
−
{{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
−| 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
+{{FieldInfoBits}}
|-
|-
−| info_bits
+|buy_price_ht
−| integer
+|double(24,8)
−| YES
+|YES
−|
+|
−| 0
+|0
−|
+|
−| TVA NPR or not
+|The buying price (for VAT calculation)
|-
|-
−| buy_price_ht
+|fk_code_ventilation
−| double(24,8)
+|integer
−| YES
+|NO
−|
+|
−| 0
+|0
−|
+|
−| TVA NPR or not
+|ID of accounting code ([[Table llx accounting account|llx_accounting_account]]->rowid)
|-
|-
−|fk_export_compta
−|integer
−|NO
−|
−|0
−|
−|ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
−| fk_export_compta
−| integer
−| NO
−|
−| 0
−|
−| ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid)
|-
|-
{{FieldSpecialCode}}
{{FieldSpecialCode}}
Line 206:
Line 199:
|}
|}
−== 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
|}
|}