Table llx propal

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

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


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