dbo.led_planes

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 (~)	33205
Created	7/27/2021 5:17:48 PM
Last Modified	8/3/2021 2:32:58 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
id_plan	int	4	10	0	True	1 - 1		False	False
doc_id	bigint	8	19	0	True			False	False
nro_plan	int	4	10	0	True			False	False
cant_cuotas	smallint	2	5	0	True			False	False
fecha_consolidacion	date	3	10	0	True			False	False
concepto_consolidado	varchar	20	0	0	True			False	False
periodo_consolidado	varchar	10	0	0	True			False	False
monto_total	decimal	9	15	2	True			False	False
importe_cuota	decimal	9	15	2	True			False	False
cuotas_canceladas	smallint	2	5	0	True			False	False
importe_cancelado	decimal	9	15	2	True			False	False
adjunto1	varchar	100	0	0	False			False	False
adjunto2	varchar	100	0	0	False			False	False
adjunto3	varchar	100	0	0	False			False	False
adjunto4	varchar	100	0	0	False			False	False
created	datetime	8	23	3	False		(getdate())	False	False
created_by	int	4	10	0	False			False	False
modified	datetime	8	23	3	False			False	False
modified_by	int	4	10	0	False			False	False
estado	varchar	1	0	0	False			False	False
fecha_vigencia	date	3	10	0	False			False	False

SQL Script

Copy

CREATE TABLE dbo.led_planes_pagos (
  id_plan int IDENTITY,
  doc_id bigint NOT NULL,
  nro_plan int NOT NULL,
  cant_cuotas smallint NOT NULL,
  fecha_consolidacion date NOT NULL,
  concepto_consolidado varchar(20) NOT NULL,
  periodo_consolidado varchar(10) NOT NULL,
  monto_total decimal(15, 2) NOT NULL,
  importe_cuota decimal(15, 2) NOT NULL,
  cuotas_canceladas smallint NOT NULL,
  importe_cancelado decimal(15, 2) NOT NULL,
  adjunto1 varchar(100) NULL,
  adjunto2 varchar(100) NULL,
  adjunto3 varchar(100) NULL,
  adjunto4 varchar(100) NULL,
  created datetime NULL DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  estado varchar(1) NULL,
  fecha_vigencia date NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.led_planes_pagos

Description

Properties

Columns

SQL Script

Depends On

Used By