dbo.balances

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

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	13	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
monedaifx	smallint	2	5	0	False			False	False
ejercicio	int	4	10	0	False			False	False
periodo	smallint	2	5	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
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_bieuso	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_bieusovo	decimal	13	20	2	False			False	False
anc_depacu	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
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
res_vtanet	decimal	13	20	2	False			False	False
res_cosmer	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_otros	decimal	13	20	2	False			False	False
res_resinv	decimal	13	20	2	False			False	False
res_ie	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
res_noasig	decimal	13	20	2	False			False	False
res_compras	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
amortiza	decimal	13	20	2	False			False	False
capsoc	decimal	13	20	2	False			False	False
ajucap	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			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		(1)	False	False
id_padron	int	4	10	0	False			False	False
moneda	varchar	3	0	0	False			False	False

Indexes

Key	Name	Columns	Unique	Type	Description
	PK__balances__D826D76B52567ABE	id_balance	True

SQL Script

Copy

CREATE TABLE dbo.balances_fide (
  id_balance int IDENTITY,
  cuit varchar(13) NULL,
  codigo int NULL,
  fecha_balance date NULL,
  bal_manifestacion varchar(1) NULL,
  monedaifx smallint NULL,
  ejercicio int NULL,
  periodo smallint 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,
  anc_crevta decimal(20, 2) NULL,
  anc_otrcre decimal(20, 2) NULL,
  anc_inver decimal(20, 2) NULL,
  anc_bieuso decimal(20, 2) NULL,
  anc_actint decimal(20, 2) NULL,
  anc_otract decimal(20, 2) NULL,
  anc_bieusovo decimal(20, 2) NULL,
  anc_depacu 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,
  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,
  res_vtanet decimal(20, 2) NULL,
  res_cosmer decimal(20, 2) NULL,
  res_gascom decimal(20, 2) NULL,
  res_gasadm decimal(20, 2) NULL,
  res_gasfin decimal(20, 2) NULL,
  res_otros decimal(20, 2) NULL,
  res_resinv decimal(20, 2) NULL,
  res_ie decimal(20, 2) NULL,
  res_resfin decimal(20, 2) NULL,
  res_iva decimal(20, 2) NULL,
  res_noasig decimal(20, 2) NULL,
  res_compras decimal(20, 2) NULL,
  res_otrosing decimal(20, 2) NULL,
  res_otrosegr decimal(20, 2) NULL,
  amortiza decimal(20, 2) NULL,
  capsoc decimal(20, 2) NULL,
  ajucap decimal(20, 2) NULL,
  fecha_act date NULL,
  usuario varchar(8) NULL,
  idifx int NULL,
  created datetime NULL,
  created_by int NULL,
  modified datetime NULL,
  modified_by int NULL,
  visible bit NULL CONSTRAINT DF_balance_visible DEFAULT (1),
  id_padron int NULL,
  moneda varchar(3) NULL,
  PRIMARY KEY NONCLUSTERED (id_balance) WITH (FILLFACTOR = 20)
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found