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/26/2023 11:43:47 AM |
| Last Modified | 7/3/2023 1:21:39 PM |
Columns
28| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUIL | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| APEYNOM | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| FECHA_NAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| SEXO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CALLE | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| ALTURA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| PISO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| DPTO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CP | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| LOCALIDAD | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PROVINCIA | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| CODAREA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TELNUMERO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| varchar | 150 | 0 | 0 | False |
False |
False |
||||||
| CUIL_SUELDO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_SAC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_EXTRAS | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_ZONA_DESFAV | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_VACACIONES | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_ADICIONALES | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_PREMIOS | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_CPTO_NO_REMUN | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_REMUN_TOTAL | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIL_REMUN_IMPON | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| PERIODO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| COD_RECTIFICATIVA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| RAZONSOCIAL | varchar | 250 | 0 | 0 | False |
False |
False |
Indexes
1| Key | Name | Columns | Unique | Type | Description |
|---|---|---|---|---|---|
| idx_NominasDiciembre2022 | CUIT | False |
SQL Script
Copy
CREATE TABLE dbo.NominasDiciembre2022 (
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(250) NULL
)
ON [PRIMARY]
GO
CREATE INDEX idx_NominasDiciembre2022
ON dbo.NominasDiciembre2022 (CUIT)
INCLUDE (CUIL, EMAIL)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
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(250) NULL
)
ON [PRIMARY]
GO
CREATE INDEX idx_NominasDiciembre2022
ON dbo.NominasDiciembre2022 (CUIT)
INCLUDE (CUIL, EMAIL)
WITH (FILLFACTOR = 80)
ON [PRIMARY]
GO
Depends On
1- Fidelitas