| co_art |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| art_des |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| fecha_reg |
datetime
|
|
|
|
| manj_ser |
tinyint(1)
|
|
|
|
| co_lin |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| co_cat |
varchar(6)
|
utf8mb4_unicode_ci
|
|
 Mostrar los valores foráneos
|
| co_subl |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| co_color |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| item |
varchar(10)
|
utf8mb4_unicode_ci
|
|
|
| ref |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| modelo |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| procedenci |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| comentario |
text
|
utf8mb4_unicode_ci
|
|
|
| co_prov |
varchar(10)
|
utf8mb4_unicode_ci
|
|
Mostrar los valores foráneos
|
| ubicacion |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| uni_venta |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| uni_compra |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| uni_relac |
decimal(18,5)
|
|
|
|
| relac_aut |
int(11)
|
|
|
|
| stock_act |
decimal(18,5)
|
|
|
|
| stock_com |
decimal(18,5)
|
|
|
|
| sstock_com |
decimal(18,5)
|
|
|
|
| stock_lle |
decimal(18,5)
|
|
|
|
| sstock_lle |
decimal(18,5)
|
|
|
|
| stock_des |
decimal(18,5)
|
|
|
|
| sstock_des |
decimal(18,5)
|
|
|
|
| suni_venta |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| suni_compr |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| suni_relac |
decimal(18,3)
|
|
|
|
| sstock_act |
decimal(18,5)
|
|
|
|
| relac_comp |
decimal(18,5)
|
|
|
|
| relac_vent |
decimal(18,5)
|
|
|
|
| pto_pedido |
decimal(18,5)
|
|
|
|
| stock_max |
decimal(18,5)
|
|
|
|
| stock_min |
decimal(18,5)
|
|
|
|
| prec_om |
tinyint(1)
|
|
|
|
| prec_vta1 |
decimal(18,5)
|
|
|
|
| fec_prec_v |
datetime
|
|
|
|
| fec_prec_2 |
datetime
|
|
|
|
| prec_vta2 |
decimal(18,5)
|
|
|
|
| fec_prec_3 |
datetime
|
|
|
|
| prec_vta3 |
decimal(18,5)
|
|
|
|
| fec_prec_4 |
datetime
|
|
|
|
| prec_vta4 |
decimal(18,5)
|
|
|
|
| fec_prec_5 |
datetime
|
|
|
|
| prec_vta5 |
decimal(18,5)
|
|
|
|
| prec_agr1 |
decimal(18,5)
|
|
|
|
| prec_agr2 |
decimal(18,5)
|
|
|
|
| prec_agr3 |
decimal(18,5)
|
|
|
|
| prec_agr4 |
decimal(18,5)
|
|
|
|
| prec_agr5 |
decimal(18,5)
|
|
|
|
| can_agr |
decimal(18,5)
|
|
|
|
| fec_des_p5 |
datetime
|
|
|
|
| fec_has_p5 |
datetime
|
|
|
|
| co_imp |
varchar(4)
|
utf8mb4_unicode_ci
|
|
|
| margen_max |
decimal(18,2)
|
|
|
|
| ult_cos_un |
decimal(18,5)
|
|
|
|
| fec_ult_co |
datetime
|
|
|
|
| cos_pro_un |
decimal(18,5)
|
|
|
|
| fec_cos_pr |
datetime
|
|
|
|
| cos_merc |
decimal(18,5)
|
|
|
|
| fec_cos_me |
datetime
|
|
|
|
| cos_prov |
decimal(18,5)
|
|
|
|
| fec_cos_p2 |
datetime
|
|
|
|
| ult_cos_do |
decimal(18,5)
|
|
|
|
| fec_cos_do |
datetime
|
|
|
|
| cos_un_an |
decimal(18,5)
|
|
|
|
| fec_cos_an |
datetime
|
|
|
|
| ult_cos_om |
decimal(18,5)
|
|
|
|
| fec_ult_om |
datetime
|
|
|
|
| cos_pro_om |
decimal(18,5)
|
|
|
|
| fec_pro_om |
datetime
|
|
|
|
| tipo_cos |
varchar(4)
|
utf8mb4_unicode_ci
|
|
|
| mont_comi |
decimal(18,2)
|
|
|
|
| porc_cos |
decimal(18,2)
|
|
|
|
| mont_cos |
decimal(18,2)
|
|
|
|
| porc_gas |
decimal(18,2)
|
|
|
|
| mont_gas |
decimal(18,2)
|
|
|
|
| f_cost |
datetime
|
|
|
|
| fisico |
tinyint(1)
|
|
|
|
| punt_cli |
decimal(18,2)
|
|
|
|
| punt_pro |
decimal(18,2)
|
|
|
|
| dias_repos |
int(11)
|
|
|
|
| tipo |
varchar(1)
|
utf8mb4_unicode_ci
|
|
|
| alm_prin |
varchar(4)
|
utf8mb4_unicode_ci
|
|
|
| anulado |
tinyint(1)
|
|
|
|
| tipo_imp |
varchar(1)
|
utf8mb4_unicode_ci
|
|
|
| dis_cen |
text
|
utf8mb4_unicode_ci
|
|
|
| mon_ilc |
decimal(18,5)
|
|
|
|
| capacidad |
decimal(18,3)
|
|
|
|
| grado_al |
decimal(10,2)
|
|
|
|
| tipo_licor |
varchar(1)
|
utf8mb4_unicode_ci
|
|
|
| compuesto |
tinyint(1)
|
|
|
|
| picture |
blob
|
|
|
|
| campo1 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo2 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo3 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo4 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo5 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo6 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo7 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| campo8 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| co_us_in |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| fe_us_in |
datetime
|
|
|
|
| co_us_mo |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| fe_us_mo |
datetime
|
|
|
|
| co_us_el |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| fe_us_el |
datetime
|
|
|
|
| revisado |
varchar(1)
|
utf8mb4_unicode_ci
|
|
|
| trasnfe |
varchar(1)
|
utf8mb4_unicode_ci
|
|
|
| co_sucu |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| rowguid |
char(36)
|
utf8mb4_unicode_ci
|
|
|
| tuni_venta |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| equi_uni1 |
decimal(18,5)
|
|
|
|
| equi_uni2 |
decimal(18,5)
|
|
|
|
| equi_uni3 |
decimal(18,5)
|
|
|
|
| lote |
tinyint(1)
|
|
|
|
| serialp |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| valido |
tinyint(1)
|
|
|
|
| atributo1 |
tinyint(1)
|
|
|
|
| vatributo1 |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| atributo2 |
tinyint(1)
|
|
|
|
| vatributo2 |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| atributo3 |
tinyint(1)
|
|
|
|
| vatributo3 |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| atributo4 |
tinyint(1)
|
|
|
|
| vatributo4 |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| atributo5 |
tinyint(1)
|
|
|
|
| vatributo5 |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| atributo6 |
tinyint(1)
|
|
|
|
| vatributo6 |
varchar(15)
|
utf8mb4_unicode_ci
|
|
|
| garantia |
varchar(30)
|
utf8mb4_unicode_ci
|
|
|
| peso |
decimal(18,5)
|
|
|
|
| pie |
decimal(18,5)
|
|
|
|
| margen1 |
decimal(18,2)
|
|
|
|
| margen2 |
decimal(18,2)
|
|
|
|
| margen3 |
decimal(18,2)
|
|
|
|
| margen4 |
decimal(18,2)
|
|
|
|
| margen5 |
decimal(18,2)
|
|
|
|
| row_id |
timestamp
|
|
|
|
| imagen1 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| imagen2 |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| i_art_des |
varchar(60)
|
utf8mb4_unicode_ci
|
|
|
| uni_emp |
varchar(6)
|
utf8mb4_unicode_ci
|
|
|
| rel_emp |
decimal(18,5)
|
|
|
|
| movil |
tinyint(1)
|
|
|
|
| tipo_foto |
varchar(4)
|
utf8mb4_unicode_ci
|
|
|
| foto |
blob
|
|
|
|
