Table llx contratdet
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL
Content/Contenu/Contenido
Contains the details of contrats. This table is linked to Table llx_contrat
Contient les détails des contrats, cette table est liée avec la Table llx_contrat
Contiene los detalles de los contratos, esta tabla está vinculada con Table llx_contrat
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| fk_contrat | int(11) | NO | MUL | ID of contrat (llx_contrat->rowid) | ||
| fk_product | int(11) | YES | MUL | NULL | ID of product (llx_product->rowid) | |
| statut | smallint(6) | YES | 0 | state | ||
| label | text | YES | NULL | label of product | ||
| description | text | YES | NULL | product or service description | ||
| fk_remise_except | int(11) | YES | NULL | ID of discount (llx_societe_remise_except->rowid) | ||
| date_commande | datetime | YES | NULL | date of order | ||
| date_ouverture_prevue | datetime | YES | MUL | NULL | open service date | |
| date_ouverture | datetime | YES | MUL | NULL | client open service date | |
| date_fin_validite | datetime | YES | MUL | NULL | end service date | |
| date_cloture | datetime | YES | NULL | close service date | ||
| tva_tx | double(6,3) | YES | 0.000 | VAT taxes | ||
| qty | real | NO | Quantity of product or service | |||
| remise_percent | real | YES | 0 | discount percentage | ||
| subprice | double(24,8) | YES | 0.00000000 | unit price | ||
| price_ht | real | YES | NULL | price excluding tax | ||
| remise | real | YES | 0 | discount amount | ||
| total_ht | double(24,8) | YES | NULL | total excluding taxes | ||
| total_tva | double(24,8) | YES | NULL | total tax | ||
| total_localtax1 | double(24,8) | YES | NULL | total local tax 1 | ||
| total_localtax2 | double(24,8) | YES | NULL | total local tax 2 | ||
| total_ttc | double(24,8) | YES | NULL | Total including discount and taxes (vat + localtax1 + localtax2) | ||
| info_bits | int(11) | YES | 0 | TVA NPR or not | ||
| fk_user_author | int(11) | 0 | ID creator user (llx_user->rowid) | |||
| fk_user_ouverture | int(11) | YES | NULL | ID activator user (llx_user->rowid) | ||
| fk_user_cloture | int(11) | YES | NULL | ID closer user (llx_user->rowid) | ||
| commentaire | text | YES | NULL | comment |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| idx_contratdet_fk_contrat | MULTIPLE | fk_contrat |
| idx_contratdet_fk_product | MULTIPLE | fk_product |
| idx_contratdet_date_ouverture_prevue | MULTIPLE | date_ouverture_prevue |
| idx_contratdet_date_ouverture | MULTIPLE | date_ouverture |
| idx_contratdet_date_fin_validite | MULTIPLE | date_fin_validite |