dbo.replicated_doc

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 (~)	3188
Created	8/2/2017 1:51:59 PM
Last Modified	8/2/2017 1:51:59 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
IDANT	bigint	8	19	0	True	False	False
PERANT	int	4	10	0	False	False	False
TIPOANT	smallint	2	5	0	False	False	False
contrant	int	4	10	0	False	False	False
empleANT	int	4	10	0	False	False	False
estadoANT	varchar	1	0	0	False	False	False
vigenciANT	datetime2	7	23	3	False	False	False
doc_id	bigint	8	19	0	True	False	False
tipo_doc	smallint	2	5	0	False	False	False
contratista	int	4	10	0	False	False	False
empleado	int	4	10	0	False	False	False
periodo	int	4	10	0	False	False	False
estado_doc	varchar	1	0	0	False	False	False
fecha_vigencia	datetime2	7	23	3	False	False	False
fecha	datetime2	7	23	3	True	False	False

SQL Script

Copy

CREATE TABLE dbo.replicated_doc_id (
  IDANT bigint NOT NULL,
  PERANT int NULL,
  TIPOANT smallint NULL,
  contrant int NULL,
  empleANT int NULL,
  estadoANT varchar(1) NULL,
  vigenciANT datetime2(3) NULL,
  doc_id bigint NOT NULL,
  tipo_doc smallint NULL,
  contratista int NULL,
  empleado int NULL,
  periodo int NULL,
  estado_doc varchar(1) NULL,
  fecha_vigencia datetime2(3) NULL,
  fecha datetime2(3) NOT NULL
)
ON [PRIMARY]
GO

Depends On

Fidelitas

Used By

dbo.Imperium_calcula_doc_id_anterior