Difference between revisions of "Table llx propal"

Latest revision as of 12:50, 10 August 2012

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

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains customer proposals. The details are in Table llx_propaldet

Contient des propositions commerciales , les détails sont dans la Table llx_propaldet

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

@@ Line 14: / Line 14: @@
 = 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>Type</b>
@@ Line 25: / Line 26: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | 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
-|
+| UNI
 |
 |
 | propal number
-|-
+{{FieldEntity}}
-| entity
+{{FieldRefExt}}
-| int(11)
-| &nbsp;
-|
-| 1
-|
-| multi company id
 |-
 | ref_client
@@ Line 69: / Line 48: @@
 | 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
@@ Line 137: / Line 133: @@
 | fk_statut
 | smallint(6)
-| YES
+| NO
 |
 | 0
@@ Line 152: / Line 148: @@
 |-
 | remise_percent
-| double
+| real
 | YES
 |
@@ Line 160: / Line 156: @@
 |-
 | remise_absolute
-| double
+| real
 | YES
 |
@@ Line 168: / Line 164: @@
 |-
 | remise
-| double
+| real
 | YES
 |
@@ Line 179: / Line 175: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | Total without VAT
@@ Line 187: / Line 183: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | total VAT
+{{FieldLocalTaxX}}
 |-
 | total
@@ Line 195: / Line 192: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | Total TTC
@@ Line 254: / Line 251: @@
 |
 | 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;