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