Table llx societe remise except

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

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


Content/Contenu/Contenido

En verysmall.png Contains exceptional discount companies have.

Fr verysmall.png Contient la remises exceptionnelles applicable à chaque société.

Es verysmall.png 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