XREGRA963

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
XAPURACAO963.CODCOLIGADA FKXAPURACAO963_XREGRA963R
XEMPREENDIMENTO.CODCOLIGADA FKXEMPREENDIMENTO_XREGRA963R
XREGRA963CONTA.CODCOLIGADA FKXREGRA963CONTA_XREGRA963R
TEVENTOSCONT.CODCOLIGADA FKXREGRA963_TEVENTOSCONTR
MTAREFA.CODCOLIGADA FKXREGRA963_MTRFETAPAR
GFORMULA.CODCOLIGADA FKXREGRA963_GFORMULAR
MPRJ.CODCOLIGADA FKXREGRA963_MPRJR
CODREGRA int 4 null
XAPURACAO963.CODREGRA FKXAPURACAO963_XREGRA963R
XEMPREENDIMENTO.CODREGRA FKXEMPREENDIMENTO_XREGRA963R
XREGRA963CONTA.CODREGRA FKXREGRA963CONTA_XREGRA963R
DESCRICAO varchar 255 √ null
IDPRJ int 4 √ null
MTAREFA.IDPRJ FKXREGRA963_MTRFR
MPRJ.IDPRJ FKXREGRA963_MPRJR
IDOBRA int 4 √ null
MTAREFA.IDTRF FKXREGRA963_MTRFR
CODEVENTO smallint 2 √ null
TEVENTOSCONT.CODEVENTO FKXREGRA963_TEVENTOSCONTR
CODCOLCONTARECEITA963 DCODCOLIGADANULL 2 √ null
CCONTA.CODCOLIGADA FKXREGRA963_CCONTAR
CODCONTARECEITA963 DCODCONTA 40 √ null
CCONTA.CODCONTA FKXREGRA963_CCONTAR
CODCOLCONTARECFIN963 DCODCOLIGADANULL 2 √ null
CCONTA.CODCOLIGADA FKXREGRA963_CCONTAFINR
CODCONTARECEITAFINANCEIRA963 DCODCONTA 40 √ null
CCONTA.CODCONTA FKXREGRA963_CCONTAFINR
CODCOLHISTVENDA DCODCOLIGADANULL 2 √ null
CHISTP.CODCOLIGADA FKXREGRA963_CHISTPR
CODHISTVENDA varchar 10 √ null
CHISTP.CODHISTP FKXREGRA963_CHISTPR
CODCOLHISTDISTRATO DCODCOLIGADANULL 2 √ null
CHISTP.CODCOLIGADA FKXREGRA963_CHISTPDISTRATOR
CODHISTDISTRATO varchar 10 √ null
CHISTP.CODHISTP FKXREGRA963_CHISTPDISTRATOR
CODCOLHISTRECEITA DCODCOLIGADANULL 2 √ null
CHISTP.CODCOLIGADA FKXREGRA963_CHISTPRECEITAR
CODHISTRECEITA varchar 10 √ null
CHISTP.CODHISTP FKXREGRA963_CHISTPRECEITAR
IDETAPA int 4 √ null
MTAREFA.IDTRF FKXREGRA963_MTRFETAPAR
CODCOLHISTABATIMENTO smallint 2 √ null
CHISTP.CODCOLIGADA FKXREGRA963_CHISTPABATR
CODHISTABATIMENTO varchar 10 √ null
CHISTP.CODHISTP FKXREGRA963_CHISTPABATR
CONSIDERARJUROSCM smallint 2 √ null
APLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKXREGRA963_GFORMULAR
CODFRM varchar 8 √ null
GFORMULA.CODIGO FKXREGRA963_GFORMULAR
SALDOANTCUSTOINCORRIDO RMDVALOR2 17,2 √ null
SALDOANTRECEITAVENDA RMDVALOR2 17,2 √ null
SALDOANTRECEITAFIN RMDVALOR2 17,2 √ null
SALDOANTRECEITARECONHECIDA RMDVALOR2 17,2 √ null
SALDOANTRECEITAFINRECONHECIDA RMDVALOR2 17,2 √ null
SALDOANTABATIMENTOADIANTCLI RMDVALOR2 17,2 √ null
SALDOANTABATIMENTOADIANTFINCLI RMDVALOR2 17,2 √ null
SALDOANTDATAREF datetime 16,3 √ 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)
PKXREGRA963 Primary key Asc/Asc CODCOLIGADA + CODREGRA

Relationships

Close relationships within degrees of separation