Table llx c payment term

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 most current payment conditions for invoices: 30 days end of month, 60 days end of month, upon receipt, proforma, etc.

Contient les conditions de règlement de factures les plus courantes: 30 jours fin de mois, 60 jours fin de mois, à réception, proforma, etc.

Contiene las condiciones de pago para las facturas más comunes: 30 días a fin de mes, 60 días a fin de mes, a la recepción, proforma, etc.

Structure

Table

Version 1.1 2009/10/07

Field	Type	Null	Key	Default	Extra	Description
rowid	int(11)	NO	PRI		auto_increment	technical index
code	varchar(16)	YES		NULL		intern code to search the translations
sortorder	smallint(6)	YES		NULL		order to view into a listbox
active	tinyint(4)	YES		1		is the payment condition active (1=yes, 0=no)?
libelle	varchar(255)	YES		NULL		label (name) shown on screen (although caught in the language files, so it is used only no translation are found)
libelle_facture	text	YES		NULL		label (name) shown on PDF documents (although caught in the language files, so it is used only if no translation are found)
fdm	tinyint(4)	YES		NULL		end of month (eg "30 days end of month"). 0=no, 1=yes
nbjour	smallint(6)	YES		NULL		number of days after invoice for due date
decalage	smallint(6)	YES		NULL		if end of month is used, you can also add an offset for days from the start of month for the due date

 

Keys

Version 1.1 2009/10/07

Key	Type	Fields
PRIMARY	PRIMARY	rowid