dbo.amx_2019_ ln

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:52 PM
Last Modified	3/6/2025 6:55:52 PM

Columns

Name	Data Type	Length	Precision	Scale	Not Null	Computed	Persisted
doc_id	int	4	10	0	True	False	False
cliente	int	4	10	0	True	False	False
contraparte	int	4	10	0	True	False	False
tipo_doc	int	4	10	0	True	False	False
doc_version	int	4	10	0	True	False	False
estado_doc	varchar	1	0	0	False	False	False
vencimiento_carga	datetime2	7	23	3	False	False	False
fecha_vigencia	datetime2	7	23	3	False	False	False
doc_attach	tinyint	1	3	0	True	False	False
ingresado	smalldatetime	4	16	0	False	False	False
ingresado_por	int	4	10	0	False	False	False
rechazado	smalldatetime	4	16	0	False	False	False
rechazado_por	int	4	10	0	False	False	False
verificado_backend	smalldatetime	4	16	0	False	False	False
verificado_backend_por	int	4	10	0	False	False	False
verificado_cliente	smalldatetime	4	16	0	False	False	False
verificado_cliente_por	int	4	10	0	False	False	False
texto_rechazo	varchar	500	0	0	False	False	False
doc_log	text		0	0	False	False	False
created	smalldatetime	4	16	0	True	False	False
created_by	int	4	10	0	False	False	False
modified	smalldatetime	4	16	0	False	False	False
modified_by	int	4	10	0	False	False	False
es_balance	tinyint	1	3	0	True	False	False
inicio_ejercicio	smalldatetime	4	16	0	False	False	False
fin_ejercicio	smalldatetime	4	16	0	False	False	False
gestion	int	4	10	0	False	False	False
id_externo	int	4	10	0	False	False	False
aplica	bit	1	1	0	False	False	False
user_id_aplica	int	4	10	0	False	False	False
fecha_aplica	smalldatetime	4	16	0	False	False	False

SQL Script

Copy

CREATE TABLE dbo.[amx_2019_ ln_docs] (
  doc_id int NOT NULL,
  cliente int NOT NULL,
  contraparte int NOT NULL,
  tipo_doc int NOT NULL,
  doc_version int NOT NULL,
  estado_doc varchar(1) NULL,
  vencimiento_carga datetime2(3) NULL,
  fecha_vigencia datetime2(3) NULL,
  doc_attach tinyint NOT NULL,
  ingresado smalldatetime NULL,
  ingresado_por int NULL,
  rechazado smalldatetime NULL,
  rechazado_por int NULL,
  verificado_backend smalldatetime NULL,
  verificado_backend_por int NULL,
  verificado_cliente smalldatetime NULL,
  verificado_cliente_por int NULL,
  texto_rechazo varchar(500) NULL,
  doc_log text NULL,
  created smalldatetime NOT NULL,
  created_by int NULL,
  modified smalldatetime NULL,
  modified_by int NULL,
  es_balance tinyint NOT NULL,
  inicio_ejercicio smalldatetime NULL,
  fin_ejercicio smalldatetime NULL,
  gestion int NULL,
  id_externo int NULL,
  aplica bit NULL,
  user_id_aplica int NULL,
  fecha_aplica smalldatetime NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

Depends On

FideDoc

Used By

No items found