Difference between revisions of "Table llx propal"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
 
(9 intermediate revisions by 2 users not shown)
Line 6: Line 6:
 
{{ListOfTables}}
 
{{ListOfTables}}
  
−
= Contenu =
+
= Content/Contenu/Contenido =
−
Table principales des propositions commerciales , les détails sont dans la [[Table llx_propaldet]]
+
{{flag en}} Contains customer proposals. The details are in [[Table llx_propaldet]]
  
−
Contains customer proposals. The details are in [[Table llx_propaldet]]
+
{{flag fr}} Contient des propositions commerciales , les détails sont dans la [[Table llx_propaldet]]
  
−
Tabla principal de los presupuestos, los detalles están en [[Table llx_propaldet]]
+
{{flag sp}} Contiene los presupuestos, los detalles están en la [[Table llx_propaldet]]
  
 
= 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 ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 
  |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>
Line 25: Line 26:
 
| rowid  
 
| rowid  
 
| int(11)  
 
| int(11)  
−
| &nbsp;
+
| NO
 
| PRI
 
| PRI
 +
|
 +
| auto_increment
 +
| technical index
 +
|-
 +
| ref
 +
| varchar(30)
 +
| NO
 +
| UNI
 +
|
 +
|
 +
| propal number
 +
{{FieldEntity}}
 +
{{FieldRefExt}}
 +
|-
 +
| ref_client
 +
| varchar(30)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| costumer proposal number
 +
|-
 +
| fk_soc
 +
| int(11)
 +
| YES
 +
| MUL
 +
| NULL
 +
|
 +
| ID society ([[Table llx_societe|llx_societe]]->rowid)
 +
|-
 +
| fk_projet
 +
| int(11)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| ID of project ([[Table llx_projet|llx_projet]]->rowid)
 +
{{FieldTms}}
 +
|-
 +
| 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 ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_valid
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID validator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_cloture
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID closer user ([[Table llx_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
 +
{{FieldLocalTaxX}}
 +
|-
 +
| total
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00000000
 +
|
 +
| Total TTC
 +
|-
 +
| fk_cond_reglement
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID of payment condition ([[Table llx_cond_reglement|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
 
| NULL
−
| auto_increment
+
|  
−
| index technique
+
| 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
 +
|}&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
 +
|-
 +
| uk_propal_ref
 +
| UNIQUE
 +
| ref,entity
 +
|-
 +
| idx_propal_fk_soc
 +
| MULTIPLE
 +
| fk_soc
 +
|}&nbsp;

Latest revision as of 12:50, 10 August 2012


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

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
ref varchar(30) NO UNI propal number
entity int(11) NO 1 See page Field Multi company id. (llx_entity->rowid)
ref_ext varchar(30) NO See page Field ref_ext.
ref_client varchar(30) YES NULL costumer proposal number
fk_soc int(11) YES MUL NULL ID society (llx_societe->rowid)
fk_projet int(11) YES 0 ID of project (llx_projet->rowid)
tms timestamp NO Current date Date of last modification. See page Field Tms.
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
localtax1 double(24,8) YES 0.00000000 Special VAT rate 1 (spain)
localtax2 double(24,8) YES 0.00000000 Special VAT rate 2 (spain)
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

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=26739"