/*
  Esquema consolidado - Plataforma de Desarrolladores Agua Hillo
  Generado a partir de las definiciones proporcionadas.

  Decisiones aplicadas:
  - Usuarios -> Sis_Usuarios.
  - Monedas -> Gral_Monedas.
  - GPS_ZonasHorarias -> ZonasHorarias.
  - Nom_Sat_Bancos -> Sat_Bancos.
  - Se omite todo lo relacionado con CveEmpresa/CveEmpresaCRM.
  - Se eliminan Comp_Proveedores, Banc_Creditos y Vta_Cortes junto con sus campos dependientes acordados.
  - Las FK se crean después de todas las tablas para evitar fallas por orden y ciclos.
*/

SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
SET XACT_ABORT ON;
GO

/* ==================== TABLAS ==================== */

CREATE TABLE [dbo].[Sis_Roles] (
  [CveRol] int IDENTITY(1,1) NOT NULL,
  [NombreRol] varchar(100) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Descripcion] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [Activo] bit CONSTRAINT [DF_Sis_Roles_Activo] DEFAULT ((1)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Roles_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  CONSTRAINT [PK_Sis_Roles]
        PRIMARY KEY CLUSTERED ([CveRol]),
  CONSTRAINT [UQ_Sis_Roles_NombreRol]
        UNIQUE NONCLUSTERED ([NombreRol])
)
;
GO

CREATE TABLE [dbo].[Sis_Plataformas] (
  [CvePlataforma] int IDENTITY(1,1) NOT NULL,
  [NombrePlataforma] varchar(100) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Descripcion] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [Activo] bit CONSTRAINT [DF_Sis_Plataformas_Activo] DEFAULT ((1)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Plataformas_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  CONSTRAINT [PK_Sis_Plataformas]
        PRIMARY KEY CLUSTERED ([CvePlataforma]),
  CONSTRAINT [UQ_Sis_Plataformas_NombrePlataforma]
        UNIQUE NONCLUSTERED ([NombrePlataforma])
)
;
GO

CREATE TABLE [dbo].[Sis_Permisos] (
  [CvePermiso] int IDENTITY(1,1) NOT NULL,
  [CodigoPermiso] varchar(100) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [NombrePermiso] varchar(150) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Descripcion] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [Activo] bit CONSTRAINT [DF_Sis_Permisos_Activo] DEFAULT ((1)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Permisos_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  CONSTRAINT [PK_Sis_Permisos]
        PRIMARY KEY CLUSTERED ([CvePermiso]),
  CONSTRAINT [UQ_Sis_Permisos_CodigoPermiso]
        UNIQUE NONCLUSTERED ([CodigoPermiso])
)
;
GO

CREATE TABLE [dbo].[Sis_Usuarios] (
  [CveUsuario] int IDENTITY(1,1) NOT NULL,
  [NombreUsuario] varchar(100) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [HashContrasena] varchar(500) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [CorreoElectronico] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [CveRol] int NOT NULL,
  [Activo] bit CONSTRAINT [DF_Sis_Usuarios_Activo] DEFAULT ((1)) NOT NULL,
  [FechaUltimaConexion] datetime NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Usuarios_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  [DebeCambiarContrasena] bit CONSTRAINT [DF_Sis_Usuarios_DebeCambiarContrasena] DEFAULT ((0)) NOT NULL,
  [IntentosFallidosInicioSesion] int CONSTRAINT [DF_Sis_Usuarios_IntentosFallidos] DEFAULT ((0)) NOT NULL,
  [BloqueadoHasta] datetime NULL,
  [FechaUltimoInicioSesion] datetime NULL,
  CONSTRAINT [PK_Sis_Usuarios]
        PRIMARY KEY CLUSTERED ([CveUsuario]),
  CONSTRAINT [UQ_Sis_Usuarios_NombreUsuario]
        UNIQUE NONCLUSTERED ([NombreUsuario])
)
;
GO

CREATE TABLE [dbo].[Sis_Modulos] (
  [CveModulo] int IDENTITY(1,1) NOT NULL,
  [CveModuloPadre] int NULL,
  [CvePlataforma] int NOT NULL,
  [NombreModulo] varchar(150) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Descripcion] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [Url] varchar(500) COLLATE Modern_Spanish_CS_AI NULL,
  [ClaseCssIcono] varchar(150) COLLATE Modern_Spanish_CS_AI NULL,
  [ClaseCssEstilo] varchar(150) COLLATE Modern_Spanish_CS_AI NULL,
  [OrdenVisualizacion] int CONSTRAINT [DF_Sis_Modulos_OrdenVisualizacion] DEFAULT ((0)) NOT NULL,
  [Visible] bit CONSTRAINT [DF_Sis_Modulos_Visible] DEFAULT ((1)) NOT NULL,
  [Activo] bit CONSTRAINT [DF_Sis_Modulos_Activo] DEFAULT ((1)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Modulos_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  CONSTRAINT [PK_Sis_Modulos]
        PRIMARY KEY CLUSTERED ([CveModulo])
)
;
GO

CREATE TABLE [dbo].[Sis_RolesPermisos] (
  [CveRolPermiso] int IDENTITY(1,1) NOT NULL,
  [CveRol] int NOT NULL,
  [CvePermiso] int NOT NULL,
  [Permitido] bit CONSTRAINT [DF_Sis_RolesPermisos_Permitido] DEFAULT ((1)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_RolesPermisos_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  CONSTRAINT [PK_Sis_RolesPermisos]
        PRIMARY KEY CLUSTERED ([CveRolPermiso]),
  CONSTRAINT [UQ_Sis_RolesPermisos]
        UNIQUE NONCLUSTERED ([CveRol], [CvePermiso])
)
;
GO

CREATE TABLE [dbo].[Sis_RolesModulos] (
  [CveRolModulo] int IDENTITY(1,1) NOT NULL,
  [CveRol] int NOT NULL,
  [CveModulo] int NOT NULL,
  [PuedeVer] bit CONSTRAINT [DF_Sis_RolesModulos_PuedeVer] DEFAULT ((1)) NOT NULL,
  [PuedeCrear] bit CONSTRAINT [DF_Sis_RolesModulos_PuedeCrear] DEFAULT ((0)) NOT NULL,
  [PuedeModificar] bit CONSTRAINT [DF_Sis_RolesModulos_PuedeModificar] DEFAULT ((0)) NOT NULL,
  [PuedeEliminar] bit CONSTRAINT [DF_Sis_RolesModulos_PuedeEliminar] DEFAULT ((0)) NOT NULL,
  [PuedeImprimir] bit CONSTRAINT [DF_Sis_RolesModulos_PuedeImprimir] DEFAULT ((0)) NOT NULL,
  [PuedeExportar] bit CONSTRAINT [DF_Sis_RolesModulos_PuedeExportar] DEFAULT ((0)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_RolesModulos_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  CONSTRAINT [PK_Sis_RolesModulos]
        PRIMARY KEY CLUSTERED ([CveRolModulo]),
  CONSTRAINT [UQ_Sis_RolesModulos]
        UNIQUE NONCLUSTERED ([CveRol], [CveModulo])
)
;
GO

CREATE TABLE [dbo].[Sis_UsuariosPermisos] (
  [CveUsuarioPermiso] int IDENTITY(1,1) NOT NULL,
  [CveUsuario] int NOT NULL,
  [CvePermiso] int NOT NULL,
  [Permitido] bit CONSTRAINT [DF_Sis_UsuariosPermisos_Permitido] DEFAULT ((1)) NOT NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_UsuariosPermisos_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  CONSTRAINT [PK_Sis_UsuariosPermisos]
        PRIMARY KEY CLUSTERED ([CveUsuarioPermiso]),
  CONSTRAINT [UQ_Sis_UsuariosPermisos]
        UNIQUE NONCLUSTERED ([CveUsuario], [CvePermiso])
)
;
GO

CREATE TABLE [dbo].[Sis_UsuariosSesiones] (
  [CveUsuarioSesion] int IDENTITY(1,1) NOT NULL,
  [CveUsuario] int NOT NULL,
  [TokenSesion] varchar(200) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [DireccionIP] varchar(50) COLLATE Modern_Spanish_CS_AI NULL,
  [AgenteUsuario] varchar(1000) COLLATE Modern_Spanish_CS_AI NULL,
  [NombreDominio] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [FechaInicio] datetime CONSTRAINT [DF_Sis_UsuariosSesiones_FechaInicio] DEFAULT (GETDATE()) NOT NULL,
  [FechaUltimaActividad] datetime NULL,
  [FechaFin] datetime NULL,
  [Activo] bit CONSTRAINT [DF_Sis_UsuariosSesiones_Activo] DEFAULT ((1)) NOT NULL,
  CONSTRAINT [PK_Sis_UsuariosSesiones]
        PRIMARY KEY CLUSTERED ([CveUsuarioSesion]),
  CONSTRAINT [UQ_Sis_UsuariosSesiones_TokenSesion]
        UNIQUE NONCLUSTERED ([TokenSesion])
)
;
GO

CREATE TABLE [dbo].[Sis_UsuariosAutorizaciones] (
  [CveUsuarioAutorizacion] int IDENTITY(1,1) NOT NULL,
  [CvePermiso] int NOT NULL,
  [CveUsuarioSolicitante] int NOT NULL,
  [CveUsuarioAutorizador] int NULL,
  [EstadoAutorizacion] varchar(30) COLLATE Modern_Spanish_CS_AI
        CONSTRAINT [DF_Sis_UsuariosAutorizaciones_Estado]
        DEFAULT ('Pendiente') NOT NULL,
  [ComentarioSolicitud] varchar(500) COLLATE Modern_Spanish_CS_AI NULL,
  [ComentarioAutorizacion] varchar(500) COLLATE Modern_Spanish_CS_AI NULL,
  [FechaSolicitud] datetime
        CONSTRAINT [DF_Sis_UsuariosAutorizaciones_FechaSolicitud]
        DEFAULT (GETDATE()) NOT NULL,
  [FechaAutorizacion] datetime NULL,
  CONSTRAINT [PK_Sis_UsuariosAutorizaciones]
        PRIMARY KEY CLUSTERED ([CveUsuarioAutorizacion]),
  CONSTRAINT [CK_Sis_UsuariosAutorizaciones_Estado]
        CHECK
        (
            [EstadoAutorizacion] IN
            (
                'Pendiente',
                'Aprobada',
                'Rechazada',
                'Cancelada'
            )
        )
)
;
GO

CREATE TABLE [dbo].[Sis_UsuariosSuscripcionesPush] (
  [CveSuscripcionPush] int IDENTITY(1,1) NOT NULL,
  [CveUsuario] int NOT NULL,
  [Endpoint] varchar(1000) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [P256DH] varchar(500) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [ClaveAutenticacion] varchar(500) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Activo] bit CONSTRAINT [DF_Sis_UsuariosSuscripcionesPush_Activo] DEFAULT ((1)) NOT NULL,
  [AgenteUsuario] varchar(1000) COLLATE Modern_Spanish_CS_AI NULL,
  [Plataforma] varchar(100) COLLATE Modern_Spanish_CS_AI NULL,
  [Navegador] varchar(100) COLLATE Modern_Spanish_CS_AI NULL,
  [NombreDominio] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [FechaUltimaConexion] datetime NULL,
  [FechaCreacion] datetime
        CONSTRAINT [DF_Sis_UsuariosSuscripcionesPush_FechaCreacion]
        DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  CONSTRAINT [PK_Sis_UsuariosSuscripcionesPush]
        PRIMARY KEY CLUSTERED ([CveSuscripcionPush])
)
;
GO

CREATE TABLE [dbo].[Sis_Notificaciones] (
  [CveNotificacion] int IDENTITY(1,1) NOT NULL,
  [CveUsuario] int NOT NULL,
  [TipoNotificacion] varchar(50) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [EstadoNotificacion] varchar(30) COLLATE Modern_Spanish_CS_AI
        CONSTRAINT [DF_Sis_Notificaciones_Estado]
        DEFAULT ('Pendiente') NOT NULL,
  [Titulo] varchar(200) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Mensaje] varchar(max) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Url] varchar(500) COLLATE Modern_Spanish_CS_AI NULL,
  [Leida] bit CONSTRAINT [DF_Sis_Notificaciones_Leida] DEFAULT ((0)) NOT NULL,
  [MostradaEnCampana] bit CONSTRAINT [DF_Sis_Notificaciones_MostradaEnCampana] DEFAULT ((0)) NOT NULL,
  [FechaEnvio] datetime NULL,
  [FechaLectura] datetime NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Notificaciones_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  [FechaActualizacion] datetime NULL,
  CONSTRAINT [PK_Sis_Notificaciones]
        PRIMARY KEY CLUSTERED ([CveNotificacion]),
  CONSTRAINT [CK_Sis_Notificaciones_Estado]
        CHECK
        (
            [EstadoNotificacion] IN
            (
                'Pendiente',
                'Enviada',
                'Fallida',
                'Cancelada'
            )
        ),
  CONSTRAINT [CK_Sis_Notificaciones_Tipo]
        CHECK
        (
            [TipoNotificacion] IN
            (
                'Local',
                'WhatsApp',
                'SignalR',
                'Correo',
                'Push',
                'Campana'
            )
        )
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY];
GO

CREATE TABLE [dbo].[Sis_NotificacionesEnvios] (
  [CveEnvioNotificacion] int IDENTITY(1,1) NOT NULL,
  [CveNotificacion] int NOT NULL,
  [CanalEnvio] varchar(50) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [EstadoEnvio] varchar(30) COLLATE Modern_Spanish_CS_AI
        CONSTRAINT [DF_Sis_NotificacionesEnvios_Estado]
        DEFAULT ('Pendiente') NOT NULL,
  [RespuestaProveedor] varchar(max) COLLATE Modern_Spanish_CS_AI NULL,
  [MensajeError] varchar(max) COLLATE Modern_Spanish_CS_AI NULL,
  [FechaEnvio] datetime NULL,
  [FechaCreacion] datetime
        CONSTRAINT [DF_Sis_NotificacionesEnvios_FechaCreacion]
        DEFAULT (GETDATE()) NOT NULL,
  CONSTRAINT [PK_Sis_NotificacionesEnvios]
        PRIMARY KEY CLUSTERED ([CveEnvioNotificacion]),
  CONSTRAINT [CK_Sis_NotificacionesEnvios_Estado]
        CHECK
        (
            [EstadoEnvio] IN
            (
                'Pendiente',
                'Enviado',
                'Fallido',
                'Cancelado'
            )
        ),
  CONSTRAINT [CK_Sis_NotificacionesEnvios_Canal]
        CHECK
        (
            [CanalEnvio] IN
            (
                'Local',
                'WhatsApp',
                'SignalR',
                'Correo',
                'Push',
                'Campana'
            )
        )
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY];
GO

CREATE TABLE [dbo].[Sis_IntentosInicioSesion] (
  [CveIntentoInicioSesion] int IDENTITY(1,1) NOT NULL,
  [CveUsuario] int NULL,
  [NombreUsuario] varchar(100) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Exitoso] bit NOT NULL,
  [MotivoFallo] varchar(200) COLLATE Modern_Spanish_CS_AI NULL,
  [DireccionIP] varchar(50) COLLATE Modern_Spanish_CS_AI NULL,
  [AgenteUsuario] varchar(1000) COLLATE Modern_Spanish_CS_AI NULL,
  [NombreDominio] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [FechaCreacion] datetime
        CONSTRAINT [DF_Sis_IntentosInicioSesion_FechaCreacion]
        DEFAULT (GETDATE()) NOT NULL,
  CONSTRAINT [PK_Sis_IntentosInicioSesion]
        PRIMARY KEY CLUSTERED ([CveIntentoInicioSesion])
)
;
GO

CREATE TABLE [dbo].[Sis_Auditorias] (
  [CveAuditoria] int IDENTITY(1,1) NOT NULL,
  [CveUsuario] int NULL,
  [TipoEvento] varchar(100) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [NombreEntidad] varchar(150) COLLATE Modern_Spanish_CS_AI NULL,
  [LlaveEntidad] varchar(100) COLLATE Modern_Spanish_CS_AI NULL,
  [Descripcion] varchar(500) COLLATE Modern_Spanish_CS_AI NULL,
  [DireccionIP] varchar(50) COLLATE Modern_Spanish_CS_AI NULL,
  [AgenteUsuario] varchar(1000) COLLATE Modern_Spanish_CS_AI NULL,
  [NombreDominio] varchar(255) COLLATE Modern_Spanish_CS_AI NULL,
  [FechaCreacion] datetime CONSTRAINT [DF_Sis_Auditorias_FechaCreacion] DEFAULT (GETDATE()) NOT NULL,
  CONSTRAINT [PK_Sis_Auditorias]
        PRIMARY KEY CLUSTERED ([CveAuditoria])
)
;
GO

CREATE TABLE [dbo].[Sis_AuditoriasDetalles] (
  [CveAuditoriaDetalle] int IDENTITY(1,1) NOT NULL,
  [CveAuditoria] int NOT NULL,
  [NombreCampo] varchar(150) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [ValorAnterior] varchar(max) COLLATE Modern_Spanish_CS_AI NULL,
  [ValorNuevo] varchar(max) COLLATE Modern_Spanish_CS_AI NULL,
  CONSTRAINT [PK_Sis_AuditoriasDetalles]
        PRIMARY KEY CLUSTERED ([CveAuditoriaDetalle])
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY];
GO

CREATE TABLE [dbo].[Gral_SAT_ProductosServicios] (
  [CveSATPS] int  IDENTITY(1,1) NOT NULL,
  [SATClavePS] nvarchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Descripcion] nvarchar(600) COLLATE Modern_Spanish_CS_AI  NULL,
  [IncluirIVAtrasladado] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [IncluirIEPStrasladado] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [ComplementoIncluir] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [IncluirIVATrasladado2] bit DEFAULT ((0)) NOT NULL,
  [IncluirIESTrasladado2] bit DEFAULT ((0)) NOT NULL,
  [FechaInicioVigencia] date  NULL,
  [FechaFinVigencia] date  NULL,
  [EstimuloFranjaFronteriza] bit  NULL,
  [PalabrasSimilares] varchar(600) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [AplicaCartaPorte] bit  NULL,
  [MaterialPeligroso] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_Gral_SAT_ProductosServicios_1] PRIMARY KEY CLUSTERED ([CveSATPS])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_Categorias] (
  [CveCategoria] int  IDENTITY(1,1) NOT NULL,
  [Categoria] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [Tipo] tinyint DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Categorias] PRIMARY KEY CLUSTERED ([CveCategoria])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UK_Gral_Categorias] UNIQUE NONCLUSTERED ([Categoria] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Clasificaciones] (
  [CveClasificacion] int  IDENTITY(1,1) NOT NULL,
  [Codigo] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Clasificacion] varchar(200) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estado] bit DEFAULT ((1)) NOT NULL,
  [Afectable] bit DEFAULT ((1)) NOT NULL,
  [CveCategoria] int  NULL,
  [UsoClasificacion] int DEFAULT ((1)) NULL,
  [Fecha] date  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [RequiereSerieLote] bit  NULL,
  [CveSATPS] int  NULL,
  [RequiereAFCompra] bit DEFAULT ((0)) NULL,
  [RequiereAFInsumo] bit DEFAULT ((0)) NULL,
  [RequierePersonal] bit DEFAULT ((0)) NULL,
  [EsAcumulador] bit DEFAULT ((0)) NULL,
  [TopVentas] bit  NULL,
  [TopCompras] bit  NULL,
  [PrecioBaseCosto] money  NULL,
  [PorMaximoDescuento] smallmoney  NULL,
  [AplicaDepositoCaja] bit DEFAULT ((0)) NULL,
  CONSTRAINT [PK_Clasificaciones] PRIMARY KEY CLUSTERED ([CveClasificacion])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_Clasificacion] UNIQUE NONCLUSTERED ([Clasificacion] ASC, [Codigo] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Banc_BancosCuentas] (
  [CveBancoCuenta] int  IDENTITY(1,1) NOT NULL,
  [CveBanco] int  NOT NULL,
  [CveTipoCuenta] int  NOT NULL,
  [NumCuenta] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CveMoneda] int DEFAULT ((1)) NOT NULL,
  [CLABE] varchar(18) COLLATE Modern_Spanish_CS_AI  NULL,
  [DiaCorte] int DEFAULT ((0)) NULL,
  [FInicial] int  NOT NULL,
  [FActual] int  NOT NULL,
  [FFinal] int  NOT NULL,
  [LimiteCredito] money DEFAULT ((0)) NOT NULL,
  [UsaLayout] bit DEFAULT ((0)) NOT NULL,
  [FormatoCheque] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ConvenioPagoElectronico] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [PrefijoConta] varchar(2) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [Fecha] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [UsaTarjeta] bit  NULL,
  [SaldoInicial] money  NULL,
  [ConvenioPagoElectronicoGrupos] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [UsaLayoutGrupos] bit  NULL,
  [TieneTerminal] bit DEFAULT ((0)) NOT NULL,
  [CveBancoCuentaPadre] int  NULL,
  [CveSubProyecto] int  NULL,
  [NumeroSucursal] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [EsCajas] bit DEFAULT ((0)) NOT NULL,
  [ConvenioPagoElectronicoNomina] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_BancosCuentas] PRIMARY KEY CLUSTERED ([CveBancoCuenta])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_Banc_BancosCuentas] UNIQUE NONCLUSTERED ([CveBanco] ASC, [NumCuenta] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_CodigosAgrupadoresSAT] (
  [CveAgrupadorSAT] int  IDENTITY(1,1) NOT NULL,
  [Codigo] nvarchar(20) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Nombre] nvarchar(200) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Tipo] nvarchar(1) COLLATE Modern_Spanish_CS_AI  NULL,
  [CtaMayor] int  NULL,
  [IdRubro] int  NULL,
  [CveAgrupadorPadre] int  NULL,
  [Nivel] smallint  NULL,
  CONSTRAINT [PK__Conta_Co__53FE69089E7C3639] PRIMARY KEY CLUSTERED ([CveAgrupadorSAT])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_Cuentas] (
  [CveCuenta] int  IDENTITY(1,1) NOT NULL,
  [CveClasificacionCuenta] int  NOT NULL,
  [Codigo] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Nombre] varchar(200) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Afectable] bit  NOT NULL,
  [TipoCuenta] int  NOT NULL,
  [Estatus] bit  NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [CveCuentaPadre] int  NULL,
  [CveMoneda] int  NULL,
  [CveAgrupadorSAT] int  NULL,
  [DigAgrup] int  NULL,
  [NomIdioma] varchar(250) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveConceptoAdmin] int  NULL,
  [CveCliente] int  NULL,
  [PorcentajeImpuesto] money  NULL,
  [CveBancoCuenta] int  NULL,
  [CodigoVinculacion] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CodigoAgrupacion] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_Conta_Cuentas] PRIMARY KEY CLUSTERED ([CveCuenta])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [CK_Conta_Cuentas_Padre] CHECK ([CveCuentaPadre]<>[CveCuenta]),
  CONSTRAINT [CK_Conta_Cuentas_Padre_Requerido] CHECK ([CveCuentaPadre] IS NOT NULL OR ([Codigo]='_ORDEN' OR [Codigo]='_ESTADISTICAS' OR [Codigo]='_GLOBAL'))
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Clientes] (
  [CveCliente] int  IDENTITY(1,1) NOT NULL,
  [Nombre] varchar(200) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Codigo] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [NombreCorto] varchar(30) COLLATE Modern_Spanish_CS_AI  NULL,
  [NombreComercial] varchar(200) COLLATE Modern_Spanish_CS_AI  NULL,
  [ApellidoPaterno] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ApellidoMaterno] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Nombres] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Sucursal] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Direccion] varchar(90) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [NoExt] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [NoInt] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Colonia] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Localidad] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Ciudad] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estado] varchar(35) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CveSATEstado] int  NOT NULL,
  [Pais] varchar(50) COLLATE Modern_Spanish_CS_AI DEFAULT ('México') NOT NULL,
  [RFC] varchar(15) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CP] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [Telefono] varchar(25) COLLATE Modern_Spanish_CS_AI  NULL,
  [TelefonoExtension] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [TelefonoOtros] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Contacto] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [Mail] varchar(500) COLLATE Modern_Spanish_CS_AI  NULL,
  [Pagina] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Giro] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [EnviarFactura] bit DEFAULT ((1)) NOT NULL,
  [NotificarA] varchar(500) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSucursal] int  NULL,
  [RetIVA] float(53) DEFAULT ((0)) NOT NULL,
  [RetISR] float(53) DEFAULT ((0)) NOT NULL,
  [RetIVAFletes] bit DEFAULT ((0)) NOT NULL,
  [ConvenioCIE] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [LimiteCredito] float(53) DEFAULT ((0)) NOT NULL,
  [PlazoCobranza] int DEFAULT ((0)) NOT NULL,
  [PlazoCobranzaRemision] smallint DEFAULT ((0)) NOT NULL,
  [RecepcionPagos] varchar(15) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoPago] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Vendedor] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveVendedor] int  NULL,
  [Tipo] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  [FormaFacturacion] varchar(13) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [Fecha] date  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [NumCtaPago] varchar(30) COLLATE Modern_Spanish_CS_AI  NULL,
  [BKEliminarCveMetodoPago] int  NULL,
  [AplicaFEMSA] bit DEFAULT ((0)) NOT NULL,
  [FEMSA_NumSociedad] varchar(4) COLLATE Modern_Spanish_CS_AI  NULL,
  [FEMSA_NumProveedor] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [FEMSA_Mail] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [AplicaDetallista] bit DEFAULT ((0)) NOT NULL,
  [Detallista_GLNComprador] varchar(18) COLLATE Modern_Spanish_CS_AI  NULL,
  [Detallista_Departamento] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Detallista_GLNVendedor] varchar(18) COLLATE Modern_Spanish_CS_AI  NULL,
  [Detallista_NumProveedor] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [SevenEleven_NumProveedor] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [AplicaFord] bit DEFAULT ((0)) NOT NULL,
  [Ford_GSDB] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [CvePrecioLista] int  NULL,
  [CveCondicionEntrega] int  NULL,
  [PermiteCredito] bit  NULL,
  [MailCotizacion] varchar(300) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveClienteClasificacion] int  NULL,
  [CveUsuarioResponsable] int  NULL,
  [CveUsuarioModifico] int  NULL,
  [ImprimeNombreSucursal] bit DEFAULT ((0)) NULL,
  [TipoCliente] int DEFAULT ((1)) NULL,
  [CveZonaHoraria] int  NULL,
  [CobranzaContacto] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [CobranzaTelefono] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [CobranzaExt] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [CobranzaCorreo] varchar(2000) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSubProyecto] int  NULL,
  [Horario] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Documentacion] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [PortalFacturacion] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSucursal2] int  NULL,
  [DiasPago] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [UsuarioPortal] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [PasswordPortal] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [DiasRevision] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ObservacionRevision] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [ReferenciaFiscal] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [Celular] varchar(15) COLLATE Modern_Spanish_CS_AI  NULL,
  [ExtOtros] varchar(15) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveUsoCFDI] tinyint  NULL,
  [CveFormaPago] tinyint  NULL,
  [CveMetodoPago] tinyint  NULL,
  [CveClienteCorporativo] int  NULL,
  [DesglosaIEPS] bit DEFAULT ((1)) NOT NULL,
  [AplicaComercioExterior] bit DEFAULT ((0)) NULL,
  [CveTipoOperacion] int  NULL,
  [CvePedimento] int  NULL,
  [CveIncoterm] int  NULL,
  [CvePais] int  NULL,
  [CveEstado] int  NULL,
  [CveMunicipio] int  NULL,
  [CveColonia] int  NULL,
  [NumRegIdTrib] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveMotivoTraslado] tinyint  NULL,
  [ComExtEstado] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ComExtMunicipio] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ComExtColonia] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [RequiereOC] bit DEFAULT ((0)) NOT NULL,
  [EsDistribuidor] bit DEFAULT ((0)) NOT NULL,
  [BonificacionUsado] bit DEFAULT ((0)) NOT NULL,
  [CargoUsado] bit DEFAULT ((0)) NOT NULL,
  [CveTipoRetencion] tinyint  NULL,
  [CorreoEntregaCompras] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CorreoEntregaAlmacen] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Punto] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveAdminTrayecto] tinyint  NULL,
  [NoDesglosaIVA] bit DEFAULT ((0)) NULL,
  [CorreoCumplimiento] varchar(200) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveRegimenFiscal] tinyint  NULL,
  [RegimenSociedad] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoPersona] bit  NULL,
  [RepresentanteLegal] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaLimiteCredito] date  NULL,
  [ComExtCalle] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ComExtNumExt] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ComExtCP] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [Genero] bit  NULL,
  [CveAlmacenAsignado] int  NULL,
  [CveAlmacenAlterno] int  NULL,
  [CveAlmacenConsignacion] int  NULL,
  [UsaProductoAlterno] bit DEFAULT ((0)) NULL,
  [EnDemanda] bit DEFAULT ((0)) NULL,
  [EnQuebranto] bit DEFAULT ((0)) NOT NULL,
  [CreditoRegistroFirmas] varchar(250) COLLATE Modern_Spanish_CS_AI  NULL,
  [GastosEnvio] smallmoney  NULL,
  [EsFilial] bit DEFAULT ((0)) NOT NULL,
  [Aseguradora] bit DEFAULT ((0)) NULL,
  [CveSubProyectoCobranza] int  NULL,
  [InformacionCompleta] bit DEFAULT ((1)) NULL,
  [VentasComplementos] varchar(max) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_Clientes] PRIMARY KEY CLUSTERED ([CveCliente])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [CK_Clientes_RFC_Requerido] CHECK ([RFC]<>'')
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_TiposPoliza] (
  [CveTipoPoliza] int  NOT NULL,
  [TipoPoliza] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Conta_TiposPoliza] PRIMARY KEY CLUSTERED ([CveTipoPoliza])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_ContaTipoPoliza] UNIQUE NONCLUSTERED ([TipoPoliza] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_PlantillasPolizas] (
  [CvePlantillaPoliza] int  NOT NULL,
  [PlantillaPoliza] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [TipoPlantilla] bit DEFAULT ((0)) NOT NULL,
  [TipoPoliza] smallint  NOT NULL,
  [Orden] smallint DEFAULT ((0)) NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Conta_PlantillasPolizas] PRIMARY KEY CLUSTERED ([CvePlantillaPoliza])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_Monedas] (
  [CveMoneda] int  IDENTITY(1,1) NOT NULL,
  [Moneda] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Abreviatura] varchar(3) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [AbreviaturaSAT] varchar(5) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [LayoutBBVA] varchar(3) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Alias1] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alias2] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alias3] varchar(30) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [Fecha] datetime DEFAULT (getdate()) NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Monedas] PRIMARY KEY CLUSTERED ([CveMoneda])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_Moneda] UNIQUE NONCLUSTERED ([Moneda] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_PrePolizas] (
  [CvePrePoliza] int  IDENTITY(1,1) NOT NULL,
  [CveCliente] int  NULL,
  [Modulo] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CvePlantillaPoliza] int  NOT NULL,
  [CveTipoPoliza] int  NOT NULL,
  [Cargos] money DEFAULT ((0)) NOT NULL,
  [Abonos] money DEFAULT ((0)) NOT NULL,
  [CveMoneda] int  NOT NULL,
  [Fecha] date  NOT NULL,
  [Concepto] varchar(200) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [NumeroPoliza] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [FolioPoliza] int  NULL,
  [FolioFijo] int  NULL,
  [FechaConta] datetime  NULL,
  [IdPoliza] int  NULL,
  [CodigoNumeroPoliza] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [CvePrePolizaUnificada] int  NULL,
  [CvePrePolizaPadre] int  NULL,
  [CveUsuarioModifico] int  NULL,
  [AnioMes] AS (CONVERT([varchar](6),[Fecha],(112))) PERSISTED,
  [TipoContable] bit DEFAULT ((1)) NOT NULL,
  CONSTRAINT [PK_Conta_PrePolizas] PRIMARY KEY CLUSTERED ([CvePrePoliza])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [CK_Conta_PrePolizas_Concepto] CHECK (rtrim([Concepto])<>''),
  CONSTRAINT [CK_Conta_PrePolizas_Fecha_2000_2050] CHECK ([Fecha]>='2000-01-01' AND [Fecha]<='2050/12/31'),
  CONSTRAINT [CK_Conta_PrePolizas_FolioPoliza] CHECK ([IdPoliza]>(0) AND isnull([FolioPoliza],(0))>(0) OR ([IdPoliza] IS NULL OR [IdPoliza]=(0)))
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_SAT_UnidadesMedida] (
  [CveSATUnidadMedida] int  IDENTITY(1,1) NOT NULL,
  [SATClaveUnidadMedida] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Nombre] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Descripcion] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [Simbolo] nvarchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_Gral_SAT_UnidadesMedida] PRIMARY KEY CLUSTERED ([CveSATUnidadMedida])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UK_Gral_SAT_UnidadesMedida] UNIQUE NONCLUSTERED ([SATClaveUnidadMedida] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_SAT_CP_MaterialPeligroso] (
  [CveMaterialPeligroso] int  IDENTITY(1,1) NOT NULL,
  [ClaveMaterialPeligroso] varchar(10) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [MaterialPeligroso] varchar(390) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [ClaseoDiv] varchar(8) COLLATE Modern_Spanish_CS_AI  NULL,
  [PeligroSecundario] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [NombreTecnico] varchar(400) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaDeInicioDeVigencia] date  NULL,
  [Version] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_Gral_SAT_CP_MaterialPeligroso] PRIMARY KEY CLUSTERED ([CveMaterialPeligroso])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[UnidadesMedida] (
  [CveUnidadMedida] int  IDENTITY(1,1) NOT NULL,
  [UnidadMedida] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Abreviatura] varchar(15) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Alias1] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alias2] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alias3] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alias4] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSATUnidadMedida] int  NULL,
  [Estado] bit DEFAULT ((1)) NOT NULL,
  [Fecha] date  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [CveUnidadMedidaSAT] int  NULL,
  [CveImpEmpaque] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveImpUM] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_UnidadesMedida] PRIMARY KEY CLUSTERED ([CveUnidadMedida])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_UnidadesMedida] UNIQUE NONCLUSTERED ([Abreviatura] ASC )
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_SAT_ObjetoImpuesto] (
  [CveObjetoImpuesto] tinyint  NOT NULL,
  [ObjetoImpuesto] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CodigoObjetoImpuesto] varchar(2) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  CONSTRAINT [PK_Gral_ObjetoImpuesto] PRIMARY KEY CLUSTERED ([CveObjetoImpuesto])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[ProductosServicios] (
  [CvePS] int  IDENTITY(1,1) NOT NULL,
  [CveClasificacion] int  NOT NULL,
  [CveUnidadMedida] int  NOT NULL,
  [CveClasificacionCosto] int  NULL,
  [CveClasificacionPresupuesto] int  NULL,
  [Codigo] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [NumeroParte] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CodigoBarras] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [PS] varchar(846) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [PSExtranjero] varchar(846) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveMarca] int  NULL,
  [Precio] float(53) DEFAULT ((0)) NOT NULL,
  [IVA] float(53)  NULL,
  [RetIVA] float(53) DEFAULT ((0)) NOT NULL,
  [MargenGanancia] float(53) DEFAULT ((0)) NOT NULL,
  [Estado] bit DEFAULT ((1)) NOT NULL,
  [Fecha] smalldatetime  NOT NULL,
  [IdCtaContVentas] int DEFAULT ((0)) NOT NULL,
  [IdCtaContCompras] int DEFAULT ((0)) NOT NULL,
  [IdCtaContInventarios] int DEFAULT ((0)) NOT NULL,
  [AsientoContableVentas] int DEFAULT ((1)) NOT NULL,
  [AsientoContableCompras] int DEFAULT ((1)) NOT NULL,
  [CveTipoPS] int DEFAULT ((1)) NOT NULL,
  [CveUsuario] int  NOT NULL,
  [Borrame] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSegmentoNegocio] int  NULL,
  [AplicaParaConcepto] bit DEFAULT ((1)) NOT NULL,
  [Inv_CveMetodoInventario] smallint DEFAULT ((0)) NULL,
  [CostoPromedio] money DEFAULT ((0)) NULL,
  [AlmacenSeccion] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [AplicaSerieLote] bit  NULL,
  [AplicaParaVenta] bit DEFAULT ((0)) NOT NULL,
  [AplicaCaducidad] bit DEFAULT ((0)) NULL,
  [AplicaLote] bit DEFAULT ((0)) NOT NULL,
  [AplicaSerie] bit DEFAULT ((0)) NOT NULL,
  [AplicaSeccion] bit DEFAULT ((0)) NOT NULL,
  [AplicaPesoKg] bit DEFAULT ((0)) NOT NULL,
  [EsPaquete] bit DEFAULT ((0)) NULL,
  [CveMoneda] int DEFAULT ((1)) NULL,
  [Imagen] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [VentaSinExistencia] bit DEFAULT ((0)) NULL,
  [FuePorXML] bit DEFAULT ((1)) NULL,
  [EsAdminPAQ] bit DEFAULT ((0)) NULL,
  [PendienteEnOC] bit  NULL,
  [Estado2] smallint  NULL,
  [CveClasificacion2] int  NULL,
  [CodigoPS] AS (case when len([Codigo])>(0) then concat([Codigo],' - ',[PS]) else [PS] end),
  [AplicaIEPS] bit  NULL,
  [IEPSGrabaIVA] bit  NULL,
  [IEPSPorcentaje] float(53)  NULL,
  [CveConceptoContable] int  NULL,
  [CveCompuesto] int  NULL,
  [CveSATPS] int  NULL,
  [Inventariable] bit DEFAULT ((0)) NOT NULL,
  [VentaMinima] smallmoney  NULL,
  [RetISR] float(53)  NULL,
  [PrecioMinimo] money  NULL,
  [CveTipoFactor] int DEFAULT ((1)) NULL,
  [CveTipoFactorIEPS] tinyint  NULL,
  [CveFraccionArancelaria] int  NULL,
  [CveUsuarioModifico] int  NULL,
  [FechaUltimaModificacion] datetime  NULL,
  [CveClasificacionDetalle] int  NULL,
  [CveTamaño] int  NULL,
  [ClaveImpuestoEmpaque] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  [ClaveImpuestoUM] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  [ClaveCategoriaToxicidad] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  [ClaveImpuestoTipoProducto] varchar(3) COLLATE Modern_Spanish_CS_AI  NULL,
  [CvePSAdicional] int  NULL,
  [PrecioMinimoAnterior] money  NULL,
  [Litraje] float(53)  NULL,
  [Code17] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [EsOutSourcing] bit DEFAULT ((0)) NOT NULL,
  [TiempoCaducidad] smallint  NULL,
  [CantidadEmpaque] smallmoney  NULL,
  [PrecioLibre] bit DEFAULT ((0)) NOT NULL,
  [PesoKg] smallmoney  NULL,
  [CveMaterialPeligroso] int  NULL,
  [CveEmbalaje] int  NULL,
  [Dimensiones] varchar(25) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveObjetoImpuesto] tinyint DEFAULT ((2)) NOT NULL,
  [RegistroRSCO] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaVigenciaRSCO] date  NULL,
  [VigenciaIndeterminadaRSCO] bit  NULL,
  [NombreComercial] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [NotasAdicionales] varchar(500) COLLATE Modern_Spanish_CS_AI  NULL,
  [EcommerceEtiquetas] varchar(200) COLLATE Modern_Spanish_CS_AI  NULL,
  [ActivoEcommerce] bit DEFAULT ((0)) NOT NULL,
  [EcommercePrecio] smallmoney  NULL,
  [CveClasificacionEcommerce] int  NULL,
  [EcommerceCantidad] smallmoney  NULL,
  [CodigoAlterno] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [PSAlterno] varchar(846) COLLATE Modern_Spanish_CS_AI  NULL,
  [ProductoExhibicion] bit  NULL,
  [PorcentajeMinimoUtilidad] smallmoney  NULL,
  [CveSelectiva] int  NULL,
  [UltimoCosto] numeric(14,6)  NULL,
  [UltimoCostoFecha] date  NULL,
  [UltimoCostoExtranjera] numeric(14,6)  NULL,
  [CveTipoRotacion] tinyint  NULL,
  CONSTRAINT [PK_ProductosServicios] PRIMARY KEY CLUSTERED ([CvePS])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [CK_ProductosServicios_IVA] CHECK ([IVA]=(-1) OR [IVA]=(0) OR [IVA] IS NULL),
  CONSTRAINT [CK_AsientoContableCompras] CHECK ([AsientoContableCompras]=(3) OR [AsientoContableCompras]=(2) OR [AsientoContableCompras]=(1)),
  CONSTRAINT [CK_AsientoContableVentas] CHECK ([AsientoContableVentas]=(2) OR [AsientoContableVentas]=(1))
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Inv_TiposAlmacenes] (
  [CveTipoAlmacen] int  NOT NULL,
  [TipoAlmacen] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] date  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [DeSistema] bit DEFAULT ((0)) NOT NULL,
  CONSTRAINT [PK_INV_TiposAlmacenes] PRIMARY KEY CLUSTERED ([CveTipoAlmacen])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [INV],
  CONSTRAINT [UN_INV_TiposAlmacenes] UNIQUE NONCLUSTERED ([TipoAlmacen] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [INV]
)
ON [INV]
GO

CREATE TABLE [dbo].[Inv_Almacenes] (
  [CveAlmacen] int  IDENTITY(1,1) NOT NULL,
  [Almacen] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CveSubProyecto] int  NOT NULL,
  [CveTipoAlmacen] int  NOT NULL,
  [AlmacenAbreviatura] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] date  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [Modalidad] tinyint DEFAULT ((0)) NULL,
  [Inventariable] bit DEFAULT ((0)) NOT NULL,
  [Orden] smallint DEFAULT ((0)) NOT NULL,
  [CveUsuarioAutoriza] int  NULL,
  [CveAlmacenVirtual] int  NULL,
  [EsAlmacenPT] bit DEFAULT ((0)) NULL,
  [CveAlmacenRef1] int  NULL,
  [CveAlmacenRef2] int  NULL,
  [CveAlmacenRef3] int  NULL,
  [CveAlmacenRef4] int  NULL,
  [CveAlmacenRef5] int  NULL,
  CONSTRAINT [PK_INV_Almacenes] PRIMARY KEY CLUSTERED ([CveAlmacen])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [INV],
  CONSTRAINT [UN_INV_Almacenes] UNIQUE NONCLUSTERED ([Almacen] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [INV]
)
ON [INV]
GO

CREATE TABLE [dbo].[Vta_ClientesSucursales] (
  [CveClienteSucursal] int  IDENTITY(1,1) NOT NULL,
  [CveCliente] int  NOT NULL,
  [SucursalCliente] varchar(100) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [Ciudad] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Colonia] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CP] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [Direccion] varchar(90) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estado] varchar(35) COLLATE Modern_Spanish_CS_AI  NULL,
  [Localidad] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Pais] varchar(50) COLLATE Modern_Spanish_CS_AI DEFAULT ('Mexico') NULL,
  [NoExt] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [NoInt] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Telefono] varchar(25) COLLATE Modern_Spanish_CS_AI  NULL,
  [Correo] varchar(300) COLLATE Modern_Spanish_CS_AI  NULL,
  [Contacto] varchar(300) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveVendedor] int  NULL,
  [CorreoCotizacion] varchar(300) COLLATE Modern_Spanish_CS_AI  NULL,
  [NumCtaPago] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveMetodoPago] int  NULL,
  [LimiteCredito] money  NULL,
  [CveResponsableCobranza] int  NULL,
  [CveMetodoPago33] tinyint  NULL,
  [CveFormaPago33] tinyint  NULL,
  [CveUsoCFDI] tinyint  NULL,
  [Punto] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [RFC] varchar(15) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveAlmacenAsignado] int  NULL,
  [CveAlmacenAlterno] int  NULL,
  [CveAlmacenConsignacion] int  NULL,
  CONSTRAINT [PK_ClientesSucursal] PRIMARY KEY CLUSTERED ([CveClienteSucursal])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_Vta_ClientesSucursales] UNIQUE NONCLUSTERED ([CveCliente] ASC, [SucursalCliente] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Vta_Procedimientos] (
  [CveProcedimiento] int  IDENTITY(1,1) NOT NULL,
  [Procedimiento] varchar(150) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit  NOT NULL,
  [FechaIng] datetime DEFAULT (getdate()) NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Vta_Procedimientos] PRIMARY KEY CLUSTERED ([CveProcedimiento])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Ventas] (
  [CveVenta] int  IDENTITY(1,1) NOT NULL,
  [FolioFiscal] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoDocto] varchar(3) COLLATE Modern_Spanish_CS_AI DEFAULT ('Ing') NOT NULL,
  [Serie] varchar(10) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Folio] int  NOT NULL,
  [SerieFolio] AS (concat(case when [Serie]<>'' then [Serie]+'-' else '' end,[Folio])),
  [Fecha] datetime  NOT NULL,
  [FechaTimbrado] datetime  NULL,
  [CveCliente] int  NULL,
  [CveClienteSucursal] int  NULL,
  [SubTotal] float(53)  NOT NULL,
  [Descuento] float(53) DEFAULT ((0)) NOT NULL,
  [Amortizacion] float(53) DEFAULT ((0)) NOT NULL,
  [IVA] float(53)  NOT NULL,
  [IEPS] float(53) DEFAULT ((0.00)) NULL,
  [RetIVA] float(53) DEFAULT ((0)) NOT NULL,
  [RetISR] float(53) DEFAULT ((0)) NOT NULL,
  [ImpuestoLocal] float(53) DEFAULT ((0)) NULL,
  [Total] float(53)  NOT NULL,
  [CveMoneda] int DEFAULT ((1)) NOT NULL,
  [TipoCambio] float(53) DEFAULT ((1)) NOT NULL,
  [CveMetodoPago] int  NULL,
  [CondicionesPago] int DEFAULT ((0)) NOT NULL,
  [FormaPago] int  NULL,
  [MotivoDescuento] varchar(500) COLLATE Modern_Spanish_CS_AI  NULL,
  [Observaciones] varchar(2000) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CveEstatusFactura] int DEFAULT ((2)) NOT NULL,
  [EnvioMail] int DEFAULT ((0)) NOT NULL,
  [SeTimbro] bit DEFAULT ((0)) NOT NULL,
  [MotivoCancelacion] varchar(500) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaEjecucion] datetime  NOT NULL,
  [CveSubProyecto] int DEFAULT ((0)) NOT NULL,
  [CveVendedor] int DEFAULT ((0)) NULL,
  [Alfa1] varchar(500) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alfa2] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [Alfa3] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [Num1] float(53)  NULL,
  [Num2] float(53)  NULL,
  [Num3] float(53)  NULL,
  [Fech1] date  NULL,
  [Fech2] date  NULL,
  [Fech3] date  NULL,
  [SelloCancelacion] varchar(800) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaCancelacion] datetime  NULL,
  [EstatusCancelacion] tinyint  NULL,
  [IdPoliza] int  NULL,
  [IdPolizaCancelacion] int  NULL,
  [CveVentaPadre] int  NULL,
  [NumeroPersonas] tinyint DEFAULT ((0)) NOT NULL,
  [FechaCierre] datetime  NULL,
  [Propina] float(53)  NULL,
  [CveVentaTerminal] int  NULL,
  [CvePrePoliza] int  NULL,
  [AtencionA] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveUsuario] int  NOT NULL,
  [CveContrato] int  NULL,
  [FechaIng] datetime  NULL,
  [Det_OrdenCompra] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Det_FechaOrdenCompra] varchar(15) COLLATE Modern_Spanish_CS_AI  NULL,
  [Otros] money DEFAULT ((0)) NULL,
  [EsFacturaPrueba] bit DEFAULT ((0)) NOT NULL,
  [Ref] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [NumeroCuenta] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaVencimiento2] date  NULL,
  [DiasVencimiento] AS (datediff(day,[FechaVencimiento2],getdate())),
  [CveVentaFacturada] int  NULL,
  [CvePAC] int  NULL,
  [Vigencia] date  NULL,
  [Entrega] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [TiempoEntrega] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveAlmacenTraspasoDestino] int  NULL,
  [CveAlmacenTraspasoOrigen] int  NULL,
  [EsDevolucionPedido] bit  NULL,
  [EsDevolucionVenta] tinyint DEFAULT ((0)) NOT NULL,
  [CveDireccionEnvio] int  NULL,
  [CveOC] int  NULL,
  [RemisionFacturada] bit DEFAULT ((0)) NOT NULL,
  [CvePACCancelacion] int  NULL,
  [TelefonoGenerico] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveCondicionEntrega] int  NULL,
  [PedidoContrato] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [SATValidadoTimbrado] bit DEFAULT ((0)) NULL,
  [SATValidadoCancelado] bit DEFAULT ((0)) NULL,
  [ObservacionesAlmacen] varchar(300) COLLATE Modern_Spanish_CS_AI  NULL,
  [CotizacionFacturada] bit  NULL,
  [CveSubProyectoEjecucion] int  NULL,
  [CveSubProyectoCobranza] int  NULL,
  [CveCobranzaEstatus] int  NULL,
  [FechaCobranza] datetime  NULL,
  [CveUsuarioCobranza] int  NULL,
  [CobranzaObservacion] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveCobranzaEstatusTurno] int  NULL,
  [TipoProceso] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoComite] varchar(255) COLLATE Modern_Spanish_CS_AI  NULL,
  [IdContabilidad] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveFormaPago33] tinyint  NULL,
  [CveMetodoPago33] tinyint  NULL,
  [CveUsoCFDI] tinyint  NULL,
  [OrdenCompra] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveCuentaTerminal] int  NULL,
  [CveTipoRelacion] int  NULL,
  [ImporteRelacion] money  NULL,
  [CveTipoAmortizacionAnticipo] int  NULL,
  [CveVentaRelacion] int  NULL,
  [Pedido2Facturado] bit DEFAULT ((0)) NULL,
  [EsInterno] bit  NULL,
  [CveAcercamiento] int  NULL,
  [TipoCambioOriginal] float(53)  NULL,
  [TipoCambioValuacion] float(53)  NULL,
  [DiasCredito] int  NULL,
  [EsDiasCreditoFijo] bit DEFAULT ((0)) NULL,
  [SeCancelaRemision] bit DEFAULT ((0)) NULL,
  [CveEstatusRefacturacion] tinyint  NULL,
  [AnticipoEspecial] bit DEFAULT ((0)) NOT NULL,
  [CveUsuarioCambioEstatus] int  NULL,
  [FechaCambioEstatus] datetime  NULL,
  [RealizarDevolucionAlmacen] bit  NULL,
  [CveAlmacenDevolucionVenta] int  NULL,
  [CveMovSalidaAlmacen] tinyint DEFAULT ((1)) NOT NULL,
  [Kilometraje] float(53)  NULL,
  [EsAmortizacion] bit  NULL,
  [CveTipoRetencion] tinyint  NULL,
  [CorreoNotificacion] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [FormaPaqueteria] int  NULL,
  [VentaDesglosaIEPS] bit  NULL,
  [FacturarSucursal] bit  NULL,
  [CveVentaAutorizacion] int  NULL,
  [CveAlmacenSurtio] int  NULL,
  [ServicioDomicilio] bit  NULL,
  [RFCReceptor] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Adjunto] varchar(150) COLLATE Modern_Spanish_CS_AI  NULL,
  [DevolucionImportePagado] money  NULL,
  [CveMotivoCancelacion] int  NULL,
  [EsGarantia] bit DEFAULT ((0)) NOT NULL,
  [EstadoCancelacion] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveEstadoCancelacion] tinyint  NULL,
  [CveOPAgropecuaria] int  NULL,
  [SelloSolicitudCancelacion] varchar(800) COLLATE Modern_Spanish_CS_AI  NULL,
  [CFDIVersion] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveLineaAdicional] int  NULL,
  [CveLineaAdicionalEstatus] int  NULL,
  [LineaAdicionalComprobante] varchar(250) COLLATE Modern_Spanish_CS_AI  NULL,
  [DescripcionVenta] varchar(300) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveMedico] int  NULL,
  [CveProcedimiento] int  NULL,
  [CveTipoVenta] int  NULL,
  [RequiereOS] bit  NULL,
  [FechaParaSurtir] datetime  NOT NULL,
  [Paciente] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Episodio] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [EsFacturaGlobal] bit DEFAULT ((0)) NULL,
  [CveSATPeriodicidad] int  NULL,
  [CveSATMes] int  NULL,
  [SATAnio] int  NULL,
  [AnticipoAutorizado] int  NULL,
  [CveMotivoDevolucion] int  NULL,
  [Addenda] varchar(2000) COLLATE Modern_Spanish_CS_AI  NULL,
  [Bloqueada] bit DEFAULT ((0)) NULL,
  [CveUsuarioModifico] int  NULL,
  [CveComplementoTimbrado] int  NULL,
  [ComplementoSAT] varchar(2000) COLLATE Modern_Spanish_CS_AI  NULL,
  [Procesando] bit DEFAULT ((0)) NULL,
  CONSTRAINT [PK_Ventas] PRIMARY KEY CLUSTERED ([CveVenta])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UK_Ventas_TipoDocto_Serie_Folio_CveSubProyecto] UNIQUE NONCLUSTERED ([CveSubProyecto] ASC, [TipoDocto] ASC, [Serie] ASC, [Folio] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [CK_Ventas] CHECK ([TipoDocto]='Egs' OR [TipoDocto]='Dev' OR [TipoDocto]='Ing' OR [TipoDocto]='Cot' OR [TipoDocto]='Rem' OR [TipoDocto]='Ped' OR [TipoDocto]='DPe' OR [TipoDocto]='Com' OR [TipoDocto]='OP' OR [TipoDocto]='Nom' OR [TipoDocto]='Ant' OR [TipoDocto]='PeC' OR [TipoDocto]='Pd2' OR [TipoDocto]='PA' OR [TipoDocto]='RNC' OR [TipoDocto]='Rmm'),
  CONSTRAINT [CK_Ventas_TMp_AlmacenInactivo] CHECK ([CveAlmacenTraspasoDestino]<>(172) AND [CveVenta]>(1012251) OR [CveVenta]<=(1012251)),
  CONSTRAINT [CK_Ventas_Dev_CveVentaPadre] CHECK ([TipoDocto]='Dev' AND [CveVentaPadre]>(0) OR [TipoDocto]<>'Dev'),
  CONSTRAINT [CK_Ventas_Moneda_TipoCambio] CHECK ([CveMoneda]>=(2) AND [TipoCambio]>=(10) OR [CveMoneda]=(1) AND [TipoCambio]=(1)),
  CONSTRAINT [CHK_VentasMail] CHECK ([EnvioMail]=(3) OR [EnvioMail]=(2) OR [EnvioMail]=(1) OR [EnvioMail]=(0)),
  CONSTRAINT [CK_Ventas_1] CHECK ([CveCliente]>(0)),
  CONSTRAINT [CK_Ventas_FechaEjecucion_MinMax] CHECK ([FechaEjecucion]>'1900-01-01' AND [FechaEjecucion]<'2900-12-31'),
  CONSTRAINT [CK_Ventas_Total] CHECK (datepart(year,[Fecha])>=(2018) AND abs(round([Total],(2))-round(((((((isnull([SubTotal],(0))+isnull([IVA],(0)))+isnull([IEPS],(0)))-isnull([Amortizacion],(0)))-isnull([RetIVA],(0)))-isnull([RetISR],(0)))-isnull([Descuento],(0)))-isnull([ImpuestoLocal],(0)),(2)))<(200.02) OR datepart(year,[Fecha])<(2018))
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_PrePolizasDetalle] (
  [CvePrePolizaDetalle] int  IDENTITY(1,1) NOT NULL,
  [CvePrePoliza] int  NOT NULL,
  [CvePrePolizaOriginal] int  NULL,
  [CveConceptoContable] int  NOT NULL,
  [TipoMovto] bit  NOT NULL,
  [Importe] money  NOT NULL,
  [ImporteME] money  NULL,
  [ImporteMN] money  NULL,
  [TC] decimal(12,9) DEFAULT ((1)) NULL,
  [TCPago] decimal(12,9) DEFAULT ((1)) NULL,
  [Contabilizable] bit DEFAULT ((1)) NOT NULL,
  [Bloqueado] bit DEFAULT ((0)) NOT NULL,
  [IdCtaContable] int DEFAULT ((0)) NOT NULL,
  [CveCuenta] int  NULL,
  [Referencia] varchar(200) COLLATE Modern_Spanish_CS_AI  NULL,
  [Concepto] varchar(200) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CveCliente] int  NULL,
  [CveVenta] int  NULL,
  [CveVentaAmortizacion] int  NULL,
  [CveCompra] int  NULL,
  [CveCompraAmortizacion] int  NULL,
  [CveClasificacion] int  NULL,
  [CveTipoGasto] int  NULL,
  [CveSubProyecto] int  NULL,
  [CveIE] int  NULL,
  [CveIEDevolucion] int  NULL,
  [CveMovimientoAlmacen] int  NULL,
  [CvePersonal] int  NULL,
  [CveActivoFijo] int  NULL,
  [CveCreditoDetalle] int  NULL,
  [CveOC] int  NULL,
  [CveOCDetalle] int  NULL,
  [Agrupacion] int  NULL,
  [PorcentajeImpuesto] smallmoney  NULL,
  [CveNominaMovtoPermanente] int  NULL,
  [Orden] smallint  NULL,
  [CveUsuarioModifico] int  NULL,
  [CveColectiva] smallint  NULL,
  [CveNominaConcepto] int  NULL,
  CONSTRAINT [PK_Conta_PrePolizasDetalle] PRIMARY KEY CLUSTERED ([CvePrePolizaDetalle])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_SAT_Localidad] (
  [CveLocalidad] int  IDENTITY(1,1) NOT NULL,
  [ClaveSATLocalidad] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [ClaveSATEstado] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [NombreLocalidad] varchar(100) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  CONSTRAINT [PK_Gral_SAT_Localidad] PRIMARY KEY CLUSTERED ([CveLocalidad])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_SAT_Estado] (
  [CveEstado] int  IDENTITY(1,1) NOT NULL,
  [ClaveSATEstado] varchar(5) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [ClaveSATPais] varchar(3) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [NombreEstado] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [ClaveImpuestoEstado] varchar(2) COLLATE Modern_Spanish_CS_AI  NULL,
  [ClaveEstadoCorteva] int  NULL,
  CONSTRAINT [PK_Gral_SAT_Estado] PRIMARY KEY CLUSTERED ([CveEstado])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Proyectos] (
  [CveProyecto] int  IDENTITY(1,1) NOT NULL,
  [Proyecto] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CveSucursal] int  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] date DEFAULT (getdate()) NOT NULL,
  [CveUsuario] int  NOT NULL,
  [CveTipoNomina] int DEFAULT ((0)) NOT NULL,
  CONSTRAINT [PK_Proyectos] PRIMARY KEY CLUSTERED ([CveProyecto])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_Proyectos] UNIQUE NONCLUSTERED ([Proyecto] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[SubProyectos] (
  [CveSubProyecto] int  IDENTITY(1,1) NOT NULL,
  [CveProyecto] int  NOT NULL,
  [ClaveSubProyecto] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [SubProyecto] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [IdSegNeg] int DEFAULT ((1)) NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] date DEFAULT (getdate()) NOT NULL,
  [CveUsuario] int  NOT NULL,
  [IdCuentaGasto] int  NULL,
  [CuentaGasto] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSubPrograma] int  NULL,
  [CveClasificacionGeografica] int  NULL,
  [CveSucursal] int  NULL,
  [CveUsuarioNomina] int  NULL,
  [Serie] varchar(15) COLLATE Modern_Spanish_CS_AI  NULL,
  [IVA] float(53)  NULL,
  [Calle] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [NoExt] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [NoInt] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [Colonia] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Localidad] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Municipio] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Pais] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [CP] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveSubProyectoPadre] int  NULL,
  [Estado] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [FormatoFactura] varchar(25) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoFormato] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoVenta] tinyint  NULL,
  [Telefono] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [TipoSucursal] tinyint  NULL,
  [EsSucursal] tinyint  NOT NULL,
  [CvePais] int  NULL,
  [CveEstado] int  NULL,
  [CveMunicipio] int  NULL,
  [CveColonia] int  NULL,
  [AplicaComercioExterior] bit  NULL,
  [Correo] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [UTCOffsetVerano] int  NULL,
  [UTCOffsetInvierno] int  NULL,
  [NoVerificaAlmacen] bit  NULL,
  [CodigoSucursal] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [Acum_CentroServicio] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [Orden] smallint  NULL,
  [CveLocalidad] int  NULL,
  [Acum_PortalUsuario] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Acum_PortalContrasena] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [DeshabilitaAutorizacion] bit  NULL,
  [CveClientePublicoGral] int  NULL,
  CONSTRAINT [PK_SubProyectos] PRIMARY KEY CLUSTERED ([CveSubProyecto])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_SubProyectos] UNIQUE NONCLUSTERED ([CveProyecto] ASC, [SubProyecto] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_SAT_UsosCFDI] (
  [CveUsoCFDI] tinyint  NOT NULL,
  [UsoCFDI] varchar(5) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Descripcion] varchar(100) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [AplicaPersonaFisica] bit DEFAULT ((0)) NOT NULL,
  [AplicaPersonaMoral] bit DEFAULT ((0)) NOT NULL,
  [RegimenFiscalReceptor] varchar(200) COLLATE Modern_Spanish_CS_AI  NULL,
  CONSTRAINT [PK_Gral_SAT_UsosCFDI] PRIMARY KEY CLUSTERED ([CveUsoCFDI])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Vta_Vendedores] (
  [CveVendedor] int  IDENTITY(1,1) NOT NULL,
  [Codigo] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [Vendedor] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Correo] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Telefono] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [CveEsquemaComision] int  NULL,
  [Celular] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [TituloDocumentos] varchar(150) COLLATE Modern_Spanish_CS_AI  NULL,
  [EsSupervisor] bit  NULL,
  [CveSupervisor] int  NULL,
  [VendedorTipo] tinyint  NULL,
  [CveSuperior] int  NULL,
  [CveSubProyecto] int  NULL,
  [CorreoAdicionalNotificaciones] varchar(200) COLLATE Modern_Spanish_CS_AI  NULL,
  [FechaModificacion] datetime  NULL,
  CONSTRAINT [PK_Vta_Vendedores] PRIMARY KEY CLUSTERED ([CveVendedor])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Vta_FormaPago] (
  [CveFormaPago] tinyint  NOT NULL,
  [FormaPago] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ClaveFormaPagoSAT] varchar(2) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveUsuario] int  NOT NULL,
  [FechaIng] date  NULL,
  CONSTRAINT [PK_Vta_FormaPago] PRIMARY KEY CLUSTERED ([CveFormaPago])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Sis_PAC] (
  [CvePAC] int  NOT NULL,
  [PAC] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Sis_PAC] PRIMARY KEY CLUSTERED ([CvePAC])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Vta_MetodoPago] (
  [CveMetodoPago] tinyint  NOT NULL,
  [MetodoPago] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [ClaveMetodoPagoSAT] varchar(5) COLLATE Modern_Spanish_CS_AI  NULL,
  [CveUsuario] int  NULL,
  [FechaIng] date  NULL,
  CONSTRAINT [PK_Vta_MetodoPago] PRIMARY KEY CLUSTERED ([CveMetodoPago])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Vta_TipoDocumentos] (
  [CveTipoDocumento] varchar(3) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [TipoDocumento] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit  NULL,
  [FechaIng] date  NULL,
  [Multiplicador] smallmoney DEFAULT ((1)) NULL,
  [Contable] smallint DEFAULT ((0)) NOT NULL,
  CONSTRAINT [PK_Vta_TipoDocumentos] PRIMARY KEY CLUSTERED ([CveTipoDocumento])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[EstatusFactura] (
  [CveEstatusFactura] int  NOT NULL,
  [EstatusFactura] varchar(30) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estado] bit DEFAULT ((1)) NOT NULL,
  [Fecha] date DEFAULT (getdate()) NOT NULL,
  [CveUsuario] int  NOT NULL,
  [TipoDocto] varchar(3) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [TipoEstatus] smallint DEFAULT ((1)) NULL,
  [Origen] smallmoney DEFAULT ((1)) NULL,
  [EnProcesoCancelacion] bit DEFAULT ((0)) NOT NULL,
  CONSTRAINT [PK_EstatusFactura] PRIMARY KEY CLUSTERED ([CveEstatusFactura])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Gral_RegimenesFiscales] (
  [CveRegimenFiscal] tinyint  NOT NULL,
  [RegimenFiscal] varchar(100) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [CodigoRegimenFiscal] varchar(3) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [AplicaPersonaFisica] bit  NOT NULL,
  [AplicaPersonaMoral] bit  NOT NULL,
  CONSTRAINT [PK_Gral_RegimenesFiscales] PRIMARY KEY CLUSTERED ([CveRegimenFiscal])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZonasHorarias] (
  --esta reemplaza GPS_ZonasHorarias
  [CveZonaHoraria] int  NOT NULL,
  [Abreviacion] varchar(7) COLLATE Modern_Spanish_CS_AI  NULL,
  [ZonaHoraria] varchar(100) COLLATE Modern_Spanish_CS_AI  NULL,
  [UTC] varchar(20) COLLATE Modern_Spanish_CS_AI  NULL,
  [UTCOffset] int  NULL,
  CONSTRAINT [PK_ZonasHorarias] PRIMARY KEY CLUSTERED ([CveZonaHoraria])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [GPS]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Sat_Bancos] (
  [CveSATBanco] int  IDENTITY(1,1) NOT NULL,
  [CveBanco] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Banco] varchar(150) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [RazonSocial] varchar(300) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Sat_Bancos] PRIMARY KEY CLUSTERED ([CveSATBanco])
WITH (PAD_INDEX = OFF, FILLFACTOR = 90, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UQ_Sat_Bancos_CveBanco] UNIQUE NONCLUSTERED ([CveBanco] ASC)
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Banc_Bancos] (
  [CveBanco] int  IDENTITY(1,1) NOT NULL,
  [Banco] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Ejecutivo] varchar(50) COLLATE Modern_Spanish_CS_AI  NULL,
  [Telefono] varchar(10) COLLATE Modern_Spanish_CS_AI  NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [Fecha] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  [CveSATBanco] int  NULL,
  CONSTRAINT [PK_Bancos] PRIMARY KEY CLUSTERED ([CveBanco])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_Bancos] UNIQUE NONCLUSTERED ([Banco] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Banc_CreditosDetalle] (
  [CveCreditoDetalle] int  IDENTITY(1,1) NOT NULL,
  [Fecha] date  NOT NULL,
  [Estatus] smallint DEFAULT ((0)) NOT NULL,
  [Importe] money DEFAULT ((0)) NOT NULL,
  [Capital] money DEFAULT ((0)) NOT NULL,
  [Intereses] money DEFAULT ((0)) NOT NULL,
  [Seguro] money DEFAULT ((0)) NOT NULL,
  [IVACapital] money DEFAULT ((0)) NOT NULL,
  [IVAIntereses] money DEFAULT ((0)) NOT NULL,
  [IVASeguro] money DEFAULT ((0)) NOT NULL,
  [IVA] AS (([IVACapital]+[IVAIntereses])+[IVASeguro]),
  [Total] AS ((((([Capital]+[Intereses])+[Seguro])+[IVACapital])+[IVAIntereses])+[IVASeguro]),
  [ImporteGarantia] money  NULL,
  [Programado] money  NULL,
  [CveUsuario] int  NULL,
  [ImporteCapital] money  NULL,
  [ImporteInteres] money  NULL,
  CONSTRAINT [PK_Banc_CreditosDetalle] PRIMARY KEY CLUSTERED ([CveCreditoDetalle])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Banc_TiposCuenta] (
  [CveTipoCuenta] int  NOT NULL,
  [TipoCuenta] varchar(50) COLLATE Modern_Spanish_CS_AI  NOT NULL,
  [Estatus] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime  NOT NULL,
  [CveUsuario] int  NOT NULL,
  CONSTRAINT [PK_Banc_TiposCuenta] PRIMARY KEY CLUSTERED ([CveTipoCuenta])
WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY],
  CONSTRAINT [UN_BancTipoCuenta] UNIQUE NONCLUSTERED ([TipoCuenta] ASC)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
)
ON [PRIMARY]
GO

CREATE TABLE [dbo].[Conta_ConceptosContables] (
  [CveConceptoContable] int NOT NULL,
  [Tipo] varchar(5) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [ConceptoContable] varchar(50) COLLATE Modern_Spanish_CS_AI NOT NULL,
  [Estado] bit DEFAULT ((1)) NOT NULL,
  [FechaIng] datetime NOT NULL,
  [CveUsuario] int NOT NULL,
  [TipoConcepto] tinyint DEFAULT ((0)) NOT NULL,
  [Naturaleza] tinyint DEFAULT ((1)) NOT NULL,
  [CveTipoSaldo] int DEFAULT ((0)) NOT NULL,
  [CveParejaContable] int NULL,
  [AplicaTC] bit DEFAULT ((0)) NOT NULL,
  [AplicaSubProyecto] bit DEFAULT ((0)) NOT NULL,
  [AplicaCliente] bit DEFAULT ((0)) NOT NULL,
  [AplicaVenta] bit DEFAULT ((0)) NOT NULL,
  [AplicaCompra] bit DEFAULT ((0)) NOT NULL,
  [AplicaPersonal] bit DEFAULT ((0)) NOT NULL,
  [AplicaClasificacion] bit DEFAULT ((0)) NOT NULL,
  [AplicaBancos] bit DEFAULT ((0)) NOT NULL,
  [AplicaAlmacen] bit DEFAULT ((0)) NOT NULL,
  [EsCuentaUnica] bit DEFAULT ((0)) NOT NULL,
  [EsMonedaExtranjera] bit DEFAULT ((0)) NOT NULL,
  [EsSistema] bit DEFAULT ((0)) NOT NULL,
  [AplicaActivoFijo] bit DEFAULT ((0)) NOT NULL,
  [AplicaNomina] bit DEFAULT ((0)) NOT NULL,
  [EsGlobal] bit DEFAULT ((0)) NOT NULL,
  [AplicaImpuesto] bit DEFAULT ((0)) NOT NULL,
  [EsComplementaria] bit DEFAULT ((0)) NOT NULL,
  [AplicaCredito] bit DEFAULT ((0)) NOT NULL,
  [AplicaMovtoPermanente] bit DEFAULT ((0)) NOT NULL,
  [AplicaColectiva] bit DEFAULT ((0)) NOT NULL,
  [EsPago] bit DEFAULT ((0)) NOT NULL,
  [AplicaTipoGasto] bit DEFAULT ((0)) NOT NULL,
  CONSTRAINT [PK_Conta_ConceptosContables] PRIMARY KEY CLUSTERED ([CveConceptoContable])
  WITH (PAD_INDEX = OFF, FILLFACTOR = 80, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
  CONSTRAINT [UN_Conta_ConceptosContables] UNIQUE NONCLUSTERED ([ConceptoContable] ASC, [Tipo] ASC)
  WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
)
ON [PRIMARY]
GO

/* ==================== LLAVES FORANEAS ==================== */

ALTER TABLE [dbo].[Sis_Usuarios] ADD CONSTRAINT [FK_Sis_Usuarios_Roles]
        FOREIGN KEY ([CveRol])
        REFERENCES [dbo].[Sis_Roles] ([CveRol])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_Modulos] ADD CONSTRAINT [FK_Sis_Modulos_ModuloPadre]
        FOREIGN KEY ([CveModuloPadre])
        REFERENCES [dbo].[Sis_Modulos] ([CveModulo])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_Modulos] ADD CONSTRAINT [FK_Sis_Modulos_Plataformas]
        FOREIGN KEY ([CvePlataforma])
        REFERENCES [dbo].[Sis_Plataformas] ([CvePlataforma])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_RolesPermisos] ADD CONSTRAINT [FK_Sis_RolesPermisos_Roles]
        FOREIGN KEY ([CveRol])
        REFERENCES [dbo].[Sis_Roles] ([CveRol])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_RolesPermisos] ADD CONSTRAINT [FK_Sis_RolesPermisos_Permisos]
        FOREIGN KEY ([CvePermiso])
        REFERENCES [dbo].[Sis_Permisos] ([CvePermiso])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_RolesModulos] ADD CONSTRAINT [FK_Sis_RolesModulos_Roles]
        FOREIGN KEY ([CveRol])
        REFERENCES [dbo].[Sis_Roles] ([CveRol])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_RolesModulos] ADD CONSTRAINT [FK_Sis_RolesModulos_Modulos]
        FOREIGN KEY ([CveModulo])
        REFERENCES [dbo].[Sis_Modulos] ([CveModulo])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosPermisos] ADD CONSTRAINT [FK_Sis_UsuariosPermisos_Usuarios]
        FOREIGN KEY ([CveUsuario])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosPermisos] ADD CONSTRAINT [FK_Sis_UsuariosPermisos_Permisos]
        FOREIGN KEY ([CvePermiso])
        REFERENCES [dbo].[Sis_Permisos] ([CvePermiso])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosSesiones] ADD CONSTRAINT [FK_Sis_UsuariosSesiones_Usuarios]
        FOREIGN KEY ([CveUsuario])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosAutorizaciones] ADD CONSTRAINT [FK_Sis_UsuariosAutorizaciones_Permisos]
        FOREIGN KEY ([CvePermiso])
        REFERENCES [dbo].[Sis_Permisos] ([CvePermiso])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosAutorizaciones] ADD CONSTRAINT [FK_Sis_UsuariosAutorizaciones_UsuarioSolicitante]
        FOREIGN KEY ([CveUsuarioSolicitante])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosAutorizaciones] ADD CONSTRAINT [FK_Sis_UsuariosAutorizaciones_UsuarioAutorizador]
        FOREIGN KEY ([CveUsuarioAutorizador])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_UsuariosSuscripcionesPush] ADD CONSTRAINT [FK_Sis_UsuariosSuscripcionesPush_Usuarios]
        FOREIGN KEY ([CveUsuario])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_Notificaciones] ADD CONSTRAINT [FK_Sis_Notificaciones_Usuarios]
        FOREIGN KEY ([CveUsuario])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_NotificacionesEnvios] ADD CONSTRAINT [FK_Sis_NotificacionesEnvios_Notificaciones]
        FOREIGN KEY ([CveNotificacion])
        REFERENCES [dbo].[Sis_Notificaciones] ([CveNotificacion])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_IntentosInicioSesion] ADD CONSTRAINT [FK_Sis_IntentosInicioSesion_Usuarios]
        FOREIGN KEY ([CveUsuario])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_Auditorias] ADD CONSTRAINT [FK_Sis_Auditorias_Usuarios]
        FOREIGN KEY ([CveUsuario])
        REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_AuditoriasDetalles] ADD CONSTRAINT [FK_Sis_AuditoriasDetalles_Auditorias]
        FOREIGN KEY ([CveAuditoria])
        REFERENCES [dbo].[Sis_Auditorias] ([CveAuditoria])
        ON DELETE NO ACTION
        ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Gral_Categorias] ADD CONSTRAINT [FK_Categorias_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clasificaciones] ADD CONSTRAINT [FK_Clasificaciones_Categoria] FOREIGN KEY ([CveCategoria]) REFERENCES [dbo].[Gral_Categorias] ([CveCategoria]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clasificaciones] ADD CONSTRAINT [FK_Clasificaciones_Gral_SAT_ProductosServicios] FOREIGN KEY ([CveSATPS]) REFERENCES [dbo].[Gral_SAT_ProductosServicios] ([CveSATPS]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clasificaciones] ADD CONSTRAINT [FK_Clasificaciones_Usuarios_CveUsuario] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_BancosCuentas] ADD CONSTRAINT [FK_Banc_BancosCuentas_SubProyectos] FOREIGN KEY ([CveSubProyecto]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_BancosCuentas] ADD CONSTRAINT [FK_Banc_BancosCuentas_Banc_BancosCuentas1] FOREIGN KEY ([CveBancoCuentaPadre]) REFERENCES [dbo].[Banc_BancosCuentas] ([CveBancoCuenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_BancosCuentas] ADD CONSTRAINT [FK_Banc_BancosCuentas_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_BancosCuentas] ADD CONSTRAINT [FK_Banc_BancosCuentas_Banc_Bancos] FOREIGN KEY ([CveBanco]) REFERENCES [dbo].[Banc_Bancos] ([CveBanco]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_BancosCuentas] ADD CONSTRAINT [FK_Banc_BancosCuentas_Monedas] FOREIGN KEY ([CveMoneda]) REFERENCES [dbo].[Gral_Monedas] ([CveMoneda]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_BancosCuentas] ADD CONSTRAINT [FK_Banc_BancosCuentas_Banc_TiposCuenta] FOREIGN KEY ([CveTipoCuenta]) REFERENCES [dbo].[Banc_TiposCuenta] ([CveTipoCuenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_Cuentas] ADD CONSTRAINT [FK_Conta_Cuentas_Clientes] FOREIGN KEY ([CveCliente]) REFERENCES [dbo].[Clientes] ([CveCliente]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_Cuentas] ADD CONSTRAINT [FK_Conta_CuentasCodigosAgrupadoresSAT] FOREIGN KEY ([CveAgrupadorSAT]) REFERENCES [dbo].[Conta_CodigosAgrupadoresSAT] ([CveAgrupadorSAT]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_Cuentas] ADD CONSTRAINT [FK_Conta_Cuentas_CveCuentaPadre] FOREIGN KEY ([CveCuentaPadre]) REFERENCES [dbo].[Conta_Cuentas] ([CveCuenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_Cuentas] ADD CONSTRAINT [FK_Conta_Cuentas_BancosCuentas] FOREIGN KEY ([CveBancoCuenta]) REFERENCES [dbo].[Banc_BancosCuentas] ([CveBancoCuenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Inv_Almacenes] FOREIGN KEY ([CveAlmacenAsignado]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Inv_Almacenes1] FOREIGN KEY ([CveAlmacenAlterno]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Inv_Almacenes2] FOREIGN KEY ([CveAlmacenConsignacion]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Gral_SAT_UsosCFDI] FOREIGN KEY ([CveUsoCFDI]) REFERENCES [dbo].[Gral_SAT_UsosCFDI] ([CveUsoCFDI]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Vta_FormaPago] FOREIGN KEY ([CveFormaPago]) REFERENCES [dbo].[Vta_FormaPago] ([CveFormaPago]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Vta_MetodoPago] FOREIGN KEY ([CveMetodoPago]) REFERENCES [dbo].[Vta_MetodoPago] ([CveMetodoPago]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Gral_SAT_Estado] FOREIGN KEY ([CveSATEstado]) REFERENCES [dbo].[Gral_SAT_Estado] ([CveEstado]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Gral_RegimenesFiscales] FOREIGN KEY ([CveRegimenFiscal]) REFERENCES [dbo].[Gral_RegimenesFiscales] ([CveRegimenFiscal]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_GPS_ZonasHorarias] FOREIGN KEY ([CveZonaHoraria]) REFERENCES [dbo].[ZonasHorarias] ([CveZonaHoraria]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Vta_Vendedores_CveVendedor] FOREIGN KEY ([CveVendedor]) REFERENCES [dbo].[Vta_Vendedores] ([CveVendedor]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_TiposPoliza] ADD CONSTRAINT [FK_Conta_TiposPoliza_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PlantillasPolizas] ADD CONSTRAINT [FK_Conta_PlantillasPolizas_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Gral_Monedas] ADD CONSTRAINT [FK_Monedas_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_Clientes] FOREIGN KEY ([CveCliente]) REFERENCES [dbo].[Clientes] ([CveCliente]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_Conta_TiposPoliza] FOREIGN KEY ([CveTipoPoliza]) REFERENCES [dbo].[Conta_TiposPoliza] ([CveTipoPoliza]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_Conta_PlantillasPolizas] FOREIGN KEY ([CvePlantillaPoliza]) REFERENCES [dbo].[Conta_PlantillasPolizas] ([CvePlantillaPoliza]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_Monedas] FOREIGN KEY ([CveMoneda]) REFERENCES [dbo].[Gral_Monedas] ([CveMoneda]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_Conta_PrePolizas] FOREIGN KEY ([CvePrePolizaUnificada]) REFERENCES [dbo].[Conta_PrePolizas] ([CvePrePoliza]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_UsuariosModifico] FOREIGN KEY ([CveUsuarioModifico]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizas] ADD CONSTRAINT [FK_Conta_PrePolizas_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[UnidadesMedida] ADD CONSTRAINT [FK_UnidadesMedida_Gral_SAT_UnidadesMedida] FOREIGN KEY ([CveSATUnidadMedida]) REFERENCES [dbo].[Gral_SAT_UnidadesMedida] ([CveSATUnidadMedida]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[UnidadesMedida] ADD CONSTRAINT [FK_UnidadesMedida_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_UnidadesMedida] FOREIGN KEY ([CveUnidadMedida]) REFERENCES [dbo].[UnidadesMedida] ([CveUnidadMedida]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Clasificaciones1] FOREIGN KEY ([CveClasificacion2]) REFERENCES [dbo].[Clasificaciones] ([CveClasificacion]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Clasificaciones] FOREIGN KEY ([CveClasificacion]) REFERENCES [dbo].[Clasificaciones] ([CveClasificacion]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Usuarios_CveUsuarioModifico] FOREIGN KEY ([CveUsuarioModifico]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Gral_SAT_CP_MaterialPeligroso] FOREIGN KEY ([CveMaterialPeligroso]) REFERENCES [dbo].[Gral_SAT_CP_MaterialPeligroso] ([CveMaterialPeligroso]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Gral_ObjetoImpuesto] FOREIGN KEY ([CveObjetoImpuesto]) REFERENCES [dbo].[Gral_SAT_ObjetoImpuesto] ([CveObjetoImpuesto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Monedas_CveMoneda] FOREIGN KEY ([CveMoneda]) REFERENCES [dbo].[Gral_Monedas] ([CveMoneda]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_TiposAlmacenes] ADD CONSTRAINT [FK_INV_TiposAlmacenes_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Inv_AlmacenesRef1] FOREIGN KEY ([CveAlmacenRef1]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Inv_AlmacenesRef2] FOREIGN KEY ([CveAlmacenRef2]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Inv_AlmacenesRef3] FOREIGN KEY ([CveAlmacenRef3]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Inv_AlmacenesRef4] FOREIGN KEY ([CveAlmacenRef4]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Inv_AlmacenesRef5] FOREIGN KEY ([CveAlmacenRef5]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Sis_Usuarios_CveUsuario] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_SubProyectos] FOREIGN KEY ([CveSubProyecto]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Sis_Usuarios_CveUsuarioAutoriza] FOREIGN KEY ([CveUsuarioAutoriza]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_Inv_Almacenes_Inv_Almacenes] FOREIGN KEY ([CveAlmacenVirtual]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Inv_Almacenes] ADD CONSTRAINT [FK_INV_Almacenes_INV_TiposAlmacenes] FOREIGN KEY ([CveTipoAlmacen]) REFERENCES [dbo].[Inv_TiposAlmacenes] ([CveTipoAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Vta_FormaPago] FOREIGN KEY ([CveFormaPago33]) REFERENCES [dbo].[Vta_FormaPago] ([CveFormaPago]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Vta_MetodoPago] FOREIGN KEY ([CveMetodoPago33]) REFERENCES [dbo].[Vta_MetodoPago] ([CveMetodoPago]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Gral_SAT_UsosCFDI] FOREIGN KEY ([CveUsoCFDI]) REFERENCES [dbo].[Gral_SAT_UsosCFDI] ([CveUsoCFDI]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Vta_Vendedores] FOREIGN KEY ([CveVendedor]) REFERENCES [dbo].[Vta_Vendedores] ([CveVendedor]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Inv_Almacenes] FOREIGN KEY ([CveAlmacenAsignado]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Inv_Almacenes2] FOREIGN KEY ([CveAlmacenAlterno]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Inv_Almacenes3] FOREIGN KEY ([CveAlmacenConsignacion]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_Vta_ClientesSucursales_Clientes_CveCliente] FOREIGN KEY ([CveCliente]) REFERENCES [dbo].[Clientes] ([CveCliente]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_ClientesSucursales] ADD CONSTRAINT [FK_SucursalCliente_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_Procedimientos] ADD CONSTRAINT [FK_Vta_Procedimientos_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Inv_Almacenes] FOREIGN KEY ([CveAlmacenTraspasoDestino]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Inv_Almacenes_TraspasoOrigen] FOREIGN KEY ([CveAlmacenTraspasoOrigen]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Inv_Almacenes1] FOREIGN KEY ([CveAlmacenSurtio]) REFERENCES [dbo].[Inv_Almacenes] ([CveAlmacen]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Usuarios1] FOREIGN KEY ([CveUsuarioCobranza]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Vta_Procedimientos] FOREIGN KEY ([CveProcedimiento]) REFERENCES [dbo].[Vta_Procedimientos] ([CveProcedimiento]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Vta_ClientesSucursales] FOREIGN KEY ([CveClienteSucursal]) REFERENCES [dbo].[Vta_ClientesSucursales] ([CveClienteSucursal]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Gral_SAT_UsosCFDI] FOREIGN KEY ([CveUsoCFDI]) REFERENCES [dbo].[Gral_SAT_UsosCFDI] ([CveUsoCFDI]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Vta_Vendedores] FOREIGN KEY ([CveVendedor]) REFERENCES [dbo].[Vta_Vendedores] ([CveVendedor]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Vta_FormaPago] FOREIGN KEY ([CveFormaPago33]) REFERENCES [dbo].[Vta_FormaPago] ([CveFormaPago]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_EstatusFactura] FOREIGN KEY ([CveEstatusFactura]) REFERENCES [dbo].[EstatusFactura] ([CveEstatusFactura]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Ventas] FOREIGN KEY ([CveVentaFacturada]) REFERENCES [dbo].[Ventas] ([CveVenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Monedas] FOREIGN KEY ([CveMoneda]) REFERENCES [dbo].[Gral_Monedas] ([CveMoneda]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Sis_PACCancelacion] FOREIGN KEY ([CvePACCancelacion]) REFERENCES [dbo].[Sis_PAC] ([CvePAC]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Sis_PAC] FOREIGN KEY ([CvePAC]) REFERENCES [dbo].[Sis_PAC] ([CvePAC]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Vta_MetodoPago] FOREIGN KEY ([CveMetodoPago33]) REFERENCES [dbo].[Vta_MetodoPago] ([CveMetodoPago]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Ventas1] FOREIGN KEY ([CveVenta]) REFERENCES [dbo].[Ventas] ([CveVenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Vta_TipoDocumentos] FOREIGN KEY ([TipoDocto]) REFERENCES [dbo].[Vta_TipoDocumentos] ([CveTipoDocumento]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_SubProyectos2] FOREIGN KEY ([CveSubProyectoCobranza]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Usuarios_CveUsuarioCambioEstatus] FOREIGN KEY ([CveUsuarioCambioEstatus]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_SubProyectos] FOREIGN KEY ([CveSubProyecto]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_SubProyectos1] FOREIGN KEY ([CveSubProyectoEjecucion]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Conta_PrePolizas] FOREIGN KEY ([CvePrePoliza]) REFERENCES [dbo].[Conta_PrePolizas] ([CvePrePoliza]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Clientes] FOREIGN KEY ([CveCliente]) REFERENCES [dbo].[Clientes] ([CveCliente]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Clasificaciones] FOREIGN KEY ([CveClasificacion]) REFERENCES [dbo].[Clasificaciones] ([CveClasificacion]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Banc_CreditosDetalle] FOREIGN KEY ([CveCreditoDetalle]) REFERENCES [dbo].[Banc_CreditosDetalle] ([CveCreditoDetalle]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Usuarios] FOREIGN KEY ([CveUsuarioModifico]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Conta_ConceptosContables] FOREIGN KEY ([CveConceptoContable]) REFERENCES [dbo].[Conta_ConceptosContables] ([CveConceptoContable]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Conta_Cuentas] FOREIGN KEY ([CveCuenta]) REFERENCES [dbo].[Conta_Cuentas] ([CveCuenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Clientes] FOREIGN KEY ([CveCliente]) REFERENCES [dbo].[Clientes] ([CveCliente]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Ventas] FOREIGN KEY ([CveVenta]) REFERENCES [dbo].[Ventas] ([CveVenta]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Proyectos] ADD CONSTRAINT [FK_Proyectos_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_Proyectos] FOREIGN KEY ([CveProyecto]) REFERENCES [dbo].[Proyectos] ([CveProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_SubProyectoPadre] FOREIGN KEY ([CveSubProyectoPadre]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_Gral_SAT_Localidad] FOREIGN KEY ([CveLocalidad]) REFERENCES [dbo].[Gral_SAT_Localidad] ([CveLocalidad]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_Gral_SAT_Estado] FOREIGN KEY ([CveEstado]) REFERENCES [dbo].[Gral_SAT_Estado] ([CveEstado]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_Sis_Usuarios_CveUsuarioNomina] FOREIGN KEY ([CveUsuarioNomina]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_Sis_Usuarios_CveUsuario] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[SubProyectos] ADD CONSTRAINT [FK_SubProyectos_Clientes] FOREIGN KEY ([CveClientePublicoGral]) REFERENCES [dbo].[Clientes] ([CveCliente]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_Vendedores] ADD CONSTRAINT [FK_Vta_Vendedores_SubProyectos] FOREIGN KEY ([CveSubProyecto]) REFERENCES [dbo].[SubProyectos] ([CveSubProyecto]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_Vendedores] ADD CONSTRAINT [FK_Vta_Vendedores_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_FormaPago] ADD CONSTRAINT [FK_Vta_FormaPago_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sis_PAC] ADD CONSTRAINT [FK_Sis_PAC_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Vta_MetodoPago] ADD CONSTRAINT [FK_Vta_MetodoPago_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[EstatusFactura] ADD CONSTRAINT [FK_EstatusFactura_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Sat_Bancos] ADD CONSTRAINT [FK_Sat_Bancos_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_Bancos] ADD CONSTRAINT [FK_Banc_Bancos_Sat_Bancos] FOREIGN KEY ([CveSATBanco]) REFERENCES [dbo].[Sat_Bancos] ([CveSATBanco]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_Bancos] ADD CONSTRAINT [FK_Banc_Bancos_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_CreditosDetalle] ADD CONSTRAINT [FK_Banc_CreditosDetalle_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Banc_TiposCuenta] ADD CONSTRAINT [FK_Banc_TiposCuenta_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_ConceptosContables] ADD CONSTRAINT [FK_Conta_ConceptosContables_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_ConceptosContables] ADD CONSTRAINT [FK_Conta_ConceptosContables_ConceptoPareja] FOREIGN KEY ([CveParejaContable]) REFERENCES [dbo].[Conta_ConceptosContables] ([CveConceptoContable]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[Conta_PrePolizasDetalle] ADD CONSTRAINT [FK_Conta_PrePolizasDetalle_Conta_PrePolizas] FOREIGN KEY ([CvePrePoliza]) REFERENCES [dbo].[Conta_PrePolizas] ([CvePrePoliza]);
GO

ALTER TABLE [dbo].[Conta_CodigosAgrupadoresSAT] ADD CONSTRAINT [FK_Conta_CodigosAgrupadoresSAT_Padre] FOREIGN KEY ([CveAgrupadorPadre]) REFERENCES [dbo].[Conta_CodigosAgrupadoresSAT] ([CveAgrupadorSAT]);
GO

ALTER TABLE [dbo].[Conta_Cuentas] ADD CONSTRAINT [FK_Conta_Cuentas_Sis_Usuarios] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]);
GO

ALTER TABLE [dbo].[Conta_Cuentas] ADD CONSTRAINT [FK_Conta_Cuentas_Gral_Monedas] FOREIGN KEY ([CveMoneda]) REFERENCES [dbo].[Gral_Monedas] ([CveMoneda]);
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Sis_Usuarios_CveUsuario] FOREIGN KEY ([CveUsuario]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]);
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Sis_Usuarios_CveUsuarioResponsable] FOREIGN KEY ([CveUsuarioResponsable]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]);
GO

ALTER TABLE [dbo].[Clientes] ADD CONSTRAINT [FK_Clientes_Sis_Usuarios_CveUsuarioModifico] FOREIGN KEY ([CveUsuarioModifico]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]);
GO

ALTER TABLE [dbo].[Ventas] ADD CONSTRAINT [FK_Ventas_Sis_Usuarios_CveUsuarioModifico] FOREIGN KEY ([CveUsuarioModifico]) REFERENCES [dbo].[Sis_Usuarios] ([CveUsuario]);
GO

ALTER TABLE [dbo].[EstatusFactura] ADD CONSTRAINT [FK_EstatusFactura_Vta_TipoDocumentos] FOREIGN KEY ([TipoDocto]) REFERENCES [dbo].[Vta_TipoDocumentos] ([CveTipoDocumento]);
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Conta_ConceptosContables] FOREIGN KEY ([CveConceptoContable]) REFERENCES [dbo].[Conta_ConceptosContables] ([CveConceptoContable]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO

ALTER TABLE [dbo].[ProductosServicios] ADD CONSTRAINT [FK_ProductosServicios_Gral_SAT_ProductosServicios] FOREIGN KEY ([CveSATPS]) REFERENCES [dbo].[Gral_SAT_ProductosServicios] ([CveSATPS]) ON DELETE NO ACTION ON UPDATE NO ACTION;
GO