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 (~)	0
Created	3/6/2025 6:55:52 PM
Last Modified	3/6/2025 6:55:55 PM

Columns

108

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
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

Key	Name	Columns	Unique	Type	Description
	PK__balances__D826D76B44A4B20A	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

Depends On

FideDoc

Used By

No items found