Table llx facture: Difference between revisions

Jump to navigation Jump to search

Table llx facture (view source)

Revision as of 09:38, 29 May 2022

300 bytes removed ,  4 years ago
→‎Content/Contenu/Contenido
VisualWikitext
Tag: 2017 source edit
Line 6: Line 6:
{{ListOfTables}}
{{ListOfTables}}


= Content/Contenu/Contenido =
=Content/Contenu/Contenido=
{{flag en}} Contains the customer invoices. The invoice details are in [[Table llx_facturedet]]
{{flag en}}
Contains the customer invoices. The invoice details are in [[Table llx_facturedet]]


{{flag fr}} Contient les factures clients. les détails de la facture sont dans la [[Table llx_facturedet]]
{{flag fr}}
Contient les factures clients. les détails de la facture sont dans la [[Table llx_facturedet]]


{{flag sp}} Contiene las facturas a clientes. Los detalles de la factura se encuentran en la [[Table llx_facturedet]]
{{flag sp}}
Contiene las facturas a clientes. Los detalles de la factura se encuentran en la [[Table llx_facturedet]]


= Structure =
=Structure=
== Table ==
==Table==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
  |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>
  |style="background-color: #e9e9ef"| <b>Null</b>
  | style="background-color: #e9e9ef" |<b>Null</b>
  |style="background-color: #e9e9ef"| <b>Key</b>
  | style="background-color: #e9e9ef" |<b>Key</b>
  |style="background-color: #e9e9ef"| <b>Default</b>
  | style="background-color: #e9e9ef" |<b>Default</b>
  |style="background-color: #e9e9ef"| <b>Extra</b>
  | style="background-color: #e9e9ef" |<b>Extra</b>
  |style="background-color: #e9e9ef"| <b>Description</b>
  | style="background-color: #e9e9ef" |<b>Description</b>
