dbo.LN_docs

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	False
Full Text Catalog
Full Text
Compression	NONE
Row Count (~)	662306
Created	10/16/2018 3:33:04 PM
Last Modified	1/5/2023 12:48:27 PM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	doc_id	int	4	10	0	True	1 - 1		False	False
3	cliente	int	4	10	0	True			False	False
	contraparte	int	4	10	0	True			False	False
	tipo_doc	int	4	10	0	True			False	False
	doc_version	int	4	10	0	True			False	False
5	estado_doc	varchar	1	0	0	False			False	False
	vencimiento_carga	datetime	8	23	3	False			False	False
	fecha_vigencia	datetime	8	23	3	False			False	False
	doc_attach	tinyint	1	3	0	True			False	False
	ingresado	smalldatetime	4	16	0	False			False	False
	ingresado_por	int	4	10	0	False			False	False
	rechazado	smalldatetime	4	16	0	False			False	False
	rechazado_por	int	4	10	0	False			False	False
	verificado_backend	smalldatetime	4	16	0	False			False	False
	verificado_backend_por	int	4	10	0	False			False	False
	verificado_cliente	smalldatetime	4	16	0	False			False	False
	verificado_cliente_por	int	4	10	0	False			False	False
	texto_rechazo	varchar	500	0	0	False			False	False
	doc_log	text		0	0	False			False	False
	created	smalldatetime	4	16	0	True			False	False
	created_by	int	4	10	0	False			False	False
	modified	smalldatetime	4	16	0	False			False	False
	modified_by	int	4	10	0	False			False	False
	es_balance	tinyint	1	3	0	True			False	False
	inicio_ejercicio	smalldatetime	4	16	0	False			False	False
	fin_ejercicio	smalldatetime	4	16	0	False			False	False
2	gestion	int	4	10	0	False			False	False
	id_externo	int	4	10	0	False			False	False
3	aplica	bit	1	1	0	False		(1)	False	False
	user_id_aplica	int	4	10	0	False			False	False
	fecha_aplica	smalldatetime	4	16	0	False			False	False
	valoracion	tinyint	1	3	0	False		(0)	False	False
	revisado	bit	1	1	0	False			False	False

Indexes

Name	Columns	Unique
idx_ln_doc_cli_ap_es	cliente, aplica, estado_doc	False
idx_ln_doc_cli_est	cliente, estado_doc	False
idx_ln_docs_estado_doc	estado_doc	False
idx_lndocs_ea	estado_doc, aplica	False
idx_lndocs_id_externo	id_externo	False
idxLN_contraparte_gestion	contraparte, gestion	False
idxLNDocs	cliente, aplica, estado_doc	False
idxLNDocsGestion	gestion	False
PK_LN_docs	doc_id	True

SQL Script

Copy

CREATE TABLE dbo.LN_docs (
  doc_id int IDENTITY,
  cliente int NOT NULL,
  contraparte int NOT NULL,
  tipo_doc int NOT NULL,
  doc_version int NOT NULL,
  estado_doc varchar(1) NULL,
  vencimiento_carga datetime NULL,
  fecha_vigencia datetime NULL,
  doc_attach tinyint NOT NULL,
  ingresado smalldatetime NULL,
  ingresado_por int NULL,
  rechazado smalldatetime NULL,
  rechazado_por int NULL,
  verificado_backend smalldatetime NULL,
  verificado_backend_por int NULL,
  verificado_cliente smalldatetime NULL,
  verificado_cliente_por int NULL,
  texto_rechazo varchar(500) NULL,
  doc_log text NULL,
  created smalldatetime NOT NULL,
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  es_balance tinyint NOT NULL,
  inicio_ejercicio smalldatetime NULL,
  fin_ejercicio smalldatetime NULL,
  gestion int NULL,
  id_externo int NULL,
  aplica bit NULL CONSTRAINT DF_LN_docs_aplica DEFAULT (1),
  user_id_aplica int NULL,
  fecha_aplica smalldatetime NULL,
  valoracion tinyint NULL DEFAULT (0),
  revisado bit NULL,
  CONSTRAINT PK_LN_docs PRIMARY KEY CLUSTERED (doc_id) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idx_ln_doc_cli_ap_es
  ON dbo.LN_docs (cliente, aplica, estado_doc)
  INCLUDE (contraparte)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_ln_doc_cli_est
  ON dbo.LN_docs (cliente, estado_doc)
  INCLUDE (contraparte, tipo_doc)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_ln_docs_estado_doc
  ON dbo.LN_docs (estado_doc)
  INCLUDE (contraparte, tipo_doc, doc_version, gestion)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_lndocs_ea
  ON dbo.LN_docs (estado_doc, aplica)
  INCLUDE (contraparte, tipo_doc, gestion)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_lndocs_id_externo
  ON dbo.LN_docs (id_externo)
  INCLUDE (estado_doc, inicio_ejercicio, fin_ejercicio)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxLN_contraparte_gestion
  ON dbo.LN_docs (contraparte, gestion)
  INCLUDE (tipo_doc, doc_version)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxLNDocs
  ON dbo.LN_docs (cliente, aplica, estado_doc)
  INCLUDE (contraparte, gestion)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxLNDocsGestion
  ON dbo.LN_docs (gestion)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

166