dbo.FACTURAS_201809_A

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

Columns

Name	Data Type	Length	Precision	Not Null	Computed	Persisted
cuit_cliente	varchar	20	0	False	False	False
nombre_cliente	varchar	250	0	False	False	False
cli_codigo	numeric	9	18	False	False	False
Comprobante	varchar	10	0	False	False	False
auto_libre	varchar	10	0	False	False	False
period	varchar	50	0	False	False	False
tipo_factura	varchar	1	0	False	False	False
nro1_factura	numeric	9	18	False	False	False
nro2_factura	numeric	9	18	False	False	False
fecha_factura	varchar	50	0	False	False	False
fecha_vto	varchar	50	0	False	False	False
fac_neto	real	4	24	False	False	False
fac_iva_1	real	4	24	False	False	False
fac_iva_2	real	4	24	False	False	False
fac_total	real	4	24	False	False	False
fac_marca_pago	varchar	10	0	False	False	False
cliente	int	4	10	False	False	False

SQL Script

Copy

CREATE TABLE dbo.FACTURAS_201809_A_202004 (
  cuit_cliente varchar(20) NULL,
  nombre_cliente varchar(250) NULL,
  cli_codigo numeric NULL,
  Comprobante varchar(10) NULL,
  auto_libre varchar(10) NULL,
  period varchar(50) NULL,
  tipo_factura varchar(1) NULL,
  nro1_factura numeric NULL,
  nro2_factura numeric NULL,
  fecha_factura varchar(50) NULL,
  fecha_vto varchar(50) NULL,
  fac_neto real NULL,
  fac_iva_1 real NULL,
  fac_iva_2 real NULL,
  fac_total real NULL,
  fac_marca_pago varchar(10) NULL,
  cliente int NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found