dbo.sircreb

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 (~)	6316021
Created	1/22/2017 10:32:42 PM
Last Modified	6/21/2017 3:15:54 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
fecha_publicacion	smalldatetime	4	16	0	True			False	False
Fecha_Vigencia_Desde	smalldatetime	4	16	0	True			False	False
Fecha_Vigencia_Hasta	smalldatetime	4	16	0	True			False	False
cuit	varchar	20	0	0	True			False	False
Tipo_Contribuyente_Inscripto	varchar	1	0	0	False			False	False
Marca_alta_sujeto	varchar	1	0	0	False			False	False
Marca_alicuota	varchar	1	0	0	False			False	False
Alicuota_Percepcion	decimal	9	10	2	False			False	False
Alicuota_Retencion	decimal	9	10	2	False			False	False
Nro_Grupo_Percepcion	varchar	2	0	0	False			False	False
Nro_Grupo_Retencion	varchar	2	0	0	False			False	False
Razon_Social	varchar	100	0	0	False			False	False
id_sircreb	int	4	10	0	True	1 - 1		False	False
created	datetime	8	23	3	False		(getdate())	False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	idx_sircreb_cuit	cuit	False

SQL Script

Copy

CREATE TABLE dbo.sircreb (
  fecha_publicacion smalldatetime NOT NULL,
  Fecha_Vigencia_Desde smalldatetime NOT NULL,
  Fecha_Vigencia_Hasta smalldatetime NOT NULL,
  cuit varchar(20) NOT NULL,
  Tipo_Contribuyente_Inscripto varchar(1) NULL,
  Marca_alta_sujeto varchar(1) NULL,
  Marca_alicuota varchar(1) NULL,
  Alicuota_Percepcion decimal(10, 2) NULL,
  Alicuota_Retencion decimal(10, 2) NULL,
  Nro_Grupo_Percepcion varchar(2) NULL,
  Nro_Grupo_Retencion varchar(2) NULL,
  Razon_Social varchar(100) NULL,
  id_sircreb int IDENTITY,
  created datetime NULL DEFAULT (getdate())
)
ON [PRIMARY]
GO

CREATE INDEX idx_sircreb_cuit
  ON dbo.sircreb (cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas