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:54 PM |
| Last Modified | 3/6/2025 6:55:54 PM |
Columns
16| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RUC | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Estado | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Condicion | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Tipo | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Actividad_Economica_CIIU_revision3_Principal | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Actividad_Economica_CIIU_revision3_Secundaria | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Actividad_Economica_CIIU_revision4_Principal | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| NroTrab | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TipoFacturacion | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TipoContabilidad | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| ComercioExterior | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| UBIGEO | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Departamento | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Provincia | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Distrito | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| PERIODO_PUBLICACION | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.padron_peru_202301 (
RUC varchar(50) NULL,
Estado varchar(50) NULL,
Condicion varchar(50) NULL,
Tipo varchar(150) NULL,
Actividad_Economica_CIIU_revision3_Principal varchar(150) NULL,
Actividad_Economica_CIIU_revision3_Secundaria varchar(150) NULL,
Actividad_Economica_CIIU_revision4_Principal varchar(150) NULL,
NroTrab varchar(50) NULL,
TipoFacturacion varchar(50) NULL,
TipoContabilidad varchar(50) NULL,
ComercioExterior varchar(50) NULL,
UBIGEO varchar(50) NULL,
Departamento varchar(150) NULL,
Provincia varchar(150) NULL,
Distrito varchar(150) NULL,
PERIODO_PUBLICACION varchar(50) NULL
)
ON [PRIMARY]
GO
RUC varchar(50) NULL,
Estado varchar(50) NULL,
Condicion varchar(50) NULL,
Tipo varchar(150) NULL,
Actividad_Economica_CIIU_revision3_Principal varchar(150) NULL,
Actividad_Economica_CIIU_revision3_Secundaria varchar(150) NULL,
Actividad_Economica_CIIU_revision4_Principal varchar(150) NULL,
NroTrab varchar(50) NULL,
TipoFacturacion varchar(50) NULL,
TipoContabilidad varchar(50) NULL,
ComercioExterior varchar(50) NULL,
UBIGEO varchar(50) NULL,
Departamento varchar(150) NULL,
Provincia varchar(150) NULL,
Distrito varchar(150) NULL,
PERIODO_PUBLICACION varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found