USE [engis_kirash]
GO
/****** Object:  Table [dbo].[ABERTURA_CAIXA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[ABERTURA_CAIXA](
	[DATACAIXA] [datetime] NULL,
	[PERIODO_CAIXA] [varchar](1) NULL,
	[CODIGO_CAIXA] [varchar](6) NULL,
	[CODIGO_GERENTE] [varchar](6) NULL,
	[HORA_ABERTURA] [datetime] NULL,
	[SITUACAO_CAIXA] [varchar](1) NULL,
	[HORA_FECHAMENTO] [datetime] NULL,
	[FUNDO_TROCO] [float] NULL,
	[VENDA_BRUTA] [float] NULL,
	[TOTAL_RECEBIMENTOS] [float] NULL,
	[TOTAL_TROCOS] [float] NULL,
	[DESCONTO_ITEM] [float] NULL,
	[DESCONTO_PENOTA] [float] NULL,
	[VENDA_LIQUIDA] [float] NULL,
	[QUANTIDADE_VENDAS] [int] NULL,
	[QUANTIDADE_ITENS_VEND] [int] NULL,
	[RETIRADAS_CAIXA] [float] NULL,
	[SANGRIA_CAIXA] [float] NULL,
	[PAGAMENTOS_RECEBIDOS] [float] NULL,
	[SUPRIMENTO_CAIXA] [float] NULL,
	[QUANTIDADE_CANCELAMENTO] [int] NULL,
	[TOTAL_CANCELAMENTOS] [float] NULL,
	[DINHEIRO] [float] NULL,
	[CHEQUE] [float] NULL,
	[CHEQUE_PRE] [float] NULL,
	[CARTAO] [float] NULL,
	[CONTA_ASSINADA] [float] NULL,
	[VALE_ALIMENTACAO] [float] NULL,
	[TROCAS_RECEBIDAS] [float] NULL,
	[TROCAS_DEVOLVIDAS] [float] NULL,
	[DUPLICATAS_RECEBIDAS] [float] NULL,
	[DUPLICATAS] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Agentes]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Agentes](
	[CCODAGENTE] [varchar](3) NULL,
	[CDESCRICAO] [varchar](25) NULL,
	[CCobrancaBancaria] [varchar](3) NULL,
	[CCODBANCO] [varchar](6) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AGENTESCONDICOESPAGAMENTO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AGENTESCONDICOESPAGAMENTO](
	[CCODAGENTE] [varchar](3) NULL,
	[NCODCONDPAGAMENTO] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AJUSTE_ESTOQUE]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AJUSTE_ESTOQUE](
	[Numero_Controle] [int] NOT NULL,
	[Data_Movimento] [datetime] NULL,
	[Referencia] [varchar](9) NULL,
	[Entrada_Saida] [varchar](1) NULL,
	[Estoque] [float] NULL,
	[Quantidade] [float] NULL,
	[Historico] [varchar](40) NULL,
 CONSTRAINT [PK_AJUSTE_ESTOQUE] PRIMARY KEY CLUSTERED 
(
	[Numero_Controle] 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
/****** Object:  Table [dbo].[AJUSTE_ESTOQUE_ITEM]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AJUSTE_ESTOQUE_ITEM](
	[NUMERO_CONTROLE] [int] NOT NULL,
	[DATA_MOVIMENTO] [datetime] NULL,
	[CODIGO_ITEM] [varchar](60) NULL,
	[ENTRADA_SAIDA] [varchar](1) NULL,
	[QUANTIDADE] [float] NULL,
	[HISTORICO] [varchar](40) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AjusteEstoqueProducao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AjusteEstoqueProducao](
	[NNUMCONTROLE] [int] NOT NULL,
	[DDATAAJUSTE] [datetime] NULL,
	[CUSUARIO] [varchar](6) NULL,
	[CMOTIVO] [varchar](1) NULL,
	[CHISTORICO] [varchar](60) NULL,
	[CSTATUS] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[AjusteEstoqueProducaoMov]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[AjusteEstoqueProducaoMov](
	[NNUMCONTROLE] [int] NOT NULL,
	[CREFERENCIA] [varchar](9) NOT NULL,
	[CTIPOMOVIMENTO] [varchar](1) NOT NULL,
	[NQUANTIDADE] [float] NULL,
	[NCTRESTOQUE] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[BANCOS]    Script Date: 11/01/2018 18:18:01 ******/
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].[CANCELAMENTO_PEDIDOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CANCELAMENTO_PEDIDOS](
	[CNUMPEDIDO] [varchar](8) NULL,
	[DDATAEMISSAO] [datetime] NULL,
	[DDATACANCELAMENTO] [datetime] NULL,
	[NVALORPEDIDO] [float] NULL,
	[COPERADOR] [varchar](6) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Carta_Correcao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Carta_Correcao](
	[CNUMNF] [varchar](6) NOT NULL,
	[CNUMSERIE] [varchar](1) NOT NULL,
	[CRAZAO] [varchar](1) NULL,
	[CENDERECO] [varchar](1) NULL,
	[CMUNICIPIO] [varchar](1) NULL,
	[CESTADO] [varchar](1) NULL,
	[CCNPJ] [varchar](1) NULL,
	[CIE] [varchar](1) NULL,
	[CNATOPER] [varchar](1) NULL,
	[CCODFISCAL] [varchar](1) NULL,
	[CVIATRASP] [varchar](1) NULL,
	[CEMISSAO] [varchar](1) NULL,
	[CSAIDA] [varchar](1) NULL,
	[CUN] [varchar](1) NULL,
	[CQTD] [varchar](1) NULL,
	[CDESCRICAO] [varchar](1) NULL,
	[CPRECO] [varchar](1) NULL,
	[CTOTAL] [varchar](1) NULL,
	[CCLASFISCAL] [varchar](1) NULL,
	[CALIQIPI] [varchar](1) NULL,
	[CVALORIPI] [varchar](1) NULL,
	[CBASECALIPI] [varchar](1) NULL,
	[CVALORTOTALNF] [varchar](1) NULL,
	[CALIQICMS] [varchar](1) NULL,
	[CVALORICMS] [varchar](1) NULL,
	[CBASEICMS] [varchar](1) NULL,
	[CTRANSPORTADOR] [varchar](1) NULL,
	[CENDTRANSPORTADOR] [varchar](1) NULL,
	[CISENCAOIPI] [varchar](1) NULL,
	[CISENCAOICMS] [varchar](1) NULL,
	[CPESOBRUTO] [varchar](1) NULL,
	[CVOLQTD] [varchar](1) NULL,
	[CRASURAS] [varchar](1) NULL,
	[CFRETE] [varchar](1) NULL,
	[CVENCIMENTO] [varchar](1) NULL,
	[CVALORDUP] [varchar](1) NULL,
	[CLOCALENTREGA] [varchar](1) NULL,
	[CDATAENTREGA] [varchar](1) NULL,
	[CDESCAUX] [varchar](1) NULL,
	[CCODIGO01] [varchar](2) NULL,
	[CCODIGO02] [varchar](2) NULL,
	[CCODIGO03] [varchar](2) NULL,
	[CCODIGO04] [varchar](2) NULL,
	[CCODIGO05] [varchar](2) NULL,
	[CRETIFICACAO01] [varchar](50) NULL,
	[CRETIFICACAO02] [varchar](50) NULL,
	[CRETIFICACAO03] [varchar](50) NULL,
	[CRETIFICACAO04] [varchar](50) NULL,
	[CRETIFICACAO05] [varchar](50) NULL,
 CONSTRAINT [PK_Carta_Correcao_1] PRIMARY KEY CLUSTERED 
(
	[CNUMNF] ASC,
	[CNUMSERIE] 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
/****** Object:  Table [dbo].[CATEGORIAS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CATEGORIAS](
	[CCODCATEGORIA] [varchar](2) NOT NULL,
	[CDESCRICAO] [varchar](25) NULL,
	[CTIPOPESSOA] [varchar](1) NULL,
	[CCLASSE] [varchar](1) NULL,
 CONSTRAINT [PK_CATEGORIAS] PRIMARY KEY CLUSTERED 
(
	[CCODCATEGORIA] 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
/****** Object:  Table [dbo].[Cedente]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cedente](
	[CODFOR] [int] NOT NULL,
	[NOME] [varchar](45) NULL,
	[ENDERECO] [varchar](45) NULL,
	[CIDADE] [varchar](20) NULL,
	[UF] [varchar](2) NULL,
	[CGC] [varchar](14) NULL,
	[CGF] [varchar](10) NULL,
	[CONTATO] [varchar](20) NULL,
	[FONE] [varchar](10) NULL,
	[FAX] [varchar](10) NULL,
	[TELEFONE] [varchar](10) NULL,
	[TIPFOR] [varchar](1) NULL,
	[CATEGORIA] [varchar](1) NULL,
	[INSISS] [varchar](15) NULL,
	[INSINSS] [varchar](15) NULL,
	[CEP] [varchar](8) NULL,
	[CXPOSTAL] [varchar](10) NULL,
	[COBSERVACOES] [text] NULL,
 CONSTRAINT [PK_Cedente] PRIMARY KEY NONCLUSTERED 
(
	[CODFOR] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Cheques_Receber]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Cheques_Receber](
	[Controle] [int] NULL,
	[Data_Movimento] [datetime] NULL,
	[Cpf_Titular] [varchar](15) NULL,
	[Titular] [varchar](40) NULL,
	[Banco] [varchar](6) NULL,
	[Numero_Cheque] [varchar](15) NULL,
	[Agencia] [varchar](15) NULL,
	[Valor] [float] NULL,
	[Vencimento] [datetime] NULL,
	[Historico] [varchar](40) NULL,
	[Status] [varchar](1) NULL,
	[Data_Extrato] [datetime] NULL,
	[Portador] [varchar](40) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Clientes]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Clientes](
	[CCODCLIENTE] [varchar](18) NOT NULL,
	[NCODSEQUENCIAL] [int] NULL,
	[CCODCATEGORIA] [varchar](2) NULL,
	[CNOME] [varchar](50) NULL,
	[CCGF] [varchar](15) NULL,
	[CENDERECO] [varchar](50) NULL,
	[CCOMPLEMENTO] [varchar](25) NULL,
	[CNUMERO] [varchar](5) NULL,
	[CBAIRRO] [varchar](25) NULL,
	[CCEP] [varchar](8) NULL,
	[CCIDADE] [varchar](25) NULL,
	[CUF] [varchar](2) NULL,
	[CCODREGIAO] [varchar](3) NULL,
	[CDDD] [varchar](3) NULL,
	[CFONE] [varchar](8) NULL,
	[CCELULAR] [varchar](9) NULL,
	[CFAX] [varchar](8) NULL,
	[CCONTATO] [varchar](25) NULL,
	[CCODAGENTE] [varchar](3) NULL,
	[CCODTRANSPORTADORA] [varchar](14) NULL,
	[NCODCONDPAGAMENTO] [float] NULL,
	[NNUMPARCELAS] [float] NULL,
	[CPRAZO] [varchar](9) NULL,
	[NDESCONTO] [float] NULL,
	[NCREDITO] [float] NULL,
	[NLIMITE] [float] NULL,
	[NVENDEDOR] [int] NULL,
	[COBSERVACOES] [text] NULL,
	[NDESCDIDATICO] [float] NULL,
	[NDESCPARADIDATICO] [float] NULL,
	[NDESCLITERATURA] [float] NULL,
	[NDESCMULTIMIDIA] [float] NULL,
	[CUSUARIO] [varchar](30) NULL,
	[CCODOPERACAO] [varchar](4) NULL,
	[DULTIMAATUALIZACAO] [datetime] NULL,
	[DDATACADASTRO] [datetime] NULL,
	[DULTIMOPEDIDO] [datetime] NULL,
	[DULTIMOFATURAMENTO] [datetime] NULL,
	[DANIVERSARIO] [datetime] NULL,
	[CSITUACAO] [varchar](1) NULL,
	[CCALCULAIPI] [varchar](1) NULL,
	[CAGRUPANOTA] [varchar](1) NULL,
	[CCALCULAICMS] [varchar](1) NULL,
	[COBSICMS1] [varchar](80) NULL,
	[COBSICMS2] [varchar](80) NULL,
	[COBSICMS3] [varchar](80) NULL,
	[COBSICMS4] [varchar](80) NULL,
	[NATRASOMAX] [int] NULL,
	[CENDERECOCOB] [varchar](50) NULL,
	[CBAIRROCOB] [varchar](25) NULL,
	[CCEPCOB] [varchar](8) NULL,
	[CUFCOB] [varchar](2) NULL,
	[CCIDADECOB] [varchar](25) NULL,
	[CDESCONTOSDE] [varchar](20) NULL,
	[CDESCONTOSATE] [varchar](20) NULL,
	[CCONDESPECIAIS] [varchar](30) NULL,
	[CPRACAPGTO] [varchar](50) NULL,
	[NPROTESTO] [int] NULL,
	[NJUROS] [float] NULL,
	[NMULTA] [float] NULL,
	[NALIQ_REDUCAO] [float] NULL,
	[CSOLICITACODIGOS] [varchar](1) NULL,
	[CEMAIL] [varchar](50) NULL,
	[CSITE] [varchar](50) NULL,
	[CCODMUNICIPIO] [varchar](10) NULL,
	[cidmunicipio] [varchar](7) NULL,
	[NAOCOBRARBOLETO] [varchar](1) NULL,
	[CEXPORTAR] [varchar](1) NULL,
	[CTABELA] [varchar](10) NULL,
	[cfantasia] [varchar](60) NULL,
	[CSEMPIS] [varchar](1) NULL,
	[CSEMCOFINS] [varchar](1) NULL,
	[CCODPAIS] [varchar](5) NULL,
	[CPAIS] [varchar](40) NULL,
	[clocalembarque] [varchar](40) NULL,
	[cufembarque] [varchar](2) NULL,
	[CARREDONDAITEMST] [varchar](1) NULL,
	[CEMBUTIRDESCONTO] [varchar](1) NULL,
	[cemailnfe] [varchar](120) NULL,
	[clatitude] [varchar](30) NULL,
	[clongitude] [varchar](30) NULL,
	[ctipo] [varchar](1) NULL,
	[CCODMATRIZ] [varchar](18) NULL,
	[COBSEXPEDICAO] [varchar](120) NULL,
	[NMETAVENDA] [float] NULL,
	[NROTAVENDEDOR] [int] NULL,
	[NROTAORDEM] [int] NULL,
	[cclassificacao] [varchar](3) NULL,
	[ccodgrupo] [varchar](18) NULL,
	[CCLASSE] [varchar](1) NULL,
	[CCLIENTE] [varchar](1) NULL,
	[CFORNECEDOR] [varchar](1) NULL,
	[CREPRESENTANTE] [varchar](1) NULL,
	[CCOMERCIAL] [varchar](1) NULL,
	[NALIQ_ICMS_INT] [float] NULL,
	[CDDD_CEL] [varchar](3) NULL,
	[CDDD_RES] [varchar](3) NULL,
	[CFONERES] [varchar](8) NULL,
	[CDDD_FAX] [varchar](3) NULL,
	[COUTROS] [varchar](1) NULL,
	[cgrupo] [int] NULL,
 CONSTRAINT [PK_Clientes] PRIMARY KEY CLUSTERED 
(
	[CCODCLIENTE] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[CODIGOBARRASPEDIDO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CODIGOBARRASPEDIDO](
	[CNUMPEDIDO] [varchar](6) NOT NULL,
	[CREFERENCIA] [varchar](9) NOT NULL,
	[CCODBARRAS] [varchar](13) NOT NULL,
	[NQTDPEDIDA] [float] NULL,
	[NQTDATENDIDA] [float] NULL,
 CONSTRAINT [PK_CODIGOBARRASPEDIDO] PRIMARY KEY CLUSTERED 
(
	[CNUMPEDIDO] ASC,
	[CREFERENCIA] ASC,
	[CCODBARRAS] 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
/****** Object:  Table [dbo].[Codigos_Barras]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Codigos_Barras](
	[Codigo_Barras] [varchar](13) NULL,
	[Descricao_Produto] [varchar](35) NULL,
	[Referencia] [varchar](9) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Composicao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Composicao](
	[CREFERENCIA] [varchar](9) NOT NULL,
	[CODIGO_ITEM] [varchar](10) NOT NULL,
	[NQUANTIDADE] [float] NULL,
 CONSTRAINT [PK_Composicao] PRIMARY KEY CLUSTERED 
(
	[CREFERENCIA] ASC,
	[CODIGO_ITEM] 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
/****** Object:  Table [dbo].[Composicao_kit]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Composicao_kit](
	[CREFERENCIA] [varchar](15) NOT NULL,
	[CREFERENCIA_KIT] [varchar](15) NOT NULL,
	[NQUANTIDADE] [float] NULL,
 CONSTRAINT [PK_Composicao_KIT] PRIMARY KEY CLUSTERED 
(
	[CREFERENCIA] ASC,
	[CREFERENCIA_KIT] 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
/****** Object:  Table [dbo].[CONDICOESPAGAMENTO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CONDICOESPAGAMENTO](
	[NCODCONDPAGAMENTO] [int] NULL,
	[CCODCATEGORIA] [varchar](1) NULL,
	[CDESCRICAO] [varchar](25) NULL,
	[NNUMPARCELAS] [int] NULL,
	[CPRAZO] [int] NULL,
	[NDESCONTO] [float] NULL,
	[NACRESCIMO] [float] NULL,
	[CIDVERIFICALIMITE] [varchar](1) NULL,
	[CEMITEFATURA] [varchar](1) NULL,
	[CEMITERECIBO] [varchar](1) NULL,
	[CDIVIDIRTOTAL] [varchar](1) NULL,
	[NPERCPARC1] [float] NULL,
	[NPRAZOPARC1] [int] NULL,
	[NPERCPARC2] [float] NULL,
	[NPRAZOPARC2] [int] NULL,
	[NPERCPARC3] [float] NULL,
	[NPRAZOPARC3] [int] NULL,
	[NPERCPARC4] [float] NULL,
	[NPRAZOPARC4] [int] NULL,
	[NPERCPARC5] [float] NULL,
	[NPRAZOPARC5] [int] NULL,
	[NPERCPARC6] [float] NULL,
	[NPRAZOPARC6] [int] NULL,
	[NPERCPARC7] [float] NULL,
	[NPRAZOPARC7] [int] NULL,
	[NPERCPARC8] [float] NULL,
	[NPRAZOPARC8] [int] NULL,
	[NPERCPARC9] [float] NULL,
	[NPRAZOPARC9] [int] NULL,
	[NPERCPARC10] [float] NULL,
	[NPRAZOPARC10] [int] NULL,
	[CEXPORTAR] [varchar](1) NULL,
	[NPERCPARC11] [float] NULL,
	[NPRAZOPARC11] [int] NULL,
	[NPERCPARC12] [float] NULL,
	[NPRAZOPARC12] [int] NULL,
	[NPERCPARC13] [float] NULL,
	[NPRAZOPARC13] [int] NULL,
	[NPERCPARC14] [float] NULL,
	[NPRAZOPARC14] [int] NULL,
	[NPERCPARC15] [float] NULL,
	[NPRAZOPARC15] [int] NULL,
	[NPERCPARC16] [float] NULL,
	[NPRAZOPARC16] [int] NULL,
	[NPERCPARC17] [float] NULL,
	[NPRAZOPARC17] [int] NULL,
	[NPERCPARC18] [float] NULL,
	[NPRAZOPARC18] [int] NULL,
	[NPERCPARC19] [float] NULL,
	[NPRAZOPARC19] [int] NULL,
	[NPERCPARC20] [float] NULL,
	[NPRAZOPARC20] [float] NULL,
	[NPERCPARC21] [float] NULL,
	[NPRAZOPARC21] [int] NULL,
	[NPERCPARC22] [float] NULL,
	[NPRAZOPARC22] [int] NULL,
	[NPERCPARC23] [float] NULL,
	[NPRAZOPARC23] [int] NULL,
	[NPERCPARC24] [float] NULL,
	[NPRAZOPARC24] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Config]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Config](
	[Juros_Mora] [float] NULL,
	[Multa_Atraso] [float] NULL,
	[Dias_Protesto] [int] NULL,
	[Valor_Cobranca] [float] NULL,
	[Tabela_Padrao] [varchar](10) NULL,
	[AliqPis] [float] NULL,
	[AliqCOnfins] [float] NULL,
	[AliqIR] [float] NULL,
	[Numero_Serie] [int] NULL,
	[Aliq_imposto] [float] NULL,
	[cInstrucoes1] [varchar](80) NULL,
	[cInstrucoes2] [varchar](80) NULL,
	[Difal_aliqF] [float] NULL,
	[Difal_aliqI] [float] NULL,
	[COPERACAOLOJA] [varchar](5) NULL,
	[CAGENTELOJA] [varchar](3) NULL,
	[CCONDICAOLOJA] [int] NULL,
	[CCODTRANSPORTADORA] [varchar](14) NULL,
	[coperacaofora] [varchar](4) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Contagem_Estoque]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Contagem_Estoque](
	[CCONTROLE] [int] NOT NULL,
	[CCODFACCAO] [varchar](5) NULL,
	[CREFERENCIA] [varchar](9) NULL,
	[NQUANTIDADE] [float] NULL,
	[DDATACONTAGEM] [datetime] NULL,
	[CUSUARIO] [varchar](5) NULL,
	[NCTRESTOQUE] [int] NULL,
 CONSTRAINT [PK_Contagem_Estoque] PRIMARY KEY CLUSTERED 
(
	[CCONTROLE] 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
/****** Object:  Table [dbo].[CONTAGEM_ESTOQUE_ITENS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CONTAGEM_ESTOQUE_ITENS](
	[NUMERO_CONTROLE] [int] NOT NULL,
	[CODIGO_ITEM] [varchar](15) NULL,
	[QUANTIDADE] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Contas_Pagar]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Contas_Pagar](
	[NUMERODOCU] [varchar](15) NOT NULL,
	[CODIGOFOR] [varchar](14) NOT NULL,
	[TIPODESPES] [varchar](5) NULL,
	[DATADOCUME] [datetime] NULL,
	[TIPODOCUME] [varchar](3) NULL,
	[NUMERO_NOTA] [int] NULL,
	[VENCIMENTO] [datetime] NULL,
	[VALORDOCUM] [float] NULL,
	[HISTORICO] [varchar](100) NULL,
	[DATAPAGTO] [datetime] NULL,
	[VALORPAGO] [float] NULL,
	[CODBANCO] [varchar](6) NULL,
	[NUMCHEQUE] [varchar](15) NULL,
	[AGENTE] [varchar](15) NULL,
	[PRACA_PAGAMENTO] [varchar](20) NULL,
	[BAIXA_PARCIAL] [varchar](1) NULL,
	[TIPO_PAGAMENTO] [varchar](15) NULL,
	[VALORJUROSDIARIO] [float] NULL,
	[ACRESCIMO_FINANCEIRO] [float] NULL,
	[DESCONTO_FINANCEIRO] [float] NULL,
	[CODIGO_DESPESA] [varchar](5) NOT NULL,
	[LANCAMENTO_BANCARIO] [int] NULL,
	[LANCAMENTO_CON] [int] NULL,
	[LANCAMENTO_DIF] [int] NULL,
	[NOVO_VENCIMENTO] [datetime] NULL,
	[CONTROLE_CAIXA] [int] NULL,
	[ULTIMA_ALTERACAO] [datetime] NULL,
	[USUARIO] [varchar](6) NULL,
	[CONTROLE] [int] NOT NULL,
	[FORNECEDOR] [varchar](40) NULL,
	[TIPO_LANCAMENTO] [varchar](1) NULL,
	[NNUMSERIE] [varchar](1) NULL,
	[CONTROLE_CCUSTO] [int] NULL,
	[FORMALANCA] [varchar](15) NULL,
	[DDATACREDITO] [datetime] NULL,
	[CODIGOBARRAS] [varchar](50) NULL,
 CONSTRAINT [PK_Contas_Pagar_1] PRIMARY KEY CLUSTERED 
(
	[NUMERODOCU] ASC,
	[CODIGOFOR] ASC,
	[CODIGO_DESPESA] 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
/****** Object:  Table [dbo].[CORES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[CORES](
	[Codigo] [varchar](2) NOT NULL,
	[Descricao] [varchar](20) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Corretores]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Corretores](
	[CODIGO] [int] NOT NULL,
	[NOME] [varchar](45) NULL,
	[ENDERECO] [varchar](45) NULL,
	[CIDADE] [varchar](20) NULL,
	[BAIRRO] [varchar](20) NULL,
	[CEP] [varchar](8) NULL,
	[UF] [varchar](2) NULL,
	[CGC] [varchar](18) NULL,
	[CGF] [varchar](10) NULL,
	[CONTATO] [varchar](40) NULL,
	[DDD] [varchar](3) NULL,
	[FONE] [varchar](20) NULL,
	[FAX] [varchar](20) NULL,
	[CELULAR] [varchar](20) NULL,
	[CXPOSTAL] [varchar](10) NULL,
	[COMISSAO] [float] NULL,
	[AGENCIA] [varchar](6) NULL,
	[BANCO] [varchar](10) NULL,
	[CONTA] [varchar](10) NULL,
	[OBSERVACOES] [text] NULL,
	[CSIGLA] [varchar](3) NULL,
	[NUMERO] [int] NULL,
	[COMPLEMENTO] [varchar](40) NULL,
	[EMAIL] [varchar](120) NULL,
	[nlimitedesconto] [float] NULL,
	[CNUMREGISTRO] [varchar](15) NULL,
 CONSTRAINT [PK_Corretores] PRIMARY KEY CLUSTERED 
(
	[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] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[COTACAO_MOEDA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[COTACAO_MOEDA](
	[CCODMOEDA] [varchar](1) NOT NULL,
	[CDATA_COTACAO] [datetime] NOT NULL,
	[CVALOR_COTACAO] [float] NULL,
 CONSTRAINT [PK_COTACAO_MOEDA] PRIMARY KEY CLUSTERED 
(
	[CCODMOEDA] 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
/****** Object:  Table [dbo].[DUPLICATAS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DUPLICATAS](
	[CNUMPEDIDO] [varchar](8) NOT NULL,
	[CNUMPARCELA] [varchar](2) NOT NULL,
	[NNUMMOV] [int] NOT NULL,
	[CTOTPARCELA] [varchar](2) NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[CCODAGENTE] [varchar](3) NULL,
	[DDATAVENCIMENTO] [datetime] NULL,
	[NVALORAPAGAR] [float] NULL,
	[NPERC_MULTA] [float] NULL,
	[NPERC_JUROS] [float] NULL,
	[NVALORCARTORIO] [float] NULL,
	[NVALORACRESCIMO] [float] NULL,
	[NVALORMULTA] [float] NULL,
	[NVALORJUROS] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NVALORPAGO] [float] NULL,
	[CNUMNF] [varchar](6) NULL,
	[DDATAPAGAMENTO] [datetime] NULL,
	[COBS] [varchar](max) NULL,
	[DDATAREMESSABANCO] [datetime] NULL,
	[DDATARETORNOBANCO] [datetime] NULL,
	[CRECEBIDOCAIXA] [varchar](1) NULL,
	[CUSUARIO] [varchar](6) NULL,
	[DULTIMAATUALIZACAO] [datetime] NULL,
	[CHIST1] [varchar](80) NULL,
	[CHIST2] [varchar](80) NULL,
	[CHIST3] [varchar](80) NULL,
	[NVALORCOMISSAO] [float] NULL,
	[NVENDEDOR] [int] NULL,
	[ddatadoc] [datetime] NULL,
	[COBSPAGAMENTO] [varchar](max) NULL,
	[TIPO_RECEITA] [varchar](5) NULL,
	[CINSTRUCOES1] [varchar](40) NULL,
	[CINSTRUCOES2] [varchar](40) NULL,
	[CINSTRUCOES3] [varchar](40) NULL,
	[FUNDO_PERDIDO] [varchar](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
SET ANSI_PADDING OFF
ALTER TABLE [dbo].[DUPLICATAS] ADD [CTIPO] [varchar](1) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CNUMSERIE] [varchar](1) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [DDATA_REMESSA] [datetime] NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [DDATARETORNO] [datetime] NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CNOSSONUMERO] [varchar](30) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CARQUIVORETORNO] [varchar](30) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CSTATUS] [varchar](1) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CCOBRANCA_BANCARIA] [varchar](1) NULL
SET ANSI_PADDING ON
ALTER TABLE [dbo].[DUPLICATAS] ADD [BANCO_BAIXA] [varchar](6) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [nnumlancbanco] [int] NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [DDATA_CAIXA] [datetime] NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CCODIGO_CAIXA] [varchar](6) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CPERIODO_CAIXA] [varchar](1) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [CSTATUS_BAIXA] [varchar](1) NULL
ALTER TABLE [dbo].[DUPLICATAS] ADD [ccontraapresentacao] [varchar](1) NULL
 CONSTRAINT [PK_DUPLICATAS] PRIMARY KEY NONCLUSTERED 
(
	[CNUMPEDIDO] ASC,
	[CNUMPARCELA] ASC,
	[NNUMMOV] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ENTRADA_ESTOQUE]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ENTRADA_ESTOQUE](
	[NUMERO_CONTROLE] [int] NOT NULL,
	[DATA_ENTRADA] [datetime] NULL,
	[CODIGO_OPERADOR] [varchar](6) NULL,
	[REFERENCIA_PRODUTO] [varchar](9) NULL,
	[ESTOQUE_ATUAL] [float] NULL,
	[QUANTIDADE_ENTRADA] [float] NULL,
	[STATUS_ENTRADA] [varchar](1) NULL,
 CONSTRAINT [PK_ENTRADA_ESTOQUE] PRIMARY KEY NONCLUSTERED 
(
	[NUMERO_CONTROLE] 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
/****** Object:  Table [dbo].[ENTRADADEPRODUTOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ENTRADADEPRODUTOS](
	[NNUMNF] [int] NOT NULL,
	[CCODFORNECEDOR] [varchar](14) NOT NULL,
	[CTIPODOC] [varchar](1) NULL,
	[CNUMSERIE] [varchar](1) NULL,
	[CCODTRANSPORTADORA] [varchar](14) NULL,
	[DDATAEMISSAO] [datetime] NULL,
	[DDATAENTREGA] [datetime] NULL,
	[NBASEICMS] [float] NULL,
	[NVALORICMS] [float] NULL,
	[NBASEICMST] [float] NULL,
	[NVALORICMST] [float] NULL,
	[NVALORPRODUTOS] [float] NULL,
	[NVALORFRETE] [float] NULL,
	[NVALORSEGURO] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NOUTRASDESPESAS] [float] NULL,
	[NVALORIPI] [float] NULL,
	[NVALORNF] [float] NULL,
	[NVALORICMSFRETE] [float] NULL,
	[NPESOTOTAL] [float] NULL,
	[CCODNATOPERACAO] [varchar](4) NULL,
	[CCHAVE] [varchar](60) NULL,
	[SSTATUS] [varchar](1) NULL,
	[NCODSIT] [varchar](1) NULL,
	[CCODSIT] [varchar](2) NULL,
	[NPEDIDOCOMPRA] [int] NULL,
 CONSTRAINT [PK_ENTRADADEPRODUTOS] PRIMARY KEY CLUSTERED 
(
	[NNUMNF] ASC,
	[CCODFORNECEDOR] 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
/****** Object:  Table [dbo].[ENTRADADEPRODUTOSITENS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ENTRADADEPRODUTOSITENS](
	[NNUMNF] [int] NOT NULL,
	[CCODFORNECEDOR] [varchar](14) NOT NULL,
	[NITEM] [int] NOT NULL,
	[CNUMSERIE] [varchar](1) NULL,
	[CCODPRODUTO] [varchar](60) NULL,
	[CCODNATOPERACAO] [varchar](5) NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[NPRECOTOTAL] [float] NULL,
	[NPERCDESCONTO] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NPERCICMS] [float] NULL,
	[NPERCIPI] [float] NULL,
	[NPESO] [float] NULL,
	[CDESCRICAOTMP] [varchar](120) NULL,
	[CLOTE] [varchar](40) NULL,
	[DVENCIMENTO] [datetime] NULL,
	[NBASEST] [float] NULL,
	[NVALORST] [float] NULL,
	[NQTDUNDDISTRIBUICAO] [float] NULL,
	[NPERCST] [float] NULL,
	[NPERCMVA] [float] NULL,
	[NREDBASE] [float] NULL,
	[NCTRESTOQUE] [int] NULL,
	[DDATAMOVIMENTO] [datetime] NULL,
	[CTIPODOC] [varchar](1) NULL,
	[cst_icms] [varchar](3) NULL,
	[CNCM] [varchar](15) NULL,
	[NFATOR] [float] NULL,
	[NQTDCONFERIDA] [float] NULL,
	[cunidade] [varchar](2) NULL,
 CONSTRAINT [PK_ENTRADADEPRODUTOSITENS] PRIMARY KEY CLUSTERED 
(
	[NNUMNF] ASC,
	[CCODFORNECEDOR] ASC,
	[NITEM] 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
/****** Object:  Table [dbo].[ENTRADADEPRODUTOSLOTES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ENTRADADEPRODUTOSLOTES](
	[NNUMNF] [int] NOT NULL,
	[CCODFORNECEDOR] [varchar](14) NOT NULL,
	[CNUMSERIE] [varchar](2) NOT NULL,
	[NITEM] [int] NOT NULL,
	[CCODPRODUTO] [varchar](15) NULL,
	[CNUMLOTE] [varchar](20) NOT NULL,
	[DDATAFAB] [datetime] NULL,
	[DDATAVAL] [datetime] NULL,
	[NQTD] [float] NULL,
	[NQTDCONSUMO] [float] NULL,
PRIMARY KEY CLUSTERED 
(
	[NNUMNF] ASC,
	[CCODFORNECEDOR] ASC,
	[CNUMSERIE] ASC,
	[NITEM] ASC,
	[CNUMLOTE] 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
/****** Object:  Table [dbo].[Equipamentos]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Equipamentos](
	[CCODEQUIPAMENTO] [varchar](10) NOT NULL,
	[CCODTIPO] [int] NULL,
	[CDESCEQUIPAMENTO] [varchar](40) NULL,
	[CSTATUS] [varchar](1) NULL,
 CONSTRAINT [PK_Equipamentos] PRIMARY KEY CLUSTERED 
(
	[CCODEQUIPAMENTO] 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
/****** Object:  Table [dbo].[EQUIPES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[EQUIPES](
	[CCODIGO] [int] NOT NULL,
	[CEQUIPE] [varchar](40) NULL,
 CONSTRAINT [PK_EQUIPES] PRIMARY KEY CLUSTERED 
(
	[CCODIGO] 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
/****** Object:  Table [dbo].[ESTOQUE_ENTRADA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ESTOQUE_ENTRADA](
	[NCONTROLE] [int] IDENTITY(1,1) NOT NULL,
	[DDATA] [datetime] NULL,
	[CCODPRODUTO] [varchar](15) NULL,
	[NESTOQUEANTERIOR] [float] NULL,
	[NQTD] [float] NULL,
	[NPRECO] [float] NULL,
	[CHISTORICO] [varchar](30) NULL,
	[CSTATUS] [varchar](1) NULL,
	[COPERADOR] [varchar](6) NULL,
	[NCTRESTOQUE] [int] NULL,
 CONSTRAINT [PK__ESTOQUE___9E54C5BA3E8F7F71] PRIMARY KEY CLUSTERED 
(
	[NCONTROLE] 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
/****** Object:  Table [dbo].[ESTOQUE_ENTRADA_MP]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ESTOQUE_ENTRADA_MP](
	[NCONTROLE] [int] IDENTITY(1,1) NOT NULL,
	[DDATA] [datetime] NULL,
	[CCODPRODUTO] [varchar](15) NULL,
	[NESTOQUEANTERIOR] [float] NULL,
	[NQTD] [float] NULL,
	[NPRECO] [float] NULL,
	[CHISTORICO] [varchar](30) NULL,
	[CSTATUS] [varchar](1) NULL,
	[COPERADOR] [varchar](6) NULL,
	[NCTRESTOQUE] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[NCONTROLE] 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
/****** Object:  Table [dbo].[ESTOQUE_SAIDA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ESTOQUE_SAIDA](
	[NCONTROLE] [int] IDENTITY(1,1) NOT NULL,
	[DDATA] [datetime] NULL,
	[CCODPRODUTO] [varchar](15) NULL,
	[NESTOQUEANTERIOR] [float] NULL,
	[NQTD] [float] NULL,
	[NPRECO] [float] NULL,
	[CHISTORICO] [varchar](30) NULL,
	[CSTATUS] [varchar](1) NULL,
	[COPERADOR] [varchar](6) NULL,
	[NCTRESTOQUE] [int] NULL,
 CONSTRAINT [PK__ESTOQUE___9E54C5BA7D087728] PRIMARY KEY CLUSTERED 
(
	[NCONTROLE] 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
/****** Object:  Table [dbo].[ESTOQUE_SAIDA_MP]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ESTOQUE_SAIDA_MP](
	[NCONTROLE] [int] IDENTITY(1,1) NOT NULL,
	[DDATA] [datetime] NULL,
	[CCODPRODUTO] [varchar](15) NULL,
	[NESTOQUEANTERIOR] [float] NULL,
	[NQTD] [float] NULL,
	[NPRECO] [float] NULL,
	[CHISTORICO] [varchar](30) NULL,
	[CSTATUS] [varchar](1) NULL,
	[COPERADOR] [varchar](6) NULL,
	[NCTRESTOQUE] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[NCONTROLE] 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
/****** Object:  Table [dbo].[F_AJUSTE_TRANSF]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_AJUSTE_TRANSF](
	[CNUMTRANSF] [char](8) NOT NULL,
	[NTIPOTRANSF] [float] NOT NULL,
	[DDATA] [datetime] NOT NULL,
	[CUSUARIO] [varchar](6) NOT NULL,
	[CCODORIGEM] [varchar](9) NOT NULL,
	[CCODDESTINO] [varchar](9) NULL,
	[NQTDE] [float] NOT NULL,
	[CMOTIVO] [varchar](50) NULL,
	[CGRUPO] [varchar](6) NULL,
	[NQTDE_ATENDIDA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_CCUSTOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_CCUSTOS](
	[CCODIGO] [char](5) NOT NULL,
	[CDESCRICAO] [varchar](35) NOT NULL,
	[CCLASSE] [char](1) NOT NULL,
	[CTIPO_DOC] [char](3) NULL,
	[CSUB_CONTA] [char](1) NOT NULL,
	[NVALOR] [float] NULL,
	[NGRUPO] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_GRUPOSCCUSTO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_GRUPOSCCUSTO](
	[NCODIGO] [float] NOT NULL,
	[CDESC] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_INVENT_CAB]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_INVENT_CAB](
	[CNUMINVENTARIO] [char](4) NOT NULL,
	[DDATA_ABERTURA] [datetime] NOT NULL,
	[DDATA_FECHA] [datetime] NULL,
	[CQUEM_ABRE] [varchar](6) NOT NULL,
	[CQUEM_FECHA] [varchar](6) NULL,
	[CSTATUS] [char](1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_INVENT_DADOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_INVENT_DADOS](
	[CNUMINVENTARIO] [char](4) NOT NULL,
	[NNR_FICHA] [float] NOT NULL,
	[CCODPRODUTO] [char](9) NOT NULL,
	[CLOCAL] [varchar](4) NOT NULL,
	[NQUANTIDADE] [float] NOT NULL,
	[CSTATUS] [char](1) NOT NULL,
	[CNUMLOTE] [varchar](6) NOT NULL,
	[CDIGITADOR] [varchar](6) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_INVENT_DIVERG]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_INVENT_DIVERG](
	[CNUMINVENTARIO] [char](4) NOT NULL,
	[CCODPRODUTO] [char](9) NOT NULL,
	[NQDE_ANTERIOR] [float] NULL,
	[NQDE_INVENTARIADA] [float] NULL,
	[NNR_FICHA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_INVENT_PROTOCOLO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_INVENT_PROTOCOLO](
	[CNUMINVENTARIO] [char](4) NOT NULL,
	[DDATA] [datetime] NOT NULL,
	[CCONTADOR] [char](3) NOT NULL,
	[NNR_INICIAL] [float] NOT NULL,
	[NNR_FINAL] [float] NOT NULL,
	[CSTATUS] [char](1) NOT NULL,
	[CUNIDADE] [char](1) NOT NULL,
	[CNUMLOTE] [varchar](6) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_SUB_CONTA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_SUB_CONTA](
	[CCODIGO] [char](3) NOT NULL,
	[CCONTA] [varchar](3) NOT NULL,
	[CDESCRICAO] [varchar](35) NOT NULL,
	[NVALOR] [float] NULL,
	[CUNIDADE] [char](1) NOT NULL,
	[CATIVO] [char](1) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[F_UNIDADES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[F_UNIDADES](
	[CCODIGO] [varchar](1) NOT NULL,
	[CDESCRICAO] [varchar](35) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[FABRICANTES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FABRICANTES](
	[CCODFABRICANTE] [int] NULL,
	[CNOME] [varchar](50) NULL,
	[CCGC] [varchar](14) NULL,
	[CCGF] [varchar](15) NULL,
	[CENDERECO] [varchar](50) NULL,
	[CBAIRRO] [varchar](25) NULL,
	[CCEP] [varchar](8) NULL,
	[CCIDADE] [varchar](25) NULL,
	[CUF] [varchar](2) NULL,
	[CCONTATO] [varchar](25) NULL,
	[CDDD] [varchar](3) NULL,
	[CFONE] [varchar](8) NULL,
	[CCELULAR] [varchar](8) NULL,
	[CFAX] [varchar](8) NULL,
	[CCODTRANSPORTADORA] [varchar](14) NULL,
	[NPRAZOMEDIOENTREGA] [int] NULL,
	[NCOMISSAO] [float] NULL,
	[SIGLA] [varchar](2) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Faccao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Faccao](
	[CCODFACCAO] [varchar](5) NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[CENDERECO] [varchar](40) NULL,
	[CCONTATO] [varchar](20) NULL,
	[CTELEFONE] [varchar](15) NULL,
	[ccodcliente] [varchar](18) NULL,
	[CCODOPERACAO] [varchar](4) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[FERIADOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FERIADOS](
	[DDATA] [datetime] NULL,
	[CDESCRICAO] [varchar](30) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[FILIAIS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FILIAIS](
	[COD_FILIAL] [varchar](3) NOT NULL,
	[NOME_FILIAL] [varchar](40) NULL,
	[FONE_FILIAL] [varchar](10) NULL,
	[RESP_FILIAL] [varchar](20) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Fluxo_caixa_sintetico]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Fluxo_caixa_sintetico](
	[DDATA] [datetime] NULL,
	[NADIANTAMENTO] [float] NULL,
	[NVALORRECEBER] [float] NULL,
	[NVALORPAGAR] [float] NULL,
	[NSALDO] [float] NULL,
	[NSALDODIARIO] [float] NULL,
	[NSALDODIARIOTOTAL] [float] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FORNECEDORES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[FORNECEDORES](
	[CCODFORNECEDOR] [varchar](14) NOT NULL,
	[CNOME] [varchar](50) NULL,
	[CCGF] [varchar](20) NULL,
	[CENDERECO] [varchar](50) NULL,
	[CBAIRRO] [varchar](25) NULL,
	[CCEP] [varchar](8) NULL,
	[CCIDADE] [varchar](25) NULL,
	[CUF] [varchar](2) NULL,
	[CCONTATO] [varchar](25) NULL,
	[CDDD] [varchar](3) NULL,
	[CFONE] [varchar](10) NULL,
	[CCELULAR] [varchar](10) NULL,
	[CFAX] [varchar](10) NULL,
	[CCODTRANSPORTADORA] [varchar](14) NULL,
	[NPRAZOMEDIOENTREGA] [int] NULL,
	[NFATORCONVERSAO] [float] NULL,
	[COD_MUN] [varchar](7) NULL,
	[CCODMUNICIPIO] [varchar](7) NULL,
	[CNUMERO] [int] NULL,
	[CCOMPLEMENTO] [varchar](30) NULL,
	[TIPO_DESPESA] [varchar](5) NULL,
	[SEQUENCIAL] [int] NULL,
	[CEMAIL] [varchar](60) NULL,
	[CWEBSITE] [varchar](60) NULL,
	[CFANTASIA] [varchar](30) NULL,
 CONSTRAINT [PK_FORNECEDORES] PRIMARY KEY CLUSTERED 
(
	[CCODFORNECEDOR] 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
/****** Object:  Table [dbo].[Funcionarios]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Funcionarios](
	[CCODIGO] [int] NOT NULL,
	[CNOME_COMPLETO] [varchar](40) NULL,
	[CPSEUDONIMO] [varchar](20) NULL,
	[CENDERECO] [varchar](30) NULL,
	[CCOMPLEMENTO] [varchar](20) NULL,
	[CBAIRRO] [varchar](20) NULL,
	[CCEP] [varchar](10) NULL,
	[CCIDADE] [varchar](20) NULL,
	[CUF] [varchar](2) NULL,
	[DNASCIMENTO] [datetime] NULL,
	[CCPF] [varchar](14) NULL,
	[CRG] [varchar](20) NULL,
	[CMAE] [varchar](40) NULL,
	[CESTADO_CIVIL] [varchar](1) NULL,
	[CCONJUGE] [varchar](40) NULL,
	[CDALTONICO] [varchar](1) NULL,
	[CCANHOTO] [varchar](1) NULL,
	[CFUMANTE] [varchar](1) NULL,
	[CULTIMO_EMPREGO] [varchar](20) NULL,
	[CTEMPO] [varchar](10) NULL,
	[CCARTEIRA_ASSINADA] [varchar](1) NULL,
	[Natestado_MEDICO] [int] NULL,
	[DDATA_ADMICAO] [datetime] NULL,
	[DAQUISICAO_FERIAS] [datetime] NULL,
	[NDIAS_UTILIZAR] [int] NULL,
	[CHISTORICO_AUSENCIA] [text] NULL,
	[CHISTORICO_DESEMP] [text] NULL,
	[NFALTAS] [int] NULL,
	[CSENHA] [varchar](10) NULL,
	[CCODIGOEQUIPE] [int] NULL,
 CONSTRAINT [PK_Funcionarios] PRIMARY KEY CLUSTERED 
(
	[CCODIGO] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[GRPUSERS]    Script Date: 11/01/2018 18:18:01 ******/
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].[GRUPO_EMPRESA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GRUPO_EMPRESA](
	[CCODIGO] [int] NOT NULL,
	[CGRUPO] [varchar](60) NULL,
PRIMARY KEY CLUSTERED 
(
	[CCODIGO] 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
/****** Object:  Table [dbo].[GRUPOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[GRUPOS](
	[COD_GRU] [varchar](3) NOT NULL,
	[DES_GRU] [varchar](30) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[HISTORICO_PEDIDOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[HISTORICO_PEDIDOS](
	[CPEDIDO] [varchar](8) NULL,
	[DDATA] [datetime] NULL,
	[CHORA] [varchar](5) NULL,
	[CUSUARIO] [varchar](6) NULL,
	[CSTATUS] [varchar](1) NULL,
	[CTIPO_OPERACAO] [varchar](40) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ICMS_UF]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ICMS_UF](
	[CUF] [varchar](2) NULL,
	[NALIQ_CICMS] [float] NULL,
	[NALIQ_ICMSST] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Inventario_Estoque]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Inventario_Estoque](
	[NNUMERO_INVENTARIO] [int] NOT NULL,
	[CREFERENCIA] [varchar](9) NOT NULL,
	[CLOJA] [varchar](3) NULL,
	[CCODBARRAS] [varchar](13) NULL,
	[NQUANTIDADE] [float] NULL,
	[DDATACONTAGEM] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ITENS_ESTOQUE]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENS_ESTOQUE](
	[CODIGO_ITEM] [varchar](60) NOT NULL,
	[DESCRICAO] [varchar](120) NULL,
	[GRUPO] [varchar](3) NULL,
	[TIPO_DESPESA] [varchar](5) NULL,
	[UNIDADE_COMPRA] [varchar](2) NULL,
	[QTDESTOQUE] [float] NULL,
	[LOTECOMPRA] [float] NULL,
	[QTDMINIMA] [float] NULL,
	[QTDMAXIMA] [float] NULL,
	[DATULTCOMP] [datetime] NULL,
	[VALULTCOMP] [float] NULL,
	[QTDULTCOMP] [float] NULL,
	[PRECOATUAL] [float] NULL,
	[SITUACAO] [varchar](1) NULL,
	[TIPO_ITEM] [varchar](1) NULL,
	[TOLERANCIA_PESO] [float] NULL,
	[CODIGO_BARRAS] [varchar](20) NULL,
	[POTENCIA] [float] NULL,
	[APRESENTACAO] [varchar](40) NULL,
	[CONCENTRACAO] [varchar](40) NULL,
	[NFATORCONVERSAO] [float] NULL,
 CONSTRAINT [PK_ITENS_ESTOQUE] PRIMARY KEY CLUSTERED 
(
	[CODIGO_ITEM] 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
/****** Object:  Table [dbo].[ITENS_ESTOQUE_CODBAR]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENS_ESTOQUE_CODBAR](
	[CODIGO_BARRA] [varchar](40) NOT NULL,
	[CODIGO_ITEM] [varchar](50) NOT NULL,
 CONSTRAINT [PK_ITENS_ESTOQUE_CODBAR] PRIMARY KEY CLUSTERED 
(
	[CODIGO_BARRA] 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
/****** Object:  Table [dbo].[ITENS_ESTOQUE_FABRICANTE]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENS_ESTOQUE_FABRICANTE](
	[CODIGO_ITEM] [int] NOT NULL,
	[CCODFABRICANTE] [varchar](14) NOT NULL,
 CONSTRAINT [PK_ITENS_ESTOQUE_FABRICANTE] PRIMARY KEY CLUSTERED 
(
	[CODIGO_ITEM] ASC,
	[CCODFABRICANTE] 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
/****** Object:  Table [dbo].[ITENS_ESTOQUE_FORNECEDOR]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENS_ESTOQUE_FORNECEDOR](
	[CODIGO_ITEM] [varchar](10) NOT NULL,
	[CCODFORNECEDOR] [varchar](14) NOT NULL,
 CONSTRAINT [PK_ITENS_ESTOQUE_FORNECEDOR] PRIMARY KEY CLUSTERED 
(
	[CODIGO_ITEM] ASC,
	[CCODFORNECEDOR] 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
/****** Object:  Table [dbo].[ITENSNF_S]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENSNF_S](
	[NNUMMOVSAIDA] [int] NOT NULL,
	[NITEM] [int] NOT NULL,
	[CREFERENCIA] [varchar](15) NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[NPRECOTOTAL] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NPRECOLIQUIDO] [float] NULL,
	[NPERCDESCONTO] [float] NULL,
	[NQTDDEVOL] [float] NULL,
	[CSITUACAO_TRIBUTARIA] [varchar](1) NULL,
	[NPERCIPI] [float] NULL,
	[NVALORIPI] [float] NULL,
	[NPERCICMS] [float] NULL,
	[CUNIDADE] [varchar](2) NULL,
	[NPESO] [float] NULL,
	[CCODOPERACAOFISCAL] [varchar](20) NULL,
	[NALIQREDUCAO] [float] NULL,
	[clote] [varchar](40) NULL,
	[cdescricao] [varchar](100) NULL,
	[NVALORPIS] [float] NULL,
	[NVALORCOFINS] [float] NULL,
	[NALIQPIS] [float] NULL,
	[NALIQCOFINS] [float] NULL,
	[CSTPIS] [varchar](2) NULL,
	[CSTCOFINS] [varchar](2) NULL,
	[CSTIPI] [varchar](2) NULL,
	[NVALORST] [float] NULL,
	[NBASEST] [float] NULL,
	[nmvast] [float] NULL,
	[npercst] [float] NULL,
	[nvaloricmsst] [float] NULL,
	[NBASEIPI] [float] NULL,
	[CSTICMS] [varchar](2) NULL,
	[nValorFrete] [float] NULL,
	[nbaseicms] [float] NULL,
	[nvaloricms] [float] NULL,
	[nRedIpi1] [float] NULL,
	[nRedPis1] [float] NULL,
	[nredCofins1] [float] NULL,
	[nRedIPI] [float] NULL,
	[nRedPIS] [float] NULL,
	[nRedCofins] [float] NULL,
	[ccodfiscal] [varchar](5) NULL,
	[ccodoperacao] [varchar](5) NULL,
	[csosn] [varchar](3) NULL,
	[NCTRESTOQUE] [int] NULL,
	[naliquotaII] [float] NULL,
	[nvalorII] [float] NULL,
	[nbaseII] [float] NULL,
	[nbasePIS] [float] NULL,
	[nBaseCOFINS] [float] NULL,
	[nValorDespesaAdu] [float] NULL,
 CONSTRAINT [PK_ITENSNF_S] PRIMARY KEY CLUSTERED 
(
	[NNUMMOVSAIDA] ASC,
	[NITEM] 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
/****** Object:  Table [dbo].[ITENSPEDIDODEVOLUCAO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENSPEDIDODEVOLUCAO](
	[CNUMPEDIDO] [varchar](6) NULL,
	[CCODPRODUTO] [varchar](9) NULL,
	[NQTDDEVOLVIDA] [int] NULL,
	[NVALORUNITARIO] [float] NULL,
	[NVALORTOTAL] [float] NULL,
	[NPERCDESCONTO] [float] NULL,
	[NVALORLIQUIDO] [float] NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[NPRECOTOTAL] [float] NULL,
	[NVALORDESCONTO] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ITENSPEDIDOLOTES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENSPEDIDOLOTES](
	[CNUMPEDIDO] [varchar](8) NOT NULL,
	[NITEM] [int] NOT NULL,
	[CLOTE] [varchar](20) NOT NULL,
	[NQTD] [float] NULL,
	[DDATAFAB] [datetime] NULL,
	[DDATAVAL] [datetime] NULL,
	[NPMC] [float] NULL,
	[CREFERENCIA] [varchar](9) NULL,
PRIMARY KEY CLUSTERED 
(
	[CNUMPEDIDO] ASC,
	[NITEM] ASC,
	[CLOTE] 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
/****** Object:  Table [dbo].[ITENSPEDIDOSAIDA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENSPEDIDOSAIDA](
	[CNUMPEDIDO] [varchar](8) NOT NULL,
	[NITEM] [int] NOT NULL,
	[CREFERENCIA] [varchar](9) NULL,
	[NQTDPEDIDA] [float] NULL,
	[NPERCDESCONTO] [float] NULL,
	[NQTDATENDIDA] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[NPRECOTOTAL] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NVALORLIQUIDO] [float] NULL,
	[NPERCIPI] [float] NULL,
	[NVALORIPI] [float] NULL,
	[NPESO] [float] NULL,
	[CNUMERONF] [varchar](6) NULL,
	[DDATANF] [datetime] NULL,
	[NTOTALFATURADO] [float] NULL,
	[DDATAPROCESSAMENTO] [datetime] NULL,
	[NVALORCOMISSAO] [float] NULL,
	[NCOMISSAO] [float] NULL,
	[clote] [varchar](40) NULL,
	[NQTDSEPARADA] [float] NULL,
	[CSTATUS_EXPEDICAO] [varchar](1) NULL,
	[cdetalhe] [varchar](40) NULL,
	[NPERCICMS] [float] NULL,
	[NVALORICMS] [float] NULL,
	[NMVAST] [float] NULL,
	[NPERCST] [float] NULL,
	[NBASEST] [float] NULL,
	[NVALORST] [float] NULL,
	[NVALORICMST] [float] NULL,
	[NPESOL] [float] NULL,
	[NPESOB] [float] NULL,
	[nbaseIPI] [float] NULL,
	[CICMSOPE] [varchar](1) NULL,
	[CICMSCLI] [varchar](1) NULL,
	[cOPERACAO] [varchar](5) NULL,
	[NICMSCREDITO] [float] NULL,
	[nprecopauta] [float] NULL,
	[NALIQREDUCAO] [float] NULL,
	[nvalorfrete] [float] NULL,
	[nbaseicms] [float] NULL,
	[nRedIpi1] [float] NULL,
	[nRedPis1] [float] NULL,
	[nredCofins1] [float] NULL,
	[nRedIPI] [float] NULL,
	[nRedPIS] [float] NULL,
	[nRedCofins] [float] NULL,
	[ccodoperacao] [varchar](5) NULL,
	[ccodfiscal] [varchar](5) NULL,
	[nprecobase] [float] NULL,
	[NCTRESTOQUE] [int] NULL,
	[NQTDRESERVADA] [float] NULL,
	[naliquotaII] [float] NULL,
	[nvalorII] [float] NULL,
	[nbaseII] [float] NULL,
	[nbaseCOFINS] [float] NULL,
	[nbasePIS] [float] NULL,
	[nvalorDespesaAdu] [float] NULL,
 CONSTRAINT [PK_ITENSPEDIDOSAIDA] PRIMARY KEY CLUSTERED 
(
	[CNUMPEDIDO] ASC,
	[NITEM] 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
/****** Object:  Table [dbo].[ITENSPENDENTES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ITENSPENDENTES](
	[CCODCLIENTE] [varchar](18) NULL,
	[CCODPRODUTO] [varchar](13) NULL,
	[NQTDPENDENTE] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[LANCAMENTO_CAIXA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LANCAMENTO_CAIXA](
	[NUMERO_MOVIMENTO] [int] NOT NULL,
	[DATA_CAIXA] [datetime] NULL,
	[PERIODO_CAIXA] [varchar](1) NULL,
	[CODIGO_CAIXA] [varchar](6) NULL,
	[DATAHORA_MOVIMENTO] [datetime] NULL,
	[TIPO_MOVIMENTO] [varchar](15) NULL,
	[TIPO_RECEBIMENTO] [varchar](2) NULL,
	[VALOR_MOVIMENTO] [float] NULL,
	[HISTORICO_MOVIMENTO] [varchar](40) NULL,
	[CODIGO_CLIENTE] [varchar](18) NULL,
	[OBSERVACAO] [varchar](80) NULL,
 CONSTRAINT [PK_MOVIMENTO_CAIXA] PRIMARY KEY CLUSTERED 
(
	[NUMERO_MOVIMENTO] 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
/****** Object:  Table [dbo].[LANCAMENTOS_BANCARIOS]    Script Date: 11/01/2018 18:18:01 ******/
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,
 CONSTRAINT [PK_LANCAMENTOS_BANCARIOS] PRIMARY KEY CLUSTERED 
(
	[LANCAMENTO] 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
/****** Object:  Table [dbo].[Lancamentos_Correntistas]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[Lancamentos_Correntistas](
	[NumeroLancamento] [int] NOT NULL,
	[Controle] [int] NULL,
	[Codigo_Cliente] [varchar](18) NULL,
	[Data_Lancamento] [datetime] NULL,
	[Data_Documento] [datetime] NULL,
	[Tipo_Lancamento] [varchar](1) NULL,
	[Numero_Pedido] [varchar](6) NULL,
	[Parcela] [varchar](2) NULL,
	[Condicao_Pagamento] [varchar](5) NULL,
	[Nota_Fiscal] [varchar](6) NULL,
	[Valor_Lancamento] [float] NULL,
	[Valor_Pago] [float] NULL,
	[Historico_lancamento] [varchar](40) NULL,
	[Data_Alteracao] [datetime] NULL,
	[Data_Extrato] [datetime] NULL,
	[Status_Baixa] [varchar](1) NULL,
	[Numero_AST] [varchar](10) NULL,
	[Referencia_Frete] [varchar](6) NULL,
	[Cobranca_Bancaria] [varchar](1) NULL,
	[Nosso_Numero] [varchar](20) NULL,
	[Data_envio] [datetime] NULL,
	[Instrucoes1] [varchar](40) NULL,
	[Instrucoes2] [varchar](40) NULL,
	[Instrucoes3] [varchar](40) NULL,
	[Numero_Baixa] [int] NULL,
	[Faturado] [varchar](1) NULL,
	[Codigo_Filial] [varchar](3) NULL,
	[Nota_Promissoria] [varchar](1) NULL,
	[Produto] [varchar](1) NULL,
	[Fundo_Perdido] [varchar](1) NULL,
	[Usuario] [varchar](6) NULL,
	[Id_Cobranca] [varchar](10) NULL,
	[Numero_Vale] [int] NULL,
	[Tipo_Receita] [varchar](5) NULL,
	[Receita_Abatimento] [varchar](1) NULL,
	[Codigo_Agente] [varchar](3) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Licitacao_Itens]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Licitacao_Itens](
	[NCONTROLE] [int] NULL,
	[NSEQUENCIA] [int] NULL,
	[CLOTE] [varchar](4) NULL,
	[CITEM] [varchar](4) NULL,
	[CCODIGO] [varchar](9) NULL,
	[CDESCRICAO] [varchar](100) NULL,
	[CUNIDADE] [varchar](20) NULL,
	[CAPRESENTACAO] [varchar](100) NULL,
	[CINICIOCOMERCIO] [varchar](30) NULL,
	[CACONDICIONAMENTO] [varchar](40) NULL,
	[CCONSERVACAO] [varchar](40) NULL,
	[CESPEFICIACAO] [text] NULL,
	[CREGMINSAUDE] [varchar](40) NULL,
	[CMARCA] [varchar](40) NULL,
	[CPROCEDENCIA] [varchar](20) NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[NPRECOTOTAL] [float] NULL,
	[NLINHAESPEC] [int] NULL,
	[NLINHATOTAL] [int] NULL,
	[BQUEBRAPAGINA] [bit] NULL,
	[BVENDIDO] [bit] NULL,
	[BENTREGUE] [bit] NULL,
	[NQTDENTREGUE] [float] NULL,
	[CCODFORNECEDOR] [varchar](18) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Licitacoes]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Licitacoes](
	[NCONTROLE] [int] NULL,
	[DDATA] [datetime] NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[CNOMECLIENTE] [varchar](50) NULL,
	[CPROCESSO] [varchar](40) NULL,
	[CCOMISSAO] [varchar](80) NULL,
	[CTIPOLICITACAO] [varchar](30) NULL,
	[CMODALIDADE] [varchar](30) NULL,
	[CREGIMEEXECUCAO] [varchar](30) NULL,
	[CNUMERO] [varchar](30) NULL,
	[DENCERRAMENTO] [datetime] NULL,
	[DHORAENCERRAMENTO] [datetime] NULL,
	[DABERTURA] [datetime] NULL,
	[DHORAABERTURA] [datetime] NULL,
	[CENDERECO] [varchar](80) NULL,
	[MOBJETO] [text] NULL,
	[CVALIDADE] [varchar](30) NULL,
	[CLOCALENTREGA] [varchar](100) NULL,
	[CPRAZOENTREGA] [varchar](100) NULL,
	[CCRONOGRAMA] [varchar](100) NULL,
	[CVIGENCIACONTRATO] [varchar](80) NULL,
	[CFORMAPAGTO] [varchar](80) NULL,
	[CBANCODEPOSITO] [varchar](30) NULL,
	[CAGENCIABANCO] [varchar](30) NULL,
	[CCONTACORRENTE] [varchar](30) NULL,
	[CFRETE] [varchar](30) NULL,
	[CVALIDADEPRODUTOS] [varchar](30) NULL,
	[CGARANTIA] [varchar](30) NULL,
	[CAGRUPALOTE] [varchar](1) NULL,
	[NTOTALGERAL] [float] NULL,
	[CDETALHADO] [varchar](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[LicitacoesItensAcompanhamento]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[LicitacoesItensAcompanhamento](
	[NCONTROLE] [int] NULL,
	[NSEQUENCIA] [int] NULL,
	[CNUMPEDIDO] [varchar](6) NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[NPRECOGLOBAL] [float] NULL,
	[CCARTACREDITO] [varchar](20) NULL,
	[CTROCAMATERIAL] [varchar](20) NULL,
	[CVALE] [varchar](20) NULL,
	[CACESSORIOS] [varchar](20) NULL,
	[MOBSERVACOES] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Linhas]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Linhas](
	[CODIGO] [varchar](2) NULL,
	[DESCRICAO] [varchar](30) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[log_registro]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[log_registro](
	[ctabela] [varchar](30) NULL,
	[coperacao] [varchar](15) NULL,
	[cusuario] [varchar](6) NULL,
	[ddata] [datetime] NULL,
	[cdetalhe] [varchar](30) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Lote_Producao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Lote_Producao](
	[Numero_Lote] [int] NOT NULL,
	[Numero_Mesa] [int] NULL,
	[Tipo_Mesa] [varchar](1) NULL,
	[Referencia] [varchar](9) NULL,
	[Quantidade] [float] NULL,
	[Data_Criacao] [datetime] NULL,
	[Data_Mesa] [datetime] NULL,
	[Data_Corte] [datetime] NULL,
	[Data_Producao] [datetime] NULL,
	[Data_Revisao] [datetime] NULL,
	[Data_Estoque] [datetime] NULL,
	[Qtd_Defeito] [float] NULL,
	[Situacao] [varchar](1) NULL,
	[Func_Criacao] [int] NULL,
	[Func_Mesa] [int] NULL,
	[Func_Corte] [int] NULL,
	[Func_Revisao] [int] NULL,
	[Func_Producao] [int] NULL,
	[Func_Estoque] [int] NULL,
	[Equipe_Producao] [int] NULL,
	[Responsavel_Revisao] [int] NULL,
	[Observacao] [varchar](120) NULL,
	[Faccao] [varchar](1) NULL,
	[Nota_Remessa] [int] NULL,
	[Nota_Retorno] [int] NULL,
	[Codigo_Faccao] [varchar](5) NULL,
	[Genero] [varchar](1) NULL,
	[Func_Cancelou] [int] NULL,
	[Data_Aprovacao] [datetime] NULL,
	[Func_Aprovou] [int] NULL,
	[nctrestoque] [int] NULL,
	[qtd_conferida_revisao] [float] NULL,
	[qtd_conferida_estoque] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Lotes_Producao_Kit]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Lotes_Producao_Kit](
	[Numero_Lote] [int] NOT NULL,
	[Referencia] [varchar](15) NOT NULL,
	[Referencia_Kit] [varchar](15) NOT NULL,
	[Referencia_LD] [varchar](15) NULL,
	[Qtd] [float] NULL,
	[Qtd_OK] [float] NULL,
	[Qtd_LD] [float] NULL,
	[cstatus] [varchar](1) NULL,
	[ddatamovimento] [datetime] NULL,
	[nctrestoque] [int] NULL,
	[qtd_conferida_Estoque] [float] NULL,
	[qtd_conferida_revisao] [float] NULL,
	[qtd_conferida_Estoque_ld] [float] NULL,
	[qtd_conferida_revisao_ld] [float] NULL,
 CONSTRAINT [PK__Lotes_Pr__7869A4A72371D8E5] PRIMARY KEY CLUSTERED 
(
	[Numero_Lote] ASC,
	[Referencia] ASC,
	[Referencia_Kit] 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
/****** Object:  Table [dbo].[Mailing]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Mailing](
	[codigo] [int] NULL,
	[nome] [varchar](40) NULL,
	[endereco] [varchar](30) NULL,
	[numero] [int] NULL,
	[complemento] [varchar](20) NULL,
	[bairro] [varchar](20) NULL,
	[cidade] [varchar](30) NULL,
	[uf] [varchar](2) NULL,
	[cep] [varchar](15) NULL,
	[email] [varchar](40) NULL,
	[emailsecundario] [varchar](40) NULL,
	[telefone] [varchar](15) NULL,
	[fax] [varchar](15) NULL,
	[grupo] [varchar](15) NULL,
	[regiao] [varchar](20) NULL,
	[palavrachave] [varchar](30) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Mapear_cfop_nota]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Mapear_cfop_nota](
	[nnumnf] [int] NOT NULL,
	[cnumserie] [varchar](1) NOT NULL,
	[ctipodoc] [varchar](1) NOT NULL,
	[ccodfornecedor] [varchar](14) NULL,
	[cfop_original] [int] NOT NULL,
	[cfop_mapeado] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[nnumnf] ASC,
	[cnumserie] ASC,
	[ctipodoc] ASC,
	[cfop_original] 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
/****** Object:  Table [dbo].[Mapear_produtos_nota]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Mapear_produtos_nota](
	[nnumnf] [int] NOT NULL,
	[cnumserie] [varchar](1) NOT NULL,
	[ctipodoc] [varchar](1) NOT NULL,
	[ccodfornecedor] [varchar](14) NOT NULL,
	[ccodproduto] [varchar](13) NOT NULL,
	[cdescricao] [varchar](120) NULL,
	[ccoditem] [varchar](15) NULL,
 CONSTRAINT [PK__Mapear_p__F03BC27967BB9D86] PRIMARY KEY CLUSTERED 
(
	[nnumnf] ASC,
	[cnumserie] ASC,
	[ctipodoc] ASC,
	[ccodfornecedor] ASC,
	[ccodproduto] 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
/****** Object:  Table [dbo].[Mensagens]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Mensagens](
	[CNUMMENSAGEM] [varchar](6) NULL,
	[CREMETENTE] [varchar](6) NULL,
	[CDESTINATARIO] [varchar](6) NULL,
	[DDATA] [datetime] NULL,
	[CMENSAGEM] [text] NULL,
	[CSTATUS] [varchar](1) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MOEDAS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MOEDAS](
	[CCODMOEDA] [char](1) NOT NULL,
	[CMOEDA] [char](15) NULL,
	[CTIPO_CORRECAO] [char](1) NULL,
	[CSIMBOLO] [char](5) NULL,
	[CEXTENSO_SINGULAR] [char](15) NULL,
	[CEXTENSO_PLURAL] [char](15) NULL,
	[CFRACAO_SINGULAR] [char](15) NULL,
	[CFRACAO_PLURAL] [char](15) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[MOVIMENTO_CAIXA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MOVIMENTO_CAIXA](
	[NUMERO_MOVIMENTO] [int] NOT NULL,
	[COD_FILIAL] [varchar](3) NULL,
	[DATA_MOVIMENTO] [datetime] NULL,
	[TIPO_MOVIMENTO] [varchar](1) NULL,
	[VALOR_MOVIMENTO] [float] NULL,
	[HISTORICO] [varchar](30) NULL,
	[DATA_ALTERACAO] [datetime] NULL,
	[USUARIO] [varchar](6) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[NATUREZAOPERACAO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NATUREZAOPERACAO](
	[CCODNATOPERACAO] [varchar](3) NULL,
	[CDESCRICAO] [varchar](25) NULL,
	[CTIPOOPERACAO] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[NCM_ST]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NCM_ST](
	[NCM] [varchar](8) NOT NULL,
	[ALIQUOTA_DENTRO] [float] NULL,
	[ALIQUOTA_FORA] [float] NULL,
	[REDUCAO_SIMPLES] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Nf]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Nf](
	[NNUMMOVSAIDA] [int] NOT NULL,
	[NNUMNF] [int] NULL,
	[CNUMSERIE] [varchar](1) NULL,
	[CCODAGENTE] [varchar](3) NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[CNUMPEDIDO] [varchar](8) NULL,
	[CCODOPERACAO] [varchar](4) NULL,
	[DDATAEMISSAO] [datetime] NULL,
	[NVALORTOTAL] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NVALORLIQUIDO] [float] NULL,
	[CCONSIGNACAOBAIXA] [varchar](1) NULL,
	[CCANCELADA] [varchar](1) NULL,
	[COBS] [varchar](120) NULL,
	[NVALORIPI] [float] NULL,
	[NBASEICMS] [float] NULL,
	[NVALORICMS] [float] NULL,
	[NVALORFRETE] [float] NULL,
	[NPESO] [float] NULL,
	[NOUTRASDESPESAS] [float] NULL,
	[CREFERENCIA_C] [varchar](1) NULL,
	[CESPECIE] [varchar](15) NULL,
	[NQTDVOLUMES] [int] NULL,
	[CMARCA] [varchar](15) NULL,
	[NPESOBRUTO] [float] NULL,
	[NALIQ_REDUCAO] [float] NULL,
	[NALIQISS] [float] NULL,
	[NBASEISS] [float] NULL,
	[NVALORISS] [float] NULL,
	[NVALORSERVICOS] [float] NULL,
	[CSTATUS_NFE] [varchar](1) NULL,
	[CPROTOCOLO_NFE] [varchar](60) NULL,
	[CRECIBO_NFE] [varchar](60) NULL,
	[CARQUIVO_NFE] [varchar](120) NULL,
	[nbaseicmst] [float] NULL,
	[nvaloricmst] [float] NULL,
	[CST] [varchar](2) NULL,
	[CDESCRICAO] [varchar](100) NULL,
	[CUNIDADE] [varchar](2) NULL,
	[NTOTALPIS] [float] NULL,
	[NTOTALCOFINS] [float] NULL,
	[DDATASAIDA] [datetime] NULL,
	[NVALORBASEIPI] [float] NULL,
	[CCHAVENFE] [varchar](60) NULL,
	[NTOTALICMSCREDITO] [float] NULL,
	[NNUMNFCOMPENSADA] [int] NULL,
	[nTotalII] [float] NULL,
	[nTotalBaseII] [float] NULL,
 CONSTRAINT [PK_Nf] PRIMARY KEY CLUSTERED 
(
	[NNUMMOVSAIDA] 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
/****** Object:  Table [dbo].[NFE_Inutilizadas]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NFE_Inutilizadas](
	[CANO] [varchar](4) NULL,
	[CMODELO] [varchar](2) NULL,
	[CSERIE] [varchar](3) NULL,
	[NNUMERO] [int] NULL,
	[CPROTOCOLO] [varchar](30) NULL,
	[DDATAHORA] [datetime] NULL,
	[CJUSTIFICATIVA] [varchar](60) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[NFE_SEQUENCIA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[NFE_SEQUENCIA](
	[NNUMERO] [int] NULL
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Ocorrencias]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Ocorrencias](
	[CCODOCORRENCIA] [int] NOT NULL,
	[CDESCRICAO] [varchar](40) NULL,
 CONSTRAINT [PK_Ocorrencias] PRIMARY KEY CLUSTERED 
(
	[CCODOCORRENCIA] 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
/****** Object:  Table [dbo].[Ocorrencias_Banco_Brasil]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Ocorrencias_Banco_Brasil](
	[CCODIGO] [varchar](2) NOT NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[NVALORTAXA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Ocorrencias_Banco_Itau]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Ocorrencias_Banco_Itau](
	[CCODIGO] [varchar](2) NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[NVALORTAXA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Ocorrencias_Banrisul]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Ocorrencias_Banrisul](
	[CCODIGO] [varchar](2) NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[NVALORTAXA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Ocorrencias_Bradesco]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Ocorrencias_Bradesco](
	[CCODIGO] [varchar](2) NOT NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[NVALORTAXA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Operacao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Operacao](
	[CCODOPERACAO] [varchar](4) NULL,
	[CDESCRICAO] [varchar](25) NULL,
	[CCODNATOPERACAO] [varchar](3) NULL,
	[CTIPOMOVIMENTO] [varchar](1) NULL,
	[CGERAFINANCEIRO] [varchar](1) NULL,
	[CCLASSE] [varchar](1) NULL,
	[CBAIXAESTOQUE] [varchar](1) NULL,
	[CVRPEDIDOZERO] [varchar](1) NULL,
	[CCALCULAICMS] [varchar](1) NULL,
	[CCODFISCAL] [varchar](6) NULL,
	[CBAIXAESTOQUEREAL] [varchar](1) NULL,
	[CST] [varchar](2) NULL,
	[CFORMACALCULO] [varchar](1) NULL,
	[CTEMST] [varchar](1) NULL,
	[CTIPONOTA] [varchar](1) NULL,
	[ccalculaipi] [varchar](1) NULL,
	[ccreditoicms] [varchar](1) NULL,
	[CICMSPRODUTO] [varchar](1) NULL,
	[ctipooperacao] [varchar](1) NULL,
	[csosn] [varchar](3) NULL,
	[csubmeterestoque] [varchar](1) NULL,
	[ccalculaii] [varchar](1) NULL,
	[CIPIBASEST] [varchar](1) NULL,
	[CISENTARPISCOFINS] [varchar](1) NULL,
	[CSTPIS] [varchar](2) NULL,
	[CSTCOFINS] [varchar](2) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[OPERACAOCONDICOES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[OPERACAOCONDICOES](
	[CCODOPERACAO] [varchar](4) NULL,
	[CCODCONDPAGAMENTO] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Ordem_Servico]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Ordem_Servico](
	[NUMERO_ORCAMENTO] [int] NULL,
	[CODIGO_CLIENTE] [int] NULL,
	[DATA_ORCAMENTO] [datetime] NULL,
	[VALOR_TOTAL] [float] NULL,
	[DESCONTO] [float] NULL,
	[VALOR_LIQUIDO] [float] NULL,
	[CONDICOES_PAGAMENTO] [varchar](10) NULL,
	[VENDEDOR] [varchar](2) NULL,
	[NUMERO_VENDA] [int] NULL,
	[STATUS] [varchar](1) NULL,
	[DESCONTO_GLOBAL] [float] NULL,
	[FORMA_VENDA] [varchar](1) NULL,
	[ORCAMENTO_CONDICIONAL] [varchar](1) NULL,
	[NCODCONDPAGAMENTO] [int] NULL,
	[VALOR_ENTRADA] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Parametros]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Parametros](
	[LojaAtiva] [int] NULL,
	[TipoECF] [varchar](20) NULL,
	[EcfAtivo] [varchar](1) NULL,
	[Pede_Vendedor] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PEDIDO_COMPRA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PEDIDO_COMPRA](
	[NUMERO_PEDIDO] [int] NOT NULL,
	[CODIGO_FORNECEDOR] [varchar](14) NULL,
	[VENDEDOR_FORNECEDOR] [varchar](30) NULL,
	[DATAHORA_PEDIDO] [datetime] NULL,
	[TOTAL_PEDIDO] [float] NULL,
	[PRAZO_ENTREGA] [int] NULL,
	[CONDICAO_PAGAMENTO] [varchar](30) NULL,
	[FORMA_PAGAMENTO] [varchar](20) NULL,
	[TOTAL_CONFIRMADO] [float] NULL,
	[OBSERVACOES_PEDIDO] [image] NULL,
	[OPERADOR_SISTEMA] [varchar](6) NULL,
	[QUANTIDADE_PARCELA] [int] NULL,
	[PRIMEIRA_PARCELA] [datetime] NULL,
	[INTEVALOS_ENTRE] [int] NULL,
	[TIPO_DESPESA] [varchar](5) NULL,
	[CONFIRMA] [varchar](1) NULL,
	[EMISSAO_NOTA] [datetime] NULL,
	[ENTRADA_NOTA] [datetime] NULL,
	[ARQUIVO_NFE] [varchar](120) NULL,
	[CHAVE_NFE] [varchar](60) NULL,
	[NUMERO_NOTA] [int] NULL,
	[NNUMOS] [varchar](10) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PEDIDODEVOLUCAO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PEDIDODEVOLUCAO](
	[CNUMPEDIDO] [varchar](6) NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[DDATAEMISSAO] [datetime] NULL,
	[CCODNATOPERACAO] [varchar](3) NULL,
	[COBS1] [varchar](40) NULL,
	[COBS2] [varchar](40) NULL,
	[NDESCONTO] [float] NULL,
	[CSTATUS] [varchar](1) NULL,
	[ccodvendedor] [varchar](2) NULL,
	[COBS] [varchar](40) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PedidoOcorrencias]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PedidoOcorrencias](
	[CNUMPEDIDO] [varchar](8) NOT NULL,
	[CCODOCORRENCIA] [int] NOT NULL,
 CONSTRAINT [PK_PedidoOcorrencias] PRIMARY KEY CLUSTERED 
(
	[CNUMPEDIDO] ASC,
	[CCODOCORRENCIA] 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
/****** Object:  Table [dbo].[PEDIDOSAIDA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PEDIDOSAIDA](
	[CNUMPEDIDO] [varchar](8) NOT NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[CCODAGENTE] [varchar](3) NULL,
	[CCODOPERACAO] [varchar](4) NULL,
	[DDATAEMISSAO] [datetime] NULL,
	[NCODCONDPAGAMENTO] [int] NULL,
	[CPRAZO] [int] NULL,
	[NNUMPARCELAS] [int] NULL,
	[NFABRICANTE] [int] NULL,
	[CCODTRANSPORTADORA] [varchar](14) NULL,
	[CPEDIDOCLIENTE] [varchar](10) NULL,
	[CTIPOFRETE] [varchar](1) NULL,
	[CTIPOPRECO] [varchar](1) NULL,
	[COBS1] [varchar](100) NULL,
	[COBS2] [varchar](100) NULL,
	[COBS3] [varchar](100) NULL,
	[NDESCONTO] [float] NULL,
	[NVALORLIQUIDO] [float] NULL,
	[NVALORFRETE] [float] NULL,
	[NDESPESAS] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NCREDITOSOBTIDOS] [float] NULL,
	[NTOTALIPI] [float] NULL,
	[NVALORTOTAL] [float] NULL,
	[NVENDEDOR] [int] NULL,
	[NCOMISSAO] [float] NULL,
	[DFATURAMENTO] [datetime] NULL,
	[DFATURAMENTOREAL] [datetime] NULL,
	[NTOTALFATURADO] [float] NULL,
	[CNUMERONF] [varchar](6) NULL,
	[CIDFAT] [varchar](1) NULL,
	[CRESTRICAO] [varchar](50) NULL,
	[CSTATUS] [varchar](1) NULL,
	[CDESPACHADO] [varchar](1) NULL,
	[DDATADESPACHO] [datetime] NULL,
	[CUSUARIODESPACHO] [varchar](5) NULL,
	[CREFERENCIA_C] [varchar](1) NULL,
	[NDIGITACAO] [int] NULL,
	[NSEPARADO] [int] NULL,
	[NCONFERIDO] [int] NULL,
	[NEMBALADO] [int] NULL,
	[NPESO] [float] NULL,
	[CESPECIE] [varchar](15) NULL,
	[NQTDVOLUMES] [int] NULL,
	[CMARCA] [varchar](15) NULL,
	[CANALISASITUACAO] [varchar](1) NULL,
	[CANALISALIMITE] [varchar](1) NULL,
	[CANALISAATRASOMED] [varchar](1) NULL,
	[CANALISADUPVENC] [varchar](1) NULL,
	[CUSUARIO] [varchar](6) NULL,
	[DULTIMAATUALIZACAO] [datetime] NULL,
	[NVALORCOMISSAO] [float] NULL,
	[NALIQ_REDUCAO] [float] NULL,
	[NPESOBRUTO] [float] NULL,
	[COBSOCORRENCIA] [varchar](max) NULL,
	[CPEDIDOPENDENTE] [varchar](8) NULL,
	[CMOEDA] [varchar](1) NULL,
	[NCODCONDPAGAMENTO_C] [int] NULL,
	[Ccodagente_c] [varchar](3) NULL,
	[DPREVISAOENTREGA] [datetime] NULL,
	[COBSADICIONAL] [text] NULL,
	[CINVERSAOIPI] [varchar](1) NULL,
	[CSITUACAOIPI] [varchar](1) NULL,
	[nbaseicmst] [float] NULL,
	[nvaloricmst] [float] NULL,
	[CCODRESPONSAVEL] [int] NULL,
	[CSTATUS_EXPEDICAO] [varchar](1) NULL,
	[DDATAATRIBUICAO] [datetime] NULL,
	[COBSROMANEIO1] [varchar](80) NULL,
	[COBSROMANEIO2] [varchar](80) NULL,
	[COBSROMANEIO3] [varchar](80) NULL,
	[CFINPEDIDO] [varchar](1) NULL,
	[CREFNFE] [varchar](60) NULL,
	[NTOTALICMS] [float] NULL,
	[NBASEICMS] [float] NULL,
	[NTOTALICMST] [float] NULL,
	[NTOTALPESOL] [float] NULL,
	[NTOTALPESOB] [float] NULL,
	[CTABELA] [varchar](10) NULL,
	[DDATASAIDA] [datetime] NULL,
	[NVALORBASEIPI] [float] NULL,
	[NTOTALICMSCREDITO] [float] NULL,
	[cobs4] [varchar](100) NULL,
	[CLATITUDE] [varchar](30) NULL,
	[CLONGITUDE] [varchar](30) NULL,
	[CSUBMETIDO] [varchar](1) NULL,
	[ccodcorretor] [int] NULL,
	[COPERADOR] [varchar](6) NULL,
	[NQTDTOTAL] [float] NULL,
	[nTotalII] [float] NULL,
	[nTotalBaseII] [float] NULL,
	[CNUMDI] [varchar](20) NULL,
	[DDATADI] [datetime] NULL,
	[cLocDesemb] [varchar](40) NULL,
	[dDesemb] [datetime] NULL,
	[CUFDesemb] [varchar](2) NULL,
	[ccontrole] [varchar](10) NULL,
	[cnumPedidoC] [varchar](8) NULL,
 CONSTRAINT [PK_PEDIDOSAIDA] PRIMARY KEY NONCLUSTERED 
(
	[CNUMPEDIDO] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Permuser]    Script Date: 11/01/2018 18:18:01 ******/
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].[Plano_Contas]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Plano_Contas](
	[Conta] [int] NULL,
	[Descricao] [varchar](40) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PREVENDA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PREVENDA](
	[NNUMERO] [int] NOT NULL,
	[DDATA] [datetime] NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[CSTATUS] [varchar](1) NULL,
	[COBSERVACOES] [varchar](120) NULL,
	[NTOTAL] [float] NULL,
	[NDESCONTO] [float] NULL,
	[NLIQUIDO] [float] NULL,
	[CTABELA] [varchar](10) NULL,
 CONSTRAINT [PK_PREVENDA] PRIMARY KEY CLUSTERED 
(
	[NNUMERO] 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
/****** Object:  Table [dbo].[PREVENDAITENS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PREVENDAITENS](
	[NNUMERO] [int] NOT NULL,
	[CCODIGOITEM] [varchar](15) NOT NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECO] [float] NULL,
	[NTOTAL] [float] NULL,
	[NPERCDESC] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NVALORLIQUIDO] [float] NULL,
	[CNUMPEDIDO] [varchar](8) NULL,
	[DDATAMOVIMENTO] [datetime] NULL,
	[NCTRESTOQUE] [int] NULL,
 CONSTRAINT [PK_PREVENDAITENS] PRIMARY KEY CLUSTERED 
(
	[NNUMERO] ASC,
	[CCODIGOITEM] 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
/****** Object:  Table [dbo].[ProcessoProducao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ProcessoProducao](
	[CREFERENCIA] [varchar](9) NOT NULL,
	[NSEQUENCIA] [int] NOT NULL,
	[CCODPROCESSO] [int] NULL,
	[CREPETE] [varchar](1) NULL,
	[CTIPOEQUIPAMENTO] [int] NULL,
	[DTEMPO] [datetime] NULL,
	[CCOMPLEMENTO] [varchar](60) NULL,
 CONSTRAINT [PK_ProcessoProducao] PRIMARY KEY CLUSTERED 
(
	[CREFERENCIA] ASC,
	[NSEQUENCIA] 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
/****** Object:  Table [dbo].[Processos]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Processos](
	[CCODPROCESSO] [int] NOT NULL,
	[CDESCRICAOPROCESSO] [varchar](120) NULL,
	[CCODGRUPOPERM] [varchar](10) NULL,
	[RANK] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ProcessosGrupo]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ProcessosGrupo](
	[CCODPROCESSO] [int] NULL,
	[COD_GRU] [varchar](10) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Producao_Faccao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Producao_Faccao](
	[NNUMNF] [int] NOT NULL,
	[CSERIE] [varchar](1) NOT NULL,
	[CCODFORNECEDOR] [varchar](19) NOT NULL,
	[CNUMLOTE] [varchar](20) NOT NULL,
	[CREFERENCIA] [varchar](9) NOT NULL,
	[DDATAEMISSAO] [datetime] NULL,
	[NQUANTIDADE] [float] NULL,
	[NPRECOUNITARIO] [float] NULL,
	[DDATAFINALIZACAO] [datetime] NULL,
	[NNUMNF_RETORNO] [int] NULL,
	[DDATARETORNO] [datetime] NULL,
	[CSTATUS] [varchar](1) NULL,
	[CCHAVE] [varchar](44) NULL,
 CONSTRAINT [PK_Producao_Faccao_1] PRIMARY KEY CLUSTERED 
(
	[NNUMNF] ASC,
	[CSERIE] ASC,
	[CCODFORNECEDOR] ASC,
	[CNUMLOTE] ASC,
	[CREFERENCIA] 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
/****** Object:  Table [dbo].[Producao_Movimento]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Producao_Movimento](
	[creferencia] [varchar](9) NULL,
	[cdocumento] [varchar](10) NULL,
	[cespecie] [varchar](5) NULL,
	[cserie] [varchar](1) NULL,
	[ddata] [datetime] NULL,
	[ccontabil] [varchar](10) NULL,
	[cfiscal] [varchar](10) NULL,
	[e_s] [varchar](1) NULL,
	[ccod] [varchar](1) NULL,
	[nqtd] [float] NULL,
	[nvalor] [float] NULL,
	[nipi] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ProducaoProcessosLote]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ProducaoProcessosLote](
	[CNUMLOTE] [int] NOT NULL,
	[NSEQUENCIA] [int] NOT NULL,
	[NORDEM] [int] NOT NULL,
	[CCODPROCESSO] [int] NULL,
	[CTIPOEQUIPAMENTO] [int] NULL,
	[CCODEQUIPAMENTO] [varchar](50) NULL,
	[DDATAINICIO] [datetime] NULL,
	[COPERADORINICIO] [int] NULL,
	[DDATAFINALIZACAO] [datetime] NULL,
	[COPERADORFINAL] [int] NULL,
 CONSTRAINT [PK_ProducaoProcessos] PRIMARY KEY CLUSTERED 
(
	[CNUMLOTE] ASC,
	[NSEQUENCIA] ASC,
	[NORDEM] 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
/****** Object:  Table [dbo].[Produtos]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Produtos](
	[CREFERENCIA] [varchar](9) NOT NULL,
	[CCODPRODUTO] [varchar](13) NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[CESPECIFICACAO] [varchar](60) NULL,
	[CAPRESENTACAO] [varchar](20) NULL,
	[CPROCEDENCIA] [varchar](1) NULL,
	[CESPECIFICACAOTEC] [text] NULL,
	[CMARCA] [varchar](15) NULL,
	[CORDEM] [varchar](5) NULL,
	[CUNIDADEVENDA] [varchar](2) NULL,
	[CCODFABRICANTE] [int] NULL,
	[CCODSECAO] [varchar](3) NULL,
	[NPRECOVENDA] [float] NULL,
	[NPRECOESPECIAL] [float] NULL,
	[NPRECOCUSTO] [float] NULL,
	[NCUSTOMEDIO] [float] NULL,
	[NPRECOCOMPRA] [float] NULL,
	[NPRECOREFERENCIA] [float] NULL,
	[NPESOTEORICO] [float] NULL,
	[NIPI] [float] NULL,
	[NALIQUOTA_ICMS] [float] NULL,
	[NESTOQUEATUAL] [float] NULL,
	[NESTOQUEMINIMO] [float] NULL,
	[NESTOQUEPENDENTE] [float] NULL,
	[NESTOQUENAOATENDIDO] [float] NULL,
	[NESTOQUEIMPLANTACAO] [float] NULL,
	[NESTOQUEMINIMOPRODUZIR] [float] NULL,
	[CCATEGORIA] [varchar](1) NULL,
	[CLINHA] [varchar](2) NULL,
	[CSEGMENTO] [varchar](2) NULL,
	[CSITUACAO_TRIBUTARIA] [varchar](2) NULL,
	[CREFERENCIA_C] [varchar](9) NULL,
	[CAGRUPA] [varchar](1) NULL,
	[NPERCDESCONTO] [float] NULL,
	[NALIQUOTA_ICMS_F] [float] NULL,
	[CESPECIE] [varchar](1) NULL,
	[CUSUARIO] [varchar](6) NULL,
	[DULTIMAATUALIZACAO] [datetime] NULL,
	[DDATACADASTRO] [datetime] NULL,
	[DULTIMAVENDA] [datetime] NULL,
	[DULTIMACOMPRA] [datetime] NULL,
	[CFORMACALCULO] [varchar](1) NULL,
	[CFORMACALCULOE] [varchar](1) NULL,
	[CPEDEPESO] [varchar](1) NULL,
	[NCOD_SEQ] [int] NULL,
	[NCOMISSAO] [float] NULL,
	[NALIQUOTA_ICMS_FPF] [float] NULL,
	[NALIQREDUCAO] [float] NULL,
	[NESTOQUEREAL] [float] NULL,
	[CCODOPERACAOFISCAL] [varchar](20) NULL,
	[cloteobrigatorio] [varchar](1) NULL,
	[CMOEDA] [varchar](1) NULL,
	[NPERCACRESCIMO] [float] NULL,
	[CUSARINDEXADOR] [varchar](1) NULL,
	[Ccodagente_c] [varchar](3) NULL,
	[CTIPOPRODUTO] [varchar](1) NULL,
	[CREFERENCIAFABRICANTE] [varchar](20) NULL,
	[CLOCALIZACAO] [varchar](20) NULL,
	[NQTDLOTE] [float] NULL,
	[NMARGEMLUCRO] [float] NULL,
	[NCOMISSAOSUP] [float] NULL,
	[NIMPOSTOSFED] [float] NULL,
	[CNCM] [varchar](15) NULL,
	[CNCMGENERO] [varchar](7) NULL,
	[CFABRICACAO] [varchar](1) NULL,
	[nqtdUNDVENDA] [float] NULL,
	[NQTDUNDDISTRIBUICAO] [float] NULL,
	[nqtdteoricaproducao] [float] NULL,
	[CCATALOGO] [varchar](1) NULL,
	[carquivoimagem] [varchar](60) NULL,
	[CLOTE] [varchar](40) NULL,
	[DVENCIMENTO] [datetime] NULL,
	[nmargembruta] [float] NULL,
	[cprecopraticar] [varchar](1) NULL,
	[NALIQ_PIS] [float] NULL,
	[NALIQ_COFINS] [float] NULL,
	[CCALCULO_IPI] [varchar](1) NULL,
	[CSTIPI] [varchar](2) NULL,
	[CSTPIS] [varchar](2) NULL,
	[CSTCOFINS] [varchar](2) NULL,
	[NPESOBRUTO] [float] NULL,
	[NPESOLIQUIDO] [float] NULL,
	[NVOLUME] [float] NULL,
	[CTEMST] [varchar](1) NULL,
	[cpauta] [varchar](1) NULL,
	[ccodst] [varchar](5) NULL,
	[CTIPOEMBALAGEM] [varchar](10) NULL,
	[CDUN14] [varchar](14) NULL,
	[NQTDEMBALAGEM] [int] NULL,
	[CCODREDUCAO] [varchar](10) NULL,
	[CFATOR] [varchar](1) NULL,
	[CKIT] [varchar](1) NULL,
	[ddatafab] [datetime] NULL,
	[CFATKITSEPARADO] [varchar](1) NULL,
	[NPRECONOVO] [float] NULL,
	[naliquotaII] [float] NULL,
	[NALIQICMST] [float] NULL,
 CONSTRAINT [PK_Produtos] PRIMARY KEY CLUSTERED 
(
	[CREFERENCIA] 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
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PRODUTOS_ORDEM_SERVICO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PRODUTOS_ORDEM_SERVICO](
	[NUMERO_ORCAMENTO] [int] NULL,
	[ITEM_ORCAMENTO] [int] NULL,
	[CODIGO_PRODUTO] [varchar](13) NULL,
	[QUANTIDADE_VENDA] [float] NULL,
	[PRECO_UNITARIO] [float] NULL,
	[PERCENTUAL_DESCONTO] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[PRODUTOS_PEDIDO_COMPRA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PRODUTOS_PEDIDO_COMPRA](
	[NUMERO_PEDIDO] [int] NOT NULL,
	[NUMERO_ITEM] [int] NOT NULL,
	[CODIGO_PRODUTO] [varchar](15) NULL,
	[QUANTIDADE_PEDIDA] [float] NULL,
	[UNIDADE_COMPRA] [varchar](4) NULL,
	[VALOR_UNITARIO] [float] NULL,
	[CONFIRMA] [varchar](1) NULL,
	[QUANTIDADE_BENEFICIADA] [float] NULL,
	[Quantidade_nota] [float] NULL,
	[Preco_Nota] [float] NULL,
	[ccodfabricante] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[RECEBIMENTOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[RECEBIMENTOS](
	[COD_REC] [varchar](2) NULL,
	[DES_REC] [varchar](30) NULL,
	[IMP_TIC] [varchar](1) NULL,
	[TIP_FAT] [varchar](1) NULL,
	[COB_SER] [varchar](1) NULL,
	[PER_TRO] [varchar](1) NULL,
	[DIAS_VEN] [int] NULL,
	[CONTRA_VALE] [varchar](1) NULL,
	[DESCONTO] [float] NULL,
	[TIP_RECEITA] [varchar](4) NULL,
	[FORMA] [varchar](1) NULL,
	[TIPO] [varchar](1) NULL,
	[DIA_UTIL] [varchar](1) NULL,
	[PEDE_CONDICAO] [varchar](1) NULL,
	[CCODAGENTE] [varchar](3) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[REDUCAO_IMPOSTOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[REDUCAO_IMPOSTOS](
	[CCODREDUCAO] [varchar](10) NOT NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[NREDIPI_ATACADO] [float] NULL,
	[NREDPIS_ATACADO] [float] NULL,
	[NREDCOFINS_ATACADO] [float] NULL,
	[NREDIPI_VAREJO] [float] NULL,
	[NREDPIS_VAREJO] [float] NULL,
	[NREDCOFINS_VAREJO] [float] NULL,
	[NREDIPI_CONSUMIDOR] [float] NULL,
	[NREDPIS_CONSUMIDOR] [float] NULL,
	[NREDCOFINS_CONSUMIDOR] [float] NULL,
	[NALIQIPI_ATACADO] [float] NULL,
	[NALIQIPI_VAREJO] [float] NULL,
	[NALIQIPI_CONSUMIDOR] [float] NULL,
	[NREDIPI_ATACADO1] [float] NULL,
	[NREDPIS_ATACADO1] [float] NULL,
	[NREDCOFINS_ATACADO1] [float] NULL,
	[NREDIPI_VAREJO1] [float] NULL,
	[NREDPIS_VAREJO1] [float] NULL,
	[NREDCOFINS_VAREJO1] [float] NULL,
	[NREDIPI_CONSUMIDOR1] [float] NULL,
	[NREDPIS_CONSUMIDOR1] [float] NULL,
	[NREDCOFINS_CONSUMIDOR1] [float] NULL,
	[NALIQPIS_ATACADO] [float] NULL,
	[NALIQCOFINS_ATACADO] [float] NULL,
	[NALIQPIS_VAREJO] [float] NULL,
	[NALIQCOFINS_VAREJO] [float] NULL,
	[NALIQPIS_CONSUMIDOR] [float] NULL,
	[NALIQCOFINS_CONSUMIDOR] [float] NULL,
 CONSTRAINT [PK_REDUCAO_IMPOSTOS] PRIMARY KEY CLUSTERED 
(
	[CCODREDUCAO] 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
/****** Object:  Table [dbo].[REGIOES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[REGIOES](
	[CCODREGIAO] [varchar](3) NULL,
	[CNOME] [varchar](25) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[REQUISICAOCONSUMO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[REQUISICAOCONSUMO](
	[NNUMERO] [int] NOT NULL,
	[DDATA] [datetime] NULL,
	[CFUNCIONARIO] [int] NULL,
	[CSTATUS] [varchar](1) NULL,
	[COBSERVACOES] [varchar](120) NULL,
 CONSTRAINT [PK_REQUISICAOCONSUMO] PRIMARY KEY CLUSTERED 
(
	[NNUMERO] 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
/****** Object:  Table [dbo].[REQUISICAOCONSUMOITENS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[REQUISICAOCONSUMOITENS](
	[NNUMERO] [int] NOT NULL,
	[CCODIGOITEM] [varchar](15) NOT NULL,
	[NQUANTIDADE] [float] NULL,
	[NCTRESTOQUE] [int] NULL,
	[DDATAMOVIMENTO] [datetime] NULL,
	[NPRECOUNITARIO] [float] NULL,
 CONSTRAINT [PK_REQUISICAOCONSUMOITENS] PRIMARY KEY CLUSTERED 
(
	[NNUMERO] ASC,
	[CCODIGOITEM] 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
/****** Object:  Table [dbo].[Retorno_Banco]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Retorno_Banco](
	[CBANCO] [varchar](3) NULL,
	[CNUMPEDIDO] [varchar](8) NULL,
	[CNUMPARCELA] [varchar](2) NULL,
	[CNUMSERIE] [varchar](1) NULL,
	[CNOSSONUMERO] [varchar](20) NULL,
	[COCORRENCIA] [varchar](2) NULL,
	[NSEQUENCIAL] [int] NULL,
	[CCODCLIENTE] [varchar](18) NULL,
	[NVALORNOMINAL] [float] NULL,
	[CAGENCIACOBRADORA] [varchar](5) NULL,
	[CDIGITOAGENCIA] [varchar](1) NULL,
	[NVALORTARIFAS] [float] NULL,
	[NJUROSMULTAS] [float] NULL,
	[NVALORDESCONTO] [float] NULL,
	[NVALORABATIMENTO] [float] NULL,
	[NVALORPAGO] [float] NULL,
	[NVALORLIQUIDO] [float] NULL,
	[NVALORDESPESAS] [float] NULL,
	[NVALORCREDITOS] [float] NULL,
	[DDATAOCORRENCIA] [datetime] NULL,
	[DDATACREDITO] [datetime] NULL,
	[COCORRENCIASACADO] [varchar](2) NULL,
	[DDATAOCORRENCIASAC] [datetime] NULL,
	[NVALOROCORRENCIA] [float] NULL,
	[DDATARETORNOBANCO] [datetime] NULL,
	[CRECEBIDOCAIXA] [varchar](1) NULL,
	[CUSUARIO] [varchar](6) NULL,
	[DULTIMAATUALIZACAO] [datetime] NULL,
	[CSTATUS] [varchar](1) NULL,
	[DDATABAIXATARIFA] [datetime] NULL,
	[DDATAVENCIMENTO] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ROTAS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ROTAS](
	[CCODIGO] [varchar](10) NULL,
	[CDESCRICAO] [varchar](40) NULL,
	[DDATA] [datetime] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ROTAS_MUNICIPIOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ROTAS_MUNICIPIOS](
	[CCODIGO] [varchar](10) NULL,
	[CCODMUNICIPIO] [varchar](7) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SEGMENTOS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SEGMENTOS](
	[CODIGOLINHA] [varchar](2) NULL,
	[CODIGO] [varchar](2) NULL,
	[DESCRICAO] [varchar](30) NULL,
	[DESCONTO] [float] NULL,
	[TIPO] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[SEQUENCIAIS]    Script Date: 11/01/2018 18:18:01 ******/
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].[Tab_municipios]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tab_municipios](
	[id] [varchar](7) NULL,
	[iduf] [varchar](2) NULL,
	[nome] [varchar](60) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TAB_ST]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TAB_ST](
	[CCODST] [varchar](5) NULL,
	[CSIGUF] [varchar](2) NULL,
	[NALIQ_ICMS] [float] NULL,
	[NALIQ_MVA] [float] NULL,
	[CIPI] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TABELA_CFOP]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TABELA_CFOP](
	[id_cfop] [int] NOT NULL,
	[descricao] [text] NULL,
	[aplicacao] [text] NULL,
	[cfop_inv] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[id_cfop] 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
/****** Object:  Table [dbo].[Tabela_Fornecedores]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tabela_Fornecedores](
	[Fornecedor] [varchar](40) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TABELA_PRECO]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TABELA_PRECO](
	[ctabela] [varchar](10) NOT NULL,
	[creferencia] [varchar](15) NOT NULL,
	[npreco] [float] NULL,
 CONSTRAINT [PK_TABELA_PRECO] PRIMARY KEY CLUSTERED 
(
	[ctabela] ASC,
	[creferencia] 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
/****** Object:  Table [dbo].[Tabela_Precos]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tabela_Precos](
	[CReferencia] [varchar](5) NULL,
	[NCodCondPagamento] [int] NULL,
	[Preco_Venda] [float] NULL,
	[Faixa_1] [float] NULL,
	[Com_Rep_Faixa_1] [float] NULL,
	[Com_Ger_Faixa_1] [float] NULL,
	[Com_Ven_Faixa_1] [float] NULL,
	[Faixa_2] [float] NULL,
	[Com_Rep_Faixa_2] [float] NULL,
	[Com_Ger_Faixa_2] [float] NULL,
	[Com_Ven_Faixa_2] [float] NULL,
	[Faixa_3] [float] NULL,
	[Com_Rep_Faixa_3] [float] NULL,
	[Com_Ger_Faixa_3] [float] NULL,
	[Com_Ven_Faixa_3] [float] NULL,
	[Faixa_4] [float] NULL,
	[Com_Rep_Faixa_4] [float] NULL,
	[Com_Ger_Faixa_4] [float] NULL,
	[Com_Ven_Faixa_4] [float] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TermosLegais]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TermosLegais](
	[TermoLegal] [int] NULL,
	[Descricao] [varchar](60) NULL,
	[Termo1] [varchar](120) NULL,
	[Termo2] [varchar](120) NULL,
	[Termo3] [varchar](120) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TermosLegaisOperacao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TermosLegaisOperacao](
	[TermoLegal] [int] NULL,
	[ccodoperacao] [varchar](4) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Tipo_Equipamento]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tipo_Equipamento](
	[CCODIGOTIPO] [int] NOT NULL,
	[CDESCRICAOTIPO] [varchar](30) NULL,
 CONSTRAINT [PK_Tipo_Equipamento] PRIMARY KEY CLUSTERED 
(
	[CCODIGOTIPO] 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
/****** Object:  Table [dbo].[TIPOREC_CONDICOES]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TIPOREC_CONDICOES](
	[NCODCONDPAGAMENTO] [int] NULL,
	[COD_REC] [varchar](2) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[TIPOS_ANALISE]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TIPOS_ANALISE](
	[CCODIGOITEM] [varchar](60) NOT NULL,
	[NORDEM] [int] NOT NULL,
	[CDESCRICAO_TESTE] [varchar](80) NULL,
	[CESPECIFICACAO_TESTE] [varchar](120) NULL,
 CONSTRAINT [PK_TIPOS_ANALISE] PRIMARY KEY CLUSTERED 
(
	[CCODIGOITEM] ASC,
	[NORDEM] 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
/****** Object:  Table [dbo].[Tpdespes]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Tpdespes](
	[CODIGOTIP] [varchar](5) NOT NULL,
	[DESCRICAO] [varchar](60) NULL,
	[TIPODESPESA] [varchar](1) NULL,
	[CONTACONTABIL] [int] NULL,
	[RATEARCUSTO] [varchar](1) NULL,
 CONSTRAINT [PK_Tpdespes] PRIMARY KEY CLUSTERED 
(
	[CODIGOTIP] 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
/****** Object:  Table [dbo].[TPRECEITA]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TPRECEITA](
	[CODIGOTIP] [varchar](5) NOT NULL,
	[DESCRICAO] [varchar](30) NULL,
	[TIPORECEITA] [varchar](1) NULL,
	[CCENTROCUSTO] [varchar](5) NULL,
	[CCLASSE] [varchar](1) NULL,
 CONSTRAINT [PK_TpReceita] PRIMARY KEY CLUSTERED 
(
	[CODIGOTIP] 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
/****** Object:  Table [dbo].[TRANSPORTADORAS]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[TRANSPORTADORAS](
	[CCODTRANSPORTADORA] [varchar](14) NOT NULL,
	[CNOME] [varchar](50) NULL,
	[CCGF] [varchar](15) NULL,
	[CENDERECO] [varchar](50) NULL,
	[CBAIRRO] [varchar](25) NULL,
	[CCEP] [varchar](8) NULL,
	[CCIDADE] [varchar](25) NULL,
	[CUF] [varchar](2) NULL,
	[CCONTATO] [varchar](25) NULL,
	[CDDD] [varchar](3) NULL,
	[CFONE] [varchar](8) NULL,
	[CCELULAR] [varchar](9) NULL,
	[CFAX] [varchar](8) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Usuarios]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Usuarios](
	[CMATRICULA] [varchar](6) 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_PEDIDOANALISE] [varchar](1) NULL,
	[CNOTIFICA_PEDIDOSEPARADO] [varchar](1) NULL,
	[CNOTIFICA_PEDIDOAPROVADO] [varchar](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Vendedores]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Vendedores](
	[CODIGO] [int] NOT NULL,
	[NOME] [varchar](45) NULL,
	[ENDERECO] [varchar](45) NULL,
	[CIDADE] [varchar](20) NULL,
	[BAIRRO] [varchar](20) NULL,
	[CEP] [varchar](8) NULL,
	[UF] [varchar](2) NULL,
	[CGC] [varchar](18) NULL,
	[CGF] [varchar](10) NULL,
	[CONTATO] [varchar](40) NULL,
	[DDD] [varchar](3) NULL,
	[FONE] [varchar](20) NULL,
	[FAX] [varchar](20) NULL,
	[CELULAR] [varchar](20) NULL,
	[CXPOSTAL] [varchar](10) NULL,
	[COMISSAO] [float] NULL,
	[AGENCIA] [varchar](6) NULL,
	[BANCO] [varchar](10) NULL,
	[CONTA] [varchar](10) NULL,
	[OBSERVACOES] [text] NULL,
	[CSIGLA] [varchar](3) NULL,
	[NUMERO] [int] NULL,
	[COMPLEMENTO] [varchar](40) NULL,
	[EMAIL] [varchar](120) NULL,
	[nlimitedesconto] [float] NULL,
	[CSITUACAO] [varchar](1) NULL,
 CONSTRAINT [PK_Vendedores] PRIMARY KEY CLUSTERED 
(
	[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] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  View [dbo].[Consulta_Estoque]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Consulta_Estoque]
AS
SELECT     CREFERENCIA, CDESCRICAO, NESTOQUEATUAL, NESTOQUEMINIMO, NESTOQUEMINIMOPRODUZIR,
                          (SELECT     SUM(i.NQTDSEPARADA) AS nSeparando
                            FROM          dbo.ITENSPEDIDOSAIDA AS i INNER JOIN
                                                   dbo.PEDIDOSAIDA AS p ON p.CNUMPEDIDO = i.CNUMPEDIDO
                            WHERE      (p.CSTATUS = '5' OR
                                                   p.CSTATUS = '6') AND (p.CSTATUS_EXPEDICAO = 'S') AND (i.CREFERENCIA = pr.CREFERENCIA)
                            GROUP BY i.CREFERENCIA) AS nSeparando
FROM         dbo.Produtos AS pr

GO
/****** Object:  View [dbo].[Consulta_Estoque_Reserva]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[Consulta_Estoque_Reserva]
AS
SELECT CREFERENCIA, CDESCRICAO + ' ' + CAPRESENTACAO AS cdescricao, NESTOQUEATUAL,
                      (SELECT SUM(i.NQTDRESERVADA) AS nReservada
                       FROM      dbo.ITENSPEDIDOSAIDA AS i INNER JOIN
                                         dbo.PedidoSaida AS p ON p.CNUMPEDIDO = i.CNUMPEDIDO
                       WHERE   (p.CSTATUS <> '9') AND (i.CREFERENCIA = pr.CREFERENCIA)
                       GROUP BY i.CREFERENCIA) AS nReservada
FROM     dbo.Produtos AS pr


GO
/****** Object:  View [dbo].[EstoquePendente]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[EstoquePendente]
AS
SELECT i.CREFERENCIA, SUM(i.NQTDATENDIDA) AS nQtdPendente
FROM     dbo.ITENSPEDIDOSAIDA AS i INNER JOIN
                  dbo.PedidoSaida AS p ON p.CNUMPEDIDO = i.CNUMPEDIDO
WHERE  (p.CSTATUS <> '9')
GROUP BY i.CREFERENCIA


GO
/****** Object:  View [dbo].[Referencia_Corte]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Referencia_Corte]
AS
SELECT     Referencia, SUM(Quantidade) AS QtdCorte
FROM         dbo.Lote_Producao AS producao
WHERE     (Situacao = 'C')
GROUP BY Referencia

GO
/****** Object:  View [dbo].[Referencia_Producao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Referencia_Producao]
AS
SELECT     Referencia, SUM(Quantidade) AS QtdProducao
FROM         dbo.Lote_Producao AS producao
WHERE     (Situacao = 'R')
GROUP BY Referencia

GO
/****** Object:  View [dbo].[Referencia_Produzir]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Referencia_Produzir]
AS
SELECT     Referencia, SUM(Quantidade) AS qtdProduzir
FROM         dbo.Lote_Producao AS Producao
WHERE     (Situacao = 'P')
GROUP BY Referencia

GO
/****** Object:  View [dbo].[Referencia_Revisao]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[Referencia_Revisao]
AS
SELECT     Referencia, SUM(Quantidade) AS qtdRevisao
FROM         dbo.Lote_Producao AS Producao
WHERE     (Situacao = 'A')
GROUP BY Referencia

GO
ALTER TABLE [dbo].[DUPLICATAS]  WITH CHECK ADD  CONSTRAINT [FK_Duplicatas_Clientes] FOREIGN KEY([CCODCLIENTE])
REFERENCES [dbo].[Clientes] ([CCODCLIENTE])
GO
ALTER TABLE [dbo].[DUPLICATAS] CHECK CONSTRAINT [FK_Duplicatas_Clientes]
GO
ALTER TABLE [dbo].[Nf]  WITH CHECK ADD  CONSTRAINT [FK_NF_Clientes] FOREIGN KEY([CCODCLIENTE])
REFERENCES [dbo].[Clientes] ([CCODCLIENTE])
GO
ALTER TABLE [dbo].[Nf] CHECK CONSTRAINT [FK_NF_Clientes]
GO
ALTER TABLE [dbo].[PEDIDOSAIDA]  WITH CHECK ADD  CONSTRAINT [FK_PedidoSaida_Clientes] FOREIGN KEY([CCODCLIENTE])
REFERENCES [dbo].[Clientes] ([CCODCLIENTE])
GO
ALTER TABLE [dbo].[PEDIDOSAIDA] CHECK CONSTRAINT [FK_PedidoSaida_Clientes]
GO
/****** Object:  StoredProcedure [dbo].[SP_AtualizaEstoque]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[SP_AtualizaEstoque](@NCONTROLE int, @CCODPRODUTO varchar(15), @NQTD float, @NPRECO float) AS

 BEGIN
    declare @contador int

	set nocount on

    set @contador = (SELECT count(*) FROM PRODUTOS WHERE CREFERENCIA = @CCODPRODUTO)

    IF @contador > 0 
        UPDATE PRODUTOS SET NESTOQUEATUAL=NESTOQUEATUAL + @NQTD
        WHERE CREFERENCIA = @CCODPRODUTO

 END 
GO
/****** Object:  StoredProcedure [dbo].[SP_AtualizaEstoque_MP]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[SP_AtualizaEstoque_MP](@NCONTROLE int, @CCODPRODUTO varchar(15), @NQTD float, @NPRECO float) AS

 BEGIN
    declare @contador int

	set nocount on

    set @contador = (SELECT count(*) FROM ITENS_ESTOQUE WHERE CODIGO_ITEM = @CCODPRODUTO)

    IF @contador > 0 
        UPDATE ITENS_ESTOQUE SET QTDESTOQUE=QTDESTOQUE + @NQTD
        WHERE CODIGO_ITEM = @CCODPRODUTO

 END 
GO
/****** Object:  StoredProcedure [dbo].[SP_EntradaEstoque]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[SP_EntradaEstoque](@NCONTROLE int, @DDATA datetime,  @CCODPRODUTO varchar(15), @NQTD FLOAT, @NPRECO float, @CHISTORICO varchar(30)) AS
 BEGIN

    set nocount on
    declare @contador int
	declare @estoque float

    set @contador = (SELECT count(*) FROM ESTOQUE_ENTRADA WHERE NCONTROLE = @NCONTROLE)
	set @estoque  = (select NESTOQUEATUAL FROM PRODUTOS WHERE CREFERENCIA = @CCODPRODUTO)

    IF @contador > 0 
        UPDATE ESTOQUE_ENTRADA SET NQTD=@NQTD, NPRECO= @NPRECO, DDATA=@DDATA  WHERE NCONTROLE = @NCONTROLE;
    ELSE
        INSERT INTO ESTOQUE_ENTRADA (NCTRESTOQUE, DDATA, CCODPRODUTO, NESTOQUEANTERIOR, NQTD, NPRECO, CHISTORICO) 
		                     values (@NCONTROLE, @DDATA, @CCODPRODUTO, @estoque, @NQTD, @NPRECO, @CHISTORICO)

 END
GO
/****** Object:  StoredProcedure [dbo].[SP_EntradaEstoque_MP]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[SP_EntradaEstoque_MP](@NCONTROLE int, @DDATA datetime,  @CCODPRODUTO varchar(15), @NQTD FLOAT, @NPRECO float, @CHISTORICO varchar(30)) AS
 BEGIN

    set nocount on
    declare @contador int
    declare @estoque float

    set @contador = (SELECT count(*) FROM ESTOQUE_ENTRADA_MP WHERE NCONTROLE = @NCONTROLE)
    set @estoque  = (select QTDESTOQUE FROM ITENS_ESTOQUE WHERE CODIGO_ITEM = @CCODPRODUTO)

    IF @contador > 0 
        UPDATE ESTOQUE_ENTRADA_MP SET NQTD=@NQTD, NPRECO= @NPRECO, DDATA=@DDATA  WHERE NCONTROLE = @NCONTROLE;
    ELSE
        INSERT INTO ESTOQUE_ENTRADA_MP(NCTRESTOQUE, DDATA, CCODPRODUTO, NESTOQUEANTERIOR, NQTD, NPRECO, CHISTORICO) 
		                     values (@NCONTROLE, @DDATA, @CCODPRODUTO, @estoque, @NQTD, @NPRECO, @CHISTORICO)

 END

GO
/****** Object:  StoredProcedure [dbo].[SP_SaidaEstoque]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROC [dbo].[SP_SaidaEstoque](@NCONTROLE int, @DDATA datetime,  @CCODPRODUTO varchar(15), @NQTD FLOAT, @NPRECO float, @CHISTORICO varchar(30)) AS
 BEGIN
    declare @contador int
	declare @estoque float

	set nocount on

    set @contador = (SELECT count(*) FROM ESTOQUE_SAIDA WHERE NCONTROLE = @NCONTROLE)
	set @estoque  = (select NESTOQUEATUAL FROM PRODUTOS WHERE CREFERENCIA = @CCODPRODUTO)

    IF @contador > 0 
        UPDATE ESTOQUE_SAIDA SET NQTD=@NQTD, NPRECO= @NPRECO, DDATA=@DDATA  WHERE NCONTROLE = @NCONTROLE;
    ELSE
        INSERT INTO ESTOQUE_SAIDA (NCTRESTOQUE, DDATA, CCODPRODUTO, NESTOQUEANTERIOR, NQTD, NPRECO, CHISTORICO) 
		                     values (@NCONTROLE, @DDATA, @CCODPRODUTO, @estoque, @NQTD, @NPRECO, @CHISTORICO)

 END

GO
/****** Object:  StoredProcedure [dbo].[SP_SaidaEstoque_MP]    Script Date: 11/01/2018 18:18:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROC [dbo].[SP_SaidaEstoque_MP](@NCONTROLE int, @DDATA datetime,  @CCODPRODUTO varchar(15), @NQTD FLOAT, @NPRECO float, @CHISTORICO varchar(30)) AS
 BEGIN
    declare @contador int
	declare @estoque float

	set nocount on

    set @contador = (SELECT count(*) FROM ESTOQUE_SAIDA_MP WHERE NCONTROLE = @NCONTROLE)
	set @estoque  = (select QTDESTOQUE FROM ITENS_ESTOQUE WHERE CODIGO_ITEM = @CCODPRODUTO)

    IF @contador > 0 
        UPDATE ESTOQUE_SAIDA_MP SET NQTD=@NQTD, NPRECO= @NPRECO, DDATA=@DDATA  WHERE NCONTROLE = @NCONTROLE;
    ELSE
        INSERT INTO ESTOQUE_SAIDA_MP (NCTRESTOQUE, DDATA, CCODPRODUTO, NESTOQUEANTERIOR, NQTD, NPRECO, CHISTORICO) 
		                     values (@NCONTROLE, @DDATA, @CCODPRODUTO, @estoque, @NQTD, @NPRECO, @CHISTORICO)

 END

GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[41] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "pr"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 272
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Consulta_Estoque'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Consulta_Estoque'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "pr"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 170
               Right = 345
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
      Begin ColumnWidths = 9
         Width = 284
         Width = 1200
         Width = 1200
         Width = 1200
         Width = 1200
         Width = 1200
         Width = 1200
         Width = 1200
         Width = 1200
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 11
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Consulta_Estoque_Reserva'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Consulta_Estoque_Reserva'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "i"
            Begin Extent = 
               Top = 7
               Left = 48
               Bottom = 186
               Right = 331
            End
            DisplayFlags = 280
            TopColumn = 0
         End
         Begin Table = "p"
            Begin Extent = 
               Top = 7
               Left = 379
               Bottom = 186
               Right = 678
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1176
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1356
         SortOrder = 1416
         GroupBy = 1350
         Filter = 1356
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'EstoquePendente'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'EstoquePendente'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "producao"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 248
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Corte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Corte'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "producao"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 248
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Producao'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Producao'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1 [50] 4 [25] 3))"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 0
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Producao"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 248
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Produzir'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Produzir'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPane1', @value=N'[0E232FF0-B466-11cf-A24F-00AA00A3EFFF, 1.00]
Begin DesignProperties = 
   Begin PaneConfigurations = 
      Begin PaneConfiguration = 0
         NumPanes = 4
         Configuration = "(H (1[40] 4[20] 2[20] 3) )"
      End
      Begin PaneConfiguration = 1
         NumPanes = 3
         Configuration = "(H (1[50] 4[25] 3) )"
      End
      Begin PaneConfiguration = 2
         NumPanes = 3
         Configuration = "(H (1 [50] 2 [25] 3))"
      End
      Begin PaneConfiguration = 3
         NumPanes = 3
         Configuration = "(H (4 [30] 2 [40] 3))"
      End
      Begin PaneConfiguration = 4
         NumPanes = 2
         Configuration = "(H (1 [56] 3))"
      End
      Begin PaneConfiguration = 5
         NumPanes = 2
         Configuration = "(H (2 [66] 3))"
      End
      Begin PaneConfiguration = 6
         NumPanes = 2
         Configuration = "(H (4 [50] 3))"
      End
      Begin PaneConfiguration = 7
         NumPanes = 1
         Configuration = "(V (3))"
      End
      Begin PaneConfiguration = 8
         NumPanes = 3
         Configuration = "(H (1[56] 4[18] 2) )"
      End
      Begin PaneConfiguration = 9
         NumPanes = 2
         Configuration = "(H (1 [75] 4))"
      End
      Begin PaneConfiguration = 10
         NumPanes = 2
         Configuration = "(H (1[66] 2) )"
      End
      Begin PaneConfiguration = 11
         NumPanes = 2
         Configuration = "(H (4 [60] 2))"
      End
      Begin PaneConfiguration = 12
         NumPanes = 1
         Configuration = "(H (1) )"
      End
      Begin PaneConfiguration = 13
         NumPanes = 1
         Configuration = "(V (4))"
      End
      Begin PaneConfiguration = 14
         NumPanes = 1
         Configuration = "(V (2))"
      End
      ActivePaneConfig = 1
   End
   Begin DiagramPane = 
      Begin Origin = 
         Top = 0
         Left = 0
      End
      Begin Tables = 
         Begin Table = "Producao"
            Begin Extent = 
               Top = 6
               Left = 38
               Bottom = 125
               Right = 248
            End
            DisplayFlags = 280
            TopColumn = 0
         End
      End
   End
   Begin SQLPane = 
      PaneHidden = 
   End
   Begin DataPane = 
      Begin ParameterDefaults = ""
      End
   End
   Begin CriteriaPane = 
      Begin ColumnWidths = 12
         Column = 1440
         Alias = 900
         Table = 1170
         Output = 720
         Append = 1400
         NewValue = 1170
         SortType = 1350
         SortOrder = 1410
         GroupBy = 1350
         Filter = 1350
         Or = 1350
         Or = 1350
         Or = 1350
      End
   End
End
' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Revisao'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_DiagramPaneCount', @value=1 , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'VIEW',@level1name=N'Referencia_Revisao'
GO
