4,395
edits
Table llx facture: Difference between revisions
Jump to navigation
Jump to search
→Structure
| Line 38: | Line 38: | ||
| | | | ||
| | | | ||
| | | invoice number | ||
|- | |||
| entity | |||
| int(11) | |||
| | |||
| | |||
| 1 | |||
| | |||
| multi company id | |||
|- | |- | ||
| type | | type | ||
| Line 46: | Line 54: | ||
| 0 | | 0 | ||
| | | | ||
| | | type of invoice | ||
|- | |- | ||
| ref_client | | ref_client | ||
| Line 70: | Line 78: | ||
| 0 | | 0 | ||
| | | | ||
| | | ID of society ([[Table llx_societe|llx_societe]]->rowid) | ||
|- | |- | ||
| datec | | datec | ||
| Line 78: | Line 86: | ||
| NULL | | NULL | ||
| | | | ||
| | | creation date of invoice | ||
|- | |- | ||
| datef | | datef | ||
| Line 86: | Line 94: | ||
| NULL | | NULL | ||
| | | | ||
| | | date of invoice | ||
|- | |- | ||
| date_valid | | date_valid | ||
| Line 94: | Line 102: | ||
| NULL | | NULL | ||
| | | | ||
| | | validation date of invoice | ||
|- | |- | ||
| paye | | paye | ||
| Line 102: | Line 110: | ||
| 0 | | 0 | ||
| | | | ||
| | | is the invoice payed? | ||
|- | |- | ||
| amount | | amount | ||
| Line 110: | Line 118: | ||
| 0 | | 0 | ||
| | | | ||
| | | amount of invoice | ||
|- | |- | ||
| remise_percent | | remise_percent | ||
| Line 118: | Line 126: | ||
| 0 | | 0 | ||
| | | | ||
| | | | ||
|- | |- | ||
| remise_absolue | | remise_absolue | ||
| Line 158: | Line 166: | ||
| 0 | | 0 | ||
| | | | ||
| | | | ||
|- | |- | ||
| total | | total | ||
| Line 190: | Line 198: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of user author of invoice ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_user_valid | | fk_user_valid | ||
| Line 198: | Line 206: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of validator user of invoice ([[Table llx_user|llx_user]]->rowid) | ||
|- | |- | ||
| fk_facture_source | | fk_facture_source | ||
| Line 206: | Line 214: | ||
| NULL | | NULL | ||
| | | | ||
| | | ID of facture source for replacement invoices and credit notes ([[Table llx_facture|llx_facture]]->rowid) | ||
|- | |- | ||
| fk_projet | | fk_projet | ||