dbo.LN_dep_econ

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 (~)	38175
Created	2/20/2019 1:09:54 PM
Last Modified	7/25/2022 11:27:16 AM

Columns

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
2	cliente	int	4	10	0	True			False	False
	identificacion	varchar	50	0	0	True			False	False
	id_padron	int	4	10	0	False			False	False
	contraparte	int	4	10	0	False			False	False
	total_compras	money	8	19	4	False			False	False
	desde	date	3	10	0	False			False	False
2	hasta	date	3	10	0	False			False	False
	producto	int	4	10	0	False			False	False
	monto_credito_solicitado	money	8	19	4	False			False	False
	fecha_solicitud	date	3	10	0	False			False	False
	valor_cliente	money	8	19	4	False			False	False
	moneda	varchar	3	0	0	False			False	False
	cotizacion	money	8	19	4	False			False	False
	visible	bit	1	1	0	True		(1)	False	False
	created	datetime	8	23	3	False		(getdate())	False	False
	id	int	4	10	0	True	1 - 1		False	False
	texto	varchar	100	0	0	False			False	False
	modified	datetime	8	23	3	False			False	False

Indexes

Name	Columns	Unique
idx_dep_econ	cliente, id_padron, desde, hasta	False
idxDepEcoContrap	contraparte	False
idxDepEconcompras	cliente, hasta	False

SQL Script

Copy

CREATE TABLE dbo.LN_dep_econ_compras (
  cliente int NOT NULL,
  identificacion varchar(50) NOT NULL,
  id_padron int NULL,
  contraparte int NULL,
  total_compras money NULL,
  desde date NULL,
  hasta date NULL,
  producto int NULL,
  monto_credito_solicitado money NULL,
  fecha_solicitud date NULL,
  valor_cliente money NULL,
  moneda varchar(3) NULL,
  cotizacion money NULL,
  visible bit NOT NULL DEFAULT (1),
  created datetime NULL DEFAULT (getdate()),
  id int IDENTITY,
  texto varchar(100) NULL,
  modified datetime NULL
)
ON [PRIMARY]
GO

CREATE INDEX idx_dep_econ
  ON dbo.LN_dep_econ_compras (cliente, id_padron, desde, hasta)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxDepEcoContrap
  ON dbo.LN_dep_econ_compras (contraparte)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idxDepEconcompras
  ON dbo.LN_dep_econ_compras (cliente, hasta)
  INCLUDE (identificacion, id_padron)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.LN_dep_econ_compras