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:55 PM |
| Last Modified | 3/6/2025 6:55:57 PM |
Columns
19| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| documento | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| sexo | varchar | 1 | 0 | 0 | False |
(NULL) | False |
False |
||||
| nombre | varchar | 100 | 0 | 0 | False |
(NULL) | False |
False |
||||
| direccion | varchar | 100 | 0 | 0 | False |
(NULL) | False |
False |
||||
| localidad | varchar | 50 | 0 | 0 | False |
(NULL) | False |
False |
||||
| cpostal | varchar | 4 | 0 | 0 | False |
(NULL) | False |
False |
||||
| provincia | varchar | 25 | 0 | 0 | False |
(NULL) | False |
False |
||||
| celular | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| telfijo | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| producto | varchar | 10 | 0 | 0 | False |
(NULL) | False |
False |
||||
| debito | varchar | 10 | 0 | 0 | False |
(NULL) | False |
False |
||||
| precio | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| recarga1 | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| recarga2 | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| recarga3 | varchar | 20 | 0 | 0 | False |
(NULL) | False |
False |
||||
| recarga4 | varchar | 20 | 0 | 0 | True |
(NULL) | False |
False |
||||
| cuit | varchar | 20 | 0 | 0 | False |
False |
False |
|||||
| id_movistar | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
||||
| _domicilios_proc | tinyint | 1 | 3 | 0 | False |
False |
False |
SQL Script
Copy
CREATE TABLE dbo.te_movistar_temp (
documento varchar(20) NULL CONSTRAINT DF__te_movist__docum__5419C19F DEFAULT (NULL),
sexo varchar(1) NULL CONSTRAINT DF__te_movista__sexo__550DE5D8 DEFAULT (NULL),
nombre varchar(100) NULL CONSTRAINT DF__te_movist__nombr__56020A11 DEFAULT (NULL),
direccion varchar(100) NULL CONSTRAINT DF__te_movist__direc__56F62E4A DEFAULT (NULL),
localidad varchar(50) NULL CONSTRAINT DF__te_movist__local__57EA5283 DEFAULT (NULL),
cpostal varchar(4) NULL CONSTRAINT DF__te_movist__cpost__58DE76BC DEFAULT (NULL),
provincia varchar(25) NULL CONSTRAINT DF__te_movist__provi__59D29AF5 DEFAULT (NULL),
celular varchar(20) NULL CONSTRAINT DF__te_movist__celul__5AC6BF2E DEFAULT (NULL),
telfijo varchar(20) NULL CONSTRAINT DF__te_movist__telfi__5BBAE367 DEFAULT (NULL),
producto varchar(10) NULL CONSTRAINT DF__te_movist__produ__5CAF07A0 DEFAULT (NULL),
debito varchar(10) NULL CONSTRAINT DF__te_movist__debit__5DA32BD9 DEFAULT (NULL),
precio varchar(20) NULL CONSTRAINT DF__te_movist__preci__5E975012 DEFAULT (NULL),
recarga1 varchar(20) NULL CONSTRAINT DF__te_movist__recar__5F8B744B DEFAULT (NULL),
recarga2 varchar(20) NULL CONSTRAINT DF__te_movist__recar__607F9884 DEFAULT (NULL),
recarga3 varchar(20) NULL CONSTRAINT DF__te_movist__recar__6173BCBD DEFAULT (NULL),
recarga4 varchar(20) NOT NULL CONSTRAINT DF__te_movist__recar__6267E0F6 DEFAULT (NULL),
cuit varchar(20) NULL,
id_movistar int IDENTITY,
_domicilios_proc tinyint NULL
)
ON [PRIMARY]
GO
documento varchar(20) NULL CONSTRAINT DF__te_movist__docum__5419C19F DEFAULT (NULL),
sexo varchar(1) NULL CONSTRAINT DF__te_movista__sexo__550DE5D8 DEFAULT (NULL),
nombre varchar(100) NULL CONSTRAINT DF__te_movist__nombr__56020A11 DEFAULT (NULL),
direccion varchar(100) NULL CONSTRAINT DF__te_movist__direc__56F62E4A DEFAULT (NULL),
localidad varchar(50) NULL CONSTRAINT DF__te_movist__local__57EA5283 DEFAULT (NULL),
cpostal varchar(4) NULL CONSTRAINT DF__te_movist__cpost__58DE76BC DEFAULT (NULL),
provincia varchar(25) NULL CONSTRAINT DF__te_movist__provi__59D29AF5 DEFAULT (NULL),
celular varchar(20) NULL CONSTRAINT DF__te_movist__celul__5AC6BF2E DEFAULT (NULL),
telfijo varchar(20) NULL CONSTRAINT DF__te_movist__telfi__5BBAE367 DEFAULT (NULL),
producto varchar(10) NULL CONSTRAINT DF__te_movist__produ__5CAF07A0 DEFAULT (NULL),
debito varchar(10) NULL CONSTRAINT DF__te_movist__debit__5DA32BD9 DEFAULT (NULL),
precio varchar(20) NULL CONSTRAINT DF__te_movist__preci__5E975012 DEFAULT (NULL),
recarga1 varchar(20) NULL CONSTRAINT DF__te_movist__recar__5F8B744B DEFAULT (NULL),
recarga2 varchar(20) NULL CONSTRAINT DF__te_movist__recar__607F9884 DEFAULT (NULL),
recarga3 varchar(20) NULL CONSTRAINT DF__te_movist__recar__6173BCBD DEFAULT (NULL),
recarga4 varchar(20) NOT NULL CONSTRAINT DF__te_movist__recar__6267E0F6 DEFAULT (NULL),
cuit varchar(20) NULL,
id_movistar int IDENTITY,
_domicilios_proc tinyint NULL
)
ON [PRIMARY]
GO
Depends On
1- FideDoc
Used By
No items found