CREATE TABLE [dbo].[SOInvoices]
(
[InvoiceID] [int] NOT NULL,
[PicketID] [int] NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipMethodID] [int] NULL,
[JobID] [int] NULL,
[ShipDate] [datetime] NULL,
[FulfillID] [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_SOInvoices_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOInvoices_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldReleaserID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NOT NULL,
[ARBranchID] [int] NOT NULL,
[EasyMerge] [bit] NOT NULL CONSTRAINT [DF_SOInvoices_EasyMerge] DEFAULT ((0)),
[DetailCount] [int] NOT NULL CONSTRAINT [DF_SOInvoices_DetailCount] DEFAULT ((0)),
[FulfillDetailCount] [int] NOT NULL CONSTRAINT [DF_SOInvoices_FulfillDetailCount] DEFAULT ((0)),
[FulfillJournalID] [int] NULL,
[InvoiceJournalID] [int] NULL,
[Merged] [bit] NOT NULL CONSTRAINT [DF_SOInvoices_Merged] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [PK_SOInvoices] PRIMARY KEY CLUSTERED ([InvoiceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_FulfillID_SOFulfills] FOREIGN KEY ([FulfillID]) REFERENCES [dbo].[SOFulfills] ([FulfillID])
GO
ALTER TABLE [dbo].[SOInvoices] WITH NOCHECK ADD CONSTRAINT [FK_SOInvoices_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_PicketID_SOPickets] FOREIGN KEY ([PicketID]) REFERENCES [dbo].[SOPickets] ([PicketID])
GO
ALTER TABLE [dbo].[SOInvoices] ADD CONSTRAINT [FK_SOInvoices_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO