Table llx propal: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
 
(6 intermediate revisions by 2 users not shown)
Line 14: Line 14:


= 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
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
| fk_soc
| int(11)
| NO
|
|
|
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
| fk_projet
| int(11)
|
|
| 0
|
| ID of proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
| ref
| ref
| varchar(30)
| varchar(30)
| NO
| NO
|  
| UNI
|  
|  
|  
|  
| propal number
| propal number
|-
{{FieldEntity}}
| entity
{{FieldRefExt}}
| int(11)
| &nbsp;
|
| 1
|
| multi company id
|-
|-
| ref_client
| ref_client
Line 69: Line 48:
| NULL
| NULL
|  
|  
| costumer order number
| 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
| datec
Line 137: Line 133:
| fk_statut
| fk_statut
| smallint(6)
| smallint(6)
| YES
| NO
|  
|  
| 0
| 0
Line 152: Line 148:
|-
|-
| remise_percent
| remise_percent
| double
| real
| YES
| YES
|  
|  
Line 160: Line 156:
|-
|-
| remise_absolute
| remise_absolute
| double
| real
| YES
| YES
|  
|  
Line 168: Line 164:
|-
|-
| remise
| remise
| double
| real
| YES
| YES
|  
|  
Line 179: Line 175:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|  
|  
| Total without VAT
| Total without VAT
Line 187: Line 183:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|  
|  
| total VAT
| total VAT
{{FieldLocalTaxX}}
|-
|-
| total
| total
Line 195: Line 192:
| YES
| YES
|  
|  
| 0.00
| 0.00000000
|  
|  
| Total TTC
| Total TTC
Line 254: Line 251:
|  
|  
| ID of delivery address
| 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"