dbo.balances_contables

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 (~)	102177
Created	4/11/2017 11:30:07 AM
Last Modified	10/15/2024 10:59:34 AM

Columns

108

Key	Name	Data Type	Length	Precision	Scale	Not Null	Identity	Default	Computed	Persisted
	id_balance	int	4	10	0	True	1 - 1		False	False
	cuit	varchar	50	0	0	False			False	False
	codigo	int	4	10	0	False			False	False
	fecha_balance	date	3	10	0	False			False	False
	bal_manifestacion	varchar	1	0	0	False			False	False
	ejercicio	int	4	10	0	False			False	False
	periodo	smallint	2	5	0	False			False	False
	monedaifx	smallint	2	5	0	False			False	False
	moneda	varchar	3	0	0	False			False	False
	ac_cajban	decimal	13	20	2	False			False	False
	ac_inver	decimal	13	20	2	False			False	False
	ac_crevta	decimal	13	20	2	False			False	False
	ac_otrcre	decimal	13	20	2	False			False	False
	ac_biecam	decimal	13	20	2	False			False	False
	ac_otract	decimal	13	20	2	False			False	False
	ac_bietan	decimal	13	20	2	False			False	False
	ac_total	decimal	13	20	2	False			False	False
	anc_crevta	decimal	13	20	2	False			False	False
	anc_otrcre	decimal	13	20	2	False			False	False
	anc_inver	decimal	13	20	2	False			False	False
	anc_actint	decimal	13	20	2	False			False	False
	anc_otract	decimal	13	20	2	False			False	False
	anc_bieuso	decimal	13	20	2	False			False	False
	anc_bieusovo	decimal	13	20	2	False			False	False
	anc_depacu	decimal	13	20	2	False			False	False
	anc_total	decimal	13	20	2	False			False	False
	act_total	decimal	13	20	2	False			False	False
	pc_ctapag	decimal	13	20	2	False			False	False
	pc_presta	decimal	13	20	2	False			False	False
	pc_remune	decimal	13	20	2	False			False	False
	pc_carfis	decimal	13	20	2	False			False	False
	pc_antcli	decimal	13	20	2	False			False	False
	pc_otrpas	decimal	13	20	2	False			False	False
	pc_total	decimal	13	20	2	False			False	False
	pnc_cuepag	decimal	13	20	2	False			False	False
	pnc_previ	decimal	13	20	2	False			False	False
	pnc_presta	decimal	13	20	2	False			False	False
	pnc_otrpas	decimal	13	20	2	False			False	False
	pnc_deufis	decimal	13	20	2	False			False	False
	pnc_total	decimal	13	20	2	False			False	False
	pas_total	decimal	13	20	2	False			False	False
	capsoc	decimal	13	20	2	False			False	False
	resacu	decimal	13	20	2	False			False	False
	res_noasig	decimal	13	20	2	False			False	False
	patrimonio	decimal	13	20	2	False			False	False
	res_vtanet	decimal	13	20	2	False			False	False
	res_compras	decimal	13	20	2	False			False	False
	res_cosmer	decimal	13	20	2	False			False	False
	amortiza	decimal	13	20	2	False			False	False
	res_gascom	decimal	13	20	2	False			False	False
	res_gasadm	decimal	13	20	2	False			False	False
	res_gasfin	decimal	13	20	2	False			False	False
	res_otrosing	decimal	13	20	2	False			False	False
	res_otrosegr	decimal	13	20	2	False			False	False
	res_resfin	decimal	13	20	2	False			False	False
	res_iva	decimal	13	20	2	False			False	False
	ganancia	decimal	13	20	2	False			False	False
	ebitda	decimal	13	20	2	False			False	False
	ajucap	decimal	13	20	2	False			False	False
	notas	text		0	0	False			False	False
	comentarios	text		0	0	False			False	False
	ind_liqcorr	decimal	13	20	2	False			False	False
	ind_liqseca	decimal	13	20	2	False			False	False
	ind_endeu	decimal	13	20	2	False			False	False
	ind_solvencia	decimal	13	20	2	False			False	False
	ind_endeuact	decimal	13	20	2	False			False	False
	ind_captra	decimal	13	20	2	False			False	False
	ind_cappro	decimal	13	20	2	False			False	False
	ind_invbu	decimal	13	20	2	False			False	False
	ind_inmact	decimal	13	20	2	False			False	False
	ind_inmpat	decimal	13	20	2	False			False	False
	ind_marbru	decimal	13	20	2	False			False	False
	ind_utilfin	decimal	13	20	2	False			False	False
	ind_retpat	decimal	13	20	2	False			False	False
	ind_rotvta	decimal	13	20	2	False			False	False
	ind_rotvta_dias	decimal	13	20	2	False			False	False
	ind_rotact	decimal	13	20	2	False			False	False
	ind_rotact_dias	decimal	13	20	2	False			False	False
	ind_rentabilidad	decimal	13	20	2	False			False	False
	ind_indrot	decimal	13	20	2	False			False	False
	ind_indrot_dias	decimal	13	20	2	False			False	False
	ind_rotinv	decimal	13	20	2	False			False	False
	ind_rotinv_dias	decimal	13	20	2	False			False	False
	ind_prest_pn	decimal	13	20	2	False			False	False
	ind_prest_vtas	decimal	13	20	2	False			False	False
	ind_solvencia_pat	decimal	13	20	2	False			False	False
	fecha_act	date	3	10	0	False			False	False
	usuario	varchar	8	0	0	False			False	False
	idifx	int	4	10	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
	visible	bit	1	1	0	False			False	False
2	estado	varchar	50	0	0	False			False	False
	id_padron	int	4	10	0	False			False	False
	ind_ebipas	decimal	13	20	2	False			False	False
	task_id	bigint	8	19	0	False			False	False
	resacu_ant	decimal	13	20	2	False			False	False
	res_noasig_ant	decimal	13	20	2	False			False	False
	ruta_archivo	varchar	200	0	0	False			False	False
	valoracion	smallint	2	5	0	False			False	False
	res_fin_cash	decimal	13	20	2	False			False	False
	res_fin_no_cash	decimal	13	20	2	False			False	False
	rec_pam	decimal	13	20	2	False			False	False
	comentarios_eng	text		0	0	False			False	False
	cargar_datos	bit	1	1	0	False		(1)	False	False
	nominal_ajustado	char	1	0	0	False			False	False

Indexes

Name	Columns	Unique
idx_balances_contables_estado_fecha_bal_ganancia_inccuit	estado, fecha_balance, ganancia	False
idx_balances_contables_estado_iccuit_fechabal	estado	False
idx_balancescont_cuit_visible	cuit, visible	False
idx_balancescont_task	task_id	False
PK__balances__D826D76B2EF69624	id_balance	True

SQL Script

Copy

CREATE TABLE dbo.balances_contables (
  id_balance int IDENTITY,
  cuit varchar(50) NULL,
  codigo int NULL,
  fecha_balance date NULL,
  bal_manifestacion varchar(1) NULL,
  ejercicio int NULL,
  periodo smallint NULL,
  monedaifx smallint NULL,
  moneda varchar(3) NULL,
  ac_cajban decimal(20, 2) NULL,
  ac_inver decimal(20, 2) NULL,
  ac_crevta decimal(20, 2) NULL,
  ac_otrcre decimal(20, 2) NULL,
  ac_biecam decimal(20, 2) NULL,
  ac_otract decimal(20, 2) NULL,
  ac_bietan decimal(20, 2) NULL,
  ac_total decimal(20, 2) NULL,
  anc_crevta decimal(20, 2) NULL,
  anc_otrcre decimal(20, 2) NULL,
  anc_inver decimal(20, 2) NULL,
  anc_actint decimal(20, 2) NULL,
  anc_otract decimal(20, 2) NULL,
  anc_bieuso decimal(20, 2) NULL,
  anc_bieusovo decimal(20, 2) NULL,
  anc_depacu decimal(20, 2) NULL,
  anc_total decimal(20, 2) NULL,
  act_total decimal(20, 2) NULL,
  pc_ctapag decimal(20, 2) NULL,
  pc_presta decimal(20, 2) NULL,
  pc_remune decimal(20, 2) NULL,
  pc_carfis decimal(20, 2) NULL,
  pc_antcli decimal(20, 2) NULL,
  pc_otrpas decimal(20, 2) NULL,
  pc_total decimal(20, 2) NULL,
  pnc_cuepag decimal(20, 2) NULL,
  pnc_previ decimal(20, 2) NULL,
  pnc_presta decimal(20, 2) NULL,
  pnc_otrpas decimal(20, 2) NULL,
  pnc_deufis decimal(20, 2) NULL,
  pnc_total decimal(20, 2) NULL,
  pas_total decimal(20, 2) NULL,
  capsoc decimal(20, 2) NULL,
  resacu decimal(20, 2) NULL,
  res_noasig decimal(20, 2) NULL,
  patrimonio decimal(20, 2) NULL,
  res_vtanet decimal(20, 2) NULL,
  res_compras decimal(20, 2) NULL,
  res_cosmer decimal(20, 2) NULL,
  amortiza decimal(20, 2) NULL,
  res_gascom decimal(20, 2) NULL,
  res_gasadm decimal(20, 2) NULL,
  res_gasfin decimal(20, 2) NULL,
  res_otrosing decimal(20, 2) NULL,
  res_otrosegr decimal(20, 2) NULL,
  res_resfin decimal(20, 2) NULL,
  res_iva decimal(20, 2) NULL,
  ganancia decimal(20, 2) NULL,
  ebitda decimal(20, 2) NULL,
  ajucap decimal(20, 2) NULL,
  notas text NULL,
  comentarios text NULL,
  ind_liqcorr decimal(20, 2) NULL,
  ind_liqseca decimal(20, 2) NULL,
  ind_endeu decimal(20, 2) NULL,
  ind_solvencia decimal(20, 2) NULL,
  ind_endeuact decimal(20, 2) NULL,
  ind_captra decimal(20, 2) NULL,
  ind_cappro decimal(20, 2) NULL,
  ind_invbu decimal(20, 2) NULL,
  ind_inmact decimal(20, 2) NULL,
  ind_inmpat decimal(20, 2) NULL,
  ind_marbru decimal(20, 2) NULL,
  ind_utilfin decimal(20, 2) NULL,
  ind_retpat decimal(20, 2) NULL,
  ind_rotvta decimal(20, 2) NULL,
  ind_rotvta_dias decimal(20, 2) NULL,
  ind_rotact decimal(20, 2) NULL,
  ind_rotact_dias decimal(20, 2) NULL,
  ind_rentabilidad decimal(20, 2) NULL,
  ind_indrot decimal(20, 2) NULL,
  ind_indrot_dias decimal(20, 2) NULL,
  ind_rotinv decimal(20, 2) NULL,
  ind_rotinv_dias decimal(20, 2) NULL,
  ind_prest_pn decimal(20, 2) NULL,
  ind_prest_vtas decimal(20, 2) NULL,
  ind_solvencia_pat decimal(20, 2) NULL,
  fecha_act date NULL,
  usuario varchar(8) NULL,
  idifx int NULL,
  created datetime NULL CONSTRAINT DF_balances_contables_created DEFAULT (getdate()),
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  visible bit NULL,
  estado varchar(50) NULL,
  id_padron int NULL,
  ind_ebipas decimal(20, 2) NULL,
  task_id bigint NULL,
  resacu_ant decimal(20, 2) NULL,
  res_noasig_ant decimal(20, 2) NULL,
  ruta_archivo varchar(200) NULL,
  valoracion smallint NULL,
  res_fin_cash decimal(20, 2) NULL,
  res_fin_no_cash decimal(20, 2) NULL,
  rec_pam decimal(20, 2) NULL,
  comentarios_eng text NULL,
  cargar_datos bit NULL CONSTRAINT df_cargar_datos DEFAULT (1),
  nominal_ajustado char(1) NULL,
  PRIMARY KEY NONCLUSTERED (id_balance) WITH (FILLFACTOR = 20)
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE INDEX idx_balances_contables_estado_fecha_bal_ganancia_inccuit
  ON dbo.balances_contables (estado, fecha_balance, ganancia)
  INCLUDE (cuit)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_balances_contables_estado_iccuit_fechabal
  ON dbo.balances_contables (estado)
  INCLUDE (cuit, fecha_balance)
  WITH (FILLFACTOR = 80)
  ON [PRIMARY]
GO

CREATE INDEX idx_balancescont_cuit_visible
  ON dbo.balances_contables (cuit, visible)
  WITH (FILLFACTOR = 20)
  ON [PRIMARY]
GO

CREATE INDEX idx_balancescont_task
  ON dbo.balances_contables (task_id)
  WITH (FILLFACTOR = 20)
  ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

147