dbo.cendeu_historico

Description

Properties

Name	Value
File Collation
File Group
Filestream File Group
Is Partitioned	False
Partitioned Column
Partition Scheme
File Groups
Filestream Partition Scheme
Filestream File Groups
Heap	True
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	0
Created	3/6/2025 6:55:52 PM
Last Modified	3/6/2025 6:55:56 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Default	Computed	Persisted
codigo_ent	varchar	5	0	0	False		False	False
fec_inf	varchar	6	0	0	False		False	False
tipo	varchar	2	0	0	False		False	False
iden	varchar	11	0	0	False		False	False
id_persona	int	4	10	0	False		False	False
actividad	varchar	3	0	0	False		False	False
situacion	varchar	2	0	0	False		False	False
prestamos	numeric	9	12	1	False		False	False
particip	numeric	9	12	1	False		False	False
garotor	numeric	9	12	1	False		False	False
o_cptos	numeric	9	12	1	False		False	False
garprefa	numeric	9	12	1	False		False	False
garprefb	numeric	9	12	1	False		False	False
singarpref	numeric	9	12	1	False		False	False
cgarprefa	numeric	9	12	1	False		False	False
cgarprefb	numeric	9	12	1	False		False	False
sincgarpre	numeric	9	12	1	False		False	False
previ	numeric	9	12	1	False		False	False
deuda_cubr	numeric	5	1	0	False		False	False
proc_jud	numeric	5	1	0	False		False	False
refinanc	numeric	5	1	0	False		False	False
rec_oblig	numeric	5	1	0	False		False	False
sit_juridi	numeric	5	1	0	False		False	False
irre_dispt	numeric	5	1	0	False		False	False
dia_atraso	numeric	5	4	0	False		False	False
id_fuente	int	4	10	0	False	(1)	False	False
vigente	bit	1	1	0	False	(1)	False	False
created	datetime	8	23	3	False	(getdate())	False	False
created_by	int	4	10	0	False		False	False
modified	datetime	8	23	3	False		False	False
modified_by	int	4	10	0	False		False	False
dbf_filename	varchar	15	0	0	False		False	False
deuda_total	numeric	9	12	1	True	(0)	False	False
observaciones	varchar	1024	0	0	False		False	False

SQL Script

Copy

CREATE TABLE dbo.cendeu_historico (
  codigo_ent varchar(5) NULL,
  fec_inf varchar(6) NULL,
  tipo varchar(2) NULL,
  iden varchar(11) NULL,
  id_persona int NULL,
  actividad varchar(3) NULL,
  situacion varchar(2) NULL,
  prestamos numeric(12, 1) NULL,
  particip numeric(12, 1) NULL,
  garotor numeric(12, 1) NULL,
  o_cptos numeric(12, 1) NULL,
  garprefa numeric(12, 1) NULL,
  garprefb numeric(12, 1) NULL,
  singarpref numeric(12, 1) NULL,
  cgarprefa numeric(12, 1) NULL,
  cgarprefb numeric(12, 1) NULL,
  sincgarpre numeric(12, 1) NULL,
  previ numeric(12, 1) NULL,
  deuda_cubr numeric(1) NULL,
  proc_jud numeric(1) NULL,
  refinanc numeric(1) NULL,
  rec_oblig numeric(1) NULL,
  sit_juridi numeric(1) NULL,
  irre_dispt numeric(1) NULL,
  dia_atraso numeric(4) NULL,
  id_fuente int NULL CONSTRAINT DF_cendeu_fuente2 DEFAULT (1),
  vigente bit NULL CONSTRAINT DF_cendeu_vigente2 DEFAULT (1),
  created datetime NULL CONSTRAINT DF_cendeu_created2 DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  dbf_filename varchar(15) NULL,
  deuda_total numeric(12, 1) NOT NULL DEFAULT (0),
  observaciones varchar(1024) NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found