dbo.sociedades

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 (~)	713534
Created	6/25/2016 8:59:09 PM
Last Modified	6/25/2016 9:37:06 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_sociedad	int	4	10	0	True	1 - 1		False	False
cuit_sociedad	varchar	20	0	0	False			False	False
c01_codigo	int	4	10	0	False			False	False
soc_codigo	smallint	2	5	0	False			False	False
sindicatura	varchar	1	0	0	False			False	False
fecha_cons	varchar	25	0	0	False			False	False
fecha_ins_rpc	date	3	10	0	False			False	False
nro_ins_rpc	int	4	10	0	False			False	False
folio	varchar	7	0	0	False			False	False
libro	int	4	10	0	False			False	False
tomo	varchar	7	0	0	False			False	False
duracion	varchar	20	0	0	False			False	False
ram_codigo	smallint	2	5	0	False			False	False
sra_codigo	smallint	2	5	0	False			False	False
actividad	varchar	120	0	0	False			False	False
capital	decimal	9	16	5	False			False	False
mon_codigo	smallint	2	5	0	False			False	False
uso_firma	varchar	50	0	0	False			False	False
nroigj	varchar	10	0	0	False			False	False
prv_codigo	varchar	1	0	0	False			False	False
iibb	varchar	14	0	0	False			False	False
nroana	varchar	10	0	0	False			False	False
nroexp	int	4	10	0	False			False	False
fecha_act	date	3	10	0	False			False	False
usuario	varchar	8	0	0	False			False	False
idifx	int	4	10	0	False			False	False
created	datetime	8	23	3	False			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
id_padron	int	4	10	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.sociedades (
  id_sociedad int IDENTITY,
  cuit_sociedad varchar(20) NULL,
  c01_codigo int NULL,
  soc_codigo smallint NULL,
  sindicatura varchar(1) NULL,
  fecha_cons varchar(25) NULL,
  fecha_ins_rpc date NULL,
  nro_ins_rpc int NULL,
  folio varchar(7) NULL,
  libro int NULL,
  tomo varchar(7) NULL,
  duracion varchar(20) NULL,
  ram_codigo smallint NULL,
  sra_codigo smallint NULL,
  actividad varchar(120) NULL,
  capital decimal(16, 5) NULL,
  mon_codigo smallint NULL,
  uso_firma varchar(50) NULL,
  nroigj varchar(10) NULL,
  prv_codigo varchar(1) NULL,
  iibb varchar(14) NULL,
  nroana varchar(10) NULL,
  nroexp int NULL,
  fecha_act date NULL,
  usuario varchar(8) NULL,
  idifx int NULL,
  created datetime NULL,
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  visible bit NULL CONSTRAINT DF_sociedades_visible DEFAULT (1),
  id_padron int NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found