4,395
edits
Table llx facturedet: Difference between revisions
Jump to navigation
Jump to search
→Structure
| Line 14: | Line 14: | ||
= Structure = | = Structure = | ||
== Table == | |||
'''Version 1.1 2009/10/07''' | |||
{| 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" | {| 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" | ||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| Line 26: | Line 27: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| | | | ||
| auto_increment | | auto_increment | ||
| technical index | | technical index | ||
| Line 34: | Line 35: | ||
| fk_facture | | fk_facture | ||
| int(11) | | int(11) | ||
| | | NO | ||
| MUL | | MUL | ||
| 0 | | 0 | ||
| Line 57: | Line 58: | ||
|- | |- | ||
| tva_taux | | tva_taux | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 65: | Line 66: | ||
|- | |- | ||
| qty | | qty | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 73: | Line 74: | ||
|- | |- | ||
| remise_percent | | remise_percent | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 81: | Line 82: | ||
|- | |- | ||
| remise | | remise | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 91: | Line 92: | ||
| int(11) | | int(11) | ||
| YES | | YES | ||
| | | UNI | ||
| NULL | | NULL | ||
| | | | ||
| Line 97: | Line 98: | ||
|- | |- | ||
| subprice | | subprice | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 105: | Line 106: | ||
|- | |- | ||
| price | | price | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 113: | Line 114: | ||
|- | |- | ||
| total_ht | | total_ht | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 121: | Line 122: | ||
|- | |- | ||
| total_tva | | total_tva | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 129: | Line 130: | ||
|- | |- | ||
| total_ttc | | total_ttc | ||
| | | real | ||
| YES | | YES | ||
| | | | ||
| Line 135: | Line 136: | ||
| | | | ||
| total with tax | | total with tax | ||
|- | |||
| product_type | |||
| int(11) | |||
| YES | |||
| | |||
| 0 | |||
| | |||
| Type of product | |||
|- | |- | ||
| date_start | | date_start | ||
| Line 162: | Line 171: | ||
| fk_code_ventilation | | fk_code_ventilation | ||
| int(11) | | int(11) | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| Line 170: | Line 179: | ||
| fk_export_compta | | fk_export_compta | ||
| int(11) | | int(11) | ||
| | | NO | ||
| | | | ||
| 0 | | 0 | ||
| | | | ||
| ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid) | | ID of acountacy export ([[Table llx_export_compta|llx_export_compta]]->rowid) | ||
|- | |||
| special_code | |||
| tinyint(4) | |||
| YES | |||
| | |||
| 0 | |||
| UNSIGNED | |||
| view order | |||
|- | |- | ||
| rang | | rang | ||
| Line 183: | Line 200: | ||
| | | | ||
| view order | | view order | ||
|} | |- | ||
| import_key | |||
| varchar(14) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| import key | |||
|} | |||
== Keys == | |||
'''Version 1.1 2009/10/07''' | |||
{| 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" | |||
|style="background-color: #e9e9ef"| <b>Key</b> | |||
|style="background-color: #e9e9ef"| <b>Type</b> | |||
|style="background-color: #e9e9ef"| <b>Fields</b> | |||
|- | |||
| PRIMARY | |||
| PRIMARY | |||
| rowid | |||
|- | |||
| uk_fk_remise_except | |||
| UNI | |||
| fk_remise_except | |||
|- | |||
| idx_facturedet_fk_facture | |||
| MULTIPLE | |||
| fk_facture | |||
|} | |||