29,031
edits
Changes
m
→Table
Line 6:
Line 6:
| info_bits+| int(11)+| YES+| +| 0+| +| TVA NPR or not+|-+| pa_ht+| double(24,8)+| YES+
−| +| 0.00000000+| +| purchase price HT+|-+| marge_tx
−| double(6,3)
−| YES
−|
−| 0.000
−|
−| margin (margin on purchase price)
−|-
−|-
−| special_code
−| tinyint(4)
−| YES
−| 0
−|
−| code for special lines. used for shipping (=1), ecotaxes (=2), product/service optional offers (=3). Otherwise=0
−|-
−| rang
−| int(11)
−| YES
−|
−| 0
−|
−| order view
−|}
−
{{ListOfTables}}
{{ListOfTables}}
−= Content/Contenu/Contenido =
+=Content/Contenu/Contenido=
{{flag en}} Contains details of customer proposals. This table is linked to [[Table llx_propal]]
{{flag en}} Contains details of customer proposals. This table is linked to [[Table llx_propal]]
Line 13:
Line 13:
{{flag sp}} Contiene los detalles de los presupuestos a clientes, esta tabla esta vinculada con [[Table llx_propal]]
{{flag sp}} Contiene los detalles de los presupuestos a clientes, esta tabla esta vinculada con [[Table llx_propal]]
−= 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)
+|int(11)
−| NO
+|NO
−| PRI
+|PRI
−|
+|
−| auto_increment
+|auto_increment
−| technical index
+|technical index
|-
|-
−| fk_propal
+|fk_propal
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of propal ([[Table llx_propal|llx_propal]]->rowid)
+|ID of propal ([[Table llx_propal|llx_propal]]->rowid)
|-
|-
−| fk_product
+|fk_product
−| int(11)
+|int(11)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of product ([[Table llx_product|llx_product]]->rowid)
+|ID of product ([[Table llx_product|llx_product]]->rowid)
|-
|-
−| description
+|label
−| text
+|varchar(255)
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| product or service description
+|
|-
|-
−| fk_remise_except
+|description
−| int(11)
+|text
−| YES
+|YES
−|
+|
−| NULL
+|NULL
−|
+|
−| ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
+|product or service description
|-
|-
−| tva_tx
+|fk_remise_except
−| double(6,3)
+|int(11)
−| YES
+|YES
−|
+|
−| 0.000
+|NULL
−|
+|
−| VAT taxes
+|ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
|-
|-
−| qty
+|tva_tx
−| real
+|double(6,3)
−| YES
+|YES
−|
+|
−| NULL
+|0.000
−|
+|
−| Quantity of product or service
+|VAT taxes
|-
|-
−| remise_percent
+|qty
−| real
+|real
−| YES
+|YES
−|
+|
−| 0
+|NULL
−|
+|
−| discount percentage
+|Quantity of product or service
|-
|-
−| remise
+|remise_percent
−| real
+|real
−| YES
+|YES
−|
+|
−| 0
+|0
−|
+|
−| discount amount (obsolete)
+|discount percentage
|-
|-
−| price
+|remise
−| real
+|real
−| YES
+|YES
−|
+|
−| NULL
+|0
−|
+|
−| final price (obsolete)
+|discount amount (obsolete)
|-
|-
−| subprice
+|price
−| double(24,8)
+|real
−| YES
+|YES
−|
+|
−| 0.00000000
+|NULL
−|
+|
−| price before discount
+|final price (obsolete)
|-
|-
−| total_ht
+|subprice
−| double(24,8)
+|double(24,8)
−| YES
+|YES
−|
+|
−| 0.00000000
+|0.00000000
−|
+|
−| total excluding tax
+|price before discount
+{{FieldTotalFields}}
|-
|-
−| total_tva
+|product_type
−| double(24,8)
+|int(11)
−| YES
+|YES
−|
+|
−| 0.00000000
+|0
−|
+|
−| total tax
+|type of product
|-
|-
−| total_ttc
+|date_start
−| double(24,8)
+|datetime
−| YES
+|YES
−|
+|
−| 0.00000000
+|NULL
−|
+|
−| total with tax
+|start date if service
|-
|-
−| product_type
+|date_end
−| int(11)
+|datetime
−| YES
+|YES
−|
+|
−| 0
+|NULL
−|
+|
−| type of prodcut
+|end date if service
+{{FieldInfoBits}}
|-
|-
−| date_start
+|pa_ht
−| datetime
+|double(24,8)
−| YES
+|YES
−|
+|
−| NULL
+|0.00000000
−|
+|
−| start date if service
+|purchase price HT
|-
|-
−| date_end
+|marge_tx
−| datetime
+|double(6,3)
−| YES
+|YES
−|
+|
−| NULL
+|0.000
−|
+|
−| end date if service
+|margin (margin on purchase price)
|-
|-
−|marque_tx
−|double(6,3)
−|YES
−|
−|0.000
−|
−|mark rate (margin on selling price)
−{{FieldSpecialCode}}
−{{FieldRang}}
−|}
−==Keys==
−{| 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>
−| marque_tx
−| double(6,3)
−| YES
−|
−| 0.000
−|
−| mark rate (margin on selling price)
−|
−== 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
−| PRIMARY
+|PRIMARY
−| rowid
+|rowid
|}
|}