FTB2

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFODEF.CODCOLIGADA FKFCFODEF_FTB2R
FCXADEF.CODCOLIGADA FKFCXADEF_FTB2R
FLAN.CODCOLIGADA FKFLAN_FTB2R
FLANBAIXA.CODCOLIGADA FKFLANBAIXA_FTB2R
FORCAMENTDETALHE.CODCOLIGADA FKFORCAMENTDETALHE_FTB2R
FTB2CONT.CODCOLIGADA FKFTB2CONT_FTB2R
FTEMPLATEACORDO.CODCOLIGADA FKFTEMPLATEACORDO_FTB2R
FXCX.CODCOLIGADA FKFXCX_FTB2FLXR
PFINANCEIRO.CODCOLIGADA FKPFINANCEIRO_FTB2R
PLANCFINANC.CODCOLIGADA FKPLANCFINANC_FTB2R
SPSCONFIGURACAOPAGAMENTOPROF.CODCOLIGADA FKSPSCONFIGPAGAMENTPROF_FTB2R
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSPROCESSOSELETIVO_FTB2R
SSERVICO.CODCOLIGADA FKSSERVICO_FTB2R
TCNT.CODCOLIGADA FKTCNT_FTB2R
TCNTPAR.CODCOLIGADA FKTCNTPAR_FTB2R
TCPGCNT.CODCOLIGADA FKTCPGCNT_FTB2R
TFITMMOV.CODCOLIGADA FKTFITMMOV_FTB2R
TFMOV.CODCOLIGADA FKTFMOV_FTB2R
TFORMAPAGTO.CODCOLIGADA FKTFORMAPAGTO_FTB2R
TITMCNT.CODCOLIGADA FKTITMCNT_FTB2R
TITMMOV.CODCOLIGADA FKTITMMOV_FTB2R
TITMTMV.CODCOLIGADA FKTITMTMV_FTB2R
TLOT.CODCOLIGADA FKTLOT_FTB2R
TMOV.CODCOLIGADA FKTMOV_FTB2R
TRPR.CODCOLIGADA FKTRPR_FTB2R
TTMV.CODCOLIGADA FKTTMV_FTB2R
XTIPORECEITATABELAOPCIONAL.CODCOLIGADA FKXTPRECTABOPCIONAL_FTB2R
TEVENTOSCONT.CODCOLIGADA FKFTB2_TEVENTOSCONTBXR
VBENEFICIOS.CODCOLIGADA FKFTB2_VBENEFICIOSR
GCOLIGADA.CODCOLIGADA FKFTB2_GCOLIGADAR
CODTB2FLX varchar 25 null
FCFODEF.CODTB2FLX FKFCFODEF_FTB2R
FCXADEF.CODTB2FLX FKFCXADEF_FTB2R
FLAN.CODTB2FLX FKFLAN_FTB2R
FLANBAIXA.CODTB2FLX FKFLANBAIXA_FTB2R
FORCAMENTDETALHE.CODTB2FLX FKFORCAMENTDETALHE_FTB2R
FTB2CONT.CODTB2FLX FKFTB2CONT_FTB2R
FTEMPLATEACORDO.CODTB2FLX FKFTEMPLATEACORDO_FTB2R
FXCX.CODTB2FLX FKFXCX_FTB2FLXR
PFINANCEIRO.CODTB2FLX FKPFINANCEIRO_FTB2R
PLANCFINANC.CODTB2FLX FKPLANCFINANC_FTB2R
SPSCONFIGURACAOPAGAMENTOPROF.CODTB2FLX FKSPSCONFIGPAGAMENTPROF_FTB2R
SPSPROCESSOSELETIVO.CODTB2FLX FKSPSPROCESSOSELETIVO_FTB2R
SSERVICO.CODTB2FLX FKSSERVICO_FTB2R
TCNT.CODTB2FLX FKTCNT_FTB2R
TCNTPAR.CODTB2FLX FKTCNTPAR_FTB2R
TCPGCNT.CODTB2FLX FKTCPGCNT_FTB2R
TFITMMOV.CODTB2FLX FKTFITMMOV_FTB2R
TFMOV.CODTB2FLX FKTFMOV_FTB2R
TFORMAPAGTO.CODTB2FLX FKTFORMAPAGTO_FTB2R
TITMCNT.CODTB2FLX FKTITMCNT_FTB2R
TITMMOV.CODTB2FLX FKTITMMOV_FTB2R
TITMTMV.CODTB2FLXIT FKTITMTMV_FTB2R
TLOT.CODTB2FLX FKTLOT_FTB2R
TMOV.CODTB2FLX FKTMOV_FTB2R
TRPR.CODTB2FLX FKTRPR_FTB2R
TTMV.CODTB2FLXMOV FKTTMV_FTB2R
XTIPORECEITATABELAOPCIONAL.CODTB2FLX FKXTPRECTABOPCIONAL_FTB2R
DESCRICAO varchar 40 √ null
CAMPOLIVRE varchar 255 √ null
EMITERECIBOAD DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CADASTRACHEQUE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONTR
CODEVENTOBX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONTBXR
CODEVENTOBXCONT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONT3R
CODEVENTOXCX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSXCXR
PERMITELANC smallint 2 √ (1)
ATIVO smallint 2 √ (1)
CODBENEFICIO varchar 10 √ null
VBENEFICIOS.CODBENEFICIO FKFTB2_VBENEFICIOSR
CODEVENTOCRT smallint 2 √ null
CODEVENTOBXACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONT1R
CODEVENTOGERADOACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_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 FKFTB2_TEVENTOSCONT4R
CODEVENTOBXACORDOLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONTBXACOLIQDUVR
CODEVENTOBXLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONTBXLIQDUVR
CODEVENTOBXCREDADIANT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB2_TEVENTOSCONTBXCREDADR

Indexes

Constraint Name Type Sort Column(s)
PKFTB2 Primary key Asc/Asc CODCOLIGADA + CODTB2FLX
FXTB2COD Performance Asc CODTB2FLX
FXTB2DESC Performance Asc DESCRICAO

Relationships

Close relationships within degrees of separation