dbo.fide_tipos

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	Identity	Computed	Persisted
f_tipo_doc	int	4	10	True	1 - 1	False	False
f_nombre_tipo_doc	varchar	200	0	True		False	False
f_descripcion	varchar		0	False		False	False
f_tipo_vencimiento	varchar	1	0	False		False	False
f_modalidad	varchar	1	0	False		False	False
f_periodicidad	varchar	1	0	False		False	False
f_tolerancia	tinyint	1	3	False		False	False
f_preaviso	tinyint	1	3	False		False	False
f_dias_vigencia	smallint	2	5	False		False	False
f_dia	tinyint	1	3	False		False	False
f_mes	tinyint	1	3	False		False	False
country_code	varchar	2	0	False		False	False
cliente	int	4	10	False		False	False
requiere_upload	bit	1	1	True		False	False
es_balance	bit	1	1	True		False	False
es_informe_comercial	bit	1	1	True		False	False
activo	bit	1	1	True		False	False

SQL Script

Copy

CREATE TABLE dbo.fide_tipos_doc (
  f_tipo_doc int IDENTITY,
  f_nombre_tipo_doc varchar(200) NOT NULL,
  f_descripcion varchar(max) NULL,
  f_tipo_vencimiento varchar(1) NULL,
  f_modalidad varchar(1) NULL,
  f_periodicidad varchar(1) NULL,
  f_tolerancia tinyint NULL,
  f_preaviso tinyint NULL,
  f_dias_vigencia smallint NULL,
  f_dia tinyint NULL,
  f_mes tinyint NULL,
  country_code varchar(2) NULL,
  cliente int NULL,
  requiere_upload bit NOT NULL,
  es_balance bit NOT NULL,
  es_informe_comercial bit NOT NULL,
  activo bit NOT NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found