CREATE TABLE [dbo].[SOOrders]
(
[SOID] [int] NOT NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[LocationID] [int] NULL,
[Date] [datetime] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReqDate] [datetime] NULL,
[TermID] [int] NULL,
[TermDiscountRate] [float] NOT NULL,
[TermDiscountDate] [datetime] NULL,
[DueDate] [datetime] NOT NULL,
[ShipMethodID] [int] NULL,
[JobID] [int] NULL,
[SalesRepID] [int] NULL,
[MailToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToAttn] [varchar] (64) 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,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DiscountRate] [decimal] (18, 6) NOT NULL,
[DiscountGLID] [int] NULL,
[Discount] [money] NOT NULL CONSTRAINT [DF_SOOrders_Discount] DEFAULT ((0)),
[FreightGLID] [int] NULL,
[Freight] [money] NOT NULL CONSTRAINT [DF_SOOrders_Freight] DEFAULT ((0)),
[TaxCodeID] [int] NULL,
[Tax] [money] NOT NULL CONSTRAINT [DF_SOOrders_Tax] DEFAULT ((0)),
[GLID] [int] NOT NULL,
[Total] [money] NOT NULL CONSTRAINT [DF_SOOrders_Total] DEFAULT ((0)),
[ApprovedByID] [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_SOOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOOrders_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[OnHold] [bit] NOT NULL,
[OnHoldCodeID] [int] NULL,
[OnHoldReleaseDate] [datetime] NULL,
[OnHoldReleaserID] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResponseCalcOverrideDate] [datetime] NULL,
[BranchID] [int] NOT NULL,
[ARBranchID] [int] NOT NULL,
[ChargeMethodID] [int] NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrders_ChargeAccountInfo] DEFAULT (''),
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SOOrders_Taxable] DEFAULT ((1)),
[FreightDeptID] [int] NULL,
[DiscountDeptID] [int] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_SOOrders_DBFileHeaderID] DEFAULT ((1)),
[AmountTotal] [money] NOT NULL CONSTRAINT [DF_SOOrders_AmountTotal] DEFAULT ((0)),
[AmountPicketed] [money] NOT NULL CONSTRAINT [DF_SOOrders_AmountPicketed] DEFAULT ((0)),
[AmountShipped] [money] NOT NULL CONSTRAINT [DF_SOOrders_AmountShipped] DEFAULT ((0)),
[AmountFulFilled] [money] NOT NULL CONSTRAINT [DF_SOOrders_AmountFulFilled] DEFAULT ((0)),
[AmountBilled] [money] NOT NULL CONSTRAINT [DF_SOOrders_AmountBilled] DEFAULT ((0)),
[QuantityTotal] [decimal] (18, 2) NOT NULL CONSTRAINT [DF_SOOrders_QuantityTotal] DEFAULT ((0)),
[QuantityShipped] [decimal] (18, 2) NOT NULL CONSTRAINT [DF_SOOrders_QuantityShipped] DEFAULT ((0)),
[QuantityFulfilled] [decimal] (18, 2) NOT NULL CONSTRAINT [DF_SOOrders_QuantityFulfilled] DEFAULT ((0)),
[QuantityBilled] [decimal] (18, 2) NOT NULL CONSTRAINT [DF_SOOrders_QuantityBilled] DEFAULT ((0)),
[BilledFreight] [money] NOT NULL CONSTRAINT [DF_SOOrders_BilledFreight] DEFAULT ((0)),
[OrderTypeID] [int] NOT NULL CONSTRAINT [DF_SOOrders_OrderTypeID] DEFAULT ((1)),
[WarehouseID] [int] NULL,
[DeptID] [int] NULL,
[AmountBackOrdered] [money] NOT NULL CONSTRAINT [DF_SOOrders_AmountBackOrdered] DEFAULT ((0)),
[QuantityBackOrdered] [decimal] (18, 2) NOT NULL CONSTRAINT [DF_SOOrders_QuantityBackOrdered] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SOOrders_NoteFlag] DEFAULT ((0)),
[BaseTypeID] [int] NOT NULL CONSTRAINT [DF_SOOrders_BaseTypeID] DEFAULT ((1)),
[StatusID] [int] NOT NULL CONSTRAINT [DF_SOOrders_StatusID] DEFAULT ((1)),
[DetailStatusID] [int] NOT NULL CONSTRAINT [DF_SOOrders_DetailStatusID] DEFAULT ((0)),
[ReturnDetailStatusID] [int] NOT NULL CONSTRAINT [DF_SOOrders_ReturnDetailStatusID] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[OrigInvoiceID] [int] NULL,
[ReturnMethodID] [int] NULL,
[ReturnWarehouseID] [int] NULL,
[ShTrackingConfigID] [int] NULL,
[OutCostNotes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrders_OutCostNotes] DEFAULT (''),
[OrderedByContactID] [int] NULL,
[QuoteID] [int] NULL,
[QuoteOriginationID] [int] NULL,
[QuoteOriginatorEmail] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SOOrders_NoteCount] DEFAULT ((0)),
[SendShippingNotifications] [bit] NOT NULL CONSTRAINT [DF_SOOrders_SendShippingNotifications] DEFAULT ((0)),
[SendShippingNotificationToOrderByContact] [bit] NOT NULL CONSTRAINT [DF_SOOrders_SendShippingNotificationToOrderByContact] DEFAULT ((0)),
[ShippingNotificationAdditionalEmails] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrders_ShippingNotificationAdditionalEmails] DEFAULT (''),
[TaxExemptCodeID] [int] NULL,
[FreightTaxFlag] [int] NOT NULL,
[FreightTaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [PK_SOOrders] PRIMARY KEY CLUSTERED ([SOID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ApprovedByID_PREmployees] FOREIGN KEY ([ApprovedByID]) REFERENCES [dbo].[PREmployees] ([EmployeeID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOOrders] WITH NOCHECK ADD CONSTRAINT [FK_SOOrders_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SOOrders] WITH NOCHECK ADD CONSTRAINT [FK_SOOrders_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_DeptID_GLDepts] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_DetailStatusID_SODetailStatuses] FOREIGN KEY ([DetailStatusID]) REFERENCES [dbo].[SODetailStatuses] ([DetailStatusID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_DiscountDeptID_GLDepts] FOREIGN KEY ([DiscountDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_DiscountGLID_GLAccounts] FOREIGN KEY ([DiscountGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_FreightDeptID_GLDepts] FOREIGN KEY ([FreightDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_FreightGLID_GLAccounts] FOREIGN KEY ([FreightGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_FreightTaxFlagID_ShTaxFlags] FOREIGN KEY ([FreightTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_GLID_GLAccounts] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SOOrders] WITH NOCHECK ADD CONSTRAINT [FK_SOOrders_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_NoteID_SOOrderNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SOOrderNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_OnHoldCodeID_ShOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_OrderedByContactID_CMContacts] FOREIGN KEY ([OrderedByContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_OrderTypeID_SOOrderTypes] FOREIGN KEY ([OrderTypeID]) REFERENCES [dbo].[SOOrderTypes] ([OrderTypeID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_OrigInvoiceID_ARInvoices] FOREIGN KEY ([OrigInvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_QuoteID_SOQuotes] FOREIGN KEY ([QuoteID]) REFERENCES [dbo].[SOQuotes] ([QuoteID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ReturnDetailStatusID_SODetailStatuses] FOREIGN KEY ([ReturnDetailStatusID]) REFERENCES [dbo].[SODetailStatuses] ([DetailStatusID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ReturnMethodID_ShShipMethods] FOREIGN KEY ([ReturnMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ReturnWarehouseID_ICWarehouses] FOREIGN KEY ([ReturnWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_StatusID_SOStatuses] FOREIGN KEY ([StatusID]) REFERENCES [dbo].[SOStatuses] ([StatusID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[SOOrders] ADD CONSTRAINT [FK_SOOrders_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO