* 2012

* epapro
#alter table epapro,codpbb,c(4)

* epapro 02/04/2012
#alter table epapro,codlmc,c(2)

* natoper  13/04/2012
#alter table natoper,reserva_epa,l

* cliente  14/04/2012
#alter table cliente,email_nfe,c(40)

* natoper  28/04/2012
#alter table natoper,fiscalpc,l
#alter table natoper,cst_pis,c(2)
#alter table natoper,cst_cofins,c(2)
#alter table natoper,cst_ipi,c(2)


* nfcom nfven
#alter table nfcom,ind_emit,c(1)
#alter table nfven,ind_emit,c(1)

* Observação e extensao do nronf 23/05/2012
#alter table nfcom,obs,m
#alter table nfven,obs,m
#alter table nfcom,nronf3d,c(3)


* Daniel - Nota fiscal referenciada de produtor
#alter table notarnfe,codigo,serial
#alter table notarnfe,nfp_cuf,c(2)
#alter table notarnfe,nfp_aamm,c(4)
#alter table notarnfe,nfp_tpdoc,c(4)
#alter table notarnfe,nfp_cpf,c(14)
#alter table notarnfe,nfp_ie,c(14)
#alter table notarnfe,nfp_modelo,c(2)
#alter table notarnfe,nfp_nronf,c(9)
#alter table notarnfe,nfp_serie,C(3)

* Mapar Resumo  29/06/2012
#alter table cadecfs,nro_serie,C(20)
#alter table ecfmri,datac,d


#alter table nfesta,vin_idkeyemp,C(50)

* Indicador da Natureza do Frete Contratado
#alter table nfcoi,cnatfre,C(1)

* Hora saida nfe
#alter table nfcom,hora,C(5)

* movdoc
#alter table movdoc,obs,m
#alter table movdoc,nrorom,c(9)


* Veiculos
#alter table epapro,tpop,c(1)
#alter table epapro,chassi,c(17)
#alter table epapro,ccor,c(4)
#alter table epapro,xcor,c(40)
#alter table epapro,pot,c(4)
#alter table epapro,cilin,c(4)
#alter table epapro,nserie,c(9)
#alter table epapro,tpcomb,c(2)
#alter table epapro,nmotor,c(21)
#alter table epapro,cmt,c(9)
#alter table epapro,dist,c(4)
#alter table epapro,anomod,c(4)
#alter table epapro,anofab,c(4)
#alter table epapro,tppint,c(1)
#alter table epapro,tpveic,c(2)
#alter table epapro,espveic,c(1)
#alter table epapro,vin,c(1)
#alter table epapro,condveic,c(1)
#alter table epapro,cmod,c(6)
#alter table epapro,ccordenatran,c(2)
#alter table epapro,lota,c(3)
#alter table epapro,tprest,c(1)

#alter table epapro,repres_moto,c(15)
#alter table epapro,localrep_moto,c(20)
#alter table epapro,dt_envio_moto,d
#alter table epapro,situacao_moto,c(15)
#alter table epapro,conces_moto,c(15)


* NFcoi
#alter table nfcoi,desconto,n(10,4)

* notainfe
#alter table notainfe,codanp,c(13)

* nfvei
#alter table nfvei,codrep,c(6)

* nfcom
#alter table nfcom,desp_icm,n(12,2)

* Imposto de importação 
#alter table nfcoi,ii_vbc,n(12,2)
#alter table nfcoi,ii_vdespadu,n(12,2)
#alter table nfcoi,ii_vii,n(12,2)
#alter table nfcoi,ii_viof,n(12,2)
#alter table nfvei,ii_vbc,n(12,2)
#alter table nfvei,ii_vdespadu,n(12,2)
#alter table nfvei,ii_vii,n(12,2)
#alter table nfvei,ii_viof,n(12,2)


#alter table notainfe,ii_vbc,n(12,2)
#alter table notainfe,ii_vdespadu,n(12,2)
#alter table notainfe,ii_vii,n(12,2)
#alter table notainfe,ii_viof,n(12,2)

#alter table nfcom,especie,c(20)
#alter table nfcom,marca,c(20)
#alter table nfcom,peso,n(10,2)
#alter table nfcom,peso_bruto,n(10,2)
#alter table nfcom,num_vol,n(10,2)
#alter table nfcom,placa_uf,c(2)
#alter table nfcom,placa_rntc,c(20)

#alter table nfven,especie,c(20)
#alter table nfven,marca,c(20)
#alter table nfven,peso,n(10,2)
#alter table nfven,peso_bruto,n(10,2)
#alter table nfven,num_vol,n(10,2)
#alter table nfven,placa_uf,c(2)
#alter table nfven,placa_rntc,c(20)

#alter table notanfe,qtde_t,n(10,3)
#alter table notanfe,especie,c(20)
#alter table notanfe,marca,c(20)
#alter table notanfe,peso,n(10,2)
#alter table notanfe,peso_bruto,n(10,2)
#alter table notanfe,num_vol,n(10,2)
#alter table notanfe,placa_uf,c(2)
#alter table notanfe,placa_rntc,c(20)

#alter table genemp,tipoir,c(1)
#alter table nfven,tpdoc,c(2)
#alter table nfcom,tpdoc,c(2)
#alter table nfvei,doc_orig,c(6)
#alter table nfcoi,doc_orig,c(6)


* forpro ( Aumenta para 20, tem fornecedores que usam mais de 13 digitos )
#alter table forpro,codpro_for,c(20)

* Contra nota produtor Rural
#alter table nfcom,nfp_cuf,c(2)
#alter table nfcom,nfp_aamm,c(4)
#alter table nfcom,nfp_tpdoc,c(4)
#alter table nfcom,nfp_cpf,c(14)
#alter table nfcom,nfp_ie,c(14)
#alter table nfcom,nfp_modelo,c(2)
#alter table nfcom,nfp_nronf,c(9)
#alter table nfcom,nfp_serie,C(3)


* genemp
#alter table genemp,iest,c(14)
#alter table genemp,cnae,C(7)

* Cidade
#alter table cidade,nomepais,C(30)

* epapro
#alter table epaprc,desc_max,n(7,2)

* Cliente
#alter table cliente,numero,c(5)
#alter table cliente,complement,c(20)

* Fornec
#alter table fornec,numero,c(5)
#alter table fornec,complement,c(20)

* notainfe
#alter table notainfe,desc_ite,n(10,3)

* epapro
#alter table epapro,res1313,l

* genusu
#alter table genusu,xleft,i
#alter table genusu,xtop,i

* moedas
#alter table moedas,operador,c(1)

* tpmov
#alter table tpmov,custo_medio,l

* efdtab - Codigo de credito
#alter table efdtab,cod_cred,c(4)

* nfven,nfcom - centro de custo
#alter table nfcom,codccu,c(2)
#alter table nfven,codccu,c(2)

* cadufs - persta2 mva de transf
#alter table cadufs,persta2,n(5,2)

* cliente - dias_juro
#alter table cliente,dias_juro,i

* nfvei - qtde_ent
#alter table nfvei,qtde_ent,n(10,4)

* movdoc - movdoci
#alter table movdoc,codnat,c(4)
#alter table movdoci,codmov,c(2)

* represi 
#alter table represi,per_comisap,n(7,2)

* NFe
#alter table nfven,nfe_cstat,c(3)
#alter table nfcom,nfe_cstat,c(3)