http://wiki.geosales.com.br:8000/index.php?action=history&feed=atom&title=Scrips_Tabelas_Web_Service_NOVO 2026-06-19T22:54:37Z Histórico de revisões para esta página neste wiki MediaWiki 1.35.0 http://wiki.geosales.com.br:8000/index.php?title=Scrips_Tabelas_Web_Service_NOVO&diff=3223&oldid=prev 2017-03-08T13:39:01Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="pt-BR"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Edição anterior</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Edição das 13h39min de 8 de março de 2017</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l269" >Linha 269:</td> <td colspan="2" class="diff-lineno">Linha 269:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>SET ANSI_PADDING OFF</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>SET ANSI_PADDING OFF</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>GO</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>GO</div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;/pre&gt;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* Adições a Pedido_Softise que foram necessárias para a compilação</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">&lt;pre&gt;</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ALTER TABLE item_pedido_softsite ADD CD_REF_PRODUTO VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ALTER TABLE item_pedido_softsite ADD PR_DESCONTO_PADRAO VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ALTER TABLE item_pedido_softsite ADD PR_DESCONTO_ADICIONAL VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL</ins></div></td></tr> <tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">ALTER TABLE item_pedido_softsite ADD PR_HIERARQUIA_DESCONTO VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&lt;/pre&gt;</div></td></tr> <!-- diff cache key wiki:diff::1.12:old-2356:rev-3223 --> </table>

Anderson http://wiki.geosales.com.br:8000/index.php?title=Scrips_Tabelas_Web_Service_NOVO&diff=2356&oldid=prev 2017-01-27T19:46:37Z

