4,395
edits
Table llx facture fourn: Difference between revisions
→Structure
| Line 31: | Line 31: | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
|- | |||
| entity | |||
| int(11) | |||
| | |||
| | |||
| 1 | |||
| | |||
| multi company id | |||
|- | |- | ||
| facnumber | | facnumber | ||
| Line 38: | Line 46: | ||
| | | | ||
| | | | ||
| | | invoice number | ||
|- | |- | ||
| type | | type | ||
| Line 46: | Line 54: | ||
| 0 | | 0 | ||
| | | | ||
| | | type of invoice | ||
|- | |- | ||
| fk_soc | | fk_soc | ||
| Line 54: | Line 62: | ||
| | | | ||
| | | | ||
| | | ID society ([[Table llx_societe|llx_societe]]->rowid) | ||
|- | |- | ||
| datec | | datec | ||
| Line 62: | Line 70: | ||
| NULL | | NULL | ||
| | | | ||
| | | creation date | ||
|- | |- | ||
| datef | | datef | ||
| Line 70: | Line 78: | ||
| NULL | | NULL | ||
| | | | ||
| date of invoice | |||
|- | |||
| tms | |||
| timestamp | |||
| NO | |||
| | |||
| CURRENT_TIMESTAMP | |||
| | | | ||
| last update date | |||
|- | |- | ||
| libelle | | libelle | ||
| Line 78: | Line 94: | ||
| NULL | | NULL | ||
| | | | ||
| | | label | ||
|- | |- | ||
| paye | | paye | ||
| Line 86: | Line 102: | ||
| 0 | | 0 | ||
| | | | ||
| 1 | | 1 if the invoice is payed, 0 otherwise | ||
|- | |- | ||
| amount | | amount | ||
| Line 94: | Line 110: | ||
| 0.00000000 | | 0.00000000 | ||
| | | | ||
| | | amount | ||
|- | |- | ||
| remise | | remise | ||
| Line 118: | Line 134: | ||
| 0.00000000 | | 0.00000000 | ||
| | | | ||
| | | total amount | ||
|- | |- | ||
| total_ht | | total_ht | ||
| Line 126: | Line 142: | ||
| 0.00000000 | | 0.00000000 | ||
| | | | ||
| | | total amount excluding VAT | ||
|- | |- | ||
| total_tva | | total_tva | ||
| Line 134: | Line 150: | ||
| 0.00000000 | | 0.00000000 | ||
| | | | ||
| | | total amount of VAT | ||
|- | |- | ||
| total_ttc | | total_ttc | ||
| Line 142: | Line 158: | ||
| 0.00000000 | | 0.00000000 | ||
| | | | ||
| | | total amount with VAT | ||
|- | |- | ||
| fk_statut | | fk_statut | ||
| Line 158: | Line 174: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of user author of invoice ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_user_valid | | fk_user_valid | ||
| Line 166: | Line 182: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of user validator of invoice ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_projet | | fk_projet | ||
| Line 174: | Line 190: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of related proyect ([[Table llx_projet|llx_projet]]->rowid) | ||
|- | |- | ||
| fk_cond_reglement | | fk_cond_reglement | ||
| Line 182: | Line 198: | ||
| 1 | | 1 | ||
| | | | ||
| | | Id of payment condition ([[Table llx_cond_reglement|llx_cond_reglement]]->rowid) | ||
|- | |- | ||
| date_lim_reglement | | date_lim_reglement | ||
| Line 190: | Line 206: | ||
| NULL | | NULL | ||
| | | | ||
| | | date limit for payment | ||
|- | |- | ||
| note | | note | ||
| Line 198: | Line 214: | ||
| NULL | | NULL | ||
| | | | ||
| | | comentary | ||
|- | |- | ||
| note_public | | note_public | ||
| Line 206: | Line 222: | ||
| NULL | | NULL | ||
| | | | ||
| public comentary | |||
|- | |||
| import_key | |||
| varchar(14) | |||
| YES | |||
| | |||
| NULL | |||
| | | | ||
| import key | |||
|} | |} | ||