dbo.Facturacion

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	Scale	Not Null	Computed	Persisted
cliente	int	4	10	0	False	False	False
cli_codigo	int	4	10	0	False	False	False
fac_comprobante	char	3	0	0	False	False	False
fac_masiva_libre	char	1	0	0	False	False	False
fac_periodo	varchar	7	0	0	False	False	False
fac_tipo_pedido	char	1	0	0	False	False	False
fac_nro_pedido	int	4	10	0	False	False	False
fac_tipo_factura	char	1	0	0	False	False	False
fac_nro_factura_1	smallint	2	5	0	False	False	False
fac_nro_factura	int	4	10	0	False	False	False
fac_fecha_fact	date	3	10	0	False	False	False
fac_fecha_vto	date	3	10	0	False	False	False
fac_neto	decimal	9	16	2	False	False	False
fac_iva_1	decimal	9	16	2	False	False	False
fac_iva_2	decimal	9	16	2	False	False	False
fac_total	decimal	9	16	2	False	False	False
fac_no_catego	decimal	9	16	2	False	False	False
fac_texto	varchar	1000	0	0	False	False	False
fac_marca_pago	varchar	2	0	0	False	False	False
created_by	int	4	10	0	False	False	False
created	datetime	8	23	3	False	False	False

SQL Script

Copy

CREATE TABLE dbo.Facturacion_enc (
  cliente int NULL,
  cli_codigo int NULL,
  fac_comprobante char(3) NULL,
  fac_masiva_libre char(1) NULL,
  fac_periodo varchar(7) NULL,
  fac_tipo_pedido char(1) NULL,
  fac_nro_pedido int NULL,
  fac_tipo_factura char(1) NULL,
  fac_nro_factura_1 smallint NULL,
  fac_nro_factura int NULL,
  fac_fecha_fact date NULL,
  fac_fecha_vto date NULL,
  fac_neto decimal(16, 2) NULL,
  fac_iva_1 decimal(16, 2) NULL,
  fac_iva_2 decimal(16, 2) NULL,
  fac_total decimal(16, 2) NULL,
  fac_no_catego decimal(16, 2) NULL,
  fac_texto varchar(1000) NULL,
  fac_marca_pago varchar(2) NULL,
  created_by int NULL,
  created datetime NULL
)
ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found