

CREATE TABLE [dbo].[ApiCourierPackages](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CourierId] [int] NOT NULL,
	[CustId] [int] NOT NULL,
	[CustLocationId] [int] NOT NULL,
	[CustContactPerson] [int] NOT NULL,
	[Direction] [int] NOT NULL,
	[AdressName] [nvarchar](200) NULL,
	[AdressStreet] [nvarchar](100) NULL,
	[AdressCity] [nvarchar](100) NULL,
	[AdressZip] [nvarchar](10) NULL,
		AdressCountry [nvarchar](100) NULL,
	[AdressPhone] [nvarchar](20) NULL,
	[AdressEmail] [nvarchar](50) NULL,
	[AdressTaxid] [nvarchar](50) NULL,
	[AdressPerson] [nvarchar](100) NULL,
	[AdressDescription] [nvarchar](max) NULL,
	[SenderAdressName] [nvarchar](200) NULL,
	[SenderAdressStreet] [nvarchar](100) NULL,
	[SenderAdressCity] [nvarchar](100) NULL,
	[SenderAdressZip] [nvarchar](10) NULL,
	[SenderAdressPhone] [nvarchar](20) NULL,
	[SenderAdressEmail] [nvarchar](50) NULL,
	[SenderAdressPerson] [nvarchar](100) NULL,
	[SenderAdressDescription] [nvarchar](max) NULL,
			SenderAdressCountry [nvarchar](100) NULL,
	[SenderAdressTaxid] [nvarchar](50) NULL,
	[DepartamentId] [int] NOT NULL,
	[WorkerId] [int] NOT NULL,
	[PackageNumber] [nvarchar](100) NULL,
	[OrderId] [nvarchar](100) NULL,
	[RefNumber] [nvarchar](100) NULL,
	[Description] [nvarchar](max) NULL,
	[Parcels] [nvarchar](max) NULL,
	[StatusName] [nvarchar](100) NULL,
	[StatusCourierId] [int] NOT NULL,
	[Status] [int] NOT NULL,
	[CreateTS] [datetime] NULL,
	[SendTS] [datetime] NULL,
	[RecivedTS] [datetime] NULL,
	[PackageListId] [int] NULL,
	[PackageListNumber] [nvarchar](100) NULL,
	[TS] [datetime] NULL,
	[Parms] [nvarchar](max) NULL,
	[ProductType] [nvarchar](100) NULL,
	[ExtraServices] [nvarchar](max) NULL,
 CONSTRAINT [PK_dbo.ApiCourierPackages] PRIMARY KEY CLUSTERED 
(
	[Id] 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


