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 | 2/14/2018 7:27:25 PM |
| Last Modified | 12/26/2018 4:22:49 PM |
Columns
16| Key | Name | Data Type | Length | Precision | Scale | Not Null | Identity | Rule | Default | Computed | Persisted | Description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| cuit_firmante | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| nro_cheque | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| fecha_rechazo | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| importe | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| id_causa | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| fecha_levantamiento | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| fecha_pago | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| cuit_relacionado | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| visible | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| en_revision | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| multa_no_aplica | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| suspendido | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| created | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| usuarioifx | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| idifx | varchar | 50 | 0 | 0 | False |
False |
False |
|||||
| id_cheque | int | 4 | 10 | 0 | True |
1 - 1 | False |
False |
SQL Script
Copy
CREATE TABLE dbo.CHEQ_RECH_20180214 (
cuit_firmante varchar(50) NULL,
nro_cheque varchar(50) NULL,
fecha_rechazo varchar(50) NULL,
importe varchar(50) NULL,
id_causa varchar(50) NULL,
fecha_levantamiento varchar(50) NULL,
fecha_pago varchar(50) NULL,
cuit_relacionado varchar(50) NULL,
visible varchar(50) NULL,
en_revision varchar(50) NULL,
multa_no_aplica varchar(50) NULL,
suspendido varchar(50) NULL,
created varchar(50) NULL,
usuarioifx varchar(50) NULL,
idifx varchar(50) NULL,
id_cheque int IDENTITY
)
ON [PRIMARY]
GO
cuit_firmante varchar(50) NULL,
nro_cheque varchar(50) NULL,
fecha_rechazo varchar(50) NULL,
importe varchar(50) NULL,
id_causa varchar(50) NULL,
fecha_levantamiento varchar(50) NULL,
fecha_pago varchar(50) NULL,
cuit_relacionado varchar(50) NULL,
visible varchar(50) NULL,
en_revision varchar(50) NULL,
multa_no_aplica varchar(50) NULL,
suspendido varchar(50) NULL,
created varchar(50) NULL,
usuarioifx varchar(50) NULL,
idifx varchar(50) NULL,
id_cheque int IDENTITY
)
ON [PRIMARY]
GO
Depends On
1- Fidelitas