Table llx societe remise except

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 exceptional discount companies have.

Contient la remises exceptionnelles applicable à chaque société.

Contiene los descuentos excepcionales aplicados a cada empresa.

Structure

Table

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
fk_soc	int(11)	NO	MUL			ID of third party (llx_societe->rowid)
datec	datetime	YES		NULL		date of creation
amount_ht	double(24,8)	NO		0.00000000		amount without VAT
amount_tva	double(24,8)	NO		0.00000000		amount VAT
amount_ttc	double(24,8)	NO		0.00000000		amount with VAT
tva_tx	double(6,3)	NO		0.000		VAT taxe
fk_user	int(11)	NO	MUL			ID creator user (llx_user->rowid)
fk_facture_line	int(11)	YES	MUL	NULL		ID line of invoice (llx_facturedet->rowid) when discount is consumed by an invoice
fk_facture	int(11)	YES	MUL	NULL		ID of invoice (llx_facture->rowid) when discount is consumed by an invoice
fk_facture_source	int(11)	YES	MUL	NULL		ID of invoice source (llx_facture->rowid) when discount comes from a credit note converted into discount
description	varchar(255)	NO				description

 

Keys

Key	Type	Fields
PRIMARY	PRIMARY	rowid
idx_societe_remise_except_fk_user	MULTIPLE	fk_user
idx_societe_remise_except_fk_soc	MULTIPLE	fk_soc
idx_societe_remise_except_fk_facture_line	MULTIPLE	fk_facture_line
idx_societe_remise_except_fk_facture	MULTIPLE	fk_facture
idx_societe_remise_except_fk_facture_source	MULTIPLE	fk_facture_source