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 (~) | 510798 |
| Created | 8/10/2016 5:05:57 PM |
| Last Modified | 8/10/2016 5:05:57 PM |
Columns
18| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUITProveedor | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| RazonSocial | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| CodigoSobre | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Sobre | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Codigodocumento | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Documento | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Anio | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Mes | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| TipoRecurso | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CodigoRecurso | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Descripcion | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| Version | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| IDRequerimiento | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FechaModificacion | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FechaAlta | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Estado | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| VigenciaDesde | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| VigenciaHasta | varchar | 50 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.Backup_AMX (
CUITProveedor varchar(50) NULL,
RazonSocial varchar(150) NULL,
CodigoSobre varchar(50) NULL,
Sobre varchar(150) NULL,
Codigodocumento varchar(50) NULL,
Documento varchar(150) NULL,
Anio varchar(50) NULL,
Mes varchar(50) NULL,
TipoRecurso varchar(50) NULL,
CodigoRecurso varchar(50) NULL,
Descripcion varchar(250) NULL,
Version varchar(50) NULL,
IDRequerimiento varchar(50) NULL,
FechaModificacion varchar(50) NULL,
FechaAlta varchar(50) NULL,
Estado varchar(50) NULL,
VigenciaDesde varchar(50) NULL,
VigenciaHasta varchar(50) NULL
)
ON [PRIMARY]
GO
CUITProveedor varchar(50) NULL,
RazonSocial varchar(150) NULL,
CodigoSobre varchar(50) NULL,
Sobre varchar(150) NULL,
Codigodocumento varchar(50) NULL,
Documento varchar(150) NULL,
Anio varchar(50) NULL,
Mes varchar(50) NULL,
TipoRecurso varchar(50) NULL,
CodigoRecurso varchar(50) NULL,
Descripcion varchar(250) NULL,
Version varchar(50) NULL,
IDRequerimiento varchar(50) NULL,
FechaModificacion varchar(50) NULL,
FechaAlta varchar(50) NULL,
Estado varchar(50) NULL,
VigenciaDesde varchar(50) NULL,
VigenciaHasta varchar(50) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found