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

1,757 bytes added ,  8 years ago
no edit summary
VisualWikitext
No edit summary
 
(One intermediate revision by one other user not shown)
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 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
|
|
|-
|} 
|} 


Line 227: 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
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/22500...38752"