Difference between revisions of "Table llx contratdet"

Latest revision as of 11:20, 25 July 2024

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 the details of contrats. This table is linked to Table llx_contrat

Contient les détails des contrats, cette table est liée avec la Table llx_contrat

Contiene los detalles de los contratos, esta tabla está vinculada con Table llx_contrat

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
tms	timestamp	NO		Current date		Date of last modification. See page Field Tms.
fk_contrat	int(11)	NO	MUL			ID of contrat (llx_contrat->rowid)
fk_product	int(11)	YES	MUL	NULL		ID of product (llx_product->rowid)
statut	smallint(6)	YES		0		state
label	text	YES		NULL		label of product
description	text	YES		NULL		product or service description
fk_remise_except	int(11)	YES		NULL		ID of discount (llx_societe_remise_except->rowid)
date_commande	datetime	YES		NULL		date of order
date_ouverture_prevue	datetime	YES	MUL	NULL		open service date
date_ouverture	datetime	YES	MUL	NULL		client open service date
date_fin_validite	datetime	YES	MUL	NULL		end service date
date_cloture	datetime	YES		NULL		close service date
tva_tx	double(6,3)	YES		0.000		VAT taxes
qty	real	NO				Quantity of product or service
remise_percent	real	YES		0		discount percentage
subprice	double(24,8)	YES		0.00000000		unit price
price_ht	real	YES		NULL		price excluding tax
remise	real	YES		0		discount amount
total_ht	double(24,8)	YES		NULL		total excluding taxes
total_tva	double(24,8)	YES		NULL		total tax
total_localtax1	double(24,8)	YES		NULL		total local tax 1
total_localtax2	double(24,8)	YES		NULL		total local tax 2
total_ttc	double(24,8)	YES		NULL		Total including discount and taxes (vat + localtax1 + localtax2)
info_bits	integer			0		TVA NPR or NOT
fk_user_author	int(11)			0		ID creator user (llx_user->rowid)
fk_user_ouverture	int(11)	YES		NULL		ID activator user (llx_user->rowid)
fk_user_cloture	int(11)	YES		NULL		ID closer user (llx_user->rowid)
commentaire	text	YES		NULL		comment

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
idx_contratdet_fk_contrat	MULTIPLE	fk_contrat
idx_contratdet_fk_product	MULTIPLE	fk_product
idx_contratdet_date_ouverture_prevue	MULTIPLE	date_ouverture_prevue
idx_contratdet_date_ouverture	MULTIPLE	date_ouverture
idx_contratdet_date_fin_validite	MULTIPLE	date_fin_validite

@@ Line 15: / Line 15: @@
 = 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 26: / Line 27: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
-|-
+{{FieldTms}}
-| tms
-| timestamp
-| NO
-|
-| CURRENT_TIMESTAMP
-|
-| last update date
 |-
 | fk_contrat
 | int(11)
-|
+| NO
-|
+| MUL
 |
 |
@@ Line 51: / Line 45: @@
 | int(11)
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 82: / Line 76: @@
 | fk_remise_except
 | int(11)
-|
+| YES
 |
 | NULL
@@ Line 99: / Line 93: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 107: / Line 101: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 115: / Line 109: @@
 | datetime
 | YES
-|
+| MUL
 | NULL
 |
@@ Line 132: / Line 126: @@
 | YES
 |
-| 0.00
+| 0.000
 |
 | VAT taxes
 |-
 | qty
-| double
+| real
-|
+| NO
 |
 |
@@ Line 145: / Line 139: @@
 |-
 | remise_percent
-| double
+| real
 | YES
 |
@@ Line 156: / Line 150: @@
 | YES
 |
-| 0.00
+| 0.00000000
 |
 | unit price
 |-
 | price_ht
-| double
+| real
 | YES
 |
@@ Line 169: / Line 163: @@
 |-
 | remise
-| double
+| real
 | YES
 |
@@ Line 175: / Line 169: @@
 |
 | discount amount
-|-
+{{FieldTotalFields}}
-| total_ht
+{{FieldInfoBits}}
-| double(24,8)
-| YES
-|
-| 0.00
-|
-| total excluding tax
-|-
-| total_tva
-| double(24,8)
-| YES
-|
-| 0.00
-|
-| total tax
-|-
-| total_ttc
-| double(24,8)
-| YES
-|
-| 0.00
-|
-| total with tax
-|-
-| info_bits
-| int(11)
-| YES
-|
-| 0
-|
-| TVA NPR or not
 |-
 | fk_user_author
@@ Line 239: / Line 203: @@
 |
 | comment
-|}
+|}&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
+|-
+| idx_contratdet_fk_contrat
+| MULTIPLE
+| fk_contrat
+|-
+| idx_contratdet_fk_product
+| MULTIPLE
+| fk_product
+|-
+| idx_contratdet_date_ouverture_prevue
+| MULTIPLE
+| date_ouverture_prevue
+|-
+| idx_contratdet_date_ouverture
+| MULTIPLE
+| date_ouverture
+|-
+| idx_contratdet_date_fin_validite
+| MULTIPLE
+| date_fin_validite
+|}&nbsp;