Table llx facture fourn: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
VisualWikitext
Line 31: Line 31:
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
| entity
| int(11)
|  
|
| 1
|
| multi company id
|-
|-
| facnumber  
| facnumber  
Line 38: Line 46:
|  
|  
|  
|  
|
| invoice number
|-  
|-  
| type  
| type  
Line 46: Line 54:
| 0  
| 0  
|  
|  
|  
| type of invoice
|-
|-
| fk_soc  
| fk_soc  
Line 54: Line 62:
|  
|  
|  
|  
|  
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| datec  
| datec  
Line 62: Line 70:
| NULL  
| NULL  
|  
|  
|  
| creation date
|-
|-
| datef  
| datef  
Line 70: Line 78:
| NULL  
| NULL  
|  
|  
| date of invoice
|-
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|  
|  
| last update date
|-
|-
| libelle  
| libelle  
Line 78: Line 94:
| NULL  
| NULL  
|  
|  
|  
| label
|-
|-
| paye  
| paye  
Line 86: Line 102:
| 0  
| 0  
|  
|  
| 1 si la facture a été payée, 0 sinon
| 1 if the invoice is payed, 0 otherwise
|-
|-
| amount  
| amount  
Line 94: Line 110:
| 0.00000000  
| 0.00000000  
|  
|  
|  
| amount
|-
|-
| remise  
| remise  
Line 118: Line 134:
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount
|-
|-
| total_ht  
| total_ht  
Line 126: Line 142:
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount excluding VAT
|-
|-
| total_tva  
| total_tva  
Line 134: Line 150:
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount of VAT
|-
|-
| total_ttc  
| total_ttc  
Line 142: Line 158:
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount with VAT
|-
|-
| fk_statut  
| fk_statut  
Line 158: Line 174:
| NULL  
| NULL  
|  
|  
|  
| ID of user author of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_valid  
| fk_user_valid  
Line 166: Line 182:
| NULL  
| NULL  
|  
|  
|  
| ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_projet  
| fk_projet  
Line 174: Line 190:
| NULL  
| NULL  
|  
|  
|  
| ID of related proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
| fk_cond_reglement  
| fk_cond_reglement  
Line 182: Line 198:
| 1  
| 1  
|  
|  
|  
| Id of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
|-
|-
| date_lim_reglement
| date_lim_reglement
Line 190: Line 206:
| NULL
| NULL
|
|
|  
| date limit for payment
|-
|-
| note
| note
Line 198: Line 214:
| NULL  
| NULL  
|  
|  
|  
| comentary
|-
|-
| note_public  
| note_public  
Line 206: Line 222:
| NULL  
| NULL  
|  
|  
| public comentary
|-
| import_key
| varchar(14)
| YES
|
| NULL
|  
|  
| import key
|}
|}


Revision as of 14:40, 4 July 2009


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


Content/Contenu/Contenido

En verysmall.png Contains invoices sent by providers. A provider invoice can be linked to a provider order (Table llx_commande_fournisseur) by the Table llx_element_element.

Fr verysmall.png Cette table contient la liste des factures émises par les fournisseurs. Une facture fournisseur peut être liée à une commande fournisseur (Table llx_commande_fournisseur) au travers de la Table llx_element_element

Es verysmall.png Contiene las facturas emitidas por los proveedores. Una factura de proveedor puede estar enlazada con un pedido a proveedor (Table llx_commande_fournisseur) a traves de la Table llx_element_element.

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
entity int(11)   1 multi company id
facnumber varchar(50) NO MUL invoice number
type smallint(6) NO 0 type of invoice
fk_soc int(11) NO MUL ID society (llx_societe->rowid)
datec datetime YES NULL creation date
datef date YES NULL date of invoice
tms timestamp NO CURRENT_TIMESTAMP last update date
libelle varchar(255) YES NULL label
paye smallint(6) NO 0 1 if the invoice is payed, 0 otherwise
amount double(16,8) NO 0.00000000 amount
remise double(16,8) YES 0.00000000
tva double(16,8) YES 0.00000000
total double(16,8) YES 0.00000000 total amount
total_ht double(16,8) YES 0.00000000 total amount excluding VAT
total_tva double(16,8) YES 0.00000000 total amount of VAT
total_ttc double(16,8) YES 0.00000000 total amount with VAT
fk_statut smallint(6) NO 0 0= brouillon, 1=impayée, 2=payée, 3=abandonnée
fk_user_author int(11) YES MUL NULL ID of user author of invoice (llx_user->rowid)
fk_user_valid int(11) YES MUL NULL ID of user validator of invoice (llx_user->rowid)
fk_projet int(11) YES MUL NULL ID of related proyect (llx_projet->rowid)
fk_cond_reglement int(11) NO 1 Id of payment condition (llx_cond_reglement->rowid)
date_lim_reglement date YES MUL NULL date limit for payment
note text YES NULL comentary
note_public text YES NULL public comentary
import_key varchar(14) YES NULL import key


En verysmall.png Attention, if the status is 1 (unpayed) but the field "paye" is also 1 (payed), which should never happen under normal use, the invoice is specified payed.

Fr verysmall.png Attention, si le statut est à 1 (impayée) mais le champ "paye" est à 1 également (payée), ce qui ne devrait jamais arriver dans des conditions normales d'utilisation, la facture est indiquée comme payée.

Es verysmall.png Atención, si el statut está a 1 (impagada) pero el campo "paye" está a 1 también (pagada), cosa que nunca pasa en condiciones normales de uso, la factura se indicará como pagada.

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_facture_fourn&oldid=12996"