dbo.fide_detail

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 (~)	20
Created	9/4/2023 12:41:59 PM
Last Modified	9/4/2023 12:41:59 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Identity	Computed	Persisted
id_pedido_fidelitas	int	4	10	0	True		False	False
item	tinyint	1	3	0	True		False	False
cod_producto	varchar	4	0	0	True		False	False
texto_factura_1	varchar	30	0	0	True		False	False
texto_factura_2	varchar	20	0	0	True		False	False
unidades	int	4	10	0	True		False	False
importe_unidad	decimal	9	12	4	True		False	False
importe_unidades_item	decimal	9	12	4	True		False	False
porc_dto_item	decimal	5	5	2	False		False	False
importe_dto_item	decimal	9	12	4	True		False	False
importe_iva_item	decimal	9	12	4	True		False	False
importe_neto_item	decimal	9	12	4	True		False	False
importe_con_iva_b	decimal	9	12	4	True		False	False
fiderow	int	4	10	0	True	1 - 1	False	False
procesado	varchar	1	0	0	False		False	False

SQL Script

Copy

CREATE TABLE dbo.fide_detail_tango (
  id_pedido_fidelitas int NOT NULL,
  item tinyint NOT NULL,
  cod_producto varchar(4) NOT NULL,
  texto_factura_1 varchar(30) NOT NULL,
  texto_factura_2 varchar(20) NOT NULL,
  unidades int NOT NULL,
  importe_unidad decimal(12, 4) NOT NULL,
  importe_unidades_item decimal(12, 4) NOT NULL,
  porc_dto_item decimal(5, 2) NULL,
  importe_dto_item decimal(12, 4) NOT NULL,
  importe_iva_item decimal(12, 4) NOT NULL,
  importe_neto_item decimal(12, 4) NOT NULL,
  importe_con_iva_b decimal(12, 4) NOT NULL,
  fiderow int IDENTITY,
  procesado varchar(1) NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

dbo.fide_detail_tango

Description

Properties

Columns

SQL Script

Depends On

Used By