USE [ShipLinkCentralDB]
GO

/****** Object:  Table [dbo].[SLCShipmentInformation]    Script Date: 1/2/2022 6:57:12 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALter TABLE [dbo].[SLCShipmentInformation]
	Add [TrkIsTrackPeriodExpired] [bit] NOT NULL DEFAULT ((0)),
	[TrkPickupDate]	[datetime] null,
	[ShipmentType] [varchar](10) NULL,
	[SiteId] [INT] NOT NULL DEFAULT ((0))	
GO

ALter TABLE [dbo].[SLCShipmentInformation]
ALTER COLUMN EDILabelType varchar(10)
Go