dbo.BALANCES_20170128

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 (~)	1
Created	4/3/2017 10:25:44 AM
Last Modified	4/3/2017 10:25:44 AM

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
cuit	varchar	50	0	False	False	False
codigo	numeric	9	18	False	False	False
fecha_balance	varchar	50	0	False	False	False
bal_manifestacion	varchar	50	0	False	False	False
moneda	varchar	50	0	False	False	False
ejercicio	varchar	50	0	False	False	False
periodo	varchar	50	0	False	False	False
ac_cajban	decimal	13	28	False	False	False
ac_inver	decimal	13	28	False	False	False
ac_crevta	decimal	13	28	False	False	False
ac_otrcre	decimal	13	28	False	False	False
ac_biecam	decimal	13	28	False	False	False
ac_otract	decimal	13	28	False	False	False
ac_bietan	decimal	13	28	False	False	False
anc_crevta	decimal	13	28	False	False	False
anc_otrcre	decimal	13	28	False	False	False
anc_inver	decimal	13	28	False	False	False
anc_bieuso	decimal	13	28	False	False	False
anc_actint	decimal	13	28	False	False	False
anc_otract	decimal	13	28	False	False	False
anc_bieusovo	decimal	13	28	False	False	False
anc_depacu	decimal	13	28	False	False	False
pc_ctapag	decimal	13	28	False	False	False
pc_presta	decimal	13	28	False	False	False
pc_remune	decimal	13	28	False	False	False
pc_carfis	decimal	13	28	False	False	False
pc_antcli	decimal	13	28	False	False	False
pc_otrpas	decimal	13	28	False	False	False
pnc_cuepag	decimal	13	28	False	False	False
pnc_previ	decimal	13	28	False	False	False
pnc_presta	decimal	13	28	False	False	False
pnc_otrpas	decimal	13	28	False	False	False
pnc_deufis	decimal	13	28	False	False	False
res_vtanet	decimal	13	28	False	False	False
res_cosmer	decimal	13	28	False	False	False
res_gascom	decimal	13	28	False	False	False
res_gasadm	decimal	13	28	False	False	False
res_gasfin	decimal	13	28	False	False	False
res_otros	decimal	13	28	False	False	False
res_resinv	decimal	13	28	False	False	False
res_ie	decimal	13	28	False	False	False
res_resfin	decimal	13	28	False	False	False
res_iva	decimal	13	28	False	False	False
res_noasig	decimal	13	28	False	False	False
res_compras	decimal	13	28	False	False	False
res_otrosing	decimal	13	28	False	False	False
res_otrosegr	decimal	13	28	False	False	False
amortiza	decimal	13	28	False	False	False
capsoc	decimal	13	28	False	False	False
ajucap	decimal	13	28	False	False	False
fecha_act	varchar	50	0	False	False	False
usuario	varchar	50	0	False	False	False
idifx	varchar	50	0	False	False	False

SQL Script

Copy

CREATE TABLE dbo.BALANCES_20170128 (
  cuit varchar(50) NULL,
  codigo numeric NULL,
  fecha_balance varchar(50) NULL,
  bal_manifestacion varchar(50) NULL,
  moneda varchar(50) NULL,
  ejercicio varchar(50) NULL,
  periodo varchar(50) NULL,
  ac_cajban decimal(28) NULL,
  ac_inver decimal(28) NULL,
  ac_crevta decimal(28) NULL,
  ac_otrcre decimal(28) NULL,
  ac_biecam decimal(28) NULL,
  ac_otract decimal(28) NULL,
  ac_bietan decimal(28) NULL,
  anc_crevta decimal(28) NULL,
  anc_otrcre decimal(28) NULL,
  anc_inver decimal(28) NULL,
  anc_bieuso decimal(28) NULL,
  anc_actint decimal(28) NULL,
  anc_otract decimal(28) NULL,
  anc_bieusovo decimal(28) NULL,
  anc_depacu decimal(28) NULL,
  pc_ctapag decimal(28) NULL,
  pc_presta decimal(28) NULL,
  pc_remune decimal(28) NULL,
  pc_carfis decimal(28) NULL,
  pc_antcli decimal(28) NULL,
  pc_otrpas decimal(28) NULL,
  pnc_cuepag decimal(28) NULL,
  pnc_previ decimal(28) NULL,
  pnc_presta decimal(28) NULL,
  pnc_otrpas decimal(28) NULL,
  pnc_deufis decimal(28) NULL,
  res_vtanet decimal(28) NULL,
  res_cosmer decimal(28) NULL,
  res_gascom decimal(28) NULL,
  res_gasadm decimal(28) NULL,
  res_gasfin decimal(28) NULL,
  res_otros decimal(28) NULL,
  res_resinv decimal(28) NULL,
  res_ie decimal(28) NULL,
  res_resfin decimal(28) NULL,
  res_iva decimal(28) NULL,
  res_noasig decimal(28) NULL,
  res_compras decimal(28) NULL,
  res_otrosing decimal(28) NULL,
  res_otrosegr decimal(28) NULL,
  amortiza decimal(28) NULL,
  capsoc decimal(28) NULL,
  ajucap decimal(28) NULL,
  fecha_act varchar(50) NULL,
  usuario varchar(50) NULL,
  idifx varchar(50) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

No items found