Dolibarr ERP CRM Wiki

Table llx facture fourn: Difference between revisions

Page

Table llx facture fourn (view source)

Revision as of 14:49, 2 July 2018

3,072 bytes added ,  8 years ago
no edit summary
VisualWikitext
No edit summary
 
(12 intermediate revisions by 3 users not shown)
Line 6: Line 6:
{{ListOfTables}}
{{ListOfTables}}


= Contenu =
= Content/Contenu/Contenido =
{{flag en}} Contains invoices sent by suppliers. A supplier invoice can be linked to a supplier order ([[Table llx_commande_fournisseur]]) by the [[Table llx_element_element]].


{{flag fr}} 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]])
{{flag fr}} 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]]
 
{{flag en}} 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]].


{{flag sp}} 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]].
{{flag sp}} 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 =
= Structure =
 
== Table ==
{|  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"
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 27: Line 26:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
|-
| facnumber
| ref
| varchar(50)  
| varchar(180)  
| NO  
| NO  
| MUL
|  
|  
|  
|  
|
|  
| invoice number
|-
| ref_supplier
| varchar(180)
| NO
|
|
|
| invoice number from supplier
{{FieldEntity}}
{{FieldRefExt}}
|-  
|-  
| type  
| type  
Line 47: Line 56:
| 0  
| 0  
|  
|  
|  
| type of invoice (0=Standard invoice, 1=Replacement invoice, 2=Credit note invoice). For the moment only 0 is supported.
|-
|-
| fk_soc  
| fk_soc  
| int(11)  
| int(11)  
| NO  
| NO  
| MUL
| UNI
|
|  
|  
|  
|  
| ID society ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| datec  
| datec  
Line 63: Line 72:
| NULL  
| NULL  
|  
|  
| creation date
|-
| datef
| date
| YES
|
| NULL
|  
|  
| date of invoice
|-
|-
| datef
| date_pointoftax
| date  
| date  
| YES  
| YES  
Line 71: Line 88:
| NULL  
| NULL  
|  
|  
| date point of tax (for GB)
|-
| date_valid
| date
| YES
|  
|  
| NULL
|
| date validation
{{FieldTms}}
|-
|-
| libelle  
| libelle  
Line 79: Line 105:
| NULL  
| NULL  
|  
|  
|  
| label
|-
|-
| paye  
| paye  
Line 87: Line 113:
| 0  
| 0  
|  
|  
| 1 si la facture a été payée, 0 sinon
| Is the invoice payed (1=yes, 0=otherwise)?
|-
|-
| amount  
| amount  
| double(16,8)  
| double(24,8)  
| NO  
| NO  
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
|  
| amount
|-
|-
| remise  
| remise  
| double(16,8)  
| double(24,8)  
| YES  
| YES  
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
| discount
|-
| close_code
| varchar(16)
| 
|
| 
|  
|  
| Code motif clôture sans paiement complet
|-
| close_note
| varchar(128)
|
|
|
|
| Commentaire clôture sans paiement complet
|-
|-
| tva  
| tva  
| double(16,8)  
| double(24,8)  
| YES  
| YES  
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
|  
| VAT
{{FieldLocalTaxX}}
|-
|-
| total  
| total  
| double(16,8)  
| double(24,8)  
| YES  
| YES  
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount
|-
|-
| total_ht  
| total_ht  
| double(16,8)  
| double(24,8)  
| YES  
| YES  
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount excluding VAT
|-
|-
| total_tva  
| total_tva  
| double(16,8)  
| double(24,8)  
| YES   
| YES   
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount of VAT
|-
|-
| total_ttc  
| total_ttc  
| double(16,8)  
| double(24,8)  
| YES  
| YES  
|  
|  
| 0.00000000  
| 0.00000000  
|  
|  
|  
| total amount with VAT
|-
|-
| fk_statut  
| fk_statut  
Line 151: Line 194:
| 0  
| 0  
|  
|  
| 0= brouillon, 1=impayée, 2=payée, 3=abandonnée
| Status of invoice (0=draft, 1=unpayed, 2=payed, 3=abandoned)
|-
|-
| fk_user_author  
| fk_user_author  
Line 159: Line 202:
| NULL  
| NULL  
|  
|  
| ID of user author of invoice ([[Table llx_user|llx_user]]->rowid)
|-
| fk_user_modif
| int(11)
| YES
| MUL
| NULL
|  
|  
| ID of user making last change of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_user_valid  
| fk_user_valid  
Line 167: Line 218:
| NULL  
| NULL  
|  
|  
| ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid)
|-
| fk_facture_source
| int(11)
| YES
| MUL
| NULL
|  
|  
| ID of the invoice source in case of credit note ([[Table llx_facture_fourn|llx_facture_fourn]]->rowid)
|-
|-
| fk_projet  
| fk_projet  
Line 175: Line 234:
| NULL  
| NULL  
|  
|  
| ID of related project ([[Table llx_projet|llx_projet]]->rowid)
|-
| fk_account
| int(11)
| YES
| MUL
| NULL
|  
|  
| ID of bank account ([[Table llx_bank_account|llx_bank_account]]->rowid)
|-
|-
| fk_cond_reglement  
| fk_cond_reglement  
Line 183: Line 250:
| 1  
| 1  
|  
|  
| Id of payment condition ([[Table llx_c_payment_term|llx__c_payment_term]]->rowid)
|-
| fk_cond_reglement
| int(11)
| YES
| MUL
| NULL
|  
|  
| ID of payment mode ([[Table llx_c_paiement|llx_c_paiement]]->rowid)
|-
|-
| date_lim_reglement
| date_lim_reglement
Line 191: Line 266:
| NULL
| NULL
|
|
|  
| date limit for payment
|-
|-
| note
| note_private
| text  
| text  
| YES   
| YES   
Line 199: Line 274:
| NULL  
| NULL  
|  
|  
|  
| private commentary
|-
|-
| note_public  
| note_public  
Line 207: Line 282:
| NULL  
| NULL  
|  
|  
| public commentary
|-
| location_incoterms
| varchar(255)
| 
|
|
|
| for incoterms
|-
| model_pdf
| varchar(255)
| 
|
|
|
|
|-
| last_main_doc
| varchar(255)
| 
|
|
|
| relative filepath+filename of last main generated document
{{FieldImportKey}}
|-
| extraparams
| varchar(255)
| 
|
|
|
| for stock other parameters with json format
|-
| fk_multicurrency
| int(11)
| YES
| 
| NULL
|
| ID of currency
|-
| multicurrency_code
| varchar(255)
| 
|
|  
|  
|}
|
|
|-
| multicurrency_tx
| double(24,8)
| YES
|
| 1
|
|
|-
| multicurrency_total_ht
| double(24,8)
| YES
|
| 0.00000000
|
|
|-
| multicurrency_total_tva
| double(24,8)
| YES
|
| 0.00000000
|
|
|-
| multicurrency_total_ttc
| double(24,8)
| YES
|
| 0.00000000
|
|
|-
|}&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
|-
| uk_facture_fourn_ref
| UNIQUE
| ref,entity
|-
| uk_facture_fourn_ref_supplier
| UNIQUE
| ref_supplier,fk_soc,entity
|-
| idx_facture_fourn_date_lim_reglement
| MULTIPLE
| date_lim_reglement
|-
| idx_facture_fourn_fk_soc
| MULTIPLE
| fk_soc
|-
| idx_facture_fourn_fk_user_author
| MULTIPLE
| fk_user_author
|-
| idx_facture_fourn_fk_user_valid
| MULTIPLE
| fk_user_valid
|-
| idx_facture_fourn_fk_projet
| MULTIPLE
| fk_projet
|}&nbsp;


= Notes =
{{flag en}} 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.
{{flag en}} 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.


Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/12664...38752"