dbo.accionistas

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 (~)	121160
Created	7/20/2016 12:22:31 PM
Last Modified	12/3/2023 6:52:04 AM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_accionista	int	4	10	0	True	1 - 1		False	False
c01_codigo	int	4	10	0	False			False	False
id_padron_sociedad	int	4	10	0	False			False	False
cuit_sociedad	varchar	20	0	0	False			False	False
codigo_acc	int	4	10	0	False			False	False
id_padron_acc	int	4	10	0	False			False	False
cuit_acc	varchar	20	0	0	False			False	False
id_padron_rep	int	4	10	0	False			False	False
codigo_rep	int	4	10	0	False			False	False
cuit_rep	varchar	13	0	0	False			False	False
cant_acciones	int	4	10	0	False			False	False
monto	decimal	9	16	4	False			False	False
porcentaje	decimal	5	5	2	False			False	False
fecha_actualizacion	datetime	8	23	3	False			False	False
ifx_usuario	varchar	8	0	0	False			False	False
idifx	int	4	10	0	False			False	False
accionista_desde	datetime	8	23	3	False			False	False
accionista_hasta	datetime	8	23	3	False			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
visible	bit	1	1	0	False		(1)	False	False
ids_sociedades_constituciones	varchar		0	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idx_accionistas_cuit_acc	cuit_acc, visible	False
	idx_accionistas_cuit_sociedad	cuit_sociedad	False

SQL Script

Copy

CREATE TABLE dbo.accionistas (
  id_accionista int IDENTITY,
  c01_codigo int NULL,
  id_padron_sociedad int NULL,
  cuit_sociedad varchar(20) NULL,
  codigo_acc int NULL,
  id_padron_acc int NULL,
  cuit_acc varchar(20) NULL,
  id_padron_rep int NULL,
  codigo_rep int NULL,
  cuit_rep varchar(13) NULL,
  cant_acciones int NULL,
  monto decimal(16, 4) NULL,
  porcentaje decimal(5, 2) NULL,
  fecha_actualizacion datetime NULL,
  ifx_usuario varchar(8) NULL,
  idifx int NULL,
  accionista_desde datetime NULL,
  accionista_hasta datetime NULL,
  created datetime NULL CONSTRAINT DF_accionista_created DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  visible bit NULL CONSTRAINT DF_accionista_visible DEFAULT (1),
  ids_sociedades_constituciones varchar(max) NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idx_accionistas_cuit_acc
  ON dbo.accionistas (cuit_acc, visible)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_accionistas_cuit_sociedad
  ON dbo.accionistas (cuit_sociedad)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas