FTB4

15 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFODEF.CODCOLIGADA FKFCFODEF_FTB4R
FCXADEF.CODCOLIGADA FKFCXADEF_FTB4R
FLAN.CODCOLIGADA FKFLAN_FTB4R
FLANBAIXA.CODCOLIGADA FKFLANBAIXA_FTB4R
FORCAMENTDETALHE.CODCOLIGADA FKFORCAMENTDETALHE_FTB4R
FTB4CONT.CODCOLIGADA FKFTB4CONT_FTB4R
FTEMPLATEACORDO.CODCOLIGADA FKFTEMPLATEACORDO_FTB4R
FXCX.CODCOLIGADA FKFXCX_FTB4FLXR
PFINANCEIRO.CODCOLIGADA FKPFINANCEIRO_FTB4R
PLANCFINANC.CODCOLIGADA FKPLANCFINANC_FTB4R
SPSCONFIGURACAOPAGAMENTOPROF.CODCOLIGADA FKSPSCONFIGPAGAMENTPROF_FTB4R
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSPROCESSOSELETIVO_FTB4R
SSERVICO.CODCOLIGADA FKSSERVICO_FTB4R
TCNT.CODCOLIGADA FKTCNT_FTB4R
TCNTPAR.CODCOLIGADA FKTCNTPAR_FTB4R
TCPGCNT.CODCOLIGADA FKTCPGCNT_FTB4R
TFITMMOV.CODCOLIGADA FKTFITMMOV_FTB4R
TFMOV.CODCOLIGADA FKTFMOV_FTB4R
TFORMAPAGTO.CODCOLIGADA FKTFORMAPAGTO_FTB4R
TITMCNT.CODCOLIGADA FKTITMCNT_FTB4R
TITMMOV.CODCOLIGADA FKTITMMOV_FTB4R
TITMTMV.CODCOLIGADA FKTITMTMV_FTB4R
TLOT.CODCOLIGADA FKTLOT_FTB4R
TMOV.CODCOLIGADA FKTMOV_FTB4R
TRPR.CODCOLIGADA FKTRPR_FTB4R
TTMV.CODCOLIGADA FKTTMV_FTB4R
XTIPORECEITATABELAOPCIONAL.CODCOLIGADA FKXTPRECTABOPCIONAL_FTB4R
TEVENTOSCONT.CODCOLIGADA FKFTB4_TEVENTOSCONT4R
VBENEFICIOS.CODCOLIGADA FKFTB4_VBENEFICIOSR
GCOLIGADA.CODCOLIGADA FKFTB4_GCOLIGADAR
CODTB4FLX varchar 25 null
FCFODEF.CODTB4FLX FKFCFODEF_FTB4R
FCXADEF.CODTB4FLX FKFCXADEF_FTB4R
FLAN.CODTB4FLX FKFLAN_FTB4R
FLANBAIXA.CODTB4FLX FKFLANBAIXA_FTB4R
FORCAMENTDETALHE.CODTB4FLX FKFORCAMENTDETALHE_FTB4R
FTB4CONT.CODTB4FLX FKFTB4CONT_FTB4R
FTEMPLATEACORDO.CODTB4FLX FKFTEMPLATEACORDO_FTB4R
FXCX.CODTB4FLX FKFXCX_FTB4FLXR
PFINANCEIRO.CODTB4FLX FKPFINANCEIRO_FTB4R
PLANCFINANC.CODTB4FLX FKPLANCFINANC_FTB4R
SPSCONFIGURACAOPAGAMENTOPROF.CODTB4FLX FKSPSCONFIGPAGAMENTPROF_FTB4R
SPSPROCESSOSELETIVO.CODTB4FLX FKSPSPROCESSOSELETIVO_FTB4R
SSERVICO.CODTB4FLX FKSSERVICO_FTB4R
TCNT.CODTB4FLX FKTCNT_FTB4R
TCNTPAR.CODTB4FLX FKTCNTPAR_FTB4R
TCPGCNT.CODTB4FLX FKTCPGCNT_FTB4R
TFITMMOV.CODTB4FLX FKTFITMMOV_FTB4R
TFMOV.CODTB4FLX FKTFMOV_FTB4R
TFORMAPAGTO.CODTB4FLX FKTFORMAPAGTO_FTB4R
TITMCNT.CODTB4FLX FKTITMCNT_FTB4R
TITMMOV.CODTB4FLX FKTITMMOV_FTB4R
TITMTMV.CODTB4FLXIT FKTITMTMV_FTB4R
TLOT.CODTB4FLX FKTLOT_FTB4R
TMOV.CODTB4FLX FKTMOV_FTB4R
TRPR.CODTB4FLX FKTRPR_FTB4R
TTMV.CODTB4FLXMOV FKTTMV_FTB4R
XTIPORECEITATABELAOPCIONAL.CODTB4FLX FKXTPRECTABOPCIONAL_FTB4R
DESCRICAO varchar 40 √ null
CAMPOLIVRE varchar 255 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONTR
CODEVENTOBX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONTBXR
CODEVENTOBXCONT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONT3R
CODEVENTOXCX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSXCXR
PERMITELANC smallint 2 √ (1)
ATIVO smallint 2 √ (1)
CODBENEFICIO varchar 10 √ null
VBENEFICIOS.CODBENEFICIO FKFTB4_VBENEFICIOSR
CODEVENTOCRT smallint 2 √ null
CODEVENTOBXACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONT1R
CODEVENTOGERADOACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONT2R
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
CODEVENTOLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONT4R
CODEVENTOBXACORDOLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONTBXACOLIQDUVR
CODEVENTOBXLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONTBXLIQDUVR
CODEVENTOBXCREDADIANT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB4_TEVENTOSCONTBXCREDADR

Indexes

Constraint Name Type Sort Column(s)
PKFTB4 Primary key Asc/Asc CODCOLIGADA + CODTB4FLX
FXTB4COD Performance Asc CODTB4FLX
FXTB4DESC Performance Asc DESCRICAO

Relationships

Close relationships within degrees of separation