| rowid |
int(11)
|
|
|
|
| ref |
varchar(30)
|
utf8_unicode_ci
|
|
|
| entity |
int(11)
|
|
|
|
| ref_ext |
varchar(255)
|
utf8_unicode_ci
|
|
|
| ref_client |
varchar(255)
|
utf8_unicode_ci
|
|
|
| type |
smallint(6)
|
|
|
|
| subtype |
smallint(6)
|
|
|
|
| fk_soc |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| datef |
date
|
|
|
|
| date_pointoftax |
date
|
|
|
|
| date_valid |
date
|
|
|
|
| tms |
timestamp
|
|
|
|
| date_closing |
datetime
|
|
|
|
| paye |
smallint(6)
|
|
|
|
| remise_percent |
double
|
|
|
|
| remise_absolue |
double
|
|
|
|
| remise |
double
|
|
|
|
| close_code |
varchar(16)
|
utf8_unicode_ci
|
|
|
| close_missing_amount |
double(24,8)
|
|
|
|
| close_note |
varchar(128)
|
utf8_unicode_ci
|
|
|
| total_tva |
double(24,8)
|
|
|
|
| localtax1 |
double(24,8)
|
|
|
|
| localtax2 |
double(24,8)
|
|
|
|
| revenuestamp |
double(24,8)
|
|
|
|
| total_ht |
double(24,8)
|
|
|
|
| total_ttc |
double(24,8)
|
|
|
|
| fk_statut |
smallint(6)
|
|
|
|
| fk_user_author |
int(11)
|
|
|
|
| fk_user_modif |
int(11)
|
|
|
|
| fk_user_valid |
int(11)
|
|
|
|
| fk_user_closing |
int(11)
|
|
|
|
| module_source |
varchar(32)
|
utf8_unicode_ci
|
|
|
| pos_source |
varchar(32)
|
utf8_unicode_ci
|
|
|
| pos_print_counter |
int(11)
|
|
|
|
| email_sent_counter |
int(11)
|
|
|
|
| fk_fac_rec_source |
int(11)
|
|
|
|
| fk_facture_source |
int(11)
|
|
|
 Fremdschlüsselwerte ansehen
|
| fk_projet |
int(11)
|
|
|
Fremdschlüsselwerte ansehen
|
| increment |
varchar(10)
|
utf8_unicode_ci
|
|
|
| fk_account |
int(11)
|
|
|
|
| fk_currency |
varchar(3)
|
utf8_unicode_ci
|
|
|
| fk_cond_reglement |
int(11)
|
|
|
|
| fk_mode_reglement |
int(11)
|
|
|
|
| date_lim_reglement |
date
|
|
|
|
| payment_reference |
varchar(25)
|
utf8_unicode_ci
|
|
|
| dispute_status |
int(11)
|
|
|
|
| note_private |
text
|
utf8_unicode_ci
|
|
|
| note_public |
text
|
utf8_unicode_ci
|
|
|
| model_pdf |
varchar(255)
|
utf8_unicode_ci
|
|
|
| last_main_doc |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_input_reason |
int(11)
|
|
|
|
| fk_incoterms |
int(11)
|
|
|
|
| location_incoterms |
varchar(255)
|
utf8_unicode_ci
|
|
|
| fk_transport_mode |
int(11)
|
|
|
|
| prorata_discount |
double
|
|
|
|
| situation_cycle_ref |
int(11)
|
|
|
|
| situation_counter |
smallint(6)
|
|
|
|
| situation_final |
smallint(6)
|
|
|
|
| retained_warranty |
double
|
|
|
|
| retained_warranty_date_limit |
date
|
|
|
|
| retained_warranty_fk_cond_reglement |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| extraparams |
varchar(255)
|
utf8_unicode_ci
|
|
|
| is_also_delivery_note |
tinyint(4)
|
|
|
|
| fk_multicurrency |
int(11)
|
|
|
|
| multicurrency_code |
varchar(3)
|
utf8_unicode_ci
|
|
|
| multicurrency_tx |
double(24,8)
|
|
|
|
| multicurrency_total_ht |
double(24,8)
|
|
|
|
| multicurrency_total_tva |
double(24,8)
|
|
|
|
| multicurrency_total_ttc |
double(24,8)
|
|
|
|
| ip |
varchar(250)
|
utf8_unicode_ci
|
|
|
