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 (~)	1943
Created	9/9/2016 12:51:33 PM
Last Modified	9/9/2016 12:51:33 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_morosidad	int	4	10	0	True	1 - 1	False	False
iden	varchar	11	0	0	False		False	False
cau_codigo	varchar	10	0	0	False		False	False
fecha	date	3	10	0	False		False	False
codigo_ent	varchar	3	0	0	False		False	False
monto_original	numeric	9	12	2	False		False	False
monto_act	numeric	9	12	2	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 (
  id_morosidad int IDENTITY,
  iden varchar(11) NULL,
  cau_codigo varchar(10) NULL,
  fecha date NULL,
  codigo_ent varchar(3) NULL,
  monto_original numeric(12, 2) NULL,
  monto_act numeric(12, 2) 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

Fidelitas