PCCUSTO

71 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PCONTAS.CODCOLIGADA FKPCONTAS_PCCUSTOR
PCONTASGER.CODCOLIGADA FKPCONTASGER_PCCUSTOR
PEVENTO.CODCOLIGADA FKPEVENTO_PCCUSTOR
PFENCCC.CODCOLIGADA FKPFENCCC_PCCUSTOR
PFEVENTOSPROG.CODCOLIGADA FKPFEVENTOSPROG_PCCUSTOR
PFHSTPROVABATMESCC.CODCOLIGADA FKPFHSTPROVABATMESCC_PCCUSTOR
PFHSTPROVFORMULAMESCC.CODCOLIGADA FKPFHSTPROVFORMULAMESCC_PCCUSTR
PFHSTPROVMESCC.CODCOLIGADA FKPFHSTPROVMESCC_PCCUSTOR
PFMOVCC.CODCOLIGADA FKPFMOVCC_PCCUSTOR
PFMOVCCCOMPL.CODCOLIGADA FKPFMOVCCCOMPL_PCCUSTOR
PFMOVENSINOIMP.CODCOLIGADA FKPFMOVENSINOIMP_PCCUSTOR
PFRATEIOFIXO.CODCOLIGADA FKPFRATEIOFIXO_PCCUSTOR
PFSALCMP.CODCOLIGADA FKPFSALCMP_PCCUSTOR
PFUNC.CODCOLIGADA FKPFUNC_PCCUSTOR
PORCAMENTORATEIOFIXOITEMS.CODCOLIGADA FKPORCAMENTORATFIXITEMS_PCCUSTR
PPROGRAMACAOAGRARIA.CODCOLIGADA FKPPROGRAMACAOAGRARIA_PCCUSTOR
PSECAO.CODCOLIGADA FKPSECAO_PCCUSTOR
PSIMULADEMISSAO.CODCOLIGADA FKPSIMULADEMISSAO_PCCUSTOR
VPOSICAORATEIOFIXO.CODCOLIGADA FKVPOSICAORATEIOFIXO_PCCUSTOR
VREQAUMENTOQUADRORATEIOCC.CODCOLREQUISICAO FKVREQAUMENTOQUADRORAT_PCCUSTOR
VREQPROMOCAORATEIOCC.CODCOLREQUISICAO FKVREQPROMOCAORATEIOCC_PCCUSTOR
VREQRATEIOCCTEMP.CODCOLREQUISICAO FKVREQRATEIOCCTEMP_PCCUSTOR
VREQSUBSTITUICAORATEIOCC.CODCOLREQUISICAO FKVREQSUBSCAORATEIOCC_PCCUSTOR
VREQTRANSFERENCIARATEIOCC.CODCOLREQUISICAO FKVREQTRANSFERATEIOCC_PCCUSTOR
VREQTRANSFLOTERATEIOCC.CODCOLREQUISICAO FKVREQTRANSFLOTERATEIOCC_PCCUSR
VREQTRANSFPROMOCAORATEIOCC.CODCOLREQUISICAO FKVREQTRANSFPROMORATCC_PCCUSTOR
GCCUSTO.CODCOLIGADA FKPCCUSTO_GCCUSTOR
GDEPTO.CODCOLIGADA FKPCCUSTO_GDEPTOR
PCODINTCONT.CODCOLIGADA FKPCCUSTO_PCODINTCONTR
PCODINTGER.CODCOLIGADA FKPCCUSTO_PCODINTGERR
GCOLIGADA.CODCOLIGADA FKPCCUSTO_GCOLIGADAR
GFILIAL.CODCOLIGADA FKPCCUSTO_GFILIALR
CODCCUSTO varchar 25 null
PCONTAS.CODCCUSTO FKPCONTAS_PCCUSTOR
PCONTASGER.CODCCUSTO FKPCONTASGER_PCCUSTOR
PEVENTO.CCUSTO FKPEVENTO_PCCUSTOR
PFENCCC.CODPCCUSTO FKPFENCCC_PCCUSTOR
PFEVENTOSPROG.CODCCUSTO FKPFEVENTOSPROG_PCCUSTOR
PFHSTPROVABATMESCC.CODCCUSTO FKPFHSTPROVABATMESCC_PCCUSTOR
PFHSTPROVFORMULAMESCC.CODCCUSTO FKPFHSTPROVFORMULAMESCC_PCCUSTR
PFHSTPROVMESCC.CODCCUSTO FKPFHSTPROVMESCC_PCCUSTOR
PFMOVCC.CODCCUSTO FKPFMOVCC_PCCUSTOR
PFMOVCCCOMPL.CODCCUSTO FKPFMOVCCCOMPL_PCCUSTOR
PFMOVENSINOIMP.CODCCUSTO FKPFMOVENSINOIMP_PCCUSTOR
PFRATEIOFIXO.CODCCUSTO FKPFRATEIOFIXO_PCCUSTOR
PFSALCMP.CODCCUSTO FKPFSALCMP_PCCUSTOR
PFUNC.CODCCUSTO FKPFUNC_PCCUSTOR
PORCAMENTORATEIOFIXOITEMS.CODCCUSTO FKPORCAMENTORATFIXITEMS_PCCUSTR
PPROGRAMACAOAGRARIA.CODCCUSTO FKPPROGRAMACAOAGRARIA_PCCUSTOR
PSECAO.NROCENCUSTOCONT FKPSECAO_PCCUSTOR
PSIMULADEMISSAO.CODCCUSTO FKPSIMULADEMISSAO_PCCUSTOR
VPOSICAORATEIOFIXO.CODCCUSTO FKVPOSICAORATEIOFIXO_PCCUSTOR
VREQAUMENTOQUADRORATEIOCC.CODCCUSTO FKVREQAUMENTOQUADRORAT_PCCUSTOR
VREQPROMOCAORATEIOCC.CODCCUSTO FKVREQPROMOCAORATEIOCC_PCCUSTOR
VREQRATEIOCCTEMP.CODCCUSTO FKVREQRATEIOCCTEMP_PCCUSTOR
VREQSUBSTITUICAORATEIOCC.CODCCUSTO FKVREQSUBSCAORATEIOCC_PCCUSTOR
VREQTRANSFERENCIARATEIOCC.CODCCUSTO FKVREQTRANSFERATEIOCC_PCCUSTOR
VREQTRANSFLOTERATEIOCC.CODCCUSTO FKVREQTRANSFLOTERATEIOCC_PCCUSR
VREQTRANSFPROMOCAORATEIOCC.CODCCUSTO FKVREQTRANSFPROMORATCC_PCCUSTOR
CODCCGLOBAL varchar 25 √ null
GCCUSTO.CODCCUSTO FKPCCUSTO_GCCUSTOR
NOME varchar 60 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
CIDADE DCIDADE 32 √ null
ESTADO varchar 2 √ null
GETD.CODETD FKPCCUSTO_GETDR
CEP DCEP 9 √ null
CODIGOINSS varchar 22 √ null
CODIGO varchar 22 √ null
CODTERCINSS varchar 4 √ null
COMPLEMENTO_GUIA varchar 120 √ null
PERC_TERC RMDVALOR2 17,2 √ null
INTEGRCONTABIL varchar 22 √ null
PCODINTCONT.CODCLIENTE FKPCCUSTO_PCODINTCONTR
INTEGRGERENCIAL varchar 22 √ null
PCODINTGER.CODCLIENTE FKPCCUSTO_PCODINTGERR
NUMEROFILIALCONTAB smallint 2 √ null
GDEPTO.CODFILIAL FKPCCUSTO_GDEPTOR
GFILIAL.CODFILIAL FKPCCUSTO_GFILIALR
CONTRIBUISESI_SENAI DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PERC_ACTRAB RMDVALOR2 17,2 √ null
CODDEPTOCONT varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKPCCUSTO_GDEPTOR
ID int identity 4 √ null
ATIVO BOOLEAN 1 √ null
PERMITELANC BOOLEAN 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKPCCUSTO Primary key Asc/Asc CODCOLIGADA + CODCCUSTO
PXCCUSTOID Must be unique Asc ID

Relationships

Close relationships within degrees of separation