dbo.facturacionBBVA

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 (~)	0
Created	3/6/2025 6:55:53 PM
Last Modified	3/6/2025 6:55:53 PM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
Proveedor	varchar	50	0	False	False	False
CONTRAPARTE	numeric	9	18	False	False	False
gestion	numeric	9	18	False	False	False
identificacion	varchar	50	0	False	False	False
nombre_persona	varchar	500	0	False	False	False
Facturacion_anual	varchar	50	0	False	False	False
2023-12-01	varchar	50	0	False	False	False
2023-11-01	varchar	50	0	False	False	False
2023-10-01	varchar	50	0	False	False	False
2023-09-01	varchar	50	0	False	False	False
2023-08-01	varchar	50	0	False	False	False
2023-07-01	varchar	50	0	False	False	False
2023-06-01	varchar	50	0	False	False	False
2023-05-01	varchar	50	0	False	False	False
2023-04-01	varchar	50	0	False	False	False
2023-03-01	varchar	50	0	False	False	False
2023-02-01	varchar	50	0	False	False	False
2023-01-01	varchar	50	0	False	False	False
2022-12-01	varchar	50	0	False	False	False
2022-11-01	varchar	50	0	False	False	False
2022-10-01	varchar	50	0	False	False	False
2022-09-01	varchar	50	0	False	False	False
2022-08-01	varchar	50	0	False	False	False
2022-07-01	varchar	50	0	False	False	False
2022-06-01	varchar	50	0	False	False	False
2022-05-01	varchar	50	0	False	False	False
2022-04-01	varchar	50	0	False	False	False
2022-03-01	varchar	50	0	False	False	False
2022-02-01	varchar	50	0	False	False	False
2022-01-01	varchar	50	0	False	False	False
2021-12-01	varchar	50	0	False	False	False
2021-11-01	varchar	50	0	False	False	False
2021-10-01	varchar	50	0	False	False	False
2021-09-01	varchar	50	0	False	False	False
2021-08-01	varchar	50	0	False	False	False
2021-07-01	varchar	50	0	False	False	False
2021-06-01	varchar	50	0	False	False	False
2021-05-01	varchar	50	0	False	False	False
2021-04-01	varchar	50	0	False	False	False
2021-03-01	varchar	50	0	False	False	False
2021-02-01	varchar	50	0	False	False	False
2021-01-01	varchar	50	0	False	False	False

SQL Script

Copy

CREATE TABLE dbo.facturacionBBVA (
  Proveedor varchar(50) NULL,
  CONTRAPARTE numeric NULL,
  gestion numeric NULL,
  identificacion varchar(50) NULL,
  nombre_persona varchar(500) NULL,
  Facturacion_anual varchar(50) NULL,
  [2023-12-01] varchar(50) NULL,
  [2023-11-01] varchar(50) NULL,
  [2023-10-01] varchar(50) NULL,
  [2023-09-01] varchar(50) NULL,
  [2023-08-01] varchar(50) NULL,
  [2023-07-01] varchar(50) NULL,
  [2023-06-01] varchar(50) NULL,
  [2023-05-01] varchar(50) NULL,
  [2023-04-01] varchar(50) NULL,
  [2023-03-01] varchar(50) NULL,
  [2023-02-01] varchar(50) NULL,
  [2023-01-01] varchar(50) NULL,
  [2022-12-01] varchar(50) NULL,
  [2022-11-01] varchar(50) NULL,
  [2022-10-01] varchar(50) NULL,
  [2022-09-01] varchar(50) NULL,
  [2022-08-01] varchar(50) NULL,
  [2022-07-01] varchar(50) NULL,
  [2022-06-01] varchar(50) NULL,
  [2022-05-01] varchar(50) NULL,
  [2022-04-01] varchar(50) NULL,
  [2022-03-01] varchar(50) NULL,
  [2022-02-01] varchar(50) NULL,
  [2022-01-01] varchar(50) NULL,
  [2021-12-01] varchar(50) NULL,
  [2021-11-01] varchar(50) NULL,
  [2021-10-01] varchar(50) NULL,
  [2021-09-01] varchar(50) NULL,
  [2021-08-01] varchar(50) NULL,
  [2021-07-01] varchar(50) NULL,
  [2021-06-01] varchar(50) NULL,
  [2021-05-01] varchar(50) NULL,
  [2021-04-01] varchar(50) NULL,
  [2021-03-01] varchar(50) NULL,
  [2021-02-01] varchar(50) NULL,
  [2021-01-01] varchar(50) NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found