USE [ShipLinkCentralDB] GO ALTER TABLE dbo.SLCSetting DROP CONSTRAINT [PK_SLCSetting]; Go ALTER TABLE dbo.SLCSetting Alter Column FieldName varchar(500) Go ALTER TABLE dbo.SLCSetting Alter Column FieldValue varchar(500) NULL Go Alter TABLE [dbo].[SLCSetting] Add [Id] [bigint] IDENTITY(1,1) NOT NULL, [FieldValue2] VARCHAR (500) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL default getdate(), [CreatedByPC] [int] NOT NULL default 0, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL default getdate(), [UpdatedByPC] [int] NOT NULL default 0, [UpdatedByUser] [int] NULL; Go ALTER TABLE dbo.SLCSetting ADD CONSTRAINT PK_SLCSetting_Id PRIMARY KEY CLUSTERED (Id); Go ALTER TABLE [FailedAutoShip] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLCEvent] Drop column [CreatedDate] Go ALTER TABLE [SLASN] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLASN] ALTER COLUMN SLCShipmentInformation_Id bigint NULL; Go ALTER TABLE [SLCDocument] ADD CompanyId INT NULL, SiteId BIGINT NULL, PCId INT NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL default getdate(), [CreatedByPC] [int] NOT NULL default 0, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL default getdate(), [UpdatedByPC] [int] NOT NULL default 0, UpdatedByUser INT NULL; Go ALTER TABLE [SLCEmailDetail] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLCEventDocument] ADD CompanyId INT NULL, SiteId BIGINT NULL, PCId INT NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL default getdate(), [CreatedByPC] [int] NOT NULL default 0, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL default getdate(), [UpdatedByPC] [int] NOT NULL default 0, UpdatedByUser INT NULL; Go ALTER TABLE [SLCOutput] ADD CompanyId INT NULL, SiteId BIGINT NULL, PCId INT NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL default getdate(), [CreatedByPC] [int] NOT NULL default 0, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL default getdate(), [UpdatedByPC] [int] NOT NULL default 0, UpdatedByUser INT NULL; Go ALTER TABLE [SLCShipmentByOrder] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLCShipmentInformation] ALTER COLUMN SiteId BIGINT; Go ALTER TABLE [SLCShipmentPackage] ALTER COLUMN SLCShipmentInformation_Id BIGINT NULL; Go ALTER TABLE [SLCShipmentPackage] ADD ShipRequest_Id BIGINT NULL, PackWorkstationIdentifier varchar(100) NULL, PackPCName varchar(50) NULL Go ALTER TABLE [SLInternationalDocumentation] ADD ShipRequest_Id BIGINT NULL, [CertifierName] [varchar](500) NULL, [CertifierAddress] [varchar](500) NULL, [CertifierCity] [varchar](500) NULL, [CertifierState] [varchar](500) NULL, [CertifierPostalCode] [varchar](20) NULL, [CertifierEmail] [varchar](500) NULL, [CertifierTaxId] [varchar](50) NULL Go ALTER TABLE [SLInternationalDocumentation] ALTER COLUMN SLCShipmentInformation_Id bigint NULL; Go ALTER TABLE SLShipFrom ALTER COLUMN SLCShipmentInformation_Id bigint NULL; Go ALTER TABLE [SLInternationalGood] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLInternationalGood] ALTER COLUMN SLCShipmentInformation_Id bigint NULL; Go ALTER TABLE [SLParcel] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLShipFrom] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SLShipmentLTLDetail] ALTER COLUMN ShipRequest_Id BIGINT; Go ALTER TABLE [SLShipTo] ADD ShipRequest_Id BIGINT NULL; Go ALTER TABLE [SystemLog] ADD CreatedByPC INT NOT NULL default 0, PCName VARCHAR (50) NULL; Go /****** Object: Table [dbo].[ShipLinkResource] Script Date: 3/24/2026 12:36:24 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipLinkResource]( [Id] [int] IDENTITY(1,1) NOT NULL, [ResourceName] [varchar](50) NOT NULL, [Type] [varchar](50) NOT NULL, [Description] [varchar](500) NULL, CONSTRAINT [PK_ShipLinkResource] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ShipLinkResourceMapping] Script Date: 3/24/2026 12:36:47 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipLinkResourceMapping]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipLinkResource_Id] [int] NOT NULL, [ShipLinkPC_Id] [int] NOT NULL, [ResourceValue] [varchar](500) NOT NULL, [ConfigFieldName] [varchar](50) NULL, CONSTRAINT [PK_ShipLinkResouceMapping] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[ShipLinkResourceMapping] WITH CHECK ADD CONSTRAINT [FK_ShipLinkResouceMapping_ShipLinkResource] FOREIGN KEY([ShipLinkResource_Id]) REFERENCES [dbo].[ShipLinkResource] ([Id]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ShipLinkResourceMapping] CHECK CONSTRAINT [FK_ShipLinkResouceMapping_ShipLinkResource] GO /****** Object: Table [dbo].[Account] Script Date: 1/21/2026 8:35:44 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Account]( [Id] [int] IDENTITY(1,1) NOT NULL, [CompanyName] [varchar](300) NOT NULL, [AccountNumber] [varchar](9) NOT NULL, [Description] [varchar](1000) NOT NULL, [Carrier] [varchar](15) NOT NULL, [IsCrossBorder] [bit] NOT NULL, [IsShipLinkConsolidation] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_Account] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ApiAccount] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ApiAccount]( [Id] [int] IDENTITY(1,1) NOT NULL, [Carrier] [varchar](50) NULL, [UserId] [varchar](100) NULL, [Password] [varchar](50) NULL, [Mode] [varchar](50) NULL, [Custom1] [varchar](200) NULL, [Custom2] [varchar](200) NULL, [Custom3] [varchar](200) NULL, [Custom4] [varchar](200) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_ApiAccount] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[AutoPickAndShip] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AutoPickAndShip]( [Id] [int] IDENTITY(1,1) NOT NULL, [Description] [varchar](500) NULL, [Weight] [varchar](500) NULL, [Length] [varchar](500) NULL, [Width] [varchar](500) NULL, [Height] [varchar](500) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_AutoPickAndShip] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[AutoShipment] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AutoShipment]( [Id] [int] IDENTITY(1,1) NOT NULL, [FormulaName] [varchar](100) NOT NULL, [NoOfShipments] [int] NULL, [NoOfOrders] [int] NULL, [StartedAt] [datetime] NULL, [EndedAt] [datetime] NULL, [IsRunning] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_AutoShipment] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[AutoShipmentShipRequest] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AutoShipmentShipRequest]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [AutoShipment_Id] [int] NULL, [IsSucceeded] [bit] NOT NULL, [Error] [varchar](5000) NULL, [NoOfOrders] [int] NULL, [OrderIds] [varchar](5000) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_AutoShipmentShipRequest] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Backup] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Backup]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Name] [varchar](50) NOT NULL, [Notes] [varchar](500) NOT NULL, [Version] [varchar](50) NOT NULL, [CreatedDate] [datetime] NOT NULL, [PCId] [int] NULL, CONSTRAINT [PK__Backup__3214EC075A763E59] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[BackupData] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[BackupData]( [Id] [bigint] NOT NULL, [Backup_Id] [bigint] NOT NULL, [TableName] [varchar](500) NOT NULL, [PrimaryKey] [varchar](500) NOT NULL, [FieldName] [varchar](500) NOT NULL, [FieldValue] [varchar](max) NOT NULL, CONSTRAINT [PK_BackupData] PRIMARY KEY CLUSTERED ( [Id] ASC, [Backup_Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[CanadaProvince] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CanadaProvince]( [Id] [int] IDENTITY(1,1) NOT NULL, [ZipStarts] [char](1) NOT NULL, [ProvinceName] [varchar](100) NOT NULL, [ProvinceCode] [varchar](10) NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK_CanadaProvince] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CarrierMatch] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CarrierMatch]( [Id] [int] IDENTITY(1,1) NOT NULL, [CarrierService_Id] [int] NOT NULL, [Package_Id] [int] NOT NULL, [Match] [varchar](100) NOT NULL, [IsOffersSatDelivery] [bit] NULL, [IsOffersSunDelivery] [bit] NULL, [IsEarlyAM] [bit] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK_CarrierMatch] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CarrierService] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CarrierService]( [Id] [int] NOT NULL, [Carrier] [varchar](50) NOT NULL, [ServiceName] [varchar](200) NOT NULL, [ServiceCode] [varchar](200) NULL, [ApiServiceId] [varchar](50) NULL, [ShipmentType] [varchar](50) NULL, [ServiceType] [varchar](50) NULL, [IsEarlyAM] [bit] NOT NULL, [IsOffersSatDelivery] [bit] NOT NULL, [IsOffersSunDelivery] [bit] NOT NULL, [IsCrossBorder] [bit] NOT NULL, [GuaranteedDays] [smallint] NULL, CONSTRAINT [PK_CarrierService] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CarrierVoid] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CarrierVoid]( [Id] [int] IDENTITY(1,1) NOT NULL, [TrackingNumber] [nvarchar](500) NULL, [MasterTrackingNumber] [nvarchar](500) NULL, [IsVoid] [bit] NOT NULL, [IsVoidStr] [varchar](50) NULL, [ShipDate] [varchar](50) NULL, [ParentOrderId] [varchar](50) NULL, [MultiOrderId] [varchar](1000) NULL, [PublishedFreightCharge] [float] NULL, [NegotiatedFreightCharge] [float] NULL, [ParActualWeight] [float] NULL, [IsProcessed] [bit] NOT NULL, [CarrierServiceName] [varchar](100) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK__CarrierV__3214EC078B0BF9D2] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CountryCode] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CountryCode]( [Id] [int] NOT NULL, [CountryName] [varchar](500) NOT NULL, [CountryCodeISO] [varchar](500) NOT NULL, [UPS] [varchar](500) NOT NULL, [FedEx] [varchar](500) NOT NULL, [Banyan] [varchar](500) NOT NULL, [Stamps] [varchar](500) NOT NULL, [Endicia] [varchar](500) NOT NULL, [DHL] [varchar](500) NOT NULL, [Purolator] [varchar](500) NOT NULL, [TNT] [varchar](500) NOT NULL, [ParcelForce] [varchar](500) NOT NULL, [RoyalMail] [varchar](500) NOT NULL, [OnTrac] [varchar](500) NOT NULL, [Speedy] [varchar](500) NOT NULL, [CanadaPost] [varchar](500) NOT NULL, [Yodel] [varchar](500) NOT NULL, [Mercury] [varchar](500) NOT NULL, [DX] [varchar](500) NOT NULL, [IsShipLinkCountry] [bit] NOT NULL, [Currency] [nvarchar](50) NULL, [IsFedExAlt] [bit] NOT NULL, [UOM] [varchar](50) NULL, [Continent1] [varchar](50) NULL, [Continent2] [varchar](50) NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Currency] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Currency]( [Id] [int] IDENTITY(1,1) NOT NULL, [ISOCurrency] [varchar](50) NULL, [ERPCurrency] [varchar](50) NULL, CONSTRAINT [PK__Currency__3214EC0782E8349F] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Customer] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Customer]( [Order_Id] [int] NOT NULL, [CustomerNumber] [varchar](50) NULL, [Name] [varchar](50) NULL, [CustomerType] [varchar](50) NULL, [CustomerClass] [varchar](50) NULL, [Branch] [varchar](50) NULL, [Area] [varchar](50) NULL, [CustomField1] [varchar](50) NULL, [CustomField2] [varchar](50) NULL, [Warehouse] [varchar](50) NULL, [MasterAccount] [varchar](500) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Order_Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[CustomerReporting] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[CustomerReporting]( [Id] [int] IDENTITY(1,1) NOT NULL, [ReportName] [varchar](200) NULL, [Output] [varchar](50) NULL, [Type] [varchar](50) NULL, [ReportPath] [varchar](500) NULL, [DocumentIf] [varchar](200) NULL, [Resource_Id] [int] NULL, [TargetPrinter] [varchar](200) NULL, [TargetFolder] [varchar](500) NULL, [TriggerEvent] [varchar](50) NULL, [OrderMethod] [varchar](50) NULL, [ReportingType] [varchar](50) NULL, [EmailTemplateId] [int] NULL, [NoOfCopies] [int] NULL, [EmailAddress] [varchar](500) NULL, [IsProcessingFormula] [bit] NOT NULL, [ProcessingFormula] [varchar](200) NULL, [IsAllowReprint] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK__Customer__3214EC0768307607] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DocumentParameter] Script Date: 4/4/2026 1:52:01 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DocumentParameter]( [Id] [int] IDENTITY(1,1) NOT NULL, [CustomerReporting_Id] [int] NULL, [ParameterName] [varchar](200) NULL, [ParameterValue] [varchar](200) NULL, [MappedFieldName] [varchar](200) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[EODCustomField] Script Date: 4/4/2026 1:52:01 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO /****** Object: Table [dbo].[EODCustomField] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[EODCustomField]( [Id] [int] IDENTITY(1,1) NOT NULL, [TableName] [varchar](100) NOT NULL, [FieldValue] [varchar](200) NOT NULL, [FieldName] [varchar](100) NOT NULL, [IsShipmentPackage] [bit] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ERPCountryCode] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ERPCountryCode]( [Id] [int] IDENTITY(1,1) NOT NULL, [ERPCountryName] [varchar](200) NOT NULL, [CountryCode_Id] [int] NOT NULL, [IsShiplink] [bit] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_ERPCountryCode] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ERPDataSource] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ERPDataSource]( [Id] [int] IDENTITY(1,1) NOT NULL, [Server] [varchar](500) NOT NULL, [UserId] [varchar](100) NULL, [Password] [varchar](100) NULL, [DatabaseName] [varchar](200) NOT NULL, [Version] [varchar](50) NULL, [IsWindowsAuthentication] [bit] NOT NULL, [IsPrimary] [bit] NOT NULL, [IsFixed] [bit] NOT NULL, [Port] [int] NULL, [ERPCompany] [text] NULL, [DataSourceType] [int] NULL, [ApiHost] [varchar](500) NULL, [AppServer] [varchar](100) NULL, [ApiCompany] [varchar](100) NULL, [ApiKey] [varchar](500) NULL, [ApiUsername] [varchar](500) NULL, [ApiPassword] [varchar](500) NULL, [ApiPlant] [varchar](200) NULL, [Alias] [varchar](200) NULL, [IsRW] [bit] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__ERPDataS__3214EC070C5A3563] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[ERPEntity] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ERPEntity]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NOT NULL, [EntityName] [nvarchar](500) NOT NULL, [EntitySerialized] [ntext] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__ERPEntit__3214EC0728D2080D] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Folder] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Folder]( [Id] [int] NOT NULL, [Name] [varchar](100) NOT NULL, [ParentId] [int] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Formula] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Formula]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NOT NULL, [Description] [varchar](500) NOT NULL, [FormulaText] [varchar](max) NOT NULL, [IsShipLink] [bit] NOT NULL, [DataType] [varchar](50) NOT NULL, [FormulaCategory_Id] [int] NULL, [FormulaType] [varchar](50) NULL, [DetailObjectType] [varchar](50) NULL, [CopiedFormulaType] [varchar](50) NULL, [FormulaOrder] [int] NULL, [DataSourceId] [int] NULL, [ProgramName] [varchar](200) NULL, [FormulaCategoryType] [varchar](100) NULL, [ReturnFormat] [varchar](50) NULL, [IsEnabled] [bit] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NULL, [CreatedByPC] [int] NOT NULL, [UpdatedDate] [datetime] NULL, [CreatedByUser] [int] NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__Formula__3214EC07B02D6595] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[FormulaCategory] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FormulaCategory]( [Id] [int] IDENTITY(1,1) NOT NULL, [CategoryName] [varchar](200) NOT NULL, [Type] [varchar](200) NULL, [IsEvent] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[FormulaDocument] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FormulaDocument]( [Id] [int] IDENTITY(1,1) NOT NULL, [Formula_Id] [int] NULL, [DocumentType] [varchar](100) NULL, [DocumentText] [varchar](max) NULL, [DocumentName] [varchar](200) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__FormulaD__3214EC07A4066995] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[FromAddCarrierAcct] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FromAddCarrierAcct]( [Id] [int] IDENTITY(1,1) NOT NULL, [FromAddress_Id] [int] NOT NULL, [Carrier] [varchar](50) NOT NULL, [FromPayAccount] [varchar](20) NOT NULL, [IsPrimary] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[FromAddress] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[FromAddress]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [Contact] [varchar](500) NULL, [CompanyName] [varchar](200) NULL, [Address1] [varchar](500) NULL, [Address2] [varchar](500) NULL, [City] [varchar](500) NULL, [State] [varchar](500) NULL, [PostalCode] [varchar](20) NULL, [CountryName] [varchar](200) NULL, [TaxId] [varchar](100) NULL, [Phone] [varchar](50) NULL, [Ext] [varchar](10) NULL, [Email] [varchar](500) NULL, [IsPrimary] [bit] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__FromAddr__3214EC07BF7FF07A] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Importer] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Importer]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [CustomerID] [varchar](50) NULL, [Attention] [varchar](100) NULL, [Address1] [varchar](100) NULL, [Address2] [varchar](100) NULL, [Address3] [varchar](100) NULL, [CountryName] [varchar](50) NULL, [City] [varchar](50) NULL, [StateProvinceCounty] [varchar](100) NULL, [PostalCode] [varchar](20) NULL, [Telephone] [varchar](50) NULL, [TaxIdNumber] [varchar](50) NULL, [UPSAccountNumber] [varchar](100) NULL, [CountryCodeIso] [varchar](50) NULL, [State] [varchar](50) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__Importer__3214EC0710C40E3E] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[IndependentThread] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[IndependentThread]( [Id] [int] IDENTITY(1,1) NOT NULL, [FormulaName] [varchar](100) NULL, [StartTime] [varchar](100) NULL, [EndedTime] [varchar](100) NULL, [Interval] [varchar](5) NULL, [IsExcludeWeekend] [bit] NOT NULL, [IntervalInHrsMins] [int] NULL, [IsScheduled] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[InternationalCompliance] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[InternationalCompliance]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [IntCompIDOwner] [varchar](100) NULL, [IntCompCountry] [varchar](200) NULL, [IntCompIDType] [varchar](200) NULL, [IntCompIDNumber] [varchar](200) NULL, [IntCompIDIssuing] [varchar](200) NULL, [IntCompFieldType] [varchar](200) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__Internat__3214EC0773340CBE] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[LogLoadSetting] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LogLoadSetting]( [Id] [int] IDENTITY(1,1) NOT NULL, [PCId] [int] NOT NULL, [LastReadDate] [datetime] NOT NULL, [ConfigMode] [varchar](50) NOT NULL, CONSTRAINT [PK_LogLoadSetting] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[LogUpdateSetting] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LogUpdateSetting]( [SiteOrCompanyId] [bigint] NOT NULL, [ConfigMode] [varchar](128) NOT NULL, [UpdatedDate] [datetime] NOT NULL, CONSTRAINT [PK_LogUpdateSetting_1] PRIMARY KEY CLUSTERED ( [SiteOrCompanyId] ASC, [ConfigMode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[LTLDetail] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[LTLDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NOT NULL, [OrderId] [varchar](50) NOT NULL, [InitLineNumber] [varchar](50) NULL, [PartNumber] [varchar](50) NULL, [ProductClass] [varchar](50) NULL, [PartDesc] [varchar](50) NULL, [OrderQty] [varchar](50) NULL, [ShipQty] [varchar](50) NULL, [ShipClass] [varchar](50) NULL, [ShipNMFC] [varchar](50) NULL, [IsHazardous] [bit] NOT NULL, [HazardousUOM] [varchar](50) NULL, [HazardousCode] [varchar](50) NULL, [HazardousType] [varchar](50) NULL, [IsORMD] [bit] NOT NULL, [HazmatCustom1] [varchar](50) NULL, [HazmatCustom2] [varchar](50) NULL, [ItemDiscPrice] [numeric](18, 2) NULL, [ItemUOM] [varchar](50) NULL, [ItemWeight] [varchar](50) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__LTLDetai__3214EC077DDE23EB] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Order] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Order]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NOT NULL, [TrackingNumber] [nvarchar](500) NULL, [OrderId] [varchar](50) NULL, [SalesOrder] [varchar](50) NULL, [InvoiceNumber] [varchar](50) NULL, [PoNumber1] [varchar](50) NULL, [PoNumber2] [varchar](50) NULL, [JobNumber] [varchar](50) NULL, [OrderStatus] [varchar](50) NULL, [OrderType] [varchar](20) NULL, [OrderComment] [varchar](50) NULL, [OrderMemo1] [varchar](50) NULL, [OrderMemo2] [varchar](50) NULL, [OrderMemo3] [varchar](50) NULL, [ReqShipDate] [datetime] NULL, [OrderDate] [datetime] NULL, [ReqDelDate] [datetime] NULL, [ShipViaCode] [varchar](20) NULL, [AltShipViaCode] [varchar](20) NULL, [ShipViaDesc] [varchar](50) NULL, [OrderShipClass] [varchar](20) NULL, [OrderGLCode] [varchar](20) NULL, [OrderPackagingType] [varchar](20) NULL, [InvoiceTerms] [varchar](20) NULL, [FreightPayTerms] [varchar](50) NULL, [FreightPayAcct] [varchar](20) NULL, [AltFreightPayAcct] [varchar](20) NULL, [FreightChargeTerms] [varchar](20) NULL, [FreightChargeType] [varchar](20) NULL, [FreightCostType] [varchar](20) NULL, [DeliveryTerms] [varchar](20) NULL, [Salesperson] [varchar](2000) NULL, [SalespersonEmail] [varchar](2000) NULL, [Warehouse] [varchar](20) NULL, [WarehouseCode] [varchar](20) NULL, [Branch] [varchar](20) NULL, [Area] [varchar](20) NULL, [Region] [varchar](20) NULL, [IsRateShop] [bit] NOT NULL, [IsCustomerOnHold] [bit] NOT NULL, [IsBackOrder] [bit] NOT NULL, [IsConsolidatedShipmentParent] [bit] NOT NULL, [IsConsolidatedShipmentChild] [bit] NOT NULL, [IsOrderSerialNumberReq] [bit] NOT NULL, [IsOrderLotNumberReq] [bit] NOT NULL, [IsAsnReq] [bit] NOT NULL, [IsResidential] [bit] NOT NULL, [IsTaxFreight] [bit] NOT NULL, [Operator] [varchar](50) NULL, [CustomerNumber] [varchar](50) NULL, [ShipCustomerName] [varchar](50) NULL, [ShipAddress1] [varchar](50) NULL, [ShipAddress2] [varchar](50) NULL, [ShipAddress3] [varchar](50) NULL, [ShipCity] [varchar](50) NULL, [ShipStateProv] [varchar](50) NULL, [ShipPostalCode] [varchar](20) NULL, [ShipCountryName] [varchar](50) NULL, [ShipCountryCodeIso] [varchar](3) NULL, [SoldCustomerName] [varchar](50) NULL, [SoldAddress1] [varchar](50) NULL, [SoldAddress2] [varchar](50) NULL, [SoldAddress3] [varchar](50) NULL, [SoldCity] [varchar](50) NULL, [SoldStateProv] [varchar](50) NULL, [SoldPostalCode] [varchar](20) NULL, [SoldCountryName] [varchar](50) NULL, [SoldCountryCodeIso] [varchar](3) NULL, [Telephone1] [varchar](15) NULL, [Telephone2] [varchar](15) NULL, [TelephoneExt1] [varchar](6) NULL, [TelephoneExt2] [varchar](6) NULL, [Email1] [varchar](50) NULL, [Email2] [varchar](50) NULL, [Email3] [varchar](50) NULL, [Email4] [varchar](50) NULL, [Email5] [varchar](50) NULL, [TaxLoc1] [varchar](50) NULL, [TaxLoc2] [varchar](50) NULL, [TaxLoc3] [varchar](50) NULL, [ExchangeRateCode] [varchar](10) NULL, [ExchangeRatePct] [decimal](18, 2) NULL, [ExchangeRateMulDivFlag] [varchar](3) NULL, [BaseCurrency] [varchar](10) NULL, [OrderCurrency] [varchar](10) NULL, [ShipmentCurrency] [varchar](10) NULL, [OrdTotalGoodsCharge] [decimal](18, 2) NULL, [OrdTotalGoodsCost] [decimal](18, 2) NULL, [OrdTotalInvoiceCharge] [decimal](18, 2) NULL, [OrdAdjTotalGoodsCharge] [decimal](18, 2) NULL, [OrdAdjTotalInvoiceCharge] [decimal](18, 2) NULL, [CreditAmt] [numeric](18, 2) NULL, [DebitAmt] [numeric](18, 2) NULL, [FixedFreightCharge] [numeric](18, 2) NULL, [FixedFreightSurcharge1] [numeric](18, 2) NULL, [FixedFreightSurcharge2] [numeric](18, 2) NULL, [PercentFreightSurcharge1] [numeric](18, 2) NULL, [PercentFreightSurcharge2] [numeric](18, 2) NULL, [IsTaxExempt] [bit] NOT NULL, [TaxIdNumber] [varchar](15) NULL, [OrderCustom1] [varchar](50) NULL, [OrderCustom2] [varchar](50) NULL, [OrderCustom3] [varchar](50) NULL, [OrderCustom4] [varchar](50) NULL, [OrderCustom5] [varchar](50) NULL, [SYS_DiscPct1] [numeric](5, 2) NULL, [SYS_DiscPct2] [numeric](5, 2) NULL, [SYS_DiscPct3] [numeric](5, 2) NULL, [SYS_AltShipAddrFlag] [varchar](1) NULL, [SYS_EntInvoice] [varchar](20) NULL, [SYS_DeliveryNote] [varchar](50) NULL, [SpecialInstructions] [varchar](300) NULL, [SYS_AlternateKey] [varchar](10) NULL, [SYS_GstExemptFlag] [varchar](1) NULL, [SYS_GstExemptORide] [varchar](1) NULL, [SYS_GstExemptNum] [varchar](15) NULL, [SYS_CounterSalesFlag] [varchar](1) NULL, [SYS_MultiShipCode] [varchar](5) NULL, [SYS_WebCreated] [varchar](1) NULL, [SYS_State] [varchar](2) NULL, [SYS_CountyZip] [varchar](5) NULL, [SYS_ExtendedTaxCode] [varchar](3) NULL, [SYS_IsEdiShippingSystemOrder] [bit] NOT NULL, [IsParent] [bit] NOT NULL, [ErpFreightCharge] [float] NOT NULL, [ErpFreightCost] [float] NOT NULL, [CurrencyCode] [nvarchar](50) NOT NULL, [OrderedValue] [decimal](18, 2) NULL, [OrderWeight] [decimal](18, 2) NULL, [OrdGLCode] [nvarchar](50) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__Order__3214EC072C49E8AA] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[OrderDetail] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[OrderDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [Order_Id] [int] NOT NULL, [AltPrice] [varchar](50) NULL, [BackOrderQty] [varchar](50) NULL, [Bin] [varchar](50) NULL, [CaseCode] [varchar](50) NULL, [CaseHeight] [numeric](5, 1) NULL, [CaseLength] [numeric](5, 1) NULL, [CaseWeight] [numeric](5, 1) NULL, [CaseWidth] [numeric](5, 1) NULL, [CusPartNumber] [varchar](50) NULL, [Ecc1] [varchar](50) NULL, [Ecc2] [varchar](50) NULL, [Ecc3] [varchar](50) NULL, [Ecc4] [varchar](50) NULL, [Ecc5] [varchar](50) NULL, [FreightCharge] [varchar](50) NULL, [HazardousCode] [varchar](50) NULL, [HazardousType] [varchar](50) NULL, [HazardousUom] [varchar](50) NULL, [HazmatCustom1] [varchar](50) NULL, [HazmatCustom2] [varchar](50) NULL, [Height] [numeric](5, 1) NULL, [InitLineNumber] [varchar](50) NULL, [IsCase] [bit] NOT NULL, [IsFreightCharge] [bit] NOT NULL, [IsHazardous] [bit] NOT NULL, [IsItemLotNoReq] [bit] NOT NULL, [IsItemSerialNoReq] [bit] NOT NULL, [IsKit] [bit] NOT NULL, [IsMiscCharge] [bit] NOT NULL, [IsServiceCharge] [bit] NOT NULL, [IsTaxable] [bit] NOT NULL, [ItemCost] [varchar](50) NULL, [ItemCustom1] [varchar](50) NULL, [ItemCustom2] [varchar](50) NULL, [ItemCustom3] [varchar](50) NULL, [ItemCustom4] [varchar](50) NULL, [ItemCustom5] [varchar](50) NULL, [ItemDiscPrice] [numeric](8, 2) NULL, [ItemPackagingType] [varchar](50) NULL, [ItemPrice] [numeric](18, 2) NULL, [ItemPriceCode] [varchar](50) NULL, [ItemShipClass] [numeric](5, 1) NULL, [ItemUom] [varchar](50) NULL, [ItemVolume] [varchar](50) NULL, [ItemWeight] [varchar](50) NULL, [KitType] [varchar](50) NULL, [Length] [numeric](4, 2) NULL, [LineNumber] [varchar](50) NULL, [LineType] [varchar](50) NULL, [ManuCountryCode] [varchar](50) NULL, [Nafta1] [varchar](50) NULL, [Nafta2] [varchar](50) NULL, [Nafta3] [varchar](50) NULL, [Nafta4] [varchar](50) NULL, [Nafta5] [varchar](50) NULL, [OrderQty] [varchar](50) NULL, [PartDesc] [varchar](50) NULL, [PartNumber] [varchar](50) NULL, [ProductClass] [varchar](50) NULL, [ShipQty] [varchar](50) NULL, [Sku] [varchar](50) NULL, [SpecialHandlingFlag] [varchar](50) NULL, [SYS_MConvFactOrdUm] [varchar](50) NULL, [SYS_MDiscValFlag] [varchar](50) NULL, [SYS_MDiscValue] [varchar](50) NULL, [SYS_MFstTaxCode] [varchar](50) NULL, [SYS_MItemDisc1] [varchar](50) NULL, [SYS_MItemDisc2] [varchar](50) NULL, [SYS_MItemDisc3] [varchar](50) NULL, [SYS_MMulDivPrcFct] [varchar](50) NULL, [SYS_MPriceUom] [varchar](50) NULL, [SYS_NComment] [varchar](500) NULL, [SYS_NCommentFromLin] [varchar](50) NULL, [SYS_NCommentTextTyp] [varchar](50) NULL, [SYS_NCommentType] [varchar](50) NULL, [TariffCode] [varchar](50) NULL, [TaxCode] [varchar](50) NULL, [TotalLineCost] [numeric](8, 2) NULL, [TotalLineCharge] [numeric](8, 2) NULL, [TraceableFlag] [varchar](50) NULL, [UpcCode] [varchar](50) NULL, [Warehouse] [varchar](50) NULL, [Width] [numeric](5, 1) NULL, [CountryOfOrigin] [varchar](50) NULL, [NMFC] [varchar](50) NULL, [IsHazMat] [bit] NOT NULL, [IsHazMatOrmd] [bit] NOT NULL, [HazMatCode] [varchar](50) NULL, [HazMatDesc] [varchar](50) NULL, [HazMatUom] [varchar](50) NULL, [HazMatQty] [numeric](8, 2) NULL, [FreightClass] [varchar](50) NULL, [IsShipable] [bit] NOT NULL, [AltDesc] [varchar](200) NULL, [IsSerialNumberReq] [bit] NOT NULL, [IsCommodity] [bit] NOT NULL, [BOMFlag] [varchar](1) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__OrderDet__3214EC07DC707CB7] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[P21CloudUserDefinedField] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[P21CloudUserDefinedField]( [Id] [int] IDENTITY(1,1) NOT NULL, [P21CloudField] [varchar](300) NULL, [ShipLinkField] [varchar](300) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Package] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Package]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [PackageName] [varchar](200) NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK_Package] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Parcel_In] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Parcel_In]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [IsCarrierDV] [bit] NOT NULL, [IsCarrierDVStr] [nvarchar](50) NULL, [IsAltDV] [bit] NOT NULL, [IsAltDVStr] [nvarchar](50) NULL, [DvAmount] [float] NULL, [DvAmountOrdCurr] [float] NULL, [IsShipperPayDv] [bit] NOT NULL, [IsShipperPayDvStr] [varchar](50) NULL, [AltDvAmount] [float] NULL, [AltDvCharge] [float] NULL, [Height] [float] NULL, [Width] [float] NULL, [Length] [float] NULL, [PiecesOnPallet] [int] NULL, [ParActualWeight] [float] NULL, [ParRoundedWeight] [float] NULL, [ParDimWeight] [float] NULL, [Reference1] [varchar](50) NULL, [Reference2] [varchar](500) NULL, [Reference3] [varchar](50) NULL, [Reference4] [varchar](50) NULL, [Reference5] [varchar](50) NULL, [IsCod] [bit] NOT NULL, [IsCodStr] [varchar](50) NULL, [CodType] [varchar](6) NULL, [CodAmount] [float] NULL, [CODAmountOrdCurr] [float] NULL, [CodCurrencyCode] [varchar](10) NULL, [IsCheckMoneyOrder] [bit] NOT NULL, [IsCheckMoneyOrderStr] [varchar](50) NULL, [IsAddShippingCharges] [bit] NOT NULL, [IsAddShippingChargesStr] [varchar](50) NULL, [IsVoid] [bit] NOT NULL, [IsVoidStr] [varchar](50) NULL, [ParRefCharge] [float] NULL, [ParPublishedCharge] [float] NULL, [UspsWeight] [float] NULL, [ParNegRatesCharge] [float] NULL, [IsUspsDelConfirmation] [bit] NOT NULL, [IsUspsDelConfirmationStr] [varchar](50) NULL, [UspsDelConfirmationType] [varchar](50) NULL, [ParType] [varchar](50) NULL, [PostalServiceTrackingID] [varchar](50) NULL, [GroundNMFC] [varchar](50) NULL, [GroundSub] [varchar](50) NULL, [GroundFreightClass] [varchar](50) NULL, [ParTotalGoodsCharge] [float] NULL, [ParTotalGoodsCost] [float] NULL, [ParTotalInvoiceCharge] [float] NULL, [ParAdjTotalGoodsCharge] [float] NULL, [ParAdjTotalInvoiceCharge] [float] NULL, [IsDelConfirmSig] [bit] NOT NULL, [IsDelConfirmSigStr] [varchar](50) NULL, [IsDelConfirmNoSig] [bit] NOT NULL, [IsDelConfirmNoSigStr] [varchar](50) NULL, [IsDelConfirmAdultSig] [bit] NOT NULL, [IsDelConfirmAdultSigStr] [varchar](50) NULL, [IsDelConfirmDirectSig] [bit] NOT NULL, [IsDelConfirmDirectSigStr] [varchar](50) NULL, [IsDelConfirmIndirectSig] [bit] NOT NULL, [IsDelConfirmIndirectSigStr] [varchar](50) NULL, [BOL] [nvarchar](500) NULL, [TrackingNumber] [nvarchar](500) NULL, [IsAutoPickAndShip] [bit] NOT NULL, [IsShipperRelease] [bit] NOT NULL, [IsShipperReleaseStr] [varchar](50) NULL, [IsAddHandlingCharges] [bit] NOT NULL, [IsAddHandlingChargesStr] [varchar](50) NULL, [ERPPackageId] [varchar](50) NULL, [ERPShipmentId] [varchar](20) NULL, CONSTRAINT [PK__Parcel_I__3214EC07F75FEDE1] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[PopupMessage] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[PopupMessage]( [Id] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NULL, [ActionFormulaId] [int] NULL, [Sequence] [varchar](200) NULL, [MessageFormulaId] [int] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Profile] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Profile]( [Id] [int] IDENTITY(1,1) NOT NULL, [ProfileName] [varchar](300) NOT NULL, [Description] [varchar](1000) NOT NULL, [Carrier] [varchar](15) NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__Profile__3214EC07D077F613] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[RateShopPackageType] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RateShopPackageType]( [Id] [int] IDENTITY(1,1) NOT NULL, [PackageName] [varchar](100) NOT NULL, [Width] [varchar](100) NULL, [Height] [varchar](100) NULL, [Length] [varchar](100) NULL, [ShortcutKey] [varchar](50) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, [GroupId] [int] NULL, CONSTRAINT [PK_RateShop_Id] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ReportDataSource] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ReportDataSource]( [Id] [int] IDENTITY(1,1) NOT NULL, [CustomerReporting_Id] [int] NULL, [SubReportName] [varchar](100) NULL, [DataSourceId] [int] NULL, [IsMainReport] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ShipLinkClass] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipLinkClass]( [Id] [int] IDENTITY(1,1) NOT NULL, [ClassName] [varchar](100) NOT NULL, [SourceCode] [varchar](max) NOT NULL, [Folder_Id] [int] NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[ShipmentIndicator] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipmentIndicator]( [Id] [int] IDENTITY(1,1) NOT NULL, [Indicator] [varchar](300) NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[ShipmentInformation_In] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipmentInformation_In]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [TrackingNumber] [nvarchar](500) NULL, [ParentOrderId] [varchar](50) NULL, [ParentPoNumber1] [varchar](50) NULL, [ParentPoNumber2] [varchar](50) NULL, [MultiPoNumber1] [varchar](500) NULL, [MultiPoNumber2] [varchar](500) NULL, [MultiOrderId] [varchar](1000) NULL, [ParentCustomerNumber] [varchar](50) NULL, [IsMultiOrder] [bit] NOT NULL, [IsMultiOrderStr] [varchar](50) NULL, [NumberOfParcels] [int] NULL, [LTLPieceQuantity] [int] NULL, [Carrier] [varchar](200) NULL, [ServiceName] [varchar](500) NULL, [ServiceCode] [varchar](50) NULL, [ServiceType] [varchar](50) NULL, [PackagingType] [varchar](50) NULL, [ShipmentCurrency] [varchar](3) NULL, [ShipTotalGoodsCharge] [float] NULL, [ShipTotalGoodsCost] [float] NULL, [ShipTotalInvoiceCharge] [float] NULL, [ShipAdjTotalGoodsCharge] [float] NULL, [ShipAdjTotalInvoiceCharge] [float] NULL, [CarrierShipmentWeightUom] [varchar](50) NULL, [ShipmentWeightUom] [varchar](10) NULL, [ShipRoundedWeight] [float] NULL, [ShipActualWeight] [float] NULL, [ShipDimWeight] [float] NULL, [FreightPayOption] [varchar](20) NULL, [FreightPayTerms] [varchar](20) NULL, [CarrierFreightPayTerms] [varchar](50) NULL, [FreightPayAccount] [varchar](20) NULL, [BillDutyTaxTo] [varchar](20) NULL, [IsSplitDutyTaxTo] [bit] NOT NULL, [IsSplitDutyTaxToStr] [varchar](50) NULL, [IsHandlingCharge] [bit] NOT NULL, [IsHandlingChargeStr] [varchar](50) NULL, [HandlingChargeType] [varchar](20) NULL, [HandlingChargeFlatRate] [float] NULL, [HandlingChargePercentage] [float] NULL, [IsCarrierDv] [bit] NOT NULL, [IsCarrierDvStr] [varchar](50) NULL, [DvAmount] [float] NULL, [DvAmountOrdCurr] [float] NULL, [IsShipperPayDv] [bit] NOT NULL, [IsShipperPayDvStr] [varchar](50) NULL, [IsAltDv] [bit] NOT NULL, [IsAltDvStr] [varchar](50) NULL, [AltDvAmount] [float] NULL, [AltDvCharge] [float] NULL, [IsReturnService] [bit] NOT NULL, [IsReturnServiceStr] [varchar](50) NULL, [ReturnServiceType] [varchar](50) NULL, [ReturnServiceMerchDesc] [varchar](50) NULL, [IsSaturdayDel] [bit] NOT NULL, [IsSaturdayDelStr] [varchar](50) NULL, [IsSaturdayPickup] [bit] NOT NULL, [IsSaturdayPickupStr] [varchar](50) NULL, [IsSundayDel] [bit] NOT NULL, [IsSundayDelStr] [varchar](50) NULL, [IsSundayPickup] [bit] NOT NULL, [IsSundayPickupStr] [varchar](50) NULL, [DescOfGoods] [varchar](50) NULL, [IsDocumentsOnly] [bit] NOT NULL, [IsDocumentsOnlyStr] [varchar](50) NULL, [SpecialInstructionsForShipment] [varchar](500) NULL, [SpecialInstructionsForDelivery] [varchar](500) NULL, [ShipperAccount] [varchar](20) NULL, [ShipperProfile] [varchar](50) NULL, [DelConfirmationOption] [varchar](40) NULL, [IsDelConfirmSig] [bit] NOT NULL, [IsDelConfirmSigStr] [varchar](50) NULL, [IsDelConfirmNoSig] [bit] NOT NULL, [IsDelConfirmNoSigStr] [varchar](50) NULL, [IsDelConfirmAdultSig] [bit] NOT NULL, [IsDelConfirmAdultSigStr] [varchar](50) NULL, [IsDelConfirmDirectSig] [bit] NOT NULL, [IsDelConfirmDirectSigStr] [varchar](50) NULL, [IsDelConfirmIndirectSig] [bit] NOT NULL, [IsDelConfirmIndirectSigStr] [varchar](50) NULL, [Reference1] [varchar](255) NULL, [Reference2] [varchar](255) NULL, [Reference3] [varchar](255) NULL, [Reference4] [varchar](255) NULL, [Reference5] [varchar](255) NULL, [IsCOD] [bit] NOT NULL, [IsCODStr] [varchar](50) NULL, [CODType] [varchar](6) NULL, [CODAmount] [float] NULL, [CODAmountOrdCurr] [float] NULL, [CODCurrencyCode] [varchar](50) NULL, [IsCheckMoneyOrder] [bit] NOT NULL, [IsCheckMoneyOrderStr] [varchar](50) NULL, [IsAddShippingCharges] [bit] NOT NULL, [IsAddShippingChargesStr] [varchar](50) NULL, [IsElecCOD] [bit] NOT NULL, [IsElecCODStr] [varchar](50) NULL, [MerchandiseDes] [varchar](255) NULL, [AdditionalDocuments] [varchar](255) NULL, [MerchandiseDescForPar] [varchar](255) NULL, [IsResidential] [bit] NOT NULL, [IsResidentialStr] [varchar](50) NULL, [ThirdPartyCompany] [nvarchar](500) NULL, [ThirdPartyAddress1] [nvarchar](500) NULL, [ThirdPartyAddress2] [nvarchar](500) NULL, [ThirdPartyCity] [nvarchar](500) NULL, [ThirdPartyState] [nvarchar](500) NULL, [ThirdPartyPostalCode] [nvarchar](500) NULL, [ThirdPartyCountry] [nvarchar](500) NULL, [CurrencyCode] [nvarchar](3) NULL, [ShipmentPublishedCharge] [float] NULL, [ShipmentNegotiatedCharge] [float] NULL, [ShipmentAndHandlingPublishedCharge] [float] NULL, [ShipmentAndHandlingNegotiatedCharge] [float] NULL, [ErpFreightCharge] [float] NULL, [ErpFreightCost] [float] NULL, [BOL] [nvarchar](500) NULL, [LoadID] [nvarchar](200) NULL, [InsuredValueCharge] [float] NULL, [ShipDate] [varchar](50) NULL, [IsVoidIndicator] [bit] NOT NULL, [IsVoidIndicatorStr] [varchar](50) NULL, [IsFreight] [bit] NOT NULL, [IsFreightStr] [varchar](50) NULL, [IsFreeFreight] [bit] NOT NULL, [IsLTL] [bit] NOT NULL, [IsLTLstr] [varchar](50) NULL, [MasterTrackingNumber] [nvarchar](100) NULL, [IsAutoPickAndShip] [bit] NOT NULL, [GoodsExchRate] [float] NULL, [ChargesExchRate] [float] NULL, [OrdCurrency] [varchar](50) NULL, [CarrCurrency] [varchar](50) NULL, [GLCode] [nvarchar](50) NULL, [BaseCurrency] [varchar](5) NULL, [CarrierRatingCurrency] [varchar](5) NULL, [SCAC] [varchar](50) NULL, [CarrierBillDutyTaxTo] [varchar](1) NULL, [TrackingUrl] [text] NULL, [IsCrossBorderConsolidation] [bit] NOT NULL, [IsShipLinkConsolidation] [bit] NOT NULL, [ItemDescription] [varchar](500) NULL, [EmailLabelTo] [varchar](500) NULL, [ExpirationDate] [varchar](50) NULL, [EmailReturnMessage] [varchar](500) NULL, [ThirdPartyPhone] [nvarchar](100) NULL, [ThirdPartyFax] [nvarchar](100) NULL, [ExpDelDate] [varchar](50) NULL, [ExpTranTime] [varchar](50) NULL, [DestinationCountry] [varchar](100) NULL, [DestinationAttention] [varchar](100) NULL, [DestinationCompany] [varchar](100) NULL, [DestinationAddress1] [varchar](100) NULL, [DestinationAddress2] [varchar](100) NULL, [DestinationCity] [varchar](100) NULL, [DestinationStateProvinceCounty] [varchar](100) NULL, [DestinationPostalCode] [varchar](100) NULL, [DestinationTelephone] [varchar](50) NULL, [DestinationTaxIdNumber] [varchar](15) NULL, [EDILabelType] [varchar](50) NULL, [Username] [nvarchar](200) NULL, [TwiddlerId] [varchar](50) NULL, CONSTRAINT [PK_ShipmentInformation_In] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[ShipRequest] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipRequest]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [IsInternational] [bit] NOT NULL, [IsMultiOrder] [bit] NOT NULL, [Carrier] [varchar](100) NULL, [Status] [varchar](50) NULL, [CreatedDate] [datetime] NOT NULL, [NumberOfParcels] [int] NULL, [IsBoxBatchTransaction] [bit] NOT NULL, [IsVoid] [bit] NOT NULL, [IsBulkShipment] [bit] NOT NULL, [BulkShipmentId] [varchar](max) NULL, [BulkShipmentProgram] [varchar](max) NULL, [IsCrossBorder] [bit] NOT NULL, [IsReturnShipment] [bit] NOT NULL, [IsRateShop] [bit] NOT NULL, [SLCShipmentInformationId] [bigint] NULL, [IsAutomatedShipping] [bit] NOT NULL, [IsFedExCrossBorderConsolidation] [bit] NOT NULL, [IsParcelCreation] [bit] NOT NULL, [PCId] [int] NULL CONSTRAINT [PK__ShipRequ__3214EC07E09BDA32] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[ShipTo_In] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ShipTo_In]( [Id] [int] IDENTITY(1,1) NOT NULL, [ShipRequest_Id] [bigint] NULL, [TrackingNumber] [nvarchar](500) NULL, [CustomerNumber] [varchar](50) NULL, [Company] [varchar](50) NULL, [Address1] [varchar](50) NULL, [Address2] [varchar](50) NULL, [Address3] [varchar](50) NULL, [Address4] [varchar](50) NULL, [City] [varchar](50) NULL, [StateProvinceCounty] [varchar](50) NULL, [PostalCode] [varchar](20) NULL, [CountryName] [varchar](50) NULL, [CountryCodeIso] [varchar](3) NULL, [CarrierCountryCode] [varchar](200) NULL, [CountryCalllingCode] [varchar](3) NULL, [Telephone] [varchar](15) NULL, [AirportCode] [varchar](15) NULL, [TaxIdNumber] [varchar](15) NULL, [IsPoBox] [bit] NOT NULL, [IsPOBoxStr] [varchar](50) NULL, [IsResidential] [bit] NOT NULL, [IsResidentialStr] [varchar](20) NULL, [Attention] [varchar](100) NULL, [AddressType] [varchar](200) NULL, CONSTRAINT [PK__ShipTo_I__3214EC071C09E21C] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[TabSetting] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[TabSetting]( [Id] [int] IDENTITY(1,1) NOT NULL, [TabName] [varchar](100) NULL, [IsSelected] [bit] NULL, [LastTabOrScreen] [varchar](100) NULL, [IsMain] [bit] NULL, [PCId] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[UspsRole] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[UspsRole]( [Id] [int] IDENTITY(1,1) NOT NULL, [RoleName] [varchar](50) NULL, [CRID] [varchar](50) NULL, [MID] [varchar](50) NULL, [ManifestMID] [varchar](50) NULL, [AccountType] [varchar](50) NULL, [AccountNumber] [varchar](50) NULL, [IsCRIDFixed] [bit] NOT NULL, [IsMIDFixed] [bit] NOT NULL, [IsManifestMIDFixed] [bit] NOT NULL, [IsAccountNumberFixed] [bit] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, CONSTRAINT [PK__UspsRole__3214EC079C7EDD0B] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[USState] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[USState]( [Id] [int] IDENTITY(1,1) NOT NULL, [StateName] [varchar](100) NOT NULL, [StateCode] [varchar](10) NOT NULL, [ZipStarts] [int] NOT NULL, [ZipEnds] [int] NOT NULL, [CompanyId] [int] NULL, [SiteId] [bigint] NULL, [PCId] [int] NULL, [GroupId] [int] NULL, [CreatedDate] [datetime] NOT NULL, [CreatedByPC] [int] NOT NULL, [CreatedByUser] [int] NULL, [UpdatedDate] [datetime] NOT NULL, [UpdatedByPC] [int] NOT NULL, [UpdatedByUser] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Version] Script Date: 1/21/2026 8:35:46 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Version]( [EntityName] [varchar](50) NOT NULL, [VersionNumber] [int] NOT NULL, PRIMARY KEY CLUSTERED ( [EntityName] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Account] ADD CONSTRAINT [DF__Account__IsCross__1A9EF37A] DEFAULT ((0)) FOR [IsCrossBorder] GO ALTER TABLE [dbo].[Account] ADD CONSTRAINT [DF__Account__IsShipL__1B9317B3] DEFAULT ((0)) FOR [IsShipLinkConsolidation] GO ALTER TABLE [dbo].[Account] ADD CONSTRAINT [DF__Account__Created__395884C4] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Account] ADD CONSTRAINT [DF__Account__Updated__3A4CA8FD] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ApiAccount] ADD CONSTRAINT [DF__ApiAccoun__Creat__3B40CD36] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ApiAccount] ADD CONSTRAINT [DF__ApiAccoun__Updat__3C34F16F] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[AutoPickAndShip] ADD CONSTRAINT [DF__AutoPickA__Creat__3D2915A8] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[AutoPickAndShip] ADD CONSTRAINT [DF__AutoPickA__Updat__3E1D39E1] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[AutoShipment] ADD CONSTRAINT [DF__AutoShipm__IsRun__038683F8] DEFAULT ((0)) FOR [IsRunning] GO ALTER TABLE [dbo].[AutoShipment] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[AutoShipment] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[AutoShipmentShipRequest] ADD CONSTRAINT [DF__AutoShipm__IsSuc__056ECC6A] DEFAULT ((0)) FOR [IsSucceeded] GO ALTER TABLE [dbo].[AutoShipmentShipRequest] ADD CONSTRAINT [DF__AutoShipm__Creat__47A6A41B] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[AutoShipmentShipRequest] ADD CONSTRAINT [DF__AutoShipm__Updat__489AC854] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[CanadaProvince] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[CanadaProvince] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[CarrierMatch] ADD CONSTRAINT [DF__CarrierMa__IsOff__0FEC5ADD] DEFAULT ((0)) FOR [IsOffersSatDelivery] GO ALTER TABLE [dbo].[CarrierMatch] ADD CONSTRAINT [DF__CarrierMa__Creat__47A6A41B] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[CarrierMatch] ADD CONSTRAINT [DF__CarrierMa__Updat__489AC854] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[CarrierService] ADD CONSTRAINT [DF__CarrierSe__Servi__46B27FE2] DEFAULT ((0)) FOR [ServiceType] GO ALTER TABLE [dbo].[CarrierService] ADD CONSTRAINT [DF__CarrierSe__IsEar__47A6A41B] DEFAULT ((0)) FOR [IsEarlyAM] GO ALTER TABLE [dbo].[CarrierService] ADD CONSTRAINT [DF__CarrierSe__IsOff__489AC854] DEFAULT ((0)) FOR [IsOffersSatDelivery] GO ALTER TABLE [dbo].[CarrierService] ADD CONSTRAINT [DF__CarrierSe__IsOff__498EEC8D] DEFAULT ((0)) FOR [IsOffersSunDelivery] GO ALTER TABLE [dbo].[CarrierService] ADD CONSTRAINT [DF__CarrierSe__IsCro__4A8310C6] DEFAULT ((0)) FOR [IsCrossBorder] GO ALTER TABLE [dbo].[CarrierVoid] ADD CONSTRAINT [DF__CarrierVo__IsVoi__2116E6DF] DEFAULT ((0)) FOR [IsVoid] GO ALTER TABLE [dbo].[CarrierVoid] ADD CONSTRAINT [DF__CarrierVo__IsPro__220B0B18] DEFAULT ((0)) FOR [IsProcessed] GO ALTER TABLE [dbo].[CarrierVoid] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[CarrierVoid] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[CountryCode] ADD DEFAULT ((0)) FOR [IsShipLinkCountry] GO ALTER TABLE [dbo].[CountryCode] ADD DEFAULT ((0)) FOR [IsFedExAlt] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Customer] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[CustomerReporting] ADD DEFAULT ((1)) FOR [NoOfCopies] GO ALTER TABLE [dbo].[CustomerReporting] ADD DEFAULT ((0)) FOR [IsProcessingFormula] GO ALTER TABLE [dbo].[CustomerReporting] ADD DEFAULT ((0)) FOR [IsAllowReprint] GO ALTER TABLE [dbo].[CustomerReporting] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[CustomerReporting] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[DocumentParameter] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[DocumentParameter] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[EODCustomField] ADD DEFAULT ((0)) FOR [IsShipmentPackage] GO ALTER TABLE [dbo].[EODCustomField] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[EODCustomField] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ERPCountryCode] ADD CONSTRAINT [DF__ERPCountr__Creat__69FBBC1F] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ERPCountryCode] ADD CONSTRAINT [DF__ERPCountr__Updat__6AEFE058] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ERPDataSource] ADD CONSTRAINT [DF__ERPDataSo__IsFix__6BE40491] DEFAULT ((0)) FOR [IsFixed] GO ALTER TABLE [dbo].[ERPDataSource] ADD CONSTRAINT [DF__ERPDataSou__IsRW__6CD828CA] DEFAULT ((0)) FOR [IsRW] GO ALTER TABLE [dbo].[ERPDataSource] ADD CONSTRAINT [DF__ERPDataSo__Creat__6DCC4D03] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ERPDataSource] ADD CONSTRAINT [DF__ERPDataSo__Updat__6EC0713C] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ERPEntity] ADD CONSTRAINT [DF__ERPEntity__Creat__7C1A6C5A] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ERPEntity] ADD CONSTRAINT [DF__ERPEntity__Updat__7D0E9093] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Folder] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Folder] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Formula] ADD CONSTRAINT [DF__Formula__IsEnabl__756D6ECB] DEFAULT ((0)) FOR [IsEnabled] GO ALTER TABLE [dbo].[FormulaCategory] ADD DEFAULT ((0)) FOR [IsEvent] GO ALTER TABLE [dbo].[FormulaCategory] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[FormulaCategory] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[FormulaDocument] ADD CONSTRAINT [DF__FormulaDo__Creat__7B264821] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[FormulaDocument] ADD CONSTRAINT [DF__FormulaDo__Updat__7C1A6C5A] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[FromAddCarrierAcct] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[FromAddCarrierAcct] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[FromAddress] ADD CONSTRAINT [DF__FromAddre__Creat__0B5CAFEA] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[FromAddress] ADD CONSTRAINT [DF__FromAddre__Updat__0C50D423] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Importer] ADD CONSTRAINT [DF__Importer__Create__0D44F85C] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Importer] ADD CONSTRAINT [DF__Importer__Update__0E391C95] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[IndependentThread] ADD DEFAULT ((0)) FOR [IsExcludeWeekend] GO ALTER TABLE [dbo].[IndependentThread] ADD DEFAULT ((0)) FOR [IsScheduled] GO ALTER TABLE [dbo].[IndependentThread] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[IndependentThread] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[InternationalCompliance] ADD CONSTRAINT [DF__Internati__Creat__12FDD1B2] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[InternationalCompliance] ADD CONSTRAINT [DF__Internati__Updat__13F1F5EB] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[LTLDetail] ADD CONSTRAINT [DF__LTLDetail__IsHaz__14E61A24] DEFAULT ((0)) FOR [IsHazardous] GO ALTER TABLE [dbo].[LTLDetail] ADD CONSTRAINT [DF__LTLDetail__IsORM__15DA3E5D] DEFAULT ((0)) FOR [IsORMD] GO ALTER TABLE [dbo].[LTLDetail] ADD CONSTRAINT [DF__LTLDetail__Creat__16CE6296] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[LTLDetail] ADD CONSTRAINT [DF__LTLDetail__Updat__17C286CF] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsRateSho__18B6AB08] DEFAULT ((0)) FOR [IsRateShop] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsCustome__19AACF41] DEFAULT ((0)) FOR [IsCustomerOnHold] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsBackOrd__1A9EF37A] DEFAULT ((0)) FOR [IsBackOrder] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsConsoli__1B9317B3] DEFAULT ((0)) FOR [IsConsolidatedShipmentParent] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsConsoli__1C873BEC] DEFAULT ((0)) FOR [IsConsolidatedShipmentChild] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsOrderSe__1D7B6025] DEFAULT ((0)) FOR [IsOrderSerialNumberReq] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsOrderLo__1E6F845E] DEFAULT ((0)) FOR [IsOrderLotNumberReq] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsAsnReq__1F63A897] DEFAULT ((0)) FOR [IsAsnReq] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsResiden__2057CCD0] DEFAULT ((0)) FOR [IsResidential] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsTaxFrei__214BF109] DEFAULT ((0)) FOR [IsTaxFreight] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsTaxExem__22401542] DEFAULT ((0)) FOR [IsTaxExempt] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__SYS_IsEdi__2334397B] DEFAULT ((0)) FOR [SYS_IsEdiShippingSystemOrder] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__IsParent__24285DB4] DEFAULT ((0)) FOR [IsParent] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__CreatedAt__251C81ED] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Order] ADD CONSTRAINT [DF__Order__UpdatedAt__2610A626] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsCas__2704CA5F] DEFAULT ((0)) FOR [IsCase] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsFre__27F8EE98] DEFAULT ((0)) FOR [IsFreightCharge] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsHaz__28ED12D1] DEFAULT ((0)) FOR [IsHazardous] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsIte__29E1370A] DEFAULT ((0)) FOR [IsItemLotNoReq] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsIte__2AD55B43] DEFAULT ((0)) FOR [IsItemSerialNoReq] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsKit__2BC97F7C] DEFAULT ((0)) FOR [IsKit] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsMis__2CBDA3B5] DEFAULT ((0)) FOR [IsMiscCharge] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsSer__2DB1C7EE] DEFAULT ((0)) FOR [IsServiceCharge] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsTax__2EA5EC27] DEFAULT ((0)) FOR [IsTaxable] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsHaz__2F9A1060] DEFAULT ((0)) FOR [IsHazMat] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsHaz__308E3499] DEFAULT ((0)) FOR [IsHazMatOrmd] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsShi__318258D2] DEFAULT ((0)) FOR [IsShipable] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsSer__32767D0B] DEFAULT ((0)) FOR [IsSerialNumberReq] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__IsCom__336AA144] DEFAULT ((1)) FOR [IsCommodity] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__Creat__345EC57D] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[OrderDetail] ADD CONSTRAINT [DF__OrderDeta__Updat__3552E9B6] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[P21CloudUserDefinedField] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[P21CloudUserDefinedField] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Package] ADD CONSTRAINT [DF__Package__Created__382F5661] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Package] ADD CONSTRAINT [DF__Package__Updated__39237A9A] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsCar__3A179ED3] DEFAULT ((0)) FOR [IsCarrierDV] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsAlt__3B0BC30C] DEFAULT ((0)) FOR [IsAltDV] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsShi__3BFFE745] DEFAULT ((0)) FOR [IsShipperPayDv] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsShi__3CF40B7E] DEFAULT ((0)) FOR [IsShipperPayDvStr] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsCod__3DE82FB7] DEFAULT ((0)) FOR [IsCod] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsChe__3EDC53F0] DEFAULT ((0)) FOR [IsCheckMoneyOrder] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsAdd__3FD07829] DEFAULT ((0)) FOR [IsAddShippingCharges] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsVoi__40C49C62] DEFAULT ((0)) FOR [IsVoid] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsVoi__41B8C09B] DEFAULT ((0)) FOR [IsVoidStr] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsUsp__42ACE4D4] DEFAULT ((0)) FOR [IsUspsDelConfirmation] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsUsp__43A1090D] DEFAULT ((0)) FOR [IsUspsDelConfirmationStr] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsDel__44952D46] DEFAULT ((0)) FOR [IsDelConfirmSig] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsDel__4589517F] DEFAULT ((0)) FOR [IsDelConfirmNoSig] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsDel__467D75B8] DEFAULT ((0)) FOR [IsDelConfirmAdultSig] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsDel__477199F1] DEFAULT ((0)) FOR [IsDelConfirmDirectSig] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsDel__4865BE2A] DEFAULT ((0)) FOR [IsDelConfirmIndirectSig] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsAut__4959E263] DEFAULT ((0)) FOR [IsAutoPickAndShip] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsShi__4A4E069C] DEFAULT ((0)) FOR [IsShipperRelease] GO ALTER TABLE [dbo].[Parcel_In] ADD CONSTRAINT [DF__Parcel_In__IsAdd__4B422AD5] DEFAULT ((0)) FOR [IsAddHandlingCharges] GO ALTER TABLE [dbo].[PopupMessage] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[PopupMessage] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Profile] ADD CONSTRAINT [DF__Profile__Created__43A1090D] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[Profile] ADD CONSTRAINT [DF__Profile__Updated__44952D46] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[RateShopPackageType] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[RateShopPackageType] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ReportDataSource] ADD DEFAULT ((0)) FOR [IsMainReport] GO ALTER TABLE [dbo].[ReportDataSource] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ReportDataSource] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ShipLinkClass] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ShipLinkClass] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ShipmentIndicator] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[ShipmentIndicator] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsMul__5A846E65] DEFAULT ((0)) FOR [IsMultiOrder] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsMul__5B78929E] DEFAULT ((0)) FOR [IsMultiOrderStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__Numbe__5C6CB6D7] DEFAULT ((0)) FOR [NumberOfParcels] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSpl__5D60DB10] DEFAULT ((0)) FOR [IsSplitDutyTaxTo] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSpl__5E54FF49] DEFAULT ((0)) FOR [IsSplitDutyTaxToStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsHan__5F492382] DEFAULT ((0)) FOR [IsHandlingCharge] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsHan__603D47BB] DEFAULT ((0)) FOR [IsHandlingChargeStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsCar__61316BF4] DEFAULT ((0)) FOR [IsCarrierDv] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsCar__6225902D] DEFAULT ((0)) FOR [IsCarrierDvStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsShi__6319B466] DEFAULT ((0)) FOR [IsShipperPayDv] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsShi__640DD89F] DEFAULT ((0)) FOR [IsShipperPayDvStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsAlt__6501FCD8] DEFAULT ((0)) FOR [IsAltDv] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsAlt__65F62111] DEFAULT ((0)) FOR [IsAltDvStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsRet__66EA454A] DEFAULT ((0)) FOR [IsReturnService] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsRet__67DE6983] DEFAULT ((0)) FOR [IsReturnServiceStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSat__68D28DBC] DEFAULT ((0)) FOR [IsSaturdayDel] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSat__69C6B1F5] DEFAULT ((0)) FOR [IsSaturdayDelStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSat__6ABAD62E] DEFAULT ((0)) FOR [IsSaturdayPickup] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSat__6BAEFA67] DEFAULT ((0)) FOR [IsSaturdayPickupStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSun__6CA31EA0] DEFAULT ((0)) FOR [IsSundayDel] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSun__6D9742D9] DEFAULT ((0)) FOR [IsSundayDelStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSun__6E8B6712] DEFAULT ((0)) FOR [IsSundayPickup] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsSun__6F7F8B4B] DEFAULT ((0)) FOR [IsSundayPickupStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDoc__7073AF84] DEFAULT ((0)) FOR [IsDocumentsOnly] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDoc__7167D3BD] DEFAULT ((0)) FOR [IsDocumentsOnlyStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDel__725BF7F6] DEFAULT ((0)) FOR [IsDelConfirmSig] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDel__73501C2F] DEFAULT ((0)) FOR [IsDelConfirmNoSig] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDel__74444068] DEFAULT ((0)) FOR [IsDelConfirmAdultSig] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDel__753864A1] DEFAULT ((0)) FOR [IsDelConfirmDirectSig] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsDel__762C88DA] DEFAULT ((0)) FOR [IsDelConfirmIndirectSig] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsCOD__7720AD13] DEFAULT ((0)) FOR [IsCOD] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsChe__7814D14C] DEFAULT ((0)) FOR [IsCheckMoneyOrder] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsAdd__7908F585] DEFAULT ((0)) FOR [IsAddShippingCharges] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsEle__79FD19BE] DEFAULT ((0)) FOR [IsElecCOD] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsRes__7AF13DF7] DEFAULT ((0)) FOR [IsResidential] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsRes__7BE56230] DEFAULT ((0)) FOR [IsResidentialStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsVoi__7CD98669] DEFAULT ((0)) FOR [IsVoidIndicator] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsFre__7DCDAAA2] DEFAULT ((0)) FOR [IsFreight] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsFre__7EC1CEDB] DEFAULT ((0)) FOR [IsFreightStr] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsFre__7FB5F314] DEFAULT ((0)) FOR [IsFreeFreight] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsLTL__00AA174D] DEFAULT ((0)) FOR [IsLTL] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsAut__019E3B86] DEFAULT ((0)) FOR [IsAutoPickAndShip] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsCro__02925FBF] DEFAULT ((0)) FOR [IsCrossBorderConsolidation] GO ALTER TABLE [dbo].[ShipmentInformation_In] ADD CONSTRAINT [DF__ShipmentI__IsShi__038683F8] DEFAULT ((0)) FOR [IsShipLinkConsolidation] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsInt__0662F0A3] DEFAULT ((0)) FOR [IsInternational] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsMul__075714DC] DEFAULT ((0)) FOR [IsMultiOrder] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__Numbe__084B3915] DEFAULT ((0)) FOR [NumberOfParcels] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsBox__093F5D4E] DEFAULT ((0)) FOR [IsBoxBatchTransaction] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsVoi__0A338187] DEFAULT ((0)) FOR [IsVoid] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsBul__0B27A5C0] DEFAULT ((0)) FOR [IsBulkShipment] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__BulkS__0C1BC9F9] DEFAULT ((0)) FOR [BulkShipmentId] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsCro__0D0FEE32] DEFAULT ((0)) FOR [IsCrossBorder] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsRet__0E04126B] DEFAULT ((0)) FOR [IsReturnShipment] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsRat__0EF836A4] DEFAULT ((0)) FOR [IsRateShop] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsAut__0FEC5ADD] DEFAULT ((0)) FOR [IsAutomatedShipping] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsFed__10E07F16] DEFAULT ((0)) FOR [IsFedExCrossBorderConsolidation] GO ALTER TABLE [dbo].[ShipRequest] ADD CONSTRAINT [DF__ShipReque__IsPar__11D4A34F] DEFAULT ((0)) FOR [IsParcelCreation] GO ALTER TABLE [dbo].[ShipTo_In] ADD CONSTRAINT [DF__ShipTo_In__IsPoB__14B10FFA] DEFAULT ((0)) FOR [IsPoBox] GO ALTER TABLE [dbo].[ShipTo_In] ADD CONSTRAINT [DF__ShipTo_In__IsRes__15A53433] DEFAULT ((0)) FOR [IsResidential] GO ALTER TABLE [dbo].[UspsRole] ADD CONSTRAINT [DF__UspsRole__IsCRID__72E607DB] DEFAULT ((1)) FOR [IsCRIDFixed] GO ALTER TABLE [dbo].[UspsRole] ADD CONSTRAINT [DF__UspsRole__IsMIDF__73DA2C14] DEFAULT ((1)) FOR [IsMIDFixed] GO ALTER TABLE [dbo].[UspsRole] ADD CONSTRAINT [DF__UspsRole__IsMani__74CE504D] DEFAULT ((1)) FOR [IsManifestMIDFixed] GO ALTER TABLE [dbo].[UspsRole] ADD CONSTRAINT [DF__UspsRole__IsAcco__75C27486] DEFAULT ((1)) FOR [IsAccountNumberFixed] GO ALTER TABLE [dbo].[UspsRole] ADD CONSTRAINT [DF_UspsRole_CreatedAt] DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[UspsRole] ADD CONSTRAINT [DF_UspsRole_UpdatedAt] DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[USState] ADD DEFAULT (getdate()) FOR [CreatedDate] GO ALTER TABLE [dbo].[USState] ADD DEFAULT (getdate()) FOR [UpdatedDate] GO ALTER TABLE [dbo].[Customer] WITH CHECK ADD CONSTRAINT [FK_Customer_Order] FOREIGN KEY([Order_Id]) REFERENCES [dbo].[Order] ([Id]) GO ALTER TABLE [dbo].[Customer] CHECK CONSTRAINT [FK_Customer_Order] GO ALTER TABLE [dbo].[ERPCountryCode] WITH CHECK ADD CONSTRAINT [FK_ERPCountryCode_CountryCode] FOREIGN KEY([CountryCode_Id]) REFERENCES [dbo].[CountryCode] ([Id]) GO ALTER TABLE [dbo].[ERPCountryCode] CHECK CONSTRAINT [FK_ERPCountryCode_CountryCode] GO ALTER TABLE [dbo].[Formula] WITH CHECK ADD CONSTRAINT [FK_Formula_FormulaCategory] FOREIGN KEY([FormulaCategory_Id]) REFERENCES [dbo].[FormulaCategory] ([Id]) GO ALTER TABLE [dbo].[Formula] CHECK CONSTRAINT [FK_Formula_FormulaCategory] GO ALTER TABLE [dbo].[FormulaDocument] WITH CHECK ADD CONSTRAINT [FK_FormulaDocument_Formula] FOREIGN KEY([Formula_Id]) REFERENCES [dbo].[Formula] ([Id]) GO ALTER TABLE [dbo].[FormulaDocument] CHECK CONSTRAINT [FK_FormulaDocument_Formula] GO ALTER TABLE [dbo].[FromAddCarrierAcct] WITH CHECK ADD CONSTRAINT [FK_FromAddCarrierAcct_FromAddress] FOREIGN KEY([FromAddress_Id]) REFERENCES [dbo].[FromAddress] ([Id]) GO ALTER TABLE [dbo].[FromAddCarrierAcct] CHECK CONSTRAINT [FK_FromAddCarrierAcct_FromAddress] GO ALTER TABLE [dbo].[Order] WITH CHECK ADD CONSTRAINT [FK_Order_ShipRequest] FOREIGN KEY([ShipRequest_Id]) REFERENCES [dbo].[ShipRequest] ([Id]) GO ALTER TABLE [dbo].[Order] CHECK CONSTRAINT [FK_Order_ShipRequest] GO ALTER TABLE [dbo].[OrderDetail] WITH CHECK ADD CONSTRAINT [FK_OrderDetail_Order] FOREIGN KEY([Order_Id]) REFERENCES [dbo].[Order] ([Id]) GO ALTER TABLE [dbo].[OrderDetail] CHECK CONSTRAINT [FK_OrderDetail_Order] GO ALTER TABLE [dbo].[PopupMessage] WITH CHECK ADD CONSTRAINT [FK_PopupMessage_Formula] FOREIGN KEY([ActionFormulaId]) REFERENCES [dbo].[Formula] ([Id]) GO ALTER TABLE [dbo].[PopupMessage] CHECK CONSTRAINT [FK_PopupMessage_Formula] GO ALTER TABLE [dbo].[PopupMessage] WITH CHECK ADD CONSTRAINT [FK_PopupMessage_Formula1] FOREIGN KEY([MessageFormulaId]) REFERENCES [dbo].[Formula] ([Id]) GO ALTER TABLE [dbo].[PopupMessage] CHECK CONSTRAINT [FK_PopupMessage_Formula1] GO