Les paso la estructura en sql
Código SQL
[-]
USE [Textil]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Guia](
[Id_Guia] [int] NOT NULL,
[Id_Cliente] [int] NULL,
[Id_ClienteTerceroTransporte] [int] NULL,
[Id_ClienteTerceroProveedor] [int] NULL,
[Id_Venta] [int] NULL,
[Id_Pedido] [int] NULL,
[Id_Parametro_TipoDoc] [int] NULL,
[Id_Parametro_Motivo] [int] NULL,
[NumeroDoc] [varchar](20) NULL,
[Serie] [varchar](6) NULL,
[Numero] [int] NULL,
[Fecha] [date] NULL,
[Destinatario] [varchar](100) NULL,
[Direccion] [varchar](100) NULL,
[DomicilioDestino] [varchar](100) NULL,
[DomicilioPartida] [varchar](100) NULL,
[Marca] [varchar](20) NULL,
[Placa] [varchar](10) NULL,
[Otros] [varchar](100) NULL,
[OrdenCompra] [varchar](50) NULL,
[Observaciones] [varchar](50) NULL,
[Cliente] [bit] NULL,
[Facturado] [bit] NULL,
[Id_Usuario] [int] NULL,
[FRegistro] [date] NULL,
CONSTRAINT [PK_Guia] PRIMARY KEY CLUSTERED
(
[Id_Guia] 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