FTB3

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFODEF.CODCOLIGADA FKFCFODEF_FTB3R
FCXADEF.CODCOLIGADA FKFCXADEF_FTB3R
FLAN.CODCOLIGADA FKFLAN_FTB3R
FLANBAIXA.CODCOLIGADA FKFLANBAIXA_FTB3R
FORCAMENTDETALHE.CODCOLIGADA FKFORCAMENTDETALHE_FTB3R
FTB3CONT.CODCOLIGADA FKFTB3CONT_FTB3R
FTEMPLATEACORDO.CODCOLIGADA FKFTEMPLATEACORDO_FTB3R
FXCX.CODCOLIGADA FKFXCX_FTB3FLXR
PFINANCEIRO.CODCOLIGADA FKPFINANCEIRO_FTB3R
PLANCFINANC.CODCOLIGADA FKPLANCFINANC_FTB3R
SPSCONFIGURACAOPAGAMENTOPROF.CODCOLIGADA FKSPSCONFIGPAGAMENTPROF_FTB3R
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSPROCESSOSELETIVO_FTB3R
SSERVICO.CODCOLIGADA FKSSERVICO_FTB3R
TCNT.CODCOLIGADA FKTCNT_FTB3R
TCNTPAR.CODCOLIGADA FKTCNTPAR_FTB3R
TCPGCNT.CODCOLIGADA FKTCPGCNT_FTB3R
TFITMMOV.CODCOLIGADA FKTFITMMOV_FTB3R
TFMOV.CODCOLIGADA FKTFMOV_FTB3R
TFORMAPAGTO.CODCOLIGADA FKTFORMAPAGTO_FTB3R
TITMCNT.CODCOLIGADA FKTITMCNT_FTB3R
TITMMOV.CODCOLIGADA FKTITMMOV_FTB3R
TITMTMV.CODCOLIGADA FKTITMTMV_FTB3R
TLOT.CODCOLIGADA FKTLOT_FTB3R
TMOV.CODCOLIGADA FKTMOV_FTB3R
TRPR.CODCOLIGADA FKTRPR_FTB3R
TTMV.CODCOLIGADA FKTTMV_FTB3R
XTIPORECEITATABELAOPCIONAL.CODCOLIGADA FKXTPRECTABOPCIONAL_FTB3R
TEVENTOSCONT.CODCOLIGADA FKFTB3_TEVENTOSCONTBXACOLIQDUVR
VBENEFICIOS.CODCOLIGADA FKFTB3_VBENEFICIOSR
GCOLIGADA.CODCOLIGADA FKFTB3_GCOLIGADAR
CODTB3FLX varchar 25 null
FCFODEF.CODTB3FLX FKFCFODEF_FTB3R
FCXADEF.CODTB3FLX FKFCXADEF_FTB3R
FLAN.CODTB3FLX FKFLAN_FTB3R
FLANBAIXA.CODTB3FLX FKFLANBAIXA_FTB3R
FORCAMENTDETALHE.CODTB3FLX FKFORCAMENTDETALHE_FTB3R
FTB3CONT.CODTB3FLX FKFTB3CONT_FTB3R
FTEMPLATEACORDO.CODTB3FLX FKFTEMPLATEACORDO_FTB3R
FXCX.CODTB3FLX FKFXCX_FTB3FLXR
PFINANCEIRO.CODTB3FLX FKPFINANCEIRO_FTB3R
PLANCFINANC.CODTB3FLX FKPLANCFINANC_FTB3R
SPSCONFIGURACAOPAGAMENTOPROF.CODTB3FLX FKSPSCONFIGPAGAMENTPROF_FTB3R
SPSPROCESSOSELETIVO.CODTB3FLX FKSPSPROCESSOSELETIVO_FTB3R
SSERVICO.CODTB3FLX FKSSERVICO_FTB3R
TCNT.CODTB3FLX FKTCNT_FTB3R
TCNTPAR.CODTB3FLX FKTCNTPAR_FTB3R
TCPGCNT.CODTB3FLX FKTCPGCNT_FTB3R
TFITMMOV.CODTB3FLX FKTFITMMOV_FTB3R
TFMOV.CODTB3FLX FKTFMOV_FTB3R
TFORMAPAGTO.CODTB3FLX FKTFORMAPAGTO_FTB3R
TITMCNT.CODTB3FLX FKTITMCNT_FTB3R
TITMMOV.CODTB3FLX FKTITMMOV_FTB3R
TITMTMV.CODTB3FLXIT FKTITMTMV_FTB3R
TLOT.CODTB3FLX FKTLOT_FTB3R
TMOV.CODTB3FLX FKTMOV_FTB3R
TRPR.CODTB3FLX FKTRPR_FTB3R
TTMV.CODTB3FLXMOV FKTTMV_FTB3R
XTIPORECEITATABELAOPCIONAL.CODTB3FLX FKXTPRECTABOPCIONAL_FTB3R
DESCRICAO varchar 40 √ null
CAMPOLIVRE varchar 255 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONTR
CODEVENTOBX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONTBXR
CODEVENTOBXCONT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONT3R
CODEVENTOXCX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSXCXR
PERMITELANC smallint 2 √ (1)
ATIVO smallint 2 √ (1)
CODBENEFICIO varchar 10 √ null
VBENEFICIOS.CODBENEFICIO FKFTB3_VBENEFICIOSR
CODEVENTOCRT smallint 2 √ null
CODEVENTOBXACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONT1R
CODEVENTOGERADOACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_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 FKFTB3_TEVENTOSCONT4R
CODEVENTOBXACORDOLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONTBXACOLIQDUVR
CODEVENTOBXLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONTBXLIQDUVR
CODEVENTOBXCREDADIANT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB3_TEVENTOSCONTBXCREDADR

Indexes

Constraint Name Type Sort Column(s)
PKFTB3 Primary key Asc/Asc CODCOLIGADA + CODTB3FLX
FXTB3COD Performance Asc CODTB3FLX
FXTB3DESC Performance Asc DESCRICAO

Relationships

Close relationships within degrees of separation