CREATE TABLE [dbo].[SOFulfills]
(
[FulfillID] [int] NOT NULL,
[FulfillNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[Period] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SOID] [int] NULL,
[SalesRepID] [int] NULL,
[ShipMethodID] [int] NULL,
[PicketID] [int] NULL,
[JobID] [int] NULL,
[TransactionTypeID] [int] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SOFulfills_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOFulfills_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[ShipmentNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfills_ShipmentNotes] DEFAULT (''),
[BranchID] [int] NOT NULL,
[CustomerID] [int] NOT NULL,
[ShipToID] [int] NULL,
[InvoiceID] [int] NULL,
[SONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfills_SONumber] DEFAULT (''),
[Void] [bit] NOT NULL CONSTRAINT [DF_SOFulfills_Void] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SOFulFills_NoteFlag] DEFAULT ((0)),
[BaseTypeID] [int] NOT NULL CONSTRAINT [DF_SOFulfills_BaseTypeID] DEFAULT ((1)),
[OutCostNotes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfills_OutCostNotes] DEFAULT (''),
[WarehouseID] [int] NULL,
[DeptID] [int] NULL,
[BillToID] [int] NULL,
[VoidID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SOFulfills_NoteCount] DEFAULT ((0)),
[SendShippingNotifications] [bit] NOT NULL CONSTRAINT [DF_SOFulfills_SendShippingNotifications] DEFAULT ((0)),
[SendShippingNotificationToOrderByContact] [bit] NOT NULL CONSTRAINT [DF_SOFulfills_SendShippingNotificationToOrderByContact] DEFAULT ((0)),
[ShippingNotificationAdditionalEmails] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfills_ShippingNotificationAdditionalEmails] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [PK_SOFulfills] PRIMARY KEY CLUSTERED ([FulfillID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_DeptID_GLDepts] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulFills_NoteID_SOFulFillNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SOFulFillNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_PicketID_SOPickets] FOREIGN KEY ([PicketID]) REFERENCES [dbo].[SOPickets] ([PicketID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_ShipToID_ARCustomers] FOREIGN KEY ([ShipToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_VoidID_SOFulfills] FOREIGN KEY ([VoidID]) REFERENCES [dbo].[SOFulfills] ([FulfillID])
GO
ALTER TABLE [dbo].[SOFulfills] ADD CONSTRAINT [FK_SOFulfills_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO