dbo.LN_limite

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:54 PM
Last Modified	3/6/2025 6:55:56 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Default	Computed	Persisted
contraparte	int	4	10	0	True		False	False
gestion	int	4	10	0	True		False	False
post_activo_caja_bancos	decimal	13	20	2	False		False	False
post_activo_inversiones	decimal	13	20	2	False		False	False
post_activo_corriente	decimal	13	20	2	False		False	False
post_activo_total	decimal	13	20	2	False		False	False
post_pasivo_corriente	decimal	13	20	2	False		False	False
post_prestamos_corrientes	decimal	13	20	2	False		False	False
post_prestamos_no_corrientes	decimal	13	20	2	False		False	False
post_pasivo_total	decimal	13	20	2	False		False	False
post_patrimonio	decimal	13	20	2	False		False	False
post_resultados_acumulados	decimal	13	20	2	False		False	False
post_ventas	decimal	13	20	2	False		False	False
post_compras	decimal	13	20	2	False		False	False
post_ganancia	decimal	13	20	2	False		False	False
post_ebitda	decimal	13	20	2	False		False	False
post_otros_ingresos	decimal	13	20	2	False		False	False
post_otros_egresos	decimal	13	20	2	False		False	False
post_patrimonio_integrado	decimal	13	20	2	False		False	False
post_capital_trabajo	decimal	13	20	2	False		False	False
post_rel_capital_trabajo_pasivo	decimal	13	20	2	False		False	False
post_rel_capital_trabajo_ventas	decimal	13	20	2	False		False	False
post_rel_compras_ventas	decimal	13	20	2	False		False	False
post_rentabilidad_final	decimal	13	20	2	False		False	False
post_resultado_operativo	decimal	13	20	2	False		False	False
post_rentabilidad_operativa	decimal	13	20	2	False		False	False
post_rel_ebitda_ventas	decimal	13	20	2	False		False	False
post_fondos	decimal	13	20	2	False		False	False
maximo_recomendado	decimal	13	20	2	False		False	False
ultimo_aprobado	decimal	13	20	2	False		False	False
ultimo_aprobado_fecha	date	3	10	0	False		False	False
recomendacion	text		0	0	False		False	False
ultimo_aprobado_usd	decimal	13	20	2	False		False	False
ultimo_aprobado_usd_fecha	date	3	10	0	False		False	False
visible	bit	1	1	0	False	(0)	False	False
informe	int	4	10	0	False		False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__LN_limit__3CEA362C957B3091	contraparte, gestion	True

SQL Script

Copy

CREATE TABLE dbo.LN_limite_credito (
  contraparte int NOT NULL,
  gestion int NOT NULL,
  post_activo_caja_bancos decimal(20, 2) NULL,
  post_activo_inversiones decimal(20, 2) NULL,
  post_activo_corriente decimal(20, 2) NULL,
  post_activo_total decimal(20, 2) NULL,
  post_pasivo_corriente decimal(20, 2) NULL,
  post_prestamos_corrientes decimal(20, 2) NULL,
  post_prestamos_no_corrientes decimal(20, 2) NULL,
  post_pasivo_total decimal(20, 2) NULL,
  post_patrimonio decimal(20, 2) NULL,
  post_resultados_acumulados decimal(20, 2) NULL,
  post_ventas decimal(20, 2) NULL,
  post_compras decimal(20, 2) NULL,
  post_ganancia decimal(20, 2) NULL,
  post_ebitda decimal(20, 2) NULL,
  post_otros_ingresos decimal(20, 2) NULL,
  post_otros_egresos decimal(20, 2) NULL,
  post_patrimonio_integrado decimal(20, 2) NULL,
  post_capital_trabajo decimal(20, 2) NULL,
  post_rel_capital_trabajo_pasivo decimal(20, 2) NULL,
  post_rel_capital_trabajo_ventas decimal(20, 2) NULL,
  post_rel_compras_ventas decimal(20, 2) NULL,
  post_rentabilidad_final decimal(20, 2) NULL,
  post_resultado_operativo decimal(20, 2) NULL,
  post_rentabilidad_operativa decimal(20, 2) NULL,
  post_rel_ebitda_ventas decimal(20, 2) NULL,
  post_fondos decimal(20, 2) NULL,
  maximo_recomendado decimal(20, 2) NULL,
  ultimo_aprobado decimal(20, 2) NULL,
  ultimo_aprobado_fecha date NULL,
  recomendacion text NULL,
  ultimo_aprobado_usd decimal(20, 2) NULL,
  ultimo_aprobado_usd_fecha date NULL,
  visible bit NULL DEFAULT (0),
  informe int NULL,
  PRIMARY KEY NONCLUSTERED (contraparte, gestion) WITH (FILLFACTOR = 80)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found