PSECAOPROPOSTA

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PSECAOPROPOSTADEPARA.CODCOLIGADA FKPSECAOPROPOSTADEPAR_PSECPROPR
VHPOSICAO.CODCOLIGADA FKVHPOSICAO_PSECAOPROPOSTAR
PSECAOREESTRUTURACAO.CODCOLIGADA FKPSECAOPROPOSTA_R
CODPROPOSTA varchar 5 null
PSECAOPROPOSTADEPARA.CODPROPOSTA FKPSECAOPROPOSTADEPAR_PSECPROPR
VHPOSICAO.CODPROPOSTA FKVHPOSICAO_PSECAOPROPOSTAR
PSECAOREESTRUTURACAO.CODPROPOSTA FKPSECAOPROPOSTA_R
CODIGO varchar 35 null
PSECAOPROPOSTADEPARA.CODSECAOPROPOSTA FKPSECAOPROPOSTADEPAR_PSECPROPR
VHPOSICAO.CODSECAOPROPOSTA FKVHPOSICAO_PSECAOPROPOSTAR
DESCRICAO varchar 60 √ null
CGC varchar 20 √ null
CGCANTERIOR varchar 20 √ null
CEI varchar 20 √ null
FPAS varchar 3 √ null
SAT varchar 12 √ null
ATIVECONOMICA varchar 7 √ null
INSCRESTADUAL varchar 15 √ null
INSCRMUNICIPAL varchar 15 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
ESTADO varchar 2 √ null
CIDADE DCIDADE 32 √ null
CEP DCEP 9 √ null
PAIS varchar 16 √ null
TELEFONE varchar 15 √ null
CODIGOCEF varchar 14 √ null
NAOEMPREGPROPR smallint 2 √ null
PREFIXORAIS varchar 2 √ null
CATEGORIA varchar 2 √ null
INTEGRCONTABIL varchar 22 √ null
INTEGRGERENCIAL varchar 22 √ null
NROFILIALCONT smallint 2 √ null
NROCENCUSTOCONT varchar 25 √ null
CODTERCEIROSINSS varchar 4 √ null
PERCENTTERCEIROS RMDVALOR2 17,2 √ null
PERCENTACIDTRAB RMDVALOR2 17,2 √ null
FATURAMENTOBRUTO RMDVALOR2 17,2 √ null
VALORFRETE RMDVALOR2 17,2 √ null
COMPLEMENTOGRPS1 varchar 58 √ null
COMPLEMENTOGRPS2 varchar 58 √ null
COMPLEMENTOGRPS3 varchar 58 √ null
CODUNIDENTREGA varchar 6 √ null
CONTATO varchar 20 √ null
RAMAL varchar 4 √ null
VTCODDEPTO varchar 6 √ null
INIPERRECPROPR1 smallint 2 √ null
FIMPERRECPROPR1 smallint 2 √ null
PROPRANTES5DIA1 DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
INIPERRECPROPR2 smallint 2 √ null
FIMPERRECPROPR2 smallint 2 √ null
PROPRANTES5DIA2 DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
INIPERRECCENTR1 smallint 2 √ null
FIMPERRECCENTR1 smallint 2 √ null
CENTRANTES5DIA1 DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
INIPERRECCENTR2 smallint 2 √ null
FIMPERRECCENTR2 smallint 2 √ null
CENTRANTES5DIA2 DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SECAOCENTRALIZ varchar 35 √ null
CONTRIBSESIESENAI DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DISTRIBPETROLEO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PESSOAFISICA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
SECAODESATIVADA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IDENTIFICACAOCGC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ENDERECOALTEROU DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ENDERECOPAGTO varchar 48 √ null
VTIDENTPEDIDO smallint 2 √ null
VTIDENTPERSONAL smallint 2 √ null
VTCODCLIENTE varchar 6 √ null
VTCODLOCAL varchar 10 √ null
VTCODSECFATURAM varchar 35 √ null
VTCODSECPEDIDO varchar 35 √ null
VTCODSECCOBRANCA varchar 35 √ null
VTCODSECENTREGA varchar 35 √ null
VTCODCENTROCUSTO varchar 25 √ null
CAUSAMUDANCACGC smallint 2 √ null
CODMUNICIPIO varchar 7 √ null
MESDATABASE smallint 2 √ null
NATUREZAJURIDICA varchar 4 √ null
CODCALENDARIO varchar 16 √ null
PREFIXOINSCRFGTS varchar 2 √ null
PRIMEIRADECLCAGED smallint 2 √ ((1))
ENCERRAMENTO smallint 2 √ ((2))
CODFILIAL smallint 2 null
CODDEPTO varchar 25 null
LIMITEFUNC int 4 √ ((0))
OPTASIMPLES smallint 2 √ null
MUDOUCNAE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CHAPACHEFE DCHAPANULL 16 √ null
PERCENT15ANOSGRPS smallint 2 √ null
PERCENT20ANOSGRPS smallint 2 √ null
PERCENT25ANOSGRPS smallint 2 √ null
ALTERACAOCAGED smallint 2 √ ((1))
CODPAGTOGPS varchar 5 √ null
PERCISENCAOFILANTROPIA RMDVALOR2 17,2 √ null
PARTICIPAPAT smallint 2 √ ((0))
PORTEEMPRESA smallint 2 √ ((2))
CODDEPTOCONT varchar 25 √ null
DDD varchar 4 √ null
VERBAQUADROVAGAS RMDVALOR2 17,2 √ null
PERCQUADROVAGAS RMDVALOR2 17,2 √ null
ISENTOCONTRIBSOCIAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
VINCPAT5SAL int 4 √ null
VINCPATMAIOR5SAL int 4 √ null
PORCSERVPROP smallint 2 √ null
PORCADMCOZINHA smallint 2 √ null
PORCREFEICAOCONV smallint 2 √ null
PORCREFEICAOTRANSP smallint 2 √ null
PORCCESTAALIMENTO smallint 2 √ null
PORCALIMCONVENIO smallint 2 √ null
DTENCERRATIV DDATETIME 16,3 √ null
CODPLANO varchar 16 √ null
DESCRICAOPPP MEMO 2147483647 √ null
CODTABELA varchar 10 √ null
EMAIL varchar 45 √ null
CNAERAIS varchar 5 √ null
VALORINSSACUMULADO RMDVALOR4 17,4 √ ((0))
VALORENTIDADESACUMULADO RMDVALOR4 17,4 √ ((0))
IDMEMOAMBTRAB int 4 √ null
VISIVELORGANOGRAMA BOOLEAN 1 √ ('T')
LOCALIDADE varchar 40 √ null
CAPITALSOCEMP RMDVALOR2 17,2 √ null
CAPITALSOCESTAB RMDVALOR2 17,2 √ null
CODIGOPAI varchar 35 √ null
BENEFPONTOS int 4 √ null
CODPAGTOGPSTERCEIROS varchar 5 √ null
TPLOTACAO varchar 2 √ null
CNO varchar 20 √ null
CODTIPORUA smallint 2 √ null
CAEPF varchar 20 √ null
TIPOCONTROLEPONTO smallint 2 ((0))
SECAOAUTONOMOS varchar 35 √ null
TIPOTAREFA int 4 √ null
CODSECAOCOPIADADOS varchar 35 √ null
DADOSCOPIADOS smallint 2 √ null
ORIGEMCOPIAPSECAO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TPPROCESSORAT char 1 √ null
NRPROCESSORAT varchar 30 √ null
TPPROCESSOFAP char 1 √ null
NRPROCESSOFAP varchar 30 √ null
TIPOCAEPF smallint 2 √ null
CNAEPREPONDERANTE varchar 7 √ null
CONTAPR numeric 12 √ null
NRPROCJUDAPR varchar 20 √ null
CONTENTEDAPR numeric 12 √ null
CONTPCD numeric 12 √ null
NRPROCJUDPCD varchar 20 √ null
TPPROCJUDAPR varchar 1 √ null
CODSUSPPROCJUDAPR varchar 14 √ null
TPPROCJUDPCD varchar 1 √ null
CODSUSPPROCJUDPCD varchar 14 √ null
CODSUSPPROCJUDRAT varchar 14 √ null
CODSUSPPROCJUDFAP varchar 14 √ null
CODTERCSSUSP varchar 4 √ null
ALIQRATISENTO RMDVALOR2 17,2 √ null
CNAESEFIP varchar 7 √ (NULL)

Indexes

Constraint Name Type Sort Column(s)
PKPSECAOPROPOSTA Primary key Asc/Asc/Asc CODCOLIGADA + CODPROPOSTA + CODIGO

Relationships

Close relationships within degrees of separation