| rowid |
int(11)
|
|
|
|
| entity |
int(11)
|
|
|
|
| datec |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_product |
int(11)
|
|
|
 Mostrar los valores foráneos
|
| fk_soc |
int(11)
|
|
|
|
| ref_fourn |
varchar(30)
|
utf8_unicode_ci
|
|
|
| desc_fourn |
text
|
utf8_unicode_ci
|
|
|
| fk_availability |
int(11)
|
|
|
|
| price |
double(24,8)
|
|
|
|
| quantity |
double
|
|
|
|
| remise_percent |
double
|
|
|
|
| remise |
double
|
|
|
|
| unitprice |
double(24,8)
|
|
|
|
| charges |
double(24,8)
|
|
|
|
| default_vat_code |
varchar(10)
|
utf8_unicode_ci
|
|
|
| barcode |
varchar(180)
|
utf8_unicode_ci
|
|
|
| fk_barcode_type |
int(11)
|
|
|
Mostrar los valores foráneos
|
| tva_tx |
double(6,3)
|
|
|
|
| localtax1_tx |
double(6,3)
|
|
|
|
| localtax1_type |
varchar(10)
|
utf8_unicode_ci
|
|
|
| localtax2_tx |
double(6,3)
|
|
|
|
| localtax2_type |
varchar(10)
|
utf8_unicode_ci
|
|
|
| info_bits |
int(11)
|
|
|
|
| fk_user |
int(11)
|
|
|
|
| fk_supplier_price_expression |
int(11)
|
|
|
|
| import_key |
varchar(14)
|
utf8_unicode_ci
|
|
|
| delivery_time_days |
int(11)
|
|
|
|
| supplier_reputation |
varchar(10)
|
utf8_unicode_ci
|
|
|
| packaging |
double(24,8)
|
|
|
|
| fk_multicurrency |
int(11)
|
|
|
|
| multicurrency_code |
varchar(255)
|
utf8_unicode_ci
|
|
|
| multicurrency_tx |
double(24,8)
|
|
|
|
| multicurrency_unitprice |
double(24,8)
|
|
|
|
| multicurrency_price |
double(24,8)
|
|
|
|
