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 (~) | 314 |
| Created | 8/17/2016 3:51:29 PM |
| Last Modified | 11/25/2016 4:25:41 PM |
Columns
13| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CUIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| RazonSocial | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| Nombre | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| varchar | 250 | 0 | 0 | False |
False |
False |
||||||
| Emailalternativo | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| Emailalternativo2 | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| Inactivo | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| Telefono | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Direccion | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| CodigoAuxiliar | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FechaAlta | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FechaActivcacion | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| last_modified | datetime | 8 | 23 | 3 | False |
(getdate()) | False |
False |
SQL Script
Copy
CREATE TABLE dbo.AMX_Proveedores (
CUIT varchar(50) NULL,
RazonSocial varchar(250) NULL,
Nombre varchar(250) NULL,
Email varchar(250) NULL,
Emailalternativo varchar(250) NULL,
Emailalternativo2 varchar(250) NULL,
Inactivo varchar(50) NULL,
Telefono varchar(150) NULL,
Direccion varchar(250) NULL,
CodigoAuxiliar varchar(50) NULL,
FechaAlta varchar(50) NULL,
FechaActivcacion varchar(50) NULL,
last_modified datetime NULL DEFAULT (getdate())
)
ON [PRIMARY]
GO
CUIT varchar(50) NULL,
RazonSocial varchar(250) NULL,
Nombre varchar(250) NULL,
Email varchar(250) NULL,
Emailalternativo varchar(250) NULL,
Emailalternativo2 varchar(250) NULL,
Inactivo varchar(50) NULL,
Telefono varchar(150) NULL,
Direccion varchar(250) NULL,
CodigoAuxiliar varchar(50) NULL,
FechaAlta varchar(50) NULL,
FechaActivcacion varchar(50) NULL,
last_modified datetime NULL DEFAULT (getdate())
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found