dbo.ChequesBCRA

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	1/17/2018 11:29:36 AM
Last Modified	5/11/2020 7:23:49 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_cheque	int	4	10	0	True	1 - 1	False	False
cuit_firmante	varchar	11	0	0	False		False	False
cuit_relacionado	varchar	11	0	0	False		False	False
nro_cheque	int	4	10	0	False		False	False
fecha_rechazo	smalldatetime	4	16	0	True		False	False
importe	money	8	19	4	True		False	False
id_causa	smallint	2	5	0	False		False	False
fecha_levantamiento	smalldatetime	4	16	0	False		False	False
fecha_pago	smalldatetime	4	16	0	False		False	False
fecha_baja	date	3	10	0	False		False	False
procesado	char	1	0	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	ChequesBCRABajasID	id_cheque	False

SQL Script

Copy

CREATE TABLE dbo.ChequesBCRA_bajas (
  id_cheque int IDENTITY,
  cuit_firmante varchar(11) NULL,
  cuit_relacionado varchar(11) NULL,
  nro_cheque int NULL,
  fecha_rechazo smalldatetime NOT NULL,
  importe money NOT NULL,
  id_causa smallint NULL,
  fecha_levantamiento smalldatetime NULL,
  fecha_pago smalldatetime NULL,
  fecha_baja date NULL,
  procesado char(1) NULL
)
ON [PRIMARY]
GO

CREATE INDEX ChequesBCRABajasID
  ON dbo.ChequesBCRA_bajas (id_cheque)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.ChequesBCRA_bajas