USE [engis_kirash_olap]
GO
/****** Object:  Table [dbo].[BANCOS]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BANCOS](
	[CODBANCO] [varchar](6) NOT NULL,
	[NOMEBANCO] [varchar](70) NULL,
	[ENDERBANC] [varchar](60) NULL,
	[CIDADEBAN] [varchar](40) NULL,
	[ESTABANC] [varchar](4) NULL,
	[CEPBANCO] [varchar](16) NULL,
	[FONE1BANC] [varchar](20) NULL,
	[FONE2BANC] [varchar](20) NULL,
	[FAXBANC] [varchar](20) NULL,
	[CONTATOBAN] [varchar](40) NULL,
	[NUMAGENCIA] [varchar](20) NULL,
	[DIGAGENCIA] [varchar](1) NULL,
	[NOMEAGENCI] [varchar](60) NULL,
	[NOCONTA] [varchar](40) NULL,
	[DIGCONTA] [varchar](1) NULL,
	[NUMCONTRATO] [varchar](20) NULL,
	[NUMCARTEIRA] [varchar](10) NULL,
	[CODCEDENTE] [varchar](20) NULL,
	[CLAYOUT] [varchar](7) NULL,
	[CPASTA] [varchar](120) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[BaseDados]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[BaseDados](
	[Cliente] [varchar](15) NULL,
	[Servidor] [varchar](40) NULL,
	[DSN] [varchar](40) NULL,
	[Base] [varchar](40) NULL,
	[BaseOlap] [varchar](40) NULL,
	[CodigoCliente] [varchar](20) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Centro_Custo]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Centro_Custo](
	[ccodigo] [varchar](5) NOT NULL,
	[cdescricao] [varchar](80) NOT NULL,
	[cnivel] [varchar](1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Centro_Custo_Lancamentos]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Centro_Custo_Lancamentos](
	[Controle] [int] NOT NULL,
	[Tipo_Despesa] [varchar](5) NULL,
	[Codigo_Empresa] [varchar](10) NULL,
	[Centro_Custo] [varchar](5) NULL,
	[Data_Documento] [datetime] NULL,
	[Data_Vencimento] [datetime] NULL,
	[Data_Pagamento] [datetime] NULL,
	[Valor_Despesa] [float] NULL,
	[Perc_Rateio] [float] NULL,
	[Valor_Rateio] [float] NULL,
	[Controle_Lancamento] [varchar](10) NULL,
	[Usuario_Gerente] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Centro_Custo_Rateio]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Centro_Custo_Rateio](
	[CTIPODESPESA] [varchar](5) NOT NULL,
	[CCENTROCUSTO] [varchar](5) NOT NULL,
	[NPERCRATEIO] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[GRPUSERS]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GRPUSERS](
	[CCODGRUPO] [varchar](10) NOT NULL,
	[CNOME] [varchar](60) NULL,
	[CFLAGBLOQUEADO] [varchar](2) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[LANCAMENTOS_BANCARIOS]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LANCAMENTOS_BANCARIOS](
	[LANCAMENTO] [int] NOT NULL,
	[COD_FILIAL] [varchar](3) NULL,
	[DATALANCAM] [datetime] NULL,
	[COD_BAN] [varchar](6) NULL,
	[TIPOLANCAM] [varchar](1) NULL,
	[VALORLANCA] [float] NULL,
	[NUMERODOCUMENTO] [varchar](15) NULL,
	[FORMALANCA] [varchar](15) NULL,
	[HISTORICO] [varchar](40) NULL,
	[DATAEXTRAT] [datetime] NULL,
	[CONTROLE_CAIXA] [int] NULL,
	[DATA_ALTERACAO] [datetime] NULL,
	[USUARIO] [varchar](6) NULL,
	[CONTROLE_DUP] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Permuser]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Permuser](
	[CMATRICULA] [varchar](6) NULL,
	[CNOMETRANSACAO] [varchar](64) NULL,
	[CCODGRUPO] [varchar](5) NULL,
	[CPODEALTERAR] [varchar](1) NULL,
	[CPODEAPAGAR] [varchar](1) NULL,
	[CPODEINCLUIR] [varchar](1) NULL,
	[CNIVELACESSO] [varchar](1) NULL,
	[CNOMECEX] [varchar](10) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Sequenciais]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Sequenciais](
	[CTIPO] [varchar](15) NULL,
	[ISEQL] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Usuarios]    Script Date: 11/01/2018 18:16:19 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Usuarios](
	[CMATRICULA] [varchar](6) NOT NULL,
	[CNOME] [varchar](35) NULL,
	[CENDERECO] [varchar](50) NULL,
	[CBAIRRO] [varchar](25) NULL,
	[CCEP] [varchar](8) NULL,
	[CCIDADE] [varchar](25) NULL,
	[CTELEFONE] [varchar](10) NULL,
	[DDTNASC] [datetime] NULL,
	[CCTPS] [varchar](10) NULL,
	[CRG] [varchar](15) NULL,
	[CCPF] [varchar](11) NULL,
	[CCODGRUPO] [varchar](5) NULL,
	[CSENHAACESSO] [varchar](10) NULL,
	[DDATAEXPIRACAO] [datetime] NULL,
	[CFLAGBLOQUEADA] [varchar](1) NULL,
	[CFLAGALTERARSENHA] [varchar](1) NULL,
	[CSITUACAO] [varchar](1) NULL,
	[CUSUARIO_GERENTE] [varchar](1) NULL,
	[NLIMITEDESCONTO] [float] NULL,
	[USUARIO_GERENTE] [varchar](1) NULL,
	[EMAIL] [varchar](40) NULL,
	[CPERMITEREABRIRPEDIDO] [varchar](1) NULL,
	[CPERMITEATRIBUIRRESPONSAVEL] [varchar](1) NULL,
	[CPERMITEMODIFICARVENDEDOR] [varchar](1) NULL,
	[CPERMITEMODIFICARDATA] [varchar](1) NULL,
	[CPERMITELIBERARPEDIDO] [varchar](1) NULL,
	[NVENDEDOR] [int] NULL,
	[CNOTIFICA_NFE] [varchar](1) NULL,
	[CNOTIFICA_PEDIDOAPROVADO] [varchar](1) NULL,
	[CNOTIFICA_PEDIDOSEPARADO] [varchar](1) NULL,
	[CNOTIFICA_PEDIDOANALISE] [varchar](1) NULL,
	[CSUBMETER_PEDIDO] [varchar](1) NULL,
 CONSTRAINT [PK_Usuarios] PRIMARY KEY CLUSTERED 
(
	[CMATRICULA] 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
SET ANSI_PADDING OFF
GO