FTB1

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FCFODEF.CODCOLIGADA FKFCFODEF_FTB1R
FCXADEF.CODCOLIGADA FKFCXADEF_FTB1R
FLAN.CODCOLIGADA FKFLAN_FTB1R
FLANBAIXA.CODCOLIGADA FKFLANBAIXA_FTB1R
FORCAMENTDETALHE.CODCOLIGADA FKFORCAMENTDETALHE_FTB1R
FTB1CONT.CODCOLIGADA FKFTB1CONT_FTB1R
FTEMPLATEACORDO.CODCOLIGADA FKFTEMPLATEACORDO_FTB1R
FXCX.CODCOLIGADA FKFXCX_FTB1FLXR
PFINANCEIRO.CODCOLIGADA FKPFINANCEIRO_FTB1R
PLANCFINANC.CODCOLIGADA FKPLANCFINANC_FTB1R
SPSCONFIGURACAOPAGAMENTOPROF.CODCOLIGADA FKSPSCONFIGPAGAMENTPROF_FTB1R
SPSPROCESSOSELETIVO.CODCOLIGADA FKSPSPROCESSOSELETIVO_FTB1R
SSERVICO.CODCOLIGADA FKSSERVICO_FTB1R
TCNT.CODCOLIGADA FKTCNT_FTB1R
TCNTPAR.CODCOLIGADA FKTCNTPAR_FTB1R
TCPGCNT.CODCOLIGADA FKTCPGCNT_FTB1R
TFITMMOV.CODCOLIGADA FKTFITMMOV_FTB1R
TFMOV.CODCOLIGADA FKTFMOV_FTB1R
TFORMAPAGTO.CODCOLIGADA FKTFORMAPAGTO_FTB1R
TITMCNT.CODCOLIGADA FKTITMCNT_FTB1R
TITMMOV.CODCOLIGADA FKTITMMOV_FTB1R
TITMTMV.CODCOLIGADA FKTITMTMV_FTB1R
TLOT.CODCOLIGADA FKTLOT_FTB1R
TMOV.CODCOLIGADA FKTMOV_FTB1R
TRPR.CODCOLIGADA FKTRPR_FTB1R
TTMV.CODCOLIGADA FKTTMV_FTB1R
XTIPORECEITATABELAOPCIONAL.CODCOLIGADA FKXTPRECTABOPCIONAL_FTB1R
TEVENTOSCONT.CODCOLIGADA FKFTB1_TEVENTOSCONT4R
GCCUSTO.CODCOLIGADA FKFTB1_GCCUSTOR
GDEPTO.CODCOLIGADA FKFTB1_GDEPTOR
VBENEFICIOS.CODCOLIGADA FKFTB1_VBENEFICIOSR
GCOLIGADA.CODCOLIGADA FKFTB1_GCOLIGADAR
GFILIAL.CODCOLIGADA FKFTB1_GFILIALR
CODTB1FLX varchar 25 null
FCFODEF.CODTB1FLX FKFCFODEF_FTB1R
FCXADEF.CODTB1FLX FKFCXADEF_FTB1R
FLAN.CODTB1FLX FKFLAN_FTB1R
FLANBAIXA.CODTB1FLX FKFLANBAIXA_FTB1R
FORCAMENTDETALHE.CODTB1FLX FKFORCAMENTDETALHE_FTB1R
FTB1CONT.CODTB1FLX FKFTB1CONT_FTB1R
FTEMPLATEACORDO.CODTB1FLX FKFTEMPLATEACORDO_FTB1R
FXCX.CODTB1FLX FKFXCX_FTB1FLXR
PFINANCEIRO.CODTB1FLX FKPFINANCEIRO_FTB1R
PLANCFINANC.CODTB1FLX FKPLANCFINANC_FTB1R
SPSCONFIGURACAOPAGAMENTOPROF.CODTB1FLX FKSPSCONFIGPAGAMENTPROF_FTB1R
SPSPROCESSOSELETIVO.CODTB1FLX FKSPSPROCESSOSELETIVO_FTB1R
SSERVICO.CODTB1FLX FKSSERVICO_FTB1R
TCNT.CODTB1FLX FKTCNT_FTB1R
TCNTPAR.CODTB1FLX FKTCNTPAR_FTB1R
TCPGCNT.CODTB1FLX FKTCPGCNT_FTB1R
TFITMMOV.CODTB1FLX FKTFITMMOV_FTB1R
TFMOV.CODTB1FLX FKTFMOV_FTB1R
TFORMAPAGTO.CODTB1FLX FKTFORMAPAGTO_FTB1R
TITMCNT.CODTB1FLX FKTITMCNT_FTB1R
TITMMOV.CODTB1FLX FKTITMMOV_FTB1R
TITMTMV.CODTB1FLXIT FKTITMTMV_FTB1R
TLOT.CODTB1FLX FKTLOT_FTB1R
TMOV.CODTB1FLX FKTMOV_FTB1R
TRPR.CODTB1FLX FKTRPR_FTB1R
TTMV.CODTB1FLXMOV FKTTMV_FTB1R
XTIPORECEITATABELAOPCIONAL.CODTB1FLX FKXTPRECTABOPCIONAL_FTB1R
DESCRICAO varchar 40 √ null
CAMPOLIVRE varchar 255 √ null
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKFTB1_GDEPTOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKFTB1_GCCUSTOR
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKFTB1_GDEPTOR
GFILIAL.CODFILIAL FKFTB1_GFILIALR
DESCONTO RMDVALOR2 17,2 √ null
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONTR
CODEVENTOBX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONTBXR
CODEVENTOBXCONT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONT3R
CODEVENTOXCX smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSXCXR
PERMITELANC smallint 2 √ (1)
ATIVO smallint 2 √ (1)
CODBENEFICIO varchar 10 √ null
VBENEFICIOS.CODBENEFICIO FKFTB1_VBENEFICIOSR
CODEVENTOCRT smallint 2 √ null
CODEVENTOBXACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONT1R
CODEVENTOGERADOACORDO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_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 FKFTB1_TEVENTOSCONT4R
CODEVENTOBXACORDOLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONTBXACOLIQDUVR
CODEVENTOBXLIQDUVIDOSA smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONTBXLIQDUVR
CODEVENTOBXCREDADIANT smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKFTB1_TEVENTOSCONTBXCREDADR

Indexes

Constraint Name Type Sort Column(s)
PKFTB1 Primary key Asc/Asc CODCOLIGADA + CODTB1FLX
FXTB1COD Performance Asc CODTB1FLX
FXTB1DESC Performance Asc DESCRICAO

Relationships

Close relationships within degrees of separation