VMIRANDA_01

USE SACP; CREATE TABLE IF NOT EXISTS EMPRESA ( CODIGO CHAR(4), FILIAL CHAR(4), NOME_EMPRESA CHAR(50), NOME_FANTASIA CHAR(20), TPEMPRESA CHAR(1), CNPJ CHAR(18), CPF CHAR(14), CEI CHAR(10), INCRA CHAR(10), INSC_ESTADUAL CHAR(12), INSC_MUNICIPAL CHAR(12), DATA_ABERTURA DATE, ATIVO CHAR(1), CNPJ_LICENCIADO CHAR(1), COD_ATIV_ECON_PRINC CHAR(10), COD_ATIV_ECON_SECUN CHAR(10), COD_NATUREZA_JURID CHAR(4), DIGNATJURID CHAR(2), ENDERECO_COB CHAR(40), NUM_END_COB CHAR(5), COMPL_END_COB CHAR(30), CIDADE_COB CHAR(30), ESTADO_COB CHAR(2), CEP_COB CHAR(9), CODMUN_COB CHAR(10), ENDERECO_ENT CHAR(40), NUM_END_ENT CHAR(5), COMPL_END_ENT CHAR(30), CIDADE_ENT CHAR(30), ESTADO_ENT CHAR(2), CEP_ENT CHAR(9), CODMUN_ENT CHAR(10), ENDERECO_FAT CHAR(40), NUM_END_FAT CHAR(5), COMPL_END_FAT CHAR(30), CIDADE_FAT CHAR(30), ESTADO_FAT CHAR(2), CEP_FAT CHAR(9), CODMUN_FAT CHAR(10), DDD_FONE_EMP CHAR(2), FONE_EMP CHAR(10), RESPONS_EMP CHAR(40), CPF_RESP_EMP CHAR(14), DDD_RESP_EMP CHAR(2), CEL_RESP_EMP CHAR(10), RESP_RH_EMP CHAR(40), DDD_RH_EMP CHAR(2), FONE_RH_EMP CHAR(9), DDD_CEL_RH_EMP CHAR(2), CEL_RH_EMP CHAR(10), PRODUTOR_RURAL CHAR(20), NATUREZA_JURIDICA CHAR(5), CNAE CHAR(5), FPAS CHAR(5), COD_ACID_TRAB CHAR(10), CAUSA_RAIS CHAR(2), DIA_PAGTO_FOL CHAR(2), TIPO_ESTAB CHAR(1), COD_ATIVIDADE CHAR(5), ATIV_ECONOMICA CHAR(50), INSC_SUFRAMA CHAR(12), NUMERO_NIRE CHAR(25), DATA_NIRE DATE, NUM_RNTRC CHAR(12), VALID_RNTRC DATE, USUARIO CHAR(50), MATRIC_USUAR CHAR(6), DT_CAD_USU DATE, HS_CAD_USU TIME, PRIMARY KEY (CODIGO,FILIAL) );