FORCAMENTDETALHE

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
FTB2.CODCOLIGADA FKFORCAMENTDETALHE_FTB2R
GCCUSTO.CODCOLIGADA FKFORCAMENTDETALHE_GCCUSTOR
GDEPTO.CODCOLIGADA FKFORCAMENTDETALHE_GDEPTOR
FORCAMENTO.CODCOLIGADA FKFORCAMENTDETALHE_FORCAMENTOR
FORCAMENTOCCUSTO.CODCOLIGADA FKFORCAMENTDETALHE_FORCCCUSTOR
FTB3.CODCOLIGADA FKFORCAMENTDETALHE_FTB3R
FTB1.CODCOLIGADA FKFORCAMENTDETALHE_FTB1R
FTB4.CODCOLIGADA FKFORCAMENTDETALHE_FTB4R
GFILIAL.CODCOLIGADA FKFORCAMENTDETALHE_GFILIALR
FTB5.CODCOLIGADA FKFORCAMENTDETALHE_FTB5R
IDORCDETALHE int 4 null
IDORCAMENTO int 4 null
FORCAMENTO.IDORCAMENTO FKFORCAMENTDETALHE_FORCAMENTOR
IDORCCCUSTO int 4 null
FORCAMENTOCCUSTO.IDORCCCUSTO FKFORCAMENTDETALHE_FORCCCUSTOR
CODTB1FLX varchar 25 √ null
FTB1.CODTB1FLX FKFORCAMENTDETALHE_FTB1R
CODTB2FLX varchar 25 √ null
FTB2.CODTB2FLX FKFORCAMENTDETALHE_FTB2R
CODTB3FLX varchar 25 √ null
FTB3.CODTB3FLX FKFORCAMENTDETALHE_FTB3R
CODTB4FLX varchar 25 √ null
FTB4.CODTB4FLX FKFORCAMENTDETALHE_FTB4R
CODTB5FLX varchar 25 √ null
FTB5.CODTB5FLX FKFORCAMENTDETALHE_FTB5R
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKFORCAMENTDETALHE_GCCUSTOR
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKFORCAMENTDETALHE_GDEPTOR
GFILIAL.CODFILIAL FKFORCAMENTDETALHE_GFILIALR
CODDEPTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKFORCAMENTDETALHE_GDEPTOR
VALORPREVISTO RMDVALOR4 17,4 null
VALORREALIZADO RMDVALOR4 17,4 √ null
CRIACAO datetime 16,3 √ null
OBSERVACAO MEMO 2147483647 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFORCAMENTDETALHE Primary key Asc/Asc CODCOLIGADA + IDORCDETALHE
FXORCAMENTDETALHE Performance Asc IDORCAMENTO

Relationships

Close relationships within degrees of separation