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 (~) | 312 |
| Created | 3/10/2022 4:56:14 PM |
| Last Modified | 3/10/2022 6:13:36 PM |
Columns
22| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SINERGIA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| FAMILIA | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| CUIT | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| GESTION | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| RAZON_SOCIAL | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| varchar | 250 | 0 | 0 | False |
False |
False |
||||||
| TE | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| NOMBRE_CONTACTO | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| PIC | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| TC | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| HOMOLOGADO | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| Comentarios | varchar | 250 | 0 | 0 | False |
False |
False |
|||||
| CLASIFICACION_2021 | varchar | 150 | 0 | 0 | False |
False |
False |
|||||
| naranja_mantienen | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| amarillo_cambian | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| verde_nuevos | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| contraparte | int | 4 | 10 | 0 | False |
False |
False |
|||||
| idfamilia | int | 4 | 10 | 0 | False |
False |
False |
|||||
| pedir_doc | bit | 1 | 1 | 0 | False |
(0) | False |
False |
||||
| procesado | bit | 1 | 1 | 0 | False |
(0) | False |
False |
||||
| idreg | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| mail1 | varchar | 250 | 0 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.AMX_2022 (
SINERGIA varchar(50) NULL,
FAMILIA varchar(50) NULL,
CUIT varchar(50) NULL,
GESTION varchar(50) NULL,
RAZON_SOCIAL varchar(150) NULL,
MAIL varchar(250) NULL,
TE varchar(250) NULL,
NOMBRE_CONTACTO varchar(250) NULL,
PIC varchar(150) NULL,
TC varchar(150) NULL,
HOMOLOGADO varchar(150) NULL,
Comentarios varchar(250) NULL,
CLASIFICACION_2021 varchar(150) NULL,
naranja_mantienen varchar(50) NULL,
amarillo_cambian varchar(50) NULL,
verde_nuevos varchar(50) NULL,
contraparte int NULL,
idfamilia int NULL,
pedir_doc bit NULL DEFAULT (0),
procesado bit NULL DEFAULT (0),
idreg int IDENTITY,
mail1 varchar(250) NULL
)
ON [PRIMARY]
GO
SINERGIA varchar(50) NULL,
FAMILIA varchar(50) NULL,
CUIT varchar(50) NULL,
GESTION varchar(50) NULL,
RAZON_SOCIAL varchar(150) NULL,
MAIL varchar(250) NULL,
TE varchar(250) NULL,
NOMBRE_CONTACTO varchar(250) NULL,
PIC varchar(150) NULL,
TC varchar(150) NULL,
HOMOLOGADO varchar(150) NULL,
Comentarios varchar(250) NULL,
CLASIFICACION_2021 varchar(150) NULL,
naranja_mantienen varchar(50) NULL,
amarillo_cambian varchar(50) NULL,
verde_nuevos varchar(50) NULL,
contraparte int NULL,
idfamilia int NULL,
pedir_doc bit NULL DEFAULT (0),
procesado bit NULL DEFAULT (0),
idreg int IDENTITY,
mail1 varchar(250) NULL
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas
Used By
No items found