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)
);
