Table llx facture: Difference between revisions

Jump to navigation Jump to search

Table llx facture (view source)

Revision as of 14:32, 11 May 2009

569 bytes removed ,  17 years ago
no edit summary
VisualWikitext
No edit summary
No edit summary
Line 1: Line 1:
[[Category:Invoices]]
[[Category:Facture]]
[[Category:Facture]]
[[Category:Facturas]]
[[Category:Facturas]]
Line 7: Line 8:
= Contenu =
= Contenu =


Contient les factures clients.
{{flag fr}} Contient les factures clients.


Contains the customer invoices.
{{flag en}} Contains the customer invoices.


Contiene las facturas a clientes.
{{flag sp}} Contiene las facturas a clientes.


= Structure =
= Structure =
 
{|  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"
<pre>
|style="background-color: #e9e9ef"| <b>Field</b>
+--------------------+--------------+------+-----+---------+----------------+
|style="background-color: #e9e9ef"| <b>Type</b>
| Field              | Type         | Null | Key | Default | Extra         |
|style="background-color: #e9e9ef"| <b>Null</b>
+--------------------+--------------+------+-----+---------+----------------+
|style="background-color: #e9e9ef"| <b>Key</b>
| rowid             | int(11)     |     | PRI | NULL   | auto_increment |
|style="background-color: #e9e9ef"| <b>Default</b>
| facnumber         | varchar(30) |     | UNI |         |               |
|style="background-color: #e9e9ef"| <b>Extra</b>
| type               | smallint(6) |     |     | 0       |               |
|style="background-color: #e9e9ef"| <b>Description</b>
| ref_client         | varchar(30) | YES |     | NULL   |               |
|-  
| increment         | varchar(10) | YES |     | NULL   |               |
| rowid  
| fk_soc             | int(11)     |     | MUL | 0       |               |
| int(11)  
| datec             | datetime     | YES |     | NULL   |               |
| &nbsp;
| datef             | date         | YES |     | NULL   |               |
| PRI
| date_valid         | date         | YES |     | NULL   |               |
| NULL
| paye               | smallint(6) |     |     | 0       |               |
| auto_increment  
| amount             | double       |     |     | 0       |               |
| technical index
| remise_percent     | double       | YES |     | 0       |               |
|-
| remise_absolue     | double       | YES |     | 0       |               |
| facnumber  
| remise             | double       | YES |     | 0       |               |
| varchar(30)  
| close_code         | varchar(16) | YES |     | NULL   |               |
|  
| close_note         | varchar(128) | YES |     | NULL   |               |
| UNI  
| tva               | double       | YES |     | 0       |               |
|
| total             | double       | YES |     | 0       |               |
|
| total_ttc         | double       | YES |     | 0       |               |
|
| fk_statut         | smallint(6) |     |     | 0       |               |
|-
| fk_user_author     | int(11)     | YES | MUL | NULL   |               |
| type  
| fk_user_valid     | int(11)     | YES | MUL | NULL   |               |
| smallint(6)  
| fk_facture_source | int(11)     | YES | MUL | NULL   |               |
|
| fk_projet         | int(11)     | YES | MUL | NULL   |               |
|
| fk_cond_reglement | int(11)     |     |     | 1       |               |
| 0  
| fk_mode_reglement | int(11)     | YES |     | NULL   |               |
|
| date_lim_reglement | date         | YES |     | NULL   |               |
|
| note               | text         | YES |     | NULL   |               |
|-
| note_public       | text         | YES |     | NULL   |               |
| ref_client  
| model_pdf         | varchar(50) | YES |     | NULL   |               |
| varchar(30)  
+--------------------+--------------+------+-----+---------+----------------+
| YES  
|
| NULL  
|  
|
|-
| increment  
| varchar(10)  
| YES  
|
| NULL
|
|
|-
| fk_soc  
| int(11)  
|
| MUL  
| 0  
|
|
|-
| datec  
| datetime  
| YES  
|
| NULL  
|
|
|-
| datef
| date  
| YES  
|  
| NULL  
|
|
|-
| date_valid  
| date  
| YES  
|
| NULL  
|
|
|-
| paye  
| smallint(6)  
|
|
| 0
|
|
|-
| amount
| double  
|
|  
| 0  
|  
|
|-
| remise_percent
| double  
| YES  
|
| 0  
|
|
|-
| remise_absolue  
| double  
| YES  
|
| 0
|
|
|-
| remise  
| double  
| YES  
|
| 0  
|
|
|-
| close_code
| varchar(16)
| YES  
|  
| NULL  
|
|
|-
| close_note  
| varchar(128)
| YES  
|
| NULL
|
|
|-
| tva  
| double  
| YES  
|
| 0  
|
|
|-
| total  
| double  
| YES  
|
| 0  
|
|
|-
| total_ttc  
| double
| YES  
|  
| 0  
|
|
|-
| fk_statut  
| smallint(6)  
|
|
| 0  
|
|
|-
| fk_user_author  
| int(11)  
| YES  
| MUL
| NULL
|
|
|-
| fk_user_valid  
| int(11)
| YES  
| MUL
| NULL  
|
|
|-
| fk_facture_source  
| int(11)  
| YES  
| MUL  
| NULL  
|
|
|-
| fk_projet  
| int(11)
| YES  
| MUL
| NULL
|  
|
|-
| fk_cond_reglement  
| int(11)  
|
|
| 1  
|  
|
|-
| fk_mode_reglement  
| int(11)  
| YES  
|
| NULL
|
|
|-
| date_lim_reglement  
| date  
| YES  
|
| NULL
|
|
|-
| note  
| text  
| YES  
|
| NULL  
|
|
|-
| note_public  
| text  
| YES  
|
| NULL  
|
|
|-
| model_pdf
| varchar(50)  
| YES  
|  
| NULL  
|
|
|}
</pre>
</pre>
Retrieved from "https://wiki.dolibarr.org/index.php/Special:MobileDiff/11401"

Navigation menu