| rowid |
int(11)
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_contrat |
int(11)
|
|
|
 Fremdschlüsselwerte ansehen
|
| fk_product |
int(11)
|
|
|
Fremdschlüsselwerte ansehen
|
| statut |
smallint(6)
|
|
|
|
| label |
text
|
utf8_unicode_ci
|
|
|
| description |
text
|
utf8_unicode_ci
|
|
|
| fk_remise_except |
int(11)
|
|
|
|
| date_commande |
datetime
|
|
|
|
| date_ouverture_prevue |
datetime
|
|
|
|
| date_ouverture |
datetime
|
|
|
|
| date_fin_validite |
datetime
|
|
|
|
| date_cloture |
datetime
|
|
|
|
| vat_src_code |
varchar(10)
|
utf8_unicode_ci
|
|
|
| tva_tx |
double(7,4)
|
|
|
|
| localtax1_tx |
double(7,4)
|
|
|
|
| localtax1_type |
varchar(10)
|
utf8_unicode_ci
|
|
|
| localtax2_tx |
double(7,4)
|
|
|
|
| localtax2_type |
varchar(10)
|
utf8_unicode_ci
|
|
|
| qty |
double
|
|
|
|
| remise_percent |
double
|
|
|
|
| subprice |
double(24,8)
|
|
|
|
| subprice_ttc |
double(24,8)
|
|
|
|
| total_ht |
double(24,8)
|
|
|
|
| total_tva |
double(24,8)
|
|
|
|
| total_localtax1 |
double(24,8)
|
|
|
|
| total_localtax2 |
double(24,8)
|
|
|
|
| total_ttc |
double(24,8)
|
|
|
|
| product_type |
int(11)
|
|
|
|
| info_bits |
int(11)
|
|
|
|
| rang |
int(11)
|
|
|
|
| buy_price_ht |
double(24,8)
|
|
|
|
| fk_product_fournisseur_price |
int(11)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_ouverture |
int(11)
|
|
|
|
| fk_user_cloture |
int(11)
|
|
|
|
| commentaire |
text
|
utf8_unicode_ci
|
|
|
| fk_unit |
int(11)
|
|
|
|
| fk_multicurrency |
int(11)
|
|
|
|
| multicurrency_code |
varchar(3)
|
utf8_unicode_ci
|
|
|
| multicurrency_subprice |
double(24,8)
|
|
|
|
| multicurrency_subprice_ttc |
double(24,8)
|
|
|
|
| multicurrency_total_ht |
double(24,8)
|
|
|
|
| multicurrency_total_tva |
double(24,8)
|
|
|
|
| multicurrency_total_ttc |
double(24,8)
|
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
