dbo.morosidad

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:54 PM
Last Modified	3/6/2025 6:55:54 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_morosidad_cancela	int	4	10	0	True	1 - 1	False	False
iden	varchar	11	0	0	False		False	False
codigo_ent	varchar	3	0	0	False		False	False
fec_inf_desde	smalldatetime	4	16	0	False		False	False
fec_inf_hasta	smalldatetime	4	16	0	False		False	False
eve_codigo	varchar	10	0	0	False		False	False
fecha	date	3	10	0	False		False	False
fue_codigo	varchar	10	0	0	False		False	False
fecha_fuente	date	3	10	0	False		False	False
observaciones	varchar		0	0	False		False	False
vigente	bit	1	1	0	False		False	False
id_persona	int	4	10	0	False		False	False
created_by	int	4	10	0	False		False	False
created	datetime	8	23	3	False		False	False
modified_by	int	4	10	0	False		False	False
modified	datetime	8	23	3	False		False	False

SQL Script

Copy

CREATE TABLE dbo.morosidad_cancela (
  id_morosidad_cancela int IDENTITY,
  iden varchar(11) NULL,
  codigo_ent varchar(3) NULL,
  fec_inf_desde smalldatetime NULL,
  fec_inf_hasta smalldatetime NULL,
  eve_codigo varchar(10) NULL,
  fecha date NULL,
  fue_codigo varchar(10) NULL,
  fecha_fuente date NULL,
  observaciones varchar(max) NULL,
  vigente bit NULL,
  id_persona int NULL,
  created_by int NULL,
  created datetime NULL,
  modified_by int NULL,
  modified datetime NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found