XALGIMOVELDESPESAS

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIMOVEL DCODCOLIGADA 2 null
XALGIMOVELDESPESASCOMPL.CODCOLIMOVEL FKXALGIMOVDESPCOMPL_XALGIMOVDER
XALGIMOVEL.CODCOLIMOVEL FKXIMOVELDESPESAS_XIMOVELR
CODIMOVEL int 4 null
XALGIMOVELDESPESASCOMPL.CODIMOVEL FKXALGIMOVDESPCOMPL_XALGIMOVDER
XALGIMOVEL.CODIMOVEL FKXIMOVELDESPESAS_XIMOVELR
IDDESPESA int 4 null
XALGIMOVELDESPESASCOMPL.IDDESPESA FKXALGIMOVDESPCOMPL_XALGIMOVDER
CODCOLDESPESA DCODCOLIGADANULL 2 √ null
XALGTIPODESPESA.CODCOLDESPESA FKXIMOVELDESPESAS_XTIPODESPESAR
CODDESPESA int 4 √ null
XALGTIPODESPESA.CODDESPESA FKXIMOVELDESPESAS_XTIPODESPESAR
OBSDESP varchar 2147483647 √ null
DTDESP DDATE 16,3 √ null
HISTDESP varchar 2147483647 √ null
RESPANTECIPDESP smallint 2 √ null
RESPREPASSEDESP smallint 2 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
SITUACAODESPESA smallint 2 √ null
CODCOLCONTADM DCODCOLIGADA 2 √ null
XALGCONTRATOADM.CODCOLCONTADM FKXIMOVELDESPESASXCONTRATOADMR
CODCONTRATOADM int 4 √ null
XALGCONTRATOADM.CODCONTRATOADM FKXIMOVELDESPESASXCONTRATOADMR
VRTOTALDESP RMDVALOR4 17,4 √ null
QTDPARCELASDESP smallint 2 √ null
VRPARCELAS RMDVALOR4 17,4 √ null
DTINICOBRANCADESP DDATE 16,3 √ null
CODCOLLANPAG DCODCOLIGADANULL 2 √ null
FLAN.CODCOLIGADA FKXALGIMOVELDESPESAS_FLANR
IDLANPAG int 4 √ null
FLAN.IDLAN FKXALGIMOVELDESPESAS_FLANR
CODCOLLANREC DCODCOLIGADANULL 2 √ null
FLAN.CODCOLIGADA FKXALGIMOVELDESPESAS_FLANICR
IDLANREC int 4 √ null
FLAN.IDLAN FKXALGIMOVELDESPESAS_FLANICR

Indexes

Constraint Name Type Sort Column(s)
PKXIMOVELDESPESAS Primary key Asc/Asc/Asc CODCOLIMOVEL + CODIMOVEL + IDDESPESA

Relationships

Close relationships within degrees of separation