Difference between revisions of "Table llx propal"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
Line 30: Line 30:
 
| 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
 +
| varchar(30)
 +
| NO
 +
|
 +
|
 +
|
 +
| propal number
 +
|-
 +
| entity
 +
| int(11)
 +
|  
 +
|
 +
| 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 ([[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)
 +
| YES
 +
|
 +
| 0
 +
|
 +
| statut
 +
|-
 +
| price
 +
| real
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise_percent
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise_absolute
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| remise
 +
| double
 +
| YES
 +
|
 +
| 0
 +
|
 +
| obsolete
 +
|-
 +
| total_ht
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| Total without VAT
 +
|-
 +
| tva
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| total VAT
 +
|-
 +
| total
 +
| double(24,8)
 +
| YES
 +
|
 +
| 0.00
 +
|
 +
| 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
 +
|
 +
| 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
 
|}
 
|}

Revision as of 06:08, 3 September 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

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
fk_soc int(11) NO ID society (llx_societe->rowid)
fk_projet int(11) 0 ID of proyect (llx_projet->rowid)
ref varchar(30) NO propal number
entity int(11)   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) YES 0 statut
price real YES 0 obsolete
remise_percent double YES 0 obsolete
remise_absolute double YES 0 obsolete
remise double YES 0 obsolete
total_ht double(24,8) YES 0.00 Total without VAT
tva double(24,8) YES 0.00 total VAT
total double(24,8) YES 0.00 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
Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_propal&oldid=15633"