| comp |
char(6)
|
utf8_general_ci
|
|
|
| fecha |
date
|
|
|
|
| codigo |
char(20)
|
utf8_general_ci
|
|
|
| tipo |
char(2)
|
utf8_general_ci
|
|
|
| numero |
char(8)
|
utf8_general_ci
|
|
|
| detalle |
char(36)
|
utf8_general_ci
|
|
|
| valor |
decimal(14,2)
|
|
|
|
| valordolar |
decimal(12,2)
|
|
|
|
| percon |
decimal(2,0)
|
|
|
|
| contab |
bit(1)
|
|
|
|
| refer |
char(8)
|
utf8_general_ci
|
|
|
| digitado |
date
|
|
|
|
| opera |
char(5)
|
utf8_general_ci
|
|
|
| integrado |
bit(1)
|
|
|
|
| comproba |
char(4)
|
utf8_general_ci
|
|
|
| monto |
decimal(16,2)
|
|
|
|
| fecha_com |
date
|
|
|
|
| si |
bit(1)
|
|
|
|
| depar |
char(8)
|
utf8_general_ci
|
|
|
| sucursal |
char(6)
|
utf8_general_ci
|
|
|
| fmr |
datetime
|
|
|
|
| aleatorio |
decimal(8,0)
|
|
|
|
| enviado |
bit(1)
|
|
|
|
| ruc |
char(20)
|
utf8_general_ci
|
|
|
| base0 |
decimal(12,2)
|
|
|
|
| basedif |
decimal(12,2)
|
|
|
|
| serie |
char(6)
|
utf8_general_ci
|
|
|
| afiliado |
bit(1)
|
|
|
|
| autorizado |
bit(1)
|
|
|
|
| base |
decimal(14,2)
|
|
|
|
| basimpgra |
decimal(12,2)
|
|
|
|
| basimpice |
decimal(12,2)
|
|
|
|
| basimpren |
decimal(12,2)
|
|
|
|
| basimpren2 |
decimal(12,2)
|
|
|
|
| bastarcer |
decimal(12,2)
|
|
|
|
| benef |
char(36)
|
utf8_general_ci
|
|
|
| bodega |
char(2)
|
utf8_general_ci
|
|
|
| borrado |
bit(1)
|
|
|
|
| bruto |
decimal(6,0)
|
|
|
|
| cancelado |
bit(1)
|
|
|
|
| cangru |
decimal(6,0)
|
|
|
|
| cannotcre |
char(12)
|
utf8_general_ci
|
|
|
| cannotdeb |
char(12)
|
utf8_general_ci
|
|
|
| cantidad |
decimal(12,2)
|
|
|
|
| canuni |
decimal(8,2)
|
|
|
|
| canvenmes |
char(12)
|
utf8_general_ci
|
|
|
| cefecaut |
date
|
|
|
|
| cehoraut |
datetime
|
|
|
|
| cenumaut |
char(60)
|
utf8_general_ci
|
|
|
| cenumcla |
char(60)
|
utf8_general_ci
|
|
|
| clase |
char(2)
|
utf8_general_ci
|
|
|
| clinica |
bit(1)
|
|
|
|
| codcon |
char(20)
|
utf8_general_ci
|
|
|
| codper |
char(6)
|
utf8_general_ci
|
|
|
| codporice |
decimal(2,0)
|
|
|
|
| codporiva |
decimal(1,0)
|
|
|
|
| codporret |
decimal(2,0)
|
|
|
|
| codporret1 |
decimal(1,0)
|
|
|
|
| codporret2 |
decimal(1,0)
|
|
|
|
| codretren |
char(5)
|
utf8_general_ci
|
|
|
| codretren2 |
char(5)
|
utf8_general_ci
|
|
|
| codsectra |
char(2)
|
utf8_general_ci
|
|
|
| codtipcom |
char(2)
|
utf8_general_ci
|
|
|
| cod_benef |
char(20)
|
utf8_general_ci
|
|
|
| cod_cb |
char(20)
|
utf8_general_ci
|
|
|
| cod_provee |
char(5)
|
utf8_general_ci
|
|
|
| cod_retenc |
char(5)
|
utf8_general_ci
|
|
|
| conretimp |
char(5)
|
utf8_general_ci
|
|
|
| costo |
decimal(14,4)
|
|
|
|
| cruzar |
char(1)
|
utf8_general_ci
|
|
|
| depositado |
bit(1)
|
|
|
|
| descto |
decimal(6,2)
|
|
|
|
| descto2 |
decimal(6,2)
|
|
|
|
| descto3 |
decimal(6,2)
|
|
|
|
| detal1 |
char(50)
|
utf8_general_ci
|
|
|
| detal2 |
char(50)
|
utf8_general_ci
|
|
|
| detal3 |
char(50)
|
utf8_general_ci
|
|
|
| detal4 |
char(50)
|
utf8_general_ci
|
|
|
| detal5 |
char(50)
|
utf8_general_ci
|
|
|
| direcc |
char(36)
|
utf8_general_ci
|
|
|
| envase |
bit(1)
|
|
|
|
| feccad |
date
|
|
|
|
| fecemi |
date
|
|
|
|
| fecemiret |
date
|
|
|
|
| fecha_con |
date
|
|
|
|
| fecha_emi1 |
date
|
|
|
|
| fecha_emis |
date
|
|
|
|
| fecha_sali |
date
|
|
|
|
| fecha_venc |
date
|
|
|
|
| fecreg |
date
|
|
|
|
| fev_cb |
date
|
|
|
|
| formulario |
decimal(8,0)
|
|
|
|
| guia |
char(8)
|
utf8_general_ci
|
|
|
| ice |
decimal(6,2)
|
|
|
|
| idecretri |
char(2)
|
utf8_general_ci
|
|
|
| idesustri |
char(2)
|
utf8_general_ci
|
|
|
| iva |
decimal(6,2)
|
|
|
|
| marca |
char(2)
|
utf8_general_ci
|
|
|
| modulo |
char(1)
|
utf8_general_ci
|
|
|
| monice |
decimal(12,2)
|
|
|
|
| moniva |
decimal(12,2)
|
|
|
|
| moniva1 |
decimal(12,2)
|
|
|
|
| moniva2 |
decimal(12,2)
|
|
|
|
| monretfue |
decimal(12,2)
|
|
|
|
| monretfue2 |
decimal(12,2)
|
|
|
|
| monretiva1 |
decimal(12,2)
|
|
|
|
| monretiva2 |
decimal(12,2)
|
|
|
|
| nombre |
char(36)
|
utf8_general_ci
|
|
|
| nomcli |
char(36)
|
utf8_general_ci
|
|
|
| numaut |
char(50)
|
utf8_general_ci
|
|
|
| numautcom |
char(49)
|
utf8_general_ci
|
|
|
| numautret |
char(40)
|
utf8_general_ci
|
|
|
| numdoc |
char(13)
|
utf8_general_ci
|
|
|
| numret |
char(8)
|
utf8_general_ci
|
|
|
| numseccom |
char(9)
|
utf8_general_ci
|
|
|
| numsecret |
char(7)
|
utf8_general_ci
|
|
|
| numsercom |
char(8)
|
utf8_general_ci
|
|
|
| numserret |
char(6)
|
utf8_general_ci
|
|
|
| num_cb |
char(8)
|
utf8_general_ci
|
|
|
| observ |
char(50)
|
utf8_general_ci
|
|
|
| orden |
char(8)
|
utf8_general_ci
|
|
|
| parcial |
decimal(14,2)
|
|
|
|
| pendiente |
bit(1)
|
|
|
|
| personal |
bit(1)
|
|
|
|
| porcentaje |
decimal(6,2)
|
|
|
|
| pordoc |
decimal(3,0)
|
|
|
|
| porretren2 |
decimal(6,2)
|
|
|
|
| precio |
decimal(12,5)
|
|
|
|
| pregru |
decimal(12,4)
|
|
|
|
| preuni |
decimal(12,4)
|
|
|
|
| procli |
char(5)
|
utf8_general_ci
|
|
|
| prodoc |
bit(1)
|
|
|
|
| prorel |
decimal(1,0)
|
|
|
|
| proveedor |
char(36)
|
utf8_general_ci
|
|
|
| recibe |
char(36)
|
utf8_general_ci
|
|
|
| referconta |
char(8)
|
utf8_general_ci
|
|
|
| regimpane |
bit(1)
|
|
|
|
| regpro |
decimal(6,0)
|
|
|
|
| reten |
decimal(12,2)
|
|
|
|
| retencion |
decimal(5,2)
|
|
|
|
| secundar |
bit(1)
|
|
|
|
| temporal |
char(20)
|
utf8_general_ci
|
|
|
| tip_cb |
char(2)
|
utf8_general_ci
|
|
|
| totcos |
decimal(14,2)
|
|
|
|
| traderdev |
char(1)
|
utf8_general_ci
|
|
|
| unidad |
char(5)
|
utf8_general_ci
|
|
|
| valdes |
decimal(14,2)
|
|
|
|
| valdoc |
decimal(12,2)
|
|
|
|
| valido |
bit(1)
|
|
|
|
| valoreal |
decimal(12,2)
|
|
|
|
| valor_base |
decimal(12,2)
|
|
|
|
| valor_dola |
decimal(14,2)
|
|
|
|
| vendedor |
char(5)
|
utf8_general_ci
|
|
|
| vende_cons |
char(5)
|
utf8_general_ci
|
|
|
| baseNoGraI |
decimal(12,2)
|
|
|
|
| baseImpExe |
decimal(12,2)
|
|
|
|
| foto |
blob
|
|
|
|
| codweb |
varchar(8)
|
utf8_general_ci
|
|
|
