dbo.AMX_2020

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 (~)	335
Created	3/15/2020 5:41:52 PM
Last Modified	3/16/2020 2:15:25 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
familia_2020	varchar	50	0	0	False		False	False
cuit	varchar	50	0	0	False		False	False
razon_social	varchar	250	0	0	False		False	False
comprado_ars	varchar	50	0	0	False		False	False
comprado_usd	varchar	50	0	0	False		False	False
facturado_ars	varchar	50	0	0	False		False	False
facturado_usd	varchar	50	0	0	False		False	False
familia_2019	varchar	50	0	0	False		False	False
mail	varchar	250	0	0	False		False	False
te	varchar	250	0	0	False		False	False
nombre	varchar	250	0	0	False		False	False
pedir_icomercial	varchar	150	0	0	False		False	False
pedir_tyc	varchar	150	0	0	False		False	False
idRow	int	4	10	0	True	1 - 1	False	False
idfamilia_2019	int	4	10	0	False		False	False
idfamilia_2020	int	4	10	0	False		False	False
contraparte	int	4	10	0	False		False	False
id_padron	int	4	10	0	False		False	False
bitpedir_ic	bit	1	1	0	False		False	False
bitpedir_tyc	bit	1	1	0	False		False	False
procesado	bit	1	1	0	False		False	False
mail_nuevo	varchar	255	0	0	False		False	False
tipo_proceso	varchar	20	0	0	False		False	False
procesado_contraparte	datetime	8	23	3	False		False	False
procesado_gestion	datetime	8	23	3	False		False	False
procesado_familia	datetime	8	23	3	False		False	False

SQL Script

Copy

CREATE TABLE dbo.AMX_2020_CSV (
  familia_2020 varchar(50) NULL,
  cuit varchar(50) NULL,
  razon_social varchar(250) NULL,
  comprado_ars varchar(50) NULL,
  comprado_usd varchar(50) NULL,
  facturado_ars varchar(50) NULL,
  facturado_usd varchar(50) NULL,
  familia_2019 varchar(50) NULL,
  mail varchar(250) NULL,
  te varchar(250) NULL,
  nombre varchar(250) NULL,
  pedir_icomercial varchar(150) NULL,
  pedir_tyc varchar(150) NULL,
  idRow int IDENTITY,
  idfamilia_2019 int NULL,
  idfamilia_2020 int NULL,
  contraparte int NULL,
  id_padron int NULL,
  bitpedir_ic bit NULL,
  bitpedir_tyc bit NULL,
  procesado bit NULL,
  mail_nuevo varchar(255) NULL,
  tipo_proceso varchar(20) NULL,
  procesado_contraparte datetime NULL,
  procesado_gestion datetime NULL,
  procesado_familia datetime NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.AMX_2020_CSV_