|-  
|-  
| rowid  
|rowid
| int(11)  
|int(11)
| NO
|NO
| PRI
|PRI
|  
|
| auto_increment  
|auto_increment
| technical index
|technical index
|-
|-
| facnumber
|ref
| varchar(30)  
|varchar(30)
| NO
|NO
| UNI  
|UNI
|
|
|
|
| invoice number
|invoice number
{{FieldEntity}}
{{FieldEntity}}
{{FieldRefExt}}
{{FieldRefExt}}
|-
|-
| ref_client  
|ref_client
| varchar(30)  
|varchar(30)
| YES  
|YES
|
|
| NULL  
|NULL
|  
|
| customer reference
|customer reference
|-
|-
| type  
|type
| smallint(6)  
|smallint(6)
| NO
|NO
|
|
| 0  
|0
|
|
| type of invoice (0=Standard invoice, 1=Replacement invoice, 2=Credit note invoice, 3=Deposit invoice, 5=Situation invoice)
|type of invoice (0=Standard invoice, 1=Replacement invoice, 2=Credit note invoice, 3=Deposit invoice, 5=Situation invoice)
|-
|-
| fk_soc  
|fk_soc
| int(11)  
|int(11)
| NO
|NO
| MUL  
|MUL
| 0  
|0
|
|
| ID of third party ([[Table llx_societe|llx_societe]]->rowid)
|ID of third party ([[Table llx_societe|llx_societe]]->rowid)
|-
|-
| datec  
|datec
| datetime  
|datetime
| YES  
|YES
|
|
| NULL  
|NULL
|
|
| creation date of invoice
|creation date of invoice
|-
|-
| datef
|datef
| date  
|date
| YES  
|YES
|
| NULL
|
|
| date of invoice
|NULL
|
|date of invoice
|-
|-
| date_pointoftax  
|date_pointoftax
| date  
|date
| YES  
|YES
|
|
| NULL  
|NULL
|
|
| Date for point of tax (Used for GB only)
|Date for point of tax (Used for GB only)
|-
|-
| date_valid  
|date_valid
| date  
|date
| YES  
|YES
|
|
| NULL  
|NULL
|
|
| validation date of invoice
|validation date of invoice
{{FieldTms}}
{{FieldTms}}
|-
|-
| paye  
|paye
| smallint(6)  
|smallint(6)
| NO
|NO
|
|
| 0
|0
|
|
| is the invoice payed completely (1=yes, 0=not paid or paid partially)
|is the invoice payed completely (1=yes, 0=not paid or paid partially)
|-
|-
| remise_percent
|remise_percent
| real
|real
| YES  
|YES
|
|
| 0  
|0
|
|
| discount percentage
|discount percentage
|-
|-
| remise_absolue  
|remise_absolue
| real
|real
| YES  
|YES
|
|
| 0
|0
|
|
| discount absolute
|discount absolute
|-
|-
| remise  
|remise
| real  
|real
| YES  
|YES
|
|
| 0  
|0
|
|
| discount
|discount
|-
|-
| close_code
|close_code
| varchar(16)
|varchar(16)
| YES  
|YES
|  
|
| NULL  
|NULL
|  
|
| close code
|close code
|-
|-
| close_note  
|close_note
| varchar(128)
|varchar(128)
| YES  
|YES
|
|
| NULL
|NULL
|
|
| close note
|close note
|-
|-
| tva  
|tva
| real
|real
| YES  
|YES
|
|
| 0  
|0
|
|
| VAT
|VAT
{{FieldLocalTaxX}}
{{FieldLocalTaxX}}
|-
|-
| revenu_stamp  
|revenu_stamp
| double(24,8)  
|double(24,8)
| YES  
|YES
|
|
| NULL  
|NULL
|
|
| Revenue stamp (for some countries line Tunisia)
|Revenue stamp (for some countries line Tunisia)
|-
|-
| total  
|total
| real  
|real
| YES  
|YES
|
|
| 0  
|0
|
|
| total amount
|total amount
|-
|-
| total_ttc  
|total_ttc
| real
|real
| YES  
|YES
|  
|
| 0  
|0
|
|
| total amount with VAT  
|total amount with VAT
|-
|-
| fk_statut  
|fk_statut
| smallint(6)  
|smallint(6)
| NO
|NO
|
|
| 0  
|0
|
|
| ID of status (0=draft, 1=unpayed, 2=payed partially or completely, 3=abandoned)
|ID of status (0=draft, 1=unpayed, 2=payed partially or completely, 3=abandoned)
|-
|-
| fk_user_author  
|fk_user_author
| int(11)  
|int(11)
| YES  
|YES
| MUL
|MUL
| NULL
|NULL
|
|
| 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_valid  
|fk_user_valid
| int(11)
|int(11)
| YES  
|YES
| MUL
|MUL
| NULL  
|NULL
|  
|
| ID of validator user of invoice ([[Table llx_user|llx_user]]->rowid)
|ID of validator user of invoice ([[Table llx_user|llx_user]]->rowid)
|-
|-
| fk_facture_source  
|fk_facture_source
| int(11)  
|int(11)
| YES  
|YES
| MUL  
|MUL
| NULL  
|NULL
|
|
| ID of source invoice for replacement invoices and credit notes ([[Table llx_facture|llx_facture]]->rowid)
|ID of source invoice for replacement invoices and credit notes ([[Table llx_facture|llx_facture]]->rowid)
|-
|-
| fk_projet  
|fk_projet
| int(11)
|int(11)
| YES  
|YES
| MUL
|MUL
| NULL
|NULL
|  
|
| ID of related proyect ([[Table llx_projet|llx_projet]]->rowid)
|ID of related proyect ([[Table llx_projet|llx_projet]]->rowid)
|-
|-
| fk_cond_reglement  
|fk_cond_reglement
| int(11)  
|int(11)
| NO
|NO
|
|
| 1  
|1
|  
|
| ID of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
|ID of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid)
|-
|-
| fk_mode_reglement  
|fk_mode_reglement
| int(11)  
|int(11)
| YES  
|YES
|
|
| NULL
|NULL
|
|
| ID of payment mode ([[Table llx_c_paiement|llx_c_paiement]]->id)
|ID of payment mode ([[Table llx_c_paiement|llx_c_paiement]]->id)
|-
|-
| date_lim_reglement  
|date_lim_reglement
| date  
|date
| YES  
|YES
|
|
| NULL
|NULL
|
|
| limit date of payment
|limit date of payment
|-
|-
| note  
|note
| text  
|text
| YES  
|YES
|
|
| NULL  
|NULL
|
|
| comentary
|comentary
|-
|-
| note_public  
|note_public
| text  
|text
| YES  
|YES
|
|
| NULL  
|NULL
|
|
| public comentary
|public comentary
|-
|-
| model_pdf
|model_pdf
| varchar(50)  
|varchar(50)
| YES  
|YES
|  
|
| NULL  
|NULL
|
|
| Model of document to suggest by default
|Model of document to suggest by default
{{FieldImportKey}}
{{FieldImportKey}}
|}&nbsp;
|}&nbsp;


== Keys ==
==Keys==
{| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
{| class="dolbox" width="100%" cellspacing="0" cellpadding="1" border="0" align="left"
  |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>
  |style="background-color: #e9e9ef"| <b>Fields</b>
  | style="background-color: #e9e9ef" |<b>Fields</b>
|-  
|-  
| PRIMARY
|PRIMARY
| PRIMARY
|PRIMARY
| rowid
|rowid
|-  
|-  
| idx_facture_uk_facnumber  
|idx_facture_uk_facnumber
| UNIQUE
|UNIQUE
| facnumber,entity
|facnumber,entity
|-  
|-  
| idx_facture_fk_soc  
|idx_facture_fk_soc
| MULTIPLE
|MULTIPLE
| fk_soc
|fk_soc
|-  
|-  
| idx_facture_fk_user_author  
|idx_facture_fk_user_author
| MULTIPLE
|MULTIPLE
| fk_user_author
|fk_user_author
|-  
|-  
| idx_facture_fk_user_valid  
|idx_facture_fk_user_valid
| MULTIPLE
|MULTIPLE
| fk_user_valid  
|fk_user_valid
|-  
|-  
| idx_facture_fk_facture_source
|idx_facture_fk_facture_source
| MULTIPLE
|MULTIPLE
| fk_facture_source
|fk_facture_source
|-  
|-  
| idx_facture_fk_projet  
|idx_facture_fk_projet
| MULTIPLE
|MULTIPLE
| fk_projet  
|fk_projet
|}&nbsp;
|}&nbsp;
Deevando
3

edits

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

Navigation menu