*EMPMOV #alter table empmov,nronf,c(6) #alter table empmov,serie,c(3) *EMPMOI #alter table empmoi,qtde_ven,n(10,3) #alter table empmoi,saldo,n(10,3) #alter table empmoi,ret_tmp,n(10,3) #alter table empmoi,ja_mov,l *NFVEN #alter table nfven,nroemm,c(6) * Nfcoi #alter table nfcoi,per_bc_pc,n(5,2) * Natoper #alter table natoper,codnati,c(4) * Fissta #alter table fissta,piscof_ise,c(50) * Nfcoi #alter table nfcoi,b_pis_tri,n(12,3) #alter table nfcoi,b_cof_tri,n(12,3) * Nfvei #alter table nfvei,b_pis_tri,n(12,3) #alter table nfvei,b_cof_tri,n(12,3) * Gensta #alter table gensta,ip_genesys,c(15) * Genemp #alter table genemp,suframa,c(12) * Cadecfs #alter table cadecfs,tty,c(2) * nfcoi daniel 29/09/2011 #alter table nfcoi,codcrepc,c(2) * genacs #alter table genacs,scriptok,m * forpro #alter table forpro,codpro_sag,c(13) #alter table forpro,codpro_for,c(13) *nfven, caxmov, carmov 15/10/2011 #drop view public.venda01 #alter table nfven,nro_car,c(20) #alter table carmov,nro_car,c(20) #alter table caxmov,nro_car,c(20) *caxacm #alter table caxacm,tty,c(2) #alter table caxacm,ctm_nome,c(15) #alter table caxacm,ctm_operador,c(1) #alter table caxacm,ctm_gera_nve,n(1) #alter table caxacm,chave_u,c(23) *nfven #alter table nfven,codecf,c(2) *editfmo #alter table editfmo,qtde_atu,n(10,3) #alter table editfmo,id,serial *nfcoi e nfvei #alter table nfcoi,b_pis_ise,n(10,2) #alter table nfcoi,b_cof_ise,n(10,2) #alter table nfvei,b_pis_ise,n(10,2) #alter table nfvei,b_cof_ise,n(10,2) * editfmo #alter table editfmo,arquivo,c(15) * nfvei #alter table nfvei,desconto,n(10,3) #alter table nfvei,acrescimo,n(10,3) * epapro #alter table epapro,cod_gen_efd,c(2) #alter table epapro,codnat,c(4) #alter table epapro,codanp,c(13) #alter table epapro,codexterno,c(13) #alter table epapro,tipo_item_efd,c(2) #alter table epapro,cst_icms,c(3) #alter table epapro,cst_ipi,c(2) #alter table epapro,cst_ipic,c(2) #alter table epapro,cst_pis,c(2) #alter table epapro,cst_pisc,c(2) #alter table epapro,cst_cofins,c(2) #alter table epapro,cst_cofinsc,c(2) *nfvei #alter table nfvei,per_pis,n(5,2) #alter table nfvei,per_cofins,n(5,2) * nfcoi #alter table nfcoi,per_pis,n(5,2) #alter table nfcoi,per_cofins,n(5,2) *nfvei #alter table nfvei,vlr_pis,n(12,3) #alter table nfvei,vlr_cofins,n(12,3) *nfcoi #alter table nfcoi,vlr_pis,n(12,3) #alter table nfcoi,vlr_cofins,n(12,3) * nfvei #alter table nfvei,cst_icms,c(3) #alter table nfvei,cst_ipi,c(2) #alter table nfvei,cst_pis,c(2) #alter table nfvei,cst_cofins,c(2) * nfcoi #alter table nfcoi,cst_icms,c(3) #alter table nfcoi,cst_ipi,c(2) #alter table nfcoi,cst_pis,c(2) #alter table nfcoi,cst_cofins,c(2) * ecfmri #alter table ecfmri,cont_cro,n(6) * cadecfs #alter table cadecfs,codemp,c(2) * fatsta #alter table fatsta,modnotcli,m * cadecfs #alter table cadecfs,nro_serie,c(20) *epapro #alter table epapro,nat_rec_pis,c(3) #alter table epapro,nat_rec_cof,c(3) * cidade #alter table cidade,codpaisibge,c(5)