CREATE TABLE [dbo].[SHExportModulePSNVendors]
(
[VendorID] [int] NOT NULL,
[VendorName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AccountNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SendCredentials] [bit] NOT NULL CONSTRAINT [DF_SHExportModulePSNVendors_SendCredentials] DEFAULT ((0)),
[UserAccount] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserPassword] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AllowBackorders] [bit] NOT NULL CONSTRAINT [DF_SHExportModulePSNVendors_AllowBackorders] DEFAULT ((0)),
[AllowPartialShipments] [bit] NOT NULL CONSTRAINT [DF_SHExportModulePSNVendors_AllowPartialShipments] DEFAULT ((1)),
[DefaultFacilityID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriceCheckFacilityIDs] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RequestTimeoutSeconds] [int] NOT NULL,
[PollingIntervalSeconds] [int] NOT NULL,
[ShortPollingPeriodSeconds] [int] NOT NULL,
[LongPollingPeriodSeconds] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNVendors] ADD CONSTRAINT [PK_SHExportModulePSNVendors_VendorID] PRIMARY KEY CLUSTERED ([VendorID]) ON [PRIMARY]
GO