Dolibarr ERP CRM Wiki

Changes

Table llx facture fourn (view source)

Revision as of 14:49, 2 July 2018

1,467 bytes added ,  6 years ago
no edit summary
Line 7: Line 7:     
= Content/Contenu/Contenido =
 
= Content/Contenu/Contenido =
−
{{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 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]]
Line 15: Line 15:  
= Structure =
 
= Structure =
 
== Table ==
 
== 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 32: Line 32:  
| technical index
 
| technical index
 
|-
 
|-
−
| facnumber
+
| ref
−
| varchar(50)  
+
| varchar(180)  
 
| NO  
 
| NO  
−
| UNI
+
|  
 
|  
 
|  
 
|  
 
|  
 
| invoice number
 
| invoice number
 +
|-
 +
| ref_supplier
 +
| varchar(180)
 +
| NO
 +
|
 +
|
 +
|
 +
| invoice number from supplier
 
{{FieldEntity}}
 
{{FieldEntity}}
 
{{FieldRefExt}}
 
{{FieldRefExt}}
Line 73: Line 81:  
|  
 
|  
 
| date of invoice
 
| date of invoice
 +
|-
 +
| date_pointoftax
 +
| date
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date point of tax (for GB)
 +
|-
 +
| date_valid
 +
| date
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date validation
 
{{FieldTms}}
 
{{FieldTms}}
 
|-
 
|-
Line 89: Line 113:  
| 0  
 
| 0  
 
|  
 
|  
−
| Is te invoice payed (1=yes, 0=otherwise)?
+
| Is the invoice payed (1=yes, 0=otherwise)?
 
|-
 
|-
 
| amount  
 
| amount  
−
| double(16,8)  
+
| double(24,8)  
 
| NO  
 
| NO  
 
|  
 
|  
Line 100: Line 124:  
|-
 
|-
 
| remise  
 
| remise  
−
| double(16,8)  
+
| double(24,8)  
 
| YES  
 
| YES  
 
|  
 
|  
Line 106: Line 130:  
|  
 
|  
 
| discount
 
| 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  
 
|  
 
|  
Line 117: Line 157:  
|-
 
|-
 
| total  
 
| total  
−
| double(16,8)  
+
| double(24,8)  
 
| YES  
 
| YES  
 
|  
 
|  
Line 125: Line 165:  
|-
 
|-
 
| total_ht  
 
| total_ht  
−
| double(16,8)  
+
| double(24,8)  
 
| YES  
 
| YES  
 
|  
 
|  
Line 133: Line 173:  
|-
 
|-
 
| total_tva  
 
| total_tva  
−
| double(16,8)  
+
| double(24,8)  
 
| YES   
 
| YES   
 
|  
 
|  
Line 141: Line 181:  
|-
 
|-
 
| total_ttc  
 
| total_ttc  
−
| double(16,8)  
+
| double(24,8)  
 
| YES  
 
| YES  
 
|  
 
|  
Line 163: Line 203:  
|  
 
|  
 
| ID of user author of invoice ([[Table llx_user|llx_user]]->rowid)
 
| 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 171: Line 219:  
|  
 
|  
 
| ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid)
 
| 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 178: Line 234:  
| NULL  
 
| NULL  
 
|  
 
|  
−
| ID of related proyect ([[Table llx_projet|llx_projet]]->rowid)
+
| 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 186: Line 250:  
| 1  
 
| 1  
 
|  
 
|  
−
| Id of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
+
| 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 196: Line 268:  
| date limit for payment
 
| date limit for payment
 
|-
 
|-
−
| note
+
| note_private
 
| text  
 
| text  
 
| YES   
 
| YES   
Line 202: Line 274:  
| NULL  
 
| NULL  
 
|  
 
|  
−
| commentary
+
| private commentary
 
|-
 
|-
 
| note_public  
 
| note_public  
Line 212: Line 284:  
| public commentary
 
| 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}}
 
{{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;
 
|}&nbsp;
    
== Keys ==
 
== Keys ==
−
'''Version 1.1 2009/10/07'''
+
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
−
{|  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"
   
  |style="background-color: #e9e9ef"| <b>Key</b>
 
  |style="background-color: #e9e9ef"| <b>Key</b>
 
  |style="background-color: #e9e9ef"| <b>Type</b>
 
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 228: Line 379:  
| uk_facture_fourn_ref  
 
| uk_facture_fourn_ref  
 
| UNIQUE
 
| UNIQUE
−
| facnumber,fk_soc,entity
+
| ref,entity
 +
|-
 +
| uk_facture_fourn_ref_supplier
 +
| UNIQUE
 +
| ref_supplier,fk_soc,entity
 
|-  
 
|-  
 
| idx_facture_fourn_date_lim_reglement
 
| idx_facture_fourn_date_lim_reglement
Line 250: Line 405:  
| fk_projet  
 
| fk_projet  
 
|}&nbsp;
 
|}&nbsp;
 +
 
= Notes =
 
= 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?title=Special:MobileDiff/22289...38752"