* 2013

* NFESTA
#alter table nfesta,eml_smtp,c(80)
#alter table nfesta,eml_email,c(80)
#alter table nfesta,eml_login,c(30)
#alter table nfesta,eml_senha,c(30)
#alter table nfesta,eml_porta,c(10)
#alter table nfesta,eml_ssl,l
#alter table nfesta,vin_proxy_end,c(80)
#alter table nfesta,vin_proxy_usuario,c(30)
#alter table nfesta,vin_proxy_senha,c(30)
#alter table nfesta,vin_proxy_autentic,l
#alter table nfesta,id,serial
#alter table nfesta,local,c(30)
#alter table nfesta,dir_receb,c(100)

* NFVEN  19/03/2013 
#alter table nfven,valor_cli,n(10,2)
#alter table nfven,troco,n(10,2)
#alter table nfven,trocosol,n(7,2)

* 17/04/2013
#alter table nfven,cgc_tmp,c(14)

* NFVEI / NFCOI 04/06/2013
#alter table nfvei,preco_vrj,n(10,4)
#alter table nfcoi,preco_vrj,n(10,4)

* GENEMP 05/06/2013
#alter table genemp,sagestru,c(20)

* nfcom  10/06/2013
#alter table nfcom,seguro,n(10,2)

* epapro  10/06/2013
#alter table epapro,per_741,n(7,2)

* CST_ICMS
#alter table epapro,cst_icms,c(4)
#alter table natoper,cst_icms,c(4)
#alter table nfvei,cst_icms,c(4)
#alter table nfcoi,cst_icms,c(4)

* Manifestação destinatário
#alter table nfesta,manifest,l

* Enviar e-mail
#alter table gencfg,porta,c(6)
#alter table gencfg,ssl,l

* Epadep
#alter table epadep,qtde_reserva,n(10,3)

*pedven
#alter table pedven,placa_uf,c(2)
#alter table pedven,cons_prop,l

*NFCOI
#alter table nfcoi,custo_adi,n(10,4)
#alter table nfcoi,preco_dig,n(10,4)

*NFCOM*NFVEN CODSIT Código da situação do documento fiscal,conforme a Tabela 4.1.2
#alter table nfcom,codsit,c(2)
#alter table nfven,codsit,c(2)

#alter table nfcoi,tipocrepc,c(3)
#alter table nfcoi,obs,c(50)

*nfctp e nfass 13/11/2013 flavio
#alter table nfctp,codccu,c(2)
#alter table nfass,codccu,c(2)

*movass e movctp 23/11/2013 flavio
#alter table movass,codccu,c(2)
#alter table movctp,codccu,c(2)

* nfesta
#alter table nfesta,contig_d,d
#alter table nfesta,contig_h,c(5)
#alter table nfesta,contig_mot,c(100)
#alter table nfesta,contig_tp,c(1)
#alter table nfesta,contig_auto,l

* Fatsta
#alter table fatsta,dias_motivo,n(4)

* Sujeito
#alter table sujeito,fax,c(15)
#alter table sujeito,celular,c(15)

*Finalidade da NFe
#alter table nfven,finnfe,c(1)
#alter table nfcom,finnfe,c(1)

* nfesta
#alter table nfesta,vin_dirautorizad,c(100)

* Valor aproximado dos tributos
#alter table nfvei,vaprox_tri,n(10,2)
#alter table nfcoi,vaprox_tri,n(10,2)


* ---- expotabil ----
* Cliente, Fornec, Nfass, Movass, Nfctp, MovCtp, Tpfin, Natoper, Ctrsta, Ctpsta - expotabil
#alter table cliente,codcta_e,c(13)
#alter table cliente,codctave_e,c(13)

#alter table fornec,codcta_e,c(13)
#alter table fornec,codctaco_e,c(13)

#alter table nfass,codcta_deb_e, c(13)
#alter table nfass,codcta_cre_e, c(13)

#alter table movass,codcta_deb_e,c(13)
#alter table movass,codcta_cre_e,c(13)
#alter table movass,ctadeb_jur_e,c(13)
#alter table movass,ctacre_jur_e,c(13)
#alter table movass,ctadeb_des_e,c(13)
#alter table movass,ctacre_des_e,c(13)

#alter table nfctp,codcta_deb_e, c(13)
#alter table nfctp,codcta_cre_e, c(13)

#alter table movctp,codcta_deb_e,c(13)
#alter table movctp,codcta_cre_e,c(13)
#alter table movctp,ctadeb_jur_e,c(13)
#alter table movctp,ctacre_jur_e,c(13)
#alter table movctp,ctadeb_des_e,c(13)
#alter table movctp,ctacre_des_e,c(13)

#alter table tpfin,codcta_cre_e,c(13)
#alter table tpfin,codcta_deb_e,c(13)
#alter table tpfin,ctacre_des_e,c(13)
#alter table tpfin,ctadeb_des_e,c(13)
#alter table tpfin,ctadeb_jur_e,c(13)
#alter table tpfin,ctacre_jur_e,c(13)

#alter table natoper,codcta_cre_e,c(13)
#alter table natoper,codcta_deb_e,c(13)
#alter table natoper,coddeb_icm_e,c(13)
#alter table natoper,codcre_icm_e,c(13)
#alter table natoper,coddeb_ipi_e,c(13)
#alter table natoper,codcre_ipi_e,c(13)
#alter table natoper,coddeb_001_e,c(13)
#alter table natoper,codcre_001_e,c(13)
#alter table natoper,variav_001_e,c(13)
#alter table natoper,histor_001_e,c(30)
#alter table natoper,coddeb_002_e,c(13)
#alter table natoper,codcre_002_e,c(13)
#alter table natoper,variav_002_e,c(13)
#alter table natoper,histor_002_e,c(30)
#alter table natoper,codexterno,c(13)

#alter table ctrsta,integracao,c(20)
#alter table ctpsta,integracao,c(20)

* Pedvei, codprc
#alter table pedvei,codprc,c(1)

* nfesta
#alter table nfesta,vin_finalid,n(1,0)

* caxacm
#alter table caxacm,valor_reg_inf,n(12,2)
#alter table caxacm,valor_apu_inf,n(12,2)
#alter table caxacm,valor_anu_inf,n(12,2)
#alter table caxacm,sobra,n(10,2)
#alter table caxacm,falta,n(10,2)

* NFe
#alter table nfven,tpemis,c(1)
#alter table nfcom,tpemis,c(1)

* Carmov
#alter table carmov,codnat,c(4)

* Inscrição Municipal ( Cliente e Fornecedor ) - NFe conjugada.
#alter table cliente,insc_mun,c(20)
#alter table fornec,insc_mun,c(20)

* Nota fiscal eletronica conjugada ( ISSQN )
#alter table epapro,isn_cods,c(5)
#alter table epapro,isn_indexi,c(1)
#alter table epapro,isn_exinp,c(30)
#alter table epapro,isn_indinc,c(1)

#alter table nfven,nfe_chave,c(44)
#alter table nfven,nfe_data_receb,d
#alter table nfven,nfe_protocolo,c(30)

#alter table nfcom,nfe_chave,c(44)
#alter table nfcom,nfe_data_receb,d
#alter table nfcom,nfe_protocolo,c(30)
#alter table nfcom,codtxt,c(2)



#alter table nfcoi,indtot,l
#alter table nfvei,indtot,l

#alter table nfcoi,icm_sub,n(10,3)
#alter table nfvei,icm_sub,n(10,3)

#alter table epapro,vlrunipi,n(7,3)
#alter table nfvei,vlrunipi,n(7,3)
#alter table nfcoi,vlrunipi,n(7,3)

* NFe 3 Geração Daniel
#alter table nfesta,indsinc,l
#alter table nfesta,indzip,l
#alter table nfcesta,indsinc,l
#alter table nfcesta,indzip,l

* EFDTAB
#alter table efdtab,codigo,c(10)
#alter table efdtab,nome,c(255)
#alter table efdtab,tabela,c(6)

* LMCPRO
#alter table lmcpro,codpro_bo7,c(13)
#alter table lmcpro,codpro_bo8,c(13)
#alter table lmcpro,codpro_bo9,c(13)
#alter table lmcpro,codpro_bo10,c(13)

* LMCMOV
#alter table lmcmov,cod_s_b7,c(13)
#alter table lmcmov,cod_s_b8,c(13)
#alter table lmcmov,cod_s_b9,c(13)
#alter table lmcmov,cod_s_b10,c(13)

#alter table lmcmov,cont_f7,n(12,3)
#alter table lmcmov,cont_f8,n(12,3)
#alter table lmcmov,cont_f9,n(12,3)
#alter table lmcmov,cont_f10,n(12,3)

#alter table lmcmov,cont_i7,n(12,3)
#alter table lmcmov,cont_i8,n(12,3)
#alter table lmcmov,cont_i9,n(12,3)
#alter table lmcmov,cont_i10,n(12,3)

#alter table lmcmov,qtde_af7,n(10,3)
#alter table lmcmov,qtde_af8,n(10,3)
#alter table lmcmov,qtde_af9,n(10,3)
#alter table lmcmov,qtde_af10,n(10,3)

#alter table lmcmov,qtde_s_b7,n(10,3)
#alter table lmcmov,qtde_s_b8,n(10,3)
#alter table lmcmov,qtde_s_b9,n(10,3)
#alter table lmcmov,qtde_s_b10,n(10,3)

*gensta
#alter table gensta,versao_sage,c(10)

*nfvei
#alter table nfvei,qtde_res,n(10,4)

*transp
#alter table transp,nfeaut,c(1)


*nfesta
#alter table nfesta,nfeaut_contador,c(1)

*pednci e pedvei
#alter table pednci,cst_icms,c(4)
#alter table pedvei,cst_icms,c(4)
#alter table pedvei,indtot,l
#alter table pednci,indtot,l

* epapronat
#alter table epapronat,codnatinpf,c(4)
#alter table epapronat,codnatexpf,c(4)


* Epapro MODELO FISCAL
#alter table epapro,modelo,l
#alter table epapro,codpromod,c(13)

*pedvei
#alter table pedvei,icm_sub,n(10,3)

*placta
#alter table placta,sint_ana,c(1)

*Plapop
#alter table plapop,lookple1,c(2)
#alter table plapop,lookple2,c(2)
#alter table plapop,lookple3,c(2)
#alter table plapop,lookple4,c(2)
#alter table plapop,codcta5,c(13)
#alter table plapop,codcta6,c(13)
#alter table plapop,lookcta5,c(2)
#alter table plapop,lookcta6,c(2)
#alter table plapop,cmd12,m
#alter table plapop,cmd34,m
#alter table plapop,cmd56,m

*Gensta
#alter table gensta,ip_genesysbanco,c(15)

*empmoi
#alter table empmoi,nroemm_ret,c(6)

*nfcom
#alter table nfcom,nfp_cuf,c(2)
#alter table nfcom,nfp_aamm,c(4)
#alter table nfcom,nfp_tpdoc,c(2)
#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_mod,c(2)
#alter table nfcom,nfp_serie,c(3)
#alter table nfcom,nfp_nronf,c(6)
#alter table nfcom,nfp_nnf,c(6)

*nfven
#alter table nfven,nfp_cuf,c(2)
#alter table nfven,nfp_aamm,c(4)
#alter table nfven,nfp_tpdoc,c(2)
#alter table nfven,nfp_cpf,c(14)
#alter table nfven,nfp_ie,c(14)
#alter table nfven,nfp_modelo,c(2)
#alter table nfven,nfp_mod,c(2)
#alter table nfven,nfp_serie,c(3)
#alter table nfven,nfp_nronf,c(6)
#alter table nfven,nfp_nnf,c(6)

#alter table epaprc,preco_vrj,n(10,4)

#alter table cidade,codpaisibge,c(5)

#alter table cliente,regimecrt,c(1)
#alter table fornec,regimecrt,c(1)

* B2B Informação de interesse do emissor para controle do B2B. (v2.0)
#alter table nfvei,b2b_xped,c(15)
#alter table nfvei,b2b_nite,c(6)
#alter table nfcoi,b2b_xped,c(15)
#alter table nfcoi,b2b_nite,c(6)

#alter table epapro,codproimg,c(13)

#alter table gensta,contador_gencli,i

#alter table epapro,emp_uso,c(20)

#alter table pedven,peso_bru,n(10,2)
#alter table pedven,peso_liq,n(10,2)

#alter table nfven,ufembarq,c(2)
#alter table nfven,xlocembarq,c(60)
#alter table nfven,xlocdespacho,c(60)

#alter table nfcom,ufembarq,c(2)
#alter table nfcom,xlocembarq,c(60)
#alter table nfcom,xlocdespacho,c(60)

#alter table cliente,dias_juro,i
#alter table epafal,obs_memo,m
#alter table epapro,codgia,c(3)
#alter table fatsta,integracao,c(20)



*Importação/Exportação - Nome completo do produto
#alter table nfvei,nome,c(150)
#alter table nfcoi,nome,c(150)

*Serie Consignado
#alter table empmov,serie,c(3)
#alter table empmoi,serie,c(3)

*Cor padrao no genarq
#alter table genarq,cor,i

*Criação de tabelas nfexport
#create table nfexport(id serial PRIMARY KEY,codpro char(13),ndraw char(20),nre char(20),qexport numeric(12,4),id_ori integer,emp_cod char(2),alias_ori char(3),chnfe char(44),chave_ori integer) WITHOUT OIDS

* dados de importação
#create table nfcoidi(id serial PRIMARY KEY) WITHOUT OIDS
#alter table nfcoidi,chave,i
#alter table nfcoidi,codpro,c(13)
#alter table nfcoidi,ndi,c(10)
#alter table nfcoidi,ddi,d
#alter table nfcoidi,xlocdesemb,c(60)
#alter table nfcoidi,ufdesemb,c(2)
#alter table nfcoidi,ddesemb,d
#alter table nfcoidi,cexportador,c(60)
#alter table nfcoidi,emp_cod,c(2)
#alter table nfcoidi,chave_nco,i
#alter table nfcoidi,nronf,c(6)
#alter table nfcoidi,serie,c(3)
#alter table nfcoidi,tpviatransp,c(2)
#alter table nfcoidi,vafrmm,n(13,2)
#alter table nfcoidi,tpintermedio,c(1)
#alter table nfcoidi,cnpj,c(14)
#alter table nfcoidi,ufterceiro,c(2)

#create table nfcoiadi(id serial PRIMARY KEY) WITHOUT OIDS
#alter table nfcoiadi,chave,i
#alter table nfcoiadi,nadicao,c(10)
#alter table nfcoiadi,nseqadic,i
#alter table nfcoiadi,cfabricante,c(60)
#alter table nfcoiadi,vdescdi,n(15,2)
#alter table nfcoiadi,emp_cod,c(2)
#alter table nfcoiadi,chave_nco,i
#alter table nfcoiadi,nronf,c(6)
#alter table nfcoiadi,serie,c(3)
#alter table nfcoiadi,ndraw,c(12)


*Criação de tabelas nferef
#create table nferef(id serial PRIMARY KEY) WITHOUT OIDS
#alter table nferef,refnfe,c(44)
#alter table nferef,alias_ori,c(3)
#alter table nferef,chave_ori,i
#alter table nferef,emp_cod,c(2)
#alter table nferef,tpdoc,c(2)
#alter table nferef,tpnf,c(2)
#alter table nferef,necf,c(3)
#alter table nferef,ncoo,c(6)
#alter table nferef,nfp_cuf,c(2)
#alter table nferef,nfp_aamm,c(4)
#alter table nferef,nfp_cgc,c(14)
#alter table nferef,nfp_ie,c(14)
#alter table nferef,nfp_mod,c(2)
#alter table nferef,nfp_serie,c(3)
#alter table nferef,nfp_nnf,c(6)


*Cheques
#alter table cheques,codpop,c(4)
#alter table chequese,codpop,c(4)

*Recibo
#alter table recibo,juros,n(10,2)
#alter table recibo,desconto,n(10,2)