dbo.BRG_Analizar

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 (~)	5468
Created	4/18/2018 1:40:26 PM
Last Modified	4/18/2018 1:40:26 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
vendorid	int	4	10	False	False	False
PERSON_TYPE	varchar	8	0	True	False	False
TAXID	varchar	50	0	False	False	False
LEGALNAME	varchar	250	0	False	False	False
LINKEDPERSONORENTITY	varchar	512	0	False	False	False
LINKTAXID	varchar	50	0	False	False	False
PARENT_TAX_ID	varchar	50	0	False	False	False
PARENT_NAME	varchar	250	0	False	False	False
POSITIONRELATION	varchar	250	0	False	False	False
PEPSANCTIONSLIST	varchar	3	0	True	False	False
POSITIONROLE	varchar	501	0	False	False	False
ESTATUS	varchar	50	0	False	False	False
FECHADEFUNCION	date	3	10	False	False	False
cuit	varchar	50	0	False	False	False
razon_social	varchar	150	0	False	False	False
cargo	varchar	501	0	False	False	False
estado	varchar	50	0	False	False	False
fecha_desde	varchar	250	0	False	False	False
fecha_hasta	varchar	250	0	False	False	False

SQL Script

Copy

CREATE TABLE dbo.BRG_Analizar_Fam (
  vendorid int NULL,
  PERSON_TYPE varchar(8) NOT NULL,
  TAXID varchar(50) NULL,
  LEGALNAME varchar(250) NULL,
  LINKEDPERSONORENTITY varchar(512) NULL,
  LINKTAXID varchar(50) NULL,
  PARENT_TAX_ID varchar(50) NULL,
  PARENT_NAME varchar(250) NULL,
  POSITIONRELATION varchar(250) NULL,
  PEPSANCTIONSLIST varchar(3) NOT NULL,
  POSITIONROLE varchar(501) NULL,
  ESTATUS varchar(50) NULL,
  FECHADEFUNCION date NULL,
  cuit varchar(50) NULL,
  razon_social varchar(150) NULL,
  cargo varchar(501) NULL,
  estado varchar(50) NULL,
  fecha_desde varchar(250) NULL,
  fecha_hasta varchar(250) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found