CREATE TABLE [dbo].[SOHFulFills]
(
[HFulfillID] [int] NOT NULL,
[HFulfillNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[DatePeriod] [int] NULL,
[Period] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToNameOverride] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[POID] [int] NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SOID] [int] NULL,
[SONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SalesRepID] [int] NULL,
[SalesRep] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipMethodID] [int] NULL,
[ShipMethod] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PicketNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[JobID] [int] NULL,
[JobNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipmentNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToID] [int] NULL,
[ShipToName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HInvoiceID] [int] NULL,
[HInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WarehouseID] [int] NULL,
[Warehouse] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeptID] [int] NULL,
[DeptNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToID] [int] NULL,
[BillToName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OutCostNotes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [PK_SOHFulFills] PRIMARY KEY CLUSTERED ([HFulfillID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_DeptID_GLDepts] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_HInvoiceID_ARHInvoices] FOREIGN KEY ([HInvoiceID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_ShipToID_ARCustomers] FOREIGN KEY ([ShipToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[SOHFulFills] ADD CONSTRAINT [FK_SOHFulFills_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO