FCENARIOFLXCX

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDCENARIO int 4 null
FCENARIOFLXCXFILTRO.IDCENARIO FKFCENARIOFLXCXFILTER_FCENARIOR
FCENARIOFLXCXVERSAO.IDCENARIO FKFCENARIOFLXCXVERSAO_FCENARIOR
MABCCOMPOSICAO.IDCENARIO Implied ConstraintR
MABCCOMPOSICAOTRF.IDCENARIO Implied ConstraintR
MABCISM.IDCENARIO Implied ConstraintR
MABCISMTRF.IDCENARIO Implied ConstraintR
MCRONOGDESEMBOLSO.IDCENARIO Implied ConstraintR
MCURVASISM.IDCENARIO Implied ConstraintR
MINTEGRACAOID.IDCENARIO Implied ConstraintR
MSERVICO.IDCENARIO Implied ConstraintR
MSERVICOTRF.IDCENARIO Implied ConstraintR
MSFDESEMBOLSO.IDCENARIO Implied ConstraintR
MTAREFA.IDCENARIO Implied ConstraintR
MTRF.IDCENARIO Implied ConstraintR
MXMTAREFACRONOG.IDCENARIO Implied ConstraintR
IDPLANEJAMENTO int 4 √ null
FPLANEJAMENTOFLXCX.IDPLANEJAMENTO FKFCENARIOFLXCX_FPLANEJAMENTOFR
VERSAOPLANEJAMENTO varchar 4 √ null
FPLANEJAMENTOFLXCX.VERSAO FKFCENARIOFLXCX_FPLANEJAMENTOFR
DATAINICIAL datetime2 16,7 √ null
DATAFINAL datetime2 16,7 √ null
TIPOFLUXOCAIXA smallint 2 √ null
MOSTRASALDOINICIALPLANEJADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MOSTRASALDOINICIALPREVISTO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ORIGEMDATAPREVISAO smallint 2 √ null
ORIGEMVALORPREVISAO smallint 2 CREATE DEFAULT DEF_DLOGICONULL AS 0
DESCONSIDERENATVALORZERO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
LANCONTACAIXAVAZIA smallint 2 √ null
CENTROCUSTOPORNATUREZA smallint 2 √ null
BXNAOCOMPENSADAEHPREVISAO smallint 2 √ null
CODIGOSINTETICONATCCUSTO smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
LISTARCONTACAIXAINATIVA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CONSIDERAHIST smallint 2 √ null
PERIODICIDADE int 4 √ null
PREVISTOSNOVENCIMENTO smallint 2 √ null
SALDOFINALPREVISTOPERIODOPOS smallint 2 ((0))
CONSIDERARAPENASCOLIGADAPROPRI smallint 2 ((0))
VALORESRATEIOINCOMPSEMRATEIO smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKFCENARIOFLXCX Primary key Asc IDCENARIO

Relationships

Close relationships within degrees of separation