dbo.NominasMarzo2023

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 (~)	14581355
Created	7/9/2023 4:41:24 PM
Last Modified	7/9/2023 4:41:24 PM

Columns

Name	Data Type	Length	Not Null	Computed	Persisted
CUIL	varchar	50	False	False	False
APEYNOM	varchar	150	False	False	False
FECHA_NAC	varchar	50	False	False	False
SEXO	varchar	50	False	False	False
CALLE	varchar	150	False	False	False
ALTURA	varchar	50	False	False	False
PISO	varchar	50	False	False	False
DPTO	varchar	50	False	False	False
CP	varchar	50	False	False	False
LOCALIDAD	varchar	150	False	False	False
PROVINCIA	varchar	150	False	False	False
CODAREA	varchar	50	False	False	False
TELNUMERO	varchar	50	False	False	False
EMAIL	varchar	150	False	False	False
CUIL_SUELDO	varchar	50	False	False	False
CUIL_SAC	varchar	50	False	False	False
CUIL_EXTRAS	varchar	50	False	False	False
CUIL_ZONA_DESFAV	varchar	50	False	False	False
CUIL_VACACIONES	varchar	50	False	False	False
CUIL_ADICIONALES	varchar	50	False	False	False
CUIL_PREMIOS	varchar	50	False	False	False
CUIL_CPTO_NO_REMUN	varchar	50	False	False	False
CUIL_REMUN_TOTAL	varchar	50	False	False	False
CUIL_REMUN_IMPON	varchar	50	False	False	False
PERIODO	varchar	50	False	False	False
COD_RECTIFICATIVA	varchar	50	False	False	False
CUIT	varchar	50	False	False	False
RAZONSOCIAL	varchar	150	False	False	False

SQL Script

Copy

CREATE TABLE dbo.NominasMarzo2023 (
  CUIL varchar(50) NULL,
  APEYNOM varchar(150) NULL,
  FECHA_NAC varchar(50) NULL,
  SEXO varchar(50) NULL,
  CALLE varchar(150) NULL,
  ALTURA varchar(50) NULL,
  PISO varchar(50) NULL,
  DPTO varchar(50) NULL,
  CP varchar(50) NULL,
  LOCALIDAD varchar(150) NULL,
  PROVINCIA varchar(150) NULL,
  CODAREA varchar(50) NULL,
  TELNUMERO varchar(50) NULL,
  EMAIL varchar(150) NULL,
  CUIL_SUELDO varchar(50) NULL,
  CUIL_SAC varchar(50) NULL,
  CUIL_EXTRAS varchar(50) NULL,
  CUIL_ZONA_DESFAV varchar(50) NULL,
  CUIL_VACACIONES varchar(50) NULL,
  CUIL_ADICIONALES varchar(50) NULL,
  CUIL_PREMIOS varchar(50) NULL,
  CUIL_CPTO_NO_REMUN varchar(50) NULL,
  CUIL_REMUN_TOTAL varchar(50) NULL,
  CUIL_REMUN_IMPON varchar(50) NULL,
  PERIODO varchar(50) NULL,
  COD_RECTIFICATIVA varchar(50) NULL,
  CUIT varchar(50) NULL,
  RAZONSOCIAL varchar(150) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found