dbo.cliente_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 (~)	425
Created	9/8/2023 1:00:10 PM
Last Modified	9/8/2023 1:15:38 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Default	Computed	Persisted
cliente	int	4	10	0	False		False	False
cli_codigo	int	4	10	0	False		False	False
lista	int	4	10	0	False		False	False
prod_codigo_viejo	char	3	0	0	False		False	False
producto	int	4	10	0	False		False	False
prod_codigo_facturacion	char	3	0	0	False		False	False
prod_bonif	decimal	5	5	2	False		False	False
prod_bonif_periodo_desde	date	3	10	0	False		False	False
prod_bonif_periodo_hasta	date	3	10	0	False		False	False
prod_car_min	int	4	10	0	False		False	False
created_by	int	4	10	0	False		False	False
created	datetime	8	23	3	False	(getdate())	False	False
modified_by	int	4	10	0	False		False	False
modified	datetime	8	23	3	False		False	False

SQL Script

Copy

CREATE TABLE dbo.cliente_facturacion (
  cliente int NULL,
  cli_codigo int NULL,
  lista int NULL,
  prod_codigo_viejo char(3) NULL,
  producto int NULL,
  prod_codigo_facturacion char(3) NULL,
  prod_bonif decimal(5, 2) NULL,
  prod_bonif_periodo_desde date NULL,
  prod_bonif_periodo_hasta date NULL,
  prod_car_min int NULL,
  created_by int NULL,
  created datetime NULL CONSTRAINT DF_cliente_facturacion_created DEFAULT (getdate()),
  modified_by int NULL,
  modified datetime NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.cliente_facturacion_precios_