FTB5

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFODEF.CODCOLIGADA FKFCFODEF_FTB5R
FCXADEF.CODCOLIGADA FKFCXADEF_FTB5R
FLAN.CODCOLIGADA FKFLAN_FTB5R
FLANBAIXA.CODCOLIGADA FKFLANBAIXA_FTB5R
FORCAMENTDETALHE.CODCOLIGADA FKFORCAMENTDETALHE_FTB5R
FTB5CONT.CODCOLIGADA FKFTB5CONT_FTB5R
FTEMPLATEACORDO.CODCOLIGADA FKFTEMPLATEACORDO_FTB5R
FXCX.CODCOLIGADA FKFXCX_FTB5FLXR
PFINANCEIRO.CODCOLIGADA FKPFINANCEIRO_FTB5R
PLANCFINANC.CODCOLIGADA FKPLANCFINANC_FTB5R
SPSCONFIGURACAOPAGAMENTOPROF.CODCOLIGADA FKSPSCONFIGPAGAMENTPROF_FTB5R
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSPROCESSOSELETIVO_FTB5R
SSERVICO.CODCOLIGADA FKSSERVICO_FTB5R
TCNT.CODCOLIGADA FKTCNT_FTB5R
TCNTPAR.CODCOLIGADA FKTCNTPAR_FTB5R
TCPGCNT.CODCOLIGADA FKTCPGCNT_FTB5R
TFITMMOV.CODCOLIGADA FKTFITMMOV_FTB5R
TFMOV.CODCOLIGADA FKTFMOV_FTB5R
TFORMAPAGTO.CODCOLIGADA FKTFORMAPAGTO_FTB5R
TITMCNT.CODCOLIGADA FKTITMCNT_FTB5R
TITMMOV.CODCOLIGADA FKTITMMOV_FTB5R
TITMTMV.CODCOLIGADA FKTITMTMV_FTB5R
TLOT.CODCOLIGADA FKTLOT_FTB5R
TMOV.CODCOLIGADA FKTMOV_FTB5R
TRPR.CODCOLIGADA FKTRPR_FTB5R
TTMV.CODCOLIGADA FKTTMV_FTB5R
XTIPORECEITATABELAOPCIONAL.CODCOLIGADA FKXTPRECTABOPCIONAL_FTB5R
TEVENTOSCONT.CODCOLIGADA FKFTB5_TEVENTOSCONT4R
VBENEFICIOS.CODCOLIGADA FKFTB5_VBENEFICIOSR
GCOLIGADA.CODCOLIGADA FKFTB5_GCOLIGADAR
CODTB5FLX varchar 25 null
FCFODEF.CODTB5FLX FKFCFODEF_FTB5R
FCXADEF.CODTB5FLX FKFCXADEF_FTB5R
FLAN.CODTB5FLX FKFLAN_FTB5R
FLANBAIXA.CODTB5FLX FKFLANBAIXA_FTB5R
FORCAMENTDETALHE.CODTB5FLX FKFORCAMENTDETALHE_FTB5R
FTB5CONT.CODTB5FLX FKFTB5CONT_FTB5R
FTEMPLATEACORDO.CODTB5FLX FKFTEMPLATEACORDO_FTB5R
FXCX.CODTB5FLX FKFXCX_FTB5FLXR
PFINANCEIRO.CODTB5FLX FKPFINANCEIRO_FTB5R
PLANCFINANC.CODTB5FLX FKPLANCFINANC_FTB5R
SPSCONFIGURACAOPAGAMENTOPROF.CODTB5FLX FKSPSCONFIGPAGAMENTPROF_FTB5R
SPSPROCESSOSELETIVO.CODTB5FLX FKSPSPROCESSOSELETIVO_FTB5R
SSERVICO.CODTB5FLX FKSSERVICO_FTB5R
TCNT.CODTB5FLX FKTCNT_FTB5R
TCNTPAR.CODTB5FLX FKTCNTPAR_FTB5R
TCPGCNT.CODTB5FLX FKTCPGCNT_FTB5R
TFITMMOV.CODTB5FLX FKTFITMMOV_FTB5R
TFMOV.CODTB5FLX FKTFMOV_FTB5R
TFORMAPAGTO.CODTB5FLX FKTFORMAPAGTO_FTB5R
TITMCNT.CODTB5FLX FKTITMCNT_FTB5R
TITMMOV.CODTB5FLX FKTITMMOV_FTB5R
TITMTMV.CODTB5FLXIT FKTITMTMV_FTB5R
TLOT.CODTB5FLX FKTLOT_FTB5R
TMOV.CODTB5FLX FKTMOV_FTB5R
TRPR.CODTB5FLX FKTRPR_FTB5R
TTMV.CODTB5FLXMOV FKTTMV_FTB5R
XTIPORECEITATABELAOPCIONAL.CODTB5FLX FKXTPRECTABOPCIONAL_FTB5R
DESCRICAO varchar 40 √ null
CAMPOLIVRE varchar 255 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONTR
CODEVENTOBX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONTBXR
CODEVENTOBXCONT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONT3R
CODEVENTOXCX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSXCXR
PERMITELANC smallint 2 √ (1)
ATIVO smallint 2 √ (1)
CODBENEFICIO varchar 10 √ null
VBENEFICIOS.CODBENEFICIO FKFTB5_VBENEFICIOSR
CODEVENTOCRT smallint 2 √ null
CODEVENTOBXACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONT1R
CODEVENTOGERADOACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_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 FKFTB5_TEVENTOSCONT4R
CODEVENTOBXACORDOLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONTBXACOLIQDUVR
CODEVENTOBXLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONTBXLIQDUVR
CODEVENTOBXCREDADIANT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB5_TEVENTOSCONTBXCREDADR

Indexes

Constraint Name Type Sort Column(s)
PKFTB5 Primary key Asc/Asc CODCOLIGADA + CODTB5FLX
FXTB5COD Performance Asc CODTB5FLX
FXTB5DESC Performance Asc DESCRICAO

Relationships

Close relationships within degrees of separation