Dolibarr ERP CRM Wiki

Changes

Table llx propaldet (view source)

Revision as of 12:52, 25 July 2024

1,648 bytes added ,  8 months ago
m
→‎Table
Line 6: Line 6:  
{{ListOfTables}}
 
{{ListOfTables}}
   −
= Contenu =
+
=Content/Contenu/Contenido=
−
Détails des propositions commerciales
+
{{flag en}} Contains details of customer proposals. This table is linked to [[Table llx_propal]]
   −
Details of costumers proposals
+
{{flag fr}} Contient les détails des propositions commerciales, cette table est liée avec la [[Table llx_propal]]
   −
Detalles de presupuestos a clientes
+
{{flag sp}} Contiene los detalles de los presupuestos a clientes, esta tabla esta vinculada con [[Table llx_propal]]
   −
= Structure =
+
=Structure=
−
{| 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"
+
==Table==
−
  |style="background-color: #e9e9ef"| <b>Field</b>
+
{| class="dolbox" align="left" width="100%" border="0" cellpadding="1" cellspacing="0"
−
  |style="background-color: #e9e9ef"| <b>Type</b>
+
  | style="background-color: #e9e9ef" |<b>Field</b>
−
  |style="background-color: #e9e9ef"| <b>Null</b>
+
  | style="background-color: #e9e9ef" |<b>Type</b>
−
  |style="background-color: #e9e9ef"| <b>Key</b>
+
  | style="background-color: #e9e9ef" |<b>Null</b>
−
  |style="background-color: #e9e9ef"| <b>Default</b>
+
  | style="background-color: #e9e9ef" |<b>Key</b>
−
  |style="background-color: #e9e9ef"| <b>Extra</b>
+
  | style="background-color: #e9e9ef" |<b>Default</b>
−
  |style="background-color: #e9e9ef"| <b>Description</b>
+
  | style="background-color: #e9e9ef" |<b>Extra</b>
 +
  | style="background-color: #e9e9ef" |<b>Description</b>
 
|-  
 
|-  
−
| rowid  
+
|rowid
−
| int(11)  
+
|int(11)
−
| &nbsp;
+
|NO
−
| PRI
+
|PRI
−
| NULL
+
|
−
| auto_increment  
+
|auto_increment
−
| technical index
+
|technical index
 +
|-
 +
|fk_propal
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of propal ([[Table llx_propal|llx_propal]]->rowid)
 +
|-
 +
|fk_product
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of product ([[Table llx_product|llx_product]]->rowid)
 +
|-
 +
|label
 +
|varchar(255)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|
 +
|-
 +
|description
 +
|text
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|product or service description
 +
|-
 +
|fk_remise_except
 +
|int(11)
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|ID of discount ([[Table llx_societe_remise_except|llx_societe_remise_except]]->rowid)
 +
|-
 +
|tva_tx
 +
|double(6,3)
 +
|YES
 +
|
 +
|0.000
 +
|
 +
|VAT taxes
 +
|-
 +
|qty
 +
|real
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|Quantity of product or service
 +
|-
 +
|remise_percent
 +
|real
 +
|YES
 +
|
 +
|0
 +
|
 +
|discount percentage
 +
|-
 +
|remise
 +
|real
 +
|YES
 +
|
 +
|0
 +
|
 +
|discount amount (obsolete)
 +
|-
 +
|price
 +
|real
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|final price (obsolete)
 +
|-
 +
|subprice
 +
|double(24,8)
 +
|YES
 +
|
 +
|0.00000000
 +
|
 +
|price before discount
 +
{{FieldTotalFields}}
 +
|-
 +
|product_type
 +
|int(11)
 +
|YES
 +
|
 +
|0
 +
|
 +
|type of product
 +
|-
 +
|date_start
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|start date if service
 +
|-
 +
|date_end
 +
|datetime
 +
|YES
 +
|
 +
|NULL
 +
|
 +
|end date if service
 +
{{FieldInfoBits}}
 +
|-
 +
|pa_ht
 +
|double(24,8)
 +
|YES
 +
|
 +
|0.00000000
 +
|
 +
|purchase price HT
 +
|-
 +
|marge_tx
 +
|double(6,3)
 +
|YES
 +
|
 +
|0.000
 +
|
 +
|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>
 +
|-
 +
|PRIMARY
 +
|PRIMARY
 +
|rowid
 +
|}&nbsp;
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/10835...61009"