<p>Criou página com &#039;===Esses são os scripts de criação de tabelas necessárias pro web service=== *CLIENTE_APROVACAO_SOFTSITE &lt;pre&gt; USE [EMPRESA] GO /****** Object: Table [dbo].[CLIENTE_APR...&#039;</p> <p><b>Página nova</b></p><div>===Esses são os scripts de criação de tabelas necessárias pro web service===<br /> <br /> *CLIENTE_APROVACAO_SOFTSITE<br /> &lt;pre&gt;<br /> USE [EMPRESA]<br /> GO<br /> <br /> /****** Object: Table [dbo].[CLIENTE_APROVACAO_SOFTSITE] Script Date: 01/27/2017 11:35:33 ******/<br /> SET ANSI_NULLS ON<br /> GO<br /> <br /> SET QUOTED_IDENTIFIER ON<br /> GO<br /> <br /> SET ANSI_PADDING ON<br /> GO<br /> <br /> CREATE TABLE [dbo].[CLIENTE_APROVACAO_SOFTSITE](<br /> [CD_APROVACAO] [bigint] NOT NULL,<br /> [CD_CLIENTE] [bigint] NOT NULL,<br /> [NM_CLIENTE] [varchar](100) NOT NULL,<br /> [NM_FANTASIA] [varchar](100) NULL,<br /> [DS_ENDERECO] [varchar](70) NOT NULL,<br /> [NM_BAIRRO] [varchar](40) NOT NULL,<br /> [NM_CIDADE] [varchar](40) NOT NULL,<br /> [NM_ESTADO] [char](2) NOT NULL,<br /> [NR_TELEFONE] [varchar](30) NULL,<br /> [DT_CADASTRO] [datetime] NOT NULL,<br /> [VR_LIMITE] [decimal](18, 6) NULL,<br /> [DS_OBSERVACAO] [varchar](80) NULL,<br /> [NR_SEQ_ATEND] [int] NULL,<br /> [CD_ROTA] [int] NULL,<br /> [NR_CEP] [varchar](15) NOT NULL,<br /> [CD_VENDEDOR] [int] NOT NULL,<br /> [NR_CNPJ_CPF] [varchar](25) NOT NULL,<br /> [NR_CGF] [varchar](25) NULL,<br /> [NR_FAX] [varchar](30) NULL,<br /> [DS_EMAIL] [varchar](40) NULL,<br /> [DS_CONTATO] [varchar](30) NULL,<br /> [NR_FONE_CONTATO] [varchar](30) NULL,<br /> [DS_ENDERECO_COBRANCA] [varchar](70) NULL,<br /> [NM_BAIRRO_COBRANCA] [varchar](40) NULL,<br /> [NM_CIDADE_COBRANCA] [varchar](40) NULL,<br /> [NM_ESTADO_COBRANCA] [varchar](2) NULL,<br /> [NR_TELEFONE_COBRANCA] [varchar](30) NULL,<br /> [NR_FAX_COBRANCA] [varchar](30) NULL,<br /> [NR_CEP_COBRANCA] [varchar](15) NULL,<br /> [CD_GRUPO] [varchar](4) NULL,<br /> [NR_ENDERECO] [varchar](20) NULL,<br /> [NR_ENDERECO_COMPL] [varchar](20) NULL,<br /> [NR_ENDERECO_COBRANCA] [varchar](20) NULL,<br /> [NR_ENDERECO_COB_COMPL] [varchar](20) NULL,<br /> [CD_CATEGORIA] [int] NULL,<br /> [DT_EXPORTACAO] [datetime] NULL,<br /> [CLIENTE_VINCULADO] [char](1) NULL,<br /> [CD_TIPO_CLIENTE] [int] NULL,<br /> [CD_ORG_VENDA] [varchar](20) NULL,<br /> [CD_REFERENCIA] [int] NULL,<br /> [NR_CNPJ_REFERENCIAS] [varchar](14) NULL,<br /> [NM_REFERENCIA] [varchar](40) NULL,<br /> [DS_ENDERECO_REFERENCIAS] [varchar](70) NULL,<br /> [NM_BAIRRO_REFERENCIAS] [varchar](40) NULL,<br /> [NM_CIDADE_REFERENCIAS] [varchar](40) NULL,<br /> [NM_ESTADO_REFERENCIAS] [varchar](40) NULL,<br /> [NR_TELEFONE_REFERENCIAS] [varchar](30) NULL,<br /> [NR_FAX_REFERENCIAS] [varchar](30) NULL,<br /> [NM_RESPONSAVEL] [varchar](40) NULL,<br /> [DS_FUNCAO_REFERENCIAS] [varchar](30) NULL,<br /> [DT_ULT_COMPRA_REFERENCIAS] [datetime] NULL,<br /> [VR_LIMITE_CREDITO_REFERENCIAS] [decimal](18, 2) NULL,<br /> [VR_MAIOR_COMPRA_REFERENCIAS] [decimal](18, 2) NULL,<br /> [VR_ACUMULADO_COMPRAS_REF] [decimal](18, 2) NULL,<br /> [DS_FORMA_PGTO_REFERENCIAS] [varchar](50) NULL,<br /> [NR_MEDIO_ATRASO_REFERENCIAS] [int] NULL,<br /> [DS_CLASSIFICACAO_CLIENTE_REF] [varchar](50) NULL,<br /> [DS_EMAIL_REFERENCIAS] [varchar](200) NULL,<br /> [FUNCAO_CLIENTE_REFERENCIAS] [varchar](200) NULL,<br /> [DT_NASCIMENTO_REFERENCIAS] [datetime] NULL,<br /> [VR_ACUMULADO_COMPRAS_REFERENCIAS] [decimal](18, 2) NULL,<br /> [DS_CLASSIFICACAO_CLIENTE_REFERENCIAS] [varchar](50) NULL,<br /> [CD_SOCIO] [int] NULL,<br /> [NM_SOCIO] [varchar](40) NULL,<br /> [DT_NASCIMENTO_SOCIO] [datetime] NULL,<br /> [DS_NACIONALIDADE_SOCIO] [varchar](30) NULL,<br /> [ID_ESTADO_CIVIL_SOCIO] [varchar](2) NULL,<br /> [NR_CPF_SOCIO] [varchar](14) NULL,<br /> [DS_EMAIL_SOCIO] [varchar](100) NULL,<br /> [DS_TELEFONE_SOCIO] [varchar](30) NULL,<br /> [DS_CARGO_SOCIO] [varchar](100) NULL,<br /> [CD_VEN__CLI_ROTA_APROVACAO] [bigint] NULL,<br /> [CD_ROTA__CLI_ROTA_APROVACAO] [int] NULL,<br /> [SEQ_ATEND__CLI_ROTA_APROVACAO] [int] NULL,<br /> [CD_IMPORT_CLI] [char](1) NULL,<br /> [CD_NEWCLI] [varchar](21) NULL,<br /> [DT_IMPTCLI] [datetime] NULL,<br /> [CD_S5CONTATO] [varchar](21) NULL,<br /> [CD_LOJCLI] [varchar](2) NULL,<br /> [CD_CLIXREF] [char](1) NULL,<br /> [CD_S5SOCIO] [varchar](21) NULL,<br /> [CD_CLIXSOC] [char](1) NULL,<br /> [NR_SUFRAMA] [varchar](40) NULL,<br /> [CD_GRUPO_CLIENTE] [int] NULL,<br /> [CD_FUNCAO] [int] NULL<br /> ) ON [PRIMARY]<br /> <br /> GO<br /> <br /> SET ANSI_PADDING OFF<br /> GO<br /> &lt;/pre&gt;<br /> <br /> *CLIENTE_CONTA_APROVACAO_SOFTSITE<br /> &lt;pre&gt;<br /> USE [EMPRESA]<br /> GO<br /> <br /> /****** Object: Table [dbo].[CLIENTE_CONTA_APROVACAO_SOFTSITE] Script Date: 01/27/2017 11:37:44 ******/<br /> SET ANSI_NULLS ON<br /> GO<br /> <br /> SET QUOTED_IDENTIFIER ON<br /> GO<br /> <br /> SET ANSI_PADDING ON<br /> GO<br /> <br /> CREATE TABLE [dbo].[CLIENTE_CONTA_APROVACAO_SOFTSITE](<br /> [CD_APROVACAO] [bigint] NOT NULL,<br /> [CD_CLIENTE] [bigint] NOT NULL,<br /> [CD_CONTA] [int] NOT NULL,<br /> [NM_BANCO] [varchar](100) NOT NULL,<br /> [DS_CONTA] [varchar](20) NOT NULL,<br /> [DS_AGENCIA] [varchar](20) NOT NULL,<br /> CONSTRAINT [PK_CLIENTE_CONTA_APROVACAO_SOFTSITE] PRIMARY KEY CLUSTERED <br /> (<br /> [CD_APROVACAO] ASC,<br /> [CD_CLIENTE] ASC,<br /> [CD_CONTA] ASC<br /> )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]<br /> ) ON [PRIMARY]<br /> <br /> GO<br /> <br /> SET ANSI_PADDING OFF<br /> GO<br /> &lt;/pre&gt;<br /> <br /> *CLIENTE_CONTA_SOFTSITE<br /> &lt;pre&gt;<br /> USE [EMPRESA]<br /> GO<br /> <br /> /****** Object: Table [dbo].[ITEM_PEDIDO_SOFTSITE] Script Date: 01/27/2017 11:38:55 ******/<br /> SET ANSI_NULLS ON<br /> GO<br /> <br /> SET QUOTED_IDENTIFIER ON<br /> GO<br /> <br /> SET ANSI_PADDING ON<br /> GO<br /> <br /> CREATE TABLE [dbo].[ITEM_PEDIDO_SOFTSITE](<br /> [CD_PEDIDO_PALM] [bigint] NOT NULL,<br /> [NR_ITEM_PEDIDO] [bigint] NULL,<br /> [CD_PRODUTO] [int] NOT NULL,<br /> [QT_ITEM] [decimal](15, 2) NULL,<br /> [VR_ITEM] [decimal](18, 6) NULL,<br /> [NR_CARACTERISTICA] [int] NULL,<br /> [NR_PRAZO_MEDIO] [int] NULL,<br /> [QT_ITEM_SOLICITADA] [decimal](15, 2) NULL,<br /> [DS_OBS_FATURAMENTO] [varchar](255) NULL,<br /> [PC_DESCONTO] [decimal](18, 6) NULL,<br /> [CD_UNIDADE] [int] NULL,<br /> [CD_MOTIVO] [int] NULL,<br /> [ID_AUTORIZADO] [varchar](1) NULL,<br /> [CD_AUTORIZACAO] [varchar](20) NULL,<br /> [CD_RESPONSAVEL_AUTORIZACAO] [int] NULL,<br /> [CD_PROMOCAO] [int] NULL,<br /> [VR_ITEM_ORIGINAL] [decimal](18, 6) NULL,<br /> [CD_REGRA] [int] NULL,<br /> [VR_FRETE] [decimal](18, 6) NULL,<br /> [CD_PROMO_MISTA] [bigint] NULL,<br /> [ID_BRINDE_PROMO_MISTA] [char](1) NULL,<br /> [CD_PRODUTO_PAI_PROMO_MISTA] [int] NULL,<br /> [PR_DESCONTO_BONIFICACAO] [decimal](18, 2) NULL,<br /> [PR_DESCONTO_COMERCIAL] [decimal](18, 2) NULL,<br /> [PR_DESCONTO_FINANCEIRO] [decimal](18, 2) NULL,<br /> [CD_REF_PRODUTO] [varchar](100) NULL,<br /> [PR_DESCONTO_ADICIONAL] [decimal](18, 6) NULL,<br /> [PR_DESCONTO_PADRAO] [decimal](18, 6) NULL,<br /> [PR_HIERARQUIA_DESCONTO] [decimal](18, 6) NULL<br /> ) ON [PRIMARY]<br /> <br /> GO<br /> <br /> SET ANSI_PADDING OFF<br /> GO<br /> &lt;/pre&gt;<br /> <br /> *PEDIDO_SOFTSITE<br /> &lt;pre&gt;<br /> USE [EMPRESA]<br /> GO<br /> <br /> /****** Object: Table [dbo].[PEDIDO_SOFTSITE] Script Date: 01/27/2017 11:39:25 ******/<br /> SET ANSI_NULLS ON<br /> GO<br /> <br /> SET QUOTED_IDENTIFIER ON<br /> GO<br /> <br /> SET ANSI_PADDING ON<br /> GO<br /> <br /> CREATE TABLE [dbo].[PEDIDO_SOFTSITE](<br /> [CD_PEDIDO_PALM] [bigint] NOT NULL,<br /> [CD_CLIENTE] [bigint] NOT NULL,<br /> [DT_EMISSAO] [datetime] NULL,<br /> [VR_PEDIDO] [decimal](18, 6) NULL,<br /> [CD_ORG_VENDA] [varchar](20) NULL,<br /> [CD_PEDIDO_CLIENTE] [varchar](35) NULL,<br /> [CD_PEDIDO] [varchar](9) NULL,<br /> [CD_COND_PGTO] [int] NULL,<br /> [CD_TIPO_PEDIDO] [varchar](20) NULL,<br /> [DT_ENTREGA] [datetime] NULL,<br /> [CD_MEIO_PGTO] [varchar](15) NULL,<br /> [CD_ST_PEDIDO] [int] NULL,<br /> [ID_PRIORIDADE] [int] NULL,<br /> [CD_VENDEDOR] [int] NOT NULL,<br /> [DT_EXPORTACAO] [datetime] NULL,<br /> [ID_TIPO_FRETE] [char](1) NULL,<br /> [CD_TRANSPORTADORA] [int] NULL,<br /> [DS_OBSERVACAO] [varchar](300) NULL,<br /> [NM_RZ_SOCIAL_ENTR] [varchar](100) NULL,<br /> [DS_ENDERECO_ENTR] [varchar](70) NULL,<br /> [NM_BAIRRO_ENTR] [varchar](40) NULL,<br /> [NM_CIDADE_ENTR] [varchar](40) NULL,<br /> [NM_ESTADO_ENTR] [char](2) NULL,<br /> [NR_CEP_ENTR] [varchar](15) NULL,<br /> [NR_FONE_ENTR] [varchar](30) NULL,<br /> [NR_CNPJ_CPF_ENTR] [varchar](25) NULL,<br /> [NR_CGF_ENTR] [varchar](25) NULL,<br /> [CD_PEDIDO_PALM_PAI] [bigint] NULL,<br /> [ASSINATURA] [image] NULL,<br /> [NM_RESPONSAVEL] [varchar](40) NULL,<br /> [ID_ORCAMENTO] [char](1) NULL,<br /> [IS_PROSPECT] [char](1) NULL,<br /> [CD_JUSTIFICATIVA_ROTA] [int] NULL,<br /> [NR_PARCELAS] [int] NULL,<br /> [ID_AUTORIZADO] [varchar](50) NULL,<br /> [CD_TAB_PRECO] [int] NULL,<br /> [DS_TAB_PRECO] [varchar](70) NULL,<br /> [CD_FRETE] [int] NULL,<br /> [CD_ROTA] [int] NULL,<br /> [DS_OBS_FATURAMENTO] [varchar](255) NULL,<br /> [DT_EXPORTACAO_MANUAL] [datetime] NULL,<br /> [NM_CLIENTE] [varchar](100) NULL,<br /> [VR_BRUTO_PEDIDO] [decimal](18, 6) NULL,<br /> [PC_DESCONTO] [decimal](18, 6) NULL,<br /> [CD_CONTAGEM] [bigint] NULL,<br /> [DT_IMPORTACAO_ERP] [datetime] NULL,<br /> [DS_HORA_ENTREGA] [varchar](15) NULL,<br /> [USUARIO_PEDIDO] [int] NULL<br /> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]<br /> <br /> GO<br /> <br /> SET ANSI_PADDING OFF<br /> GO<br /> &lt;/pre&gt;</div>

Anderson