| rowid |
int
|
|
|
|
| nom |
varchar(128)
|
latin1_swedish_ci
|
|
|
| name_alias |
varchar(128)
|
latin1_swedish_ci
|
|
|
| entity |
int
|
|
|
|
| ref_ext |
varchar(255)
|
latin1_swedish_ci
|
|
|
| ref_int |
varchar(255)
|
latin1_swedish_ci
|
|
|
| statut |
tinyint
|
|
|
|
| parent |
int
|
|
|
|
| status |
tinyint
|
|
|
|
| code_client |
varchar(24)
|
latin1_swedish_ci
|
|
|
| code_fournisseur |
varchar(24)
|
latin1_swedish_ci
|
|
|
| code_compta |
varchar(24)
|
latin1_swedish_ci
|
|
|
| code_compta_fournisseur |
varchar(24)
|
latin1_swedish_ci
|
|
|
| address |
varchar(255)
|
latin1_swedish_ci
|
|
|
| zip |
varchar(25)
|
latin1_swedish_ci
|
|
|
| town |
varchar(50)
|
latin1_swedish_ci
|
|
|
| fk_departement |
int
|
|
|
|
| fk_pays |
int
|
|
|
|
| fk_account |
int
|
|
|
|
| phone |
varchar(20)
|
latin1_swedish_ci
|
|
|
| fax |
varchar(20)
|
latin1_swedish_ci
|
|
|
| url |
varchar(255)
|
latin1_swedish_ci
|
|
|
| email |
varchar(128)
|
latin1_swedish_ci
|
|
|
| socialnetworks |
text
|
latin1_swedish_ci
|
|
|
| skype |
varchar(255)
|
latin1_swedish_ci
|
|
|
| twitter |
varchar(255)
|
latin1_swedish_ci
|
|
|
| facebook |
varchar(255)
|
latin1_swedish_ci
|
|
|
| linkedin |
varchar(255)
|
latin1_swedish_ci
|
|
|
| instagram |
varchar(255)
|
latin1_swedish_ci
|
|
|
| snapchat |
varchar(255)
|
latin1_swedish_ci
|
|
|
| googleplus |
varchar(255)
|
latin1_swedish_ci
|
|
|
| youtube |
varchar(255)
|
latin1_swedish_ci
|
|
|
| whatsapp |
varchar(255)
|
latin1_swedish_ci
|
|
|
| fk_effectif |
int
|
|
|
|
| fk_typent |
int
|
|
|
|
| fk_forme_juridique |
int
|
|
|
|
| fk_currency |
varchar(3)
|
latin1_swedish_ci
|
|
|
| siren |
varchar(128)
|
latin1_swedish_ci
|
|
|
| siret |
varchar(128)
|
latin1_swedish_ci
|
|
|
| ape |
varchar(128)
|
latin1_swedish_ci
|
|
|
| idprof4 |
varchar(128)
|
latin1_swedish_ci
|
|
|
| idprof5 |
varchar(128)
|
latin1_swedish_ci
|
|
|
| idprof6 |
varchar(128)
|
latin1_swedish_ci
|
|
|
| tva_intra |
varchar(20)
|
latin1_swedish_ci
|
|
|
| capital |
double(24,8)
|
|
|
|
| fk_stcomm |
int
|
|
|
|
| note_private |
text
|
latin1_swedish_ci
|
|
|
| note_public |
text
|
latin1_swedish_ci
|
|
|
| model_pdf |
varchar(255)
|
latin1_swedish_ci
|
|
|
| prefix_comm |
varchar(5)
|
latin1_swedish_ci
|
|
|
| client |
tinyint
|
|
|
|
| fournisseur |
tinyint
|
|
|
|
| supplier_account |
varchar(32)
|
latin1_swedish_ci
|
|
|
| fk_prospectlevel |
varchar(12)
|
latin1_swedish_ci
|
|
|
| fk_incoterms |
int
|
|
|
|
| location_incoterms |
varchar(255)
|
latin1_swedish_ci
|
|
|
| customer_bad |
tinyint
|
|
|
|
| customer_rate |
double
|
|
|
|
| supplier_rate |
double
|
|
|
|
| remise_client |
double
|
|
|
|
| remise_supplier |
double
|
|
|
|
| mode_reglement |
tinyint
|
|
|
|
| cond_reglement |
tinyint
|
|
|
|
| mode_reglement_supplier |
tinyint
|
|
|
|
| cond_reglement_supplier |
tinyint
|
|
|
|
| fk_shipping_method |
int
|
|
|
|
| tva_assuj |
tinyint
|
|
|
|
| localtax1_assuj |
tinyint
|
|
|
|
| localtax1_value |
double(6,3)
|
|
|
|
| localtax2_assuj |
tinyint
|
|
|
|
| localtax2_value |
double(6,3)
|
|
|
|
| barcode |
varchar(180)
|
latin1_swedish_ci
|
|
|
| fk_barcode_type |
int
|
|
|
|
| price_level |
int
|
|
|
|
| outstanding_limit |
double(24,8)
|
|
|
|
| order_min_amount |
double(24,8)
|
|
|
|
| supplier_order_min_amount |
double(24,8)
|
|
|
|
| default_lang |
varchar(6)
|
latin1_swedish_ci
|
|
|
| logo |
varchar(255)
|
latin1_swedish_ci
|
|
|
| logo_squarred |
varchar(255)
|
latin1_swedish_ci
|
|
|
| canvas |
varchar(32)
|
latin1_swedish_ci
|
|
|
| fk_entrepot |
int
|
|
|
|
| webservices_url |
varchar(255)
|
latin1_swedish_ci
|
|
|
| webservices_key |
varchar(128)
|
latin1_swedish_ci
|
|
|
| tms |
timestamp
|
|
|
|
| datec |
datetime
|
|
|
|
| fk_user_creat |
int
|
|
|
|
| fk_user_modif |
int
|
|
|
|
| fk_multicurrency |
int
|
|
|
|
| multicurrency_code |
varchar(255)
|
latin1_swedish_ci
|
|
|
| import_key |
varchar(14)
|
latin1_swedish_ci
|
|
|
