PGRPLANC

16 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PEVTGRP.CODCOLIGADA FKPEVTGRP_PGRPLANCR
PORCAMENTOGRUPOEVENTOS.CODCOLIGADA FKPORCAMENTOGRUPOEVENTOS_PGRPLR
GCOLIGADA.CODCOLIGADA FKPGRPLANC_GCOLIGADAR
PCODEMPRT.CODCOLIGADA FKPGRPLANC_PCODEMPRTR
GFORMULA.CODCOLIGADA FKPGRPLANC_GFORMULAR
CODIGO varchar 10 null
PEVTGRP.CODGRUPOLANC FKPEVTGRP_PGRPLANCR
PORCAMENTOGRUPOEVENTOS.CODGRPLANC FKPORCAMENTOGRUPOEVENTOS_PGRPLR
DESCRICAO varchar 45 √ null
CODIGOQUEBRA varchar 35 √ null
FORMULASELECAO varchar 8 √ null
GFORMULA.CODIGO FKPGRPLANC_GFORMULAR
LANCACODFIXOS smallint 2 √ null
SELECAOSITUACAO varchar 32 √ null
SELECAOTIPOFUNC varchar 32 √ null
SELECAOCODRECEB varchar 32 √ null
TIPOCODFIXOS int 4 √ null
LANCATIPOCODFIXOS smallint 2 √ null
APLICACAO varchar 1 √ ('P')
GFORMULA.APLICACAO FKPGRPLANC_GFORMULAR
CHAPAFUNC DCHAPANULL 16 √ null
CODFIXOSLANC varchar 40 √ null
LANCDESCMESANT smallint 2 √ (0)
LANCASALCOMP DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
FILTRO int 4 √ null
LANCAPARADEMITIDOS smallint 2 √ null
LANCAEVENTOSINCIDE DLOGICO 2 (0)
LANCAEMPRESTIMO smallint 2 √ null
TODOSEMPRESTIMOS smallint 2 √ null
TIPOEMPRESTIMO varchar 10 √ null
PCODEMPRT.CODCLIENTE FKPGRPLANC_PCODEMPRTR
LANCAVALETRANSP int 4 √ null
LANCALICMATERNIDADE int 4 √ null
LANCAEVENTOPROG smallint 2 √ null
EVENTOSPROGLANC varchar 40 √ null
LANCATIPOEVTTEMP smallint 2 √ null
TIPOSLANC varchar 40 √ null
COMPEVTTEMP varchar 1 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
LANCAEVENTOGRUPO smallint 2 √ ((0))
RECALCMEDSALMATERNIDADE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKPGRPLANC Primary key Asc/Asc CODCOLIGADA + CODIGO

Relationships

Close relationships within degrees of separation