Difference between revisions of "Table llx propal"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 14: Line 14:
  
 
= Structure =
 
= Structure =
 +
== Table ==
 +
'''Version 1.1 2009/10/07'''
 
{|  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"
 
{|  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"
 
  |style="background-color: #e9e9ef"| <b>Field</b>
 
  |style="background-color: #e9e9ef"| <b>Field</b>
Line 25: Line 27:
 
| rowid  
 
| rowid  
 
| int(11)  
 
| int(11)  
−
| &nbsp;
+
| NO
 
| PRI
 
| PRI
−
| NULL
+
|  
 
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
Line 33: Line 35:
 
| fk_soc  
 
| fk_soc  
 
| int(11)
 
| int(11)
−
| NO
+
| YES
−
|  
+
| MUL
−
|  
+
| NULL
 
|  
 
|  
 
| ID society ([[Table llx_societe|llx_societe]]->rowid)
 
| ID society ([[Table llx_societe|llx_societe]]->rowid)
Line 41: Line 43:
 
| fk_projet
 
| fk_projet
 
| int(11)
 
| int(11)
−
|  
+
| YES
 
|  
 
|  
 
| 0
 
| 0
Line 50: Line 52:
 
| varchar(30)
 
| varchar(30)
 
| NO
 
| NO
−
|  
+
| UNI
 
|  
 
|  
 
|  
 
|  
Line 57: Line 59:
 
| entity
 
| entity
 
| int(11)  
 
| int(11)  
−
| &nbsp;
+
| NO
−
|  
+
| UNI
 
| 1
 
| 1
 
|  
 
|  
Line 137: Line 139:
 
| fk_statut
 
| fk_statut
 
| smallint(6)
 
| smallint(6)
−
| YES
+
| NO
 
|  
 
|  
 
| 0
 
| 0
Line 152: Line 154:
 
|-
 
|-
 
| remise_percent
 
| remise_percent
−
| double
+
| real
 
| YES
 
| YES
 
|  
 
|  
Line 160: Line 162:
 
|-
 
|-
 
| remise_absolute
 
| remise_absolute
−
| double
+
| real
 
| YES
 
| YES
 
|  
 
|  
Line 168: Line 170:
 
|-
 
|-
 
| remise
 
| remise
−
| double
+
| real
 
| YES
 
| YES
 
|  
 
|  
Line 179: Line 181:
 
| YES
 
| YES
 
|  
 
|  
−
| 0.00
+
| 0.00000000
 
|  
 
|  
 
| Total without VAT
 
| Total without VAT
Line 187: Line 189:
 
| YES
 
| YES
 
|  
 
|  
−
| 0.00
+
| 0.00000000
 
|  
 
|  
 
| total VAT
 
| total VAT
Line 195: Line 197:
 
| YES
 
| YES
 
|  
 
|  
−
| 0.00
+
| 0.00000000
 
|  
 
|  
 
| Total TTC
 
| Total TTC
Line 254: Line 256:
 
|  
 
|  
 
| ID of delivery address
 
| ID of delivery address
−
|}
+
|}&nbsp;
 +
== Keys ==
 +
'''Version 1.1 2009/10/07'''
 +
{|  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"
 +
|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_propal_ref
 +
| UNIQUE
 +
| ref,entity
 +
|-
 +
| idx_propal_fk_soc
 +
| MULTIPLE
 +
| fk_soc
 +
|}&nbsp;

Revision as of 08:42, 9 November 2009


En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains customer proposals. The details are in Table llx_propaldet

Fr verysmall.png Contient des propositions commerciales , les détails sont dans la Table llx_propaldet

Es verysmall.png Contiene los presupuestos, los detalles están en la Table llx_propaldet

Structure

Table

Version 1.1 2009/10/07

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
fk_soc int(11) YES MUL NULL ID society (llx_societe->rowid)
fk_projet int(11) YES 0 ID of proyect (llx_projet->rowid)
ref varchar(30) NO UNI propal number
entity int(11) NO UNI 1 multi company id
ref_client varchar(30) YES NULL costumer order number
datec datetime YES NULL creation date
datep date YES NULL proposal date
fin_validite datetime YES NULL end valid date
date_valid datetime YES NULL validation date
date_cloture datetime YES NULL closed date
fk_user_author int(11) YES NULL ID creator user (llx_user->rowid)
fk_user_valid int(11) YES NULL ID validator user (llx_user->rowid)
fk_user_cloture int(11) YES NULL ID closer user (llx_user->rowid)
fk_statut smallint(6) NO 0 statut
price real YES 0 obsolete
remise_percent real YES 0 obsolete
remise_absolute real YES 0 obsolete
remise real YES 0 obsolete
total_ht double(24,8) YES 0.00000000 Total without VAT
tva double(24,8) YES 0.00000000 total VAT
total double(24,8) YES 0.00000000 Total TTC
fk_cond_reglement int(11) YES NULL ID of payment condition (llx_cond_reglement->rowid)
fk_mode_reglement int(11) YES NULL ID of payment mode
note text YES NULL comentary
note_public text YES NULL public comentary
model_pdf varchar(50) YES NULL Model PDF to print
date_livraison date YES NULL delivery date
fk_livraison int(11) YES NULL ID of delivery address

 

Keys

Version 1.1 2009/10/07

Key Type Fields
PRIMARY PRIMARY rowid
uk_propal_ref UNIQUE ref,entity
idx_propal_fk_soc MULTIPLE fk_soc

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_propal&oldid=17138"