Table llx facturedet rec: Difference between revisions

← Older edit

Table llx facturedet rec (view source)

Revision as of 15:24, 19 July 2011

2,050 bytes added , 15 years ago

→‎Structure

VisualWikitext

Simnandez

Bureaucrats, Administrators

4,395

edits

@@ Line 1: / Line 1: @@
+[[Category:Facture]]
+[[Category:Facturas]]
+[[Category:Invoices]]
 [[Category:Table SQL]]
-  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
-  The documentation related to other tables is available on the tables list page: [[Liste des tables]]
-= Contenu =
+{{ListOfTables}}
+= Content/Contenu/Contenido =
+{{Flag en}} Contains the lines of predefined invoices, this table is linked with [[Table llx_facture_rec]].
+{{Flag fr}} Contient les lignes des factures prédéfinies, cette table est liée avec la [[Table llx_facture_rec]].
+{{Flag sp}} Contiene las líneas de las facturas predefinidas, esta tabla está vinculada con [[Table llx_facture_rec]].
 = Structure =
+== Table ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Field</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Null</b>
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Default</b>
+ |style="background-color: #e9e9ef"| <b>Extra</b>
+ |style="background-color: #e9e9ef"| <b>Description</b>
+|-
+| rowid
+| int(11)
+| NO
+| PRI
+|
+| auto_increment
+| technical index
+|-
+| fk_facture
+| int(11)
+| NO
+|
+|
+|
+| ID of related facture ([[Table llx_facture_rec|llx_facture_rec]]->rowid)
+|-
+| fk_product
+| int(11)
+| YES
+|
+| NULL
+|
+| ID of related product ([[Table llx_product|llx_product]]->rowid)
+|-
+| product_type
+| int(11)
+| YES
+|
+| 0
+|
+| type of product
+|-
+| description
+| text
+| YES
+|
+| NULL
+|
+| description of product
+|-
+| datec
+| datetime
+| YES
+|
+| NULL
+|
+| creation date
+|-
+| tva_taux
+| real
+| YES
+|
+| 19.6
+|
+| VAT tax
+|-
+| qty
+| real
+| YES
+|
+| NULL
+|
+| quantity
+|-
+| remise
+| real
+| YES
+|
+| 0
+|
+| discount
+|-
+| remise_percent
+| real
+| YES
+|
+| 0
+|
+| percent discount
+|-
+| price
+| real
+| YES
+|
+| NULL
+|
+| final price
+|-
+| subprice
+| real
+| YES
+|
+| NULL
+|
+| price before discount
+|-
+| total_ttc
+| real
+| YES
+|
+| NULL
+|
+| total with tax
+|-
+| total_ht
+| ral
+| YES
+|
+| NULL
+|
+| total excluding tax
+|-
+| total_tva
+| real
+| YES
+|
+| NULL
+|
+| total tax
+|-
+| total_ttc
+| real
+| YES
+|
+| NULL
+|
+| total with tax
+|}&nbsp;
+== Keys ==
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
+ |style="background-color: #e9e9ef"| <b>Key</b>
+ |style="background-color: #e9e9ef"| <b>Type</b>
+ |style="background-color: #e9e9ef"| <b>Fields</b>
+|-
+| PRIMARY
+| PRIMARY
+| rowid
+|}&nbsp;