| articulo |
varchar(14)
|
utf8mb3_general_ci
|
|
|
| marca |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| descripcion |
varchar(80)
|
utf8mb3_general_ci
|
|
|
| serie |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| pvpsiniva |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| pvpconiva |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| umed |
varchar(2)
|
utf8mb3_general_ci
|
|
|
| stock |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| stockuni |
varchar(7)
|
utf8mb3_general_ci
|
|
|
| stockcaj |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| stockpal |
varchar(5)
|
utf8mb3_general_ci
|
|
|
| ancho |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| largo |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| grosor |
decimal(3,2)
|
|
|
|
| uncaja |
int
|
|
|
|
| cjpalet |
varchar(14)
|
utf8mb3_general_ci
|
|
|
| unpalet |
int
|
|
|
|
| fmtminv |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| m2pieza |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| m2caja |
varchar(5)
|
utf8mb3_general_ci
|
|
|
| m2palet |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| pesounpz |
varchar(5)
|
utf8mb3_general_ci
|
|
|
| pesocaja |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| pesopalet |
varchar(8)
|
utf8mb3_general_ci
|
|
|
| familia |
varchar(5)
|
utf8mb3_general_ci
|
|
|
| descfam |
varchar(56)
|
utf8mb3_general_ci
|
|
|
| refprov1 |
varchar(16)
|
utf8mb3_general_ci
|
|
|
| refprov2 |
varchar(13)
|
utf8mb3_general_ci
|
|
|
| refprov3 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| ean131 |
varchar(13)
|
utf8mb3_general_ci
|
|
|
| ean132 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| ean133 |
varchar(1)
|
utf8mb3_general_ci
|
|
|
| abc |
varchar(1)
|
utf8mb3_general_ci
|
|
|
| abcpos |
varchar(6)
|
utf8mb3_general_ci
|
|
|
| estado |
varchar(13)
|
utf8mb3_general_ci
|
|
|
| iva |
varchar(8)
|
utf8mb3_general_ci
|
|
|
| fechalta |
varchar(8)
|
utf8mb3_general_ci
|
|
|
| ufecompr |
varchar(8)
|
utf8mb3_general_ci
|
|
|
| ufecvent |
varchar(8)
|
utf8mb3_general_ci
|
|
|
| stkreser |
decimal(3,2)
|
|
|
|
| pserprov |
decimal(3,2)
|
|
|
|
| minimo |
decimal(3,2)
|
|
|
|
| maximo |
varchar(23)
|
utf8mb3_general_ci
|
|
|
| proveedor |
varchar(38)
|
utf8mb3_general_ci
|
|
|
| webart1 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart2 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart3 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart4 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart5 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart6 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart7 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart8 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| webart9 |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| obs1 (+descripcion) |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| obs2 (+descripcion) |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| obs3 (+descripcion) |
varchar(10)
|
utf8mb3_general_ci
|
|
|
| obs4 (+descripcion) |
varchar(10)
|
utf8mb3_general_ci
|
|
|
