CREATE TABLE [dbo].[SCWorkOrders]
(
[WorkOrderID] [int] NOT NULL,
[WorkOrderNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransDate] [datetime] NOT NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[TermID] [int] NULL,
[TermDiscountRate] [float] 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,
[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,
[TaxCodeID] [int] NULL,
[Status] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Remarks] [text] COLLATE SQL_Latin1_General_CP1_CI_AS 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_SCWorkOrders_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCWorkOrders_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] 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_SCWorkOrders_ChargeAccountInfo] DEFAULT (''),
[PartnerID] [int] NULL,
[PartnerReference] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCWorkOrders_Taxable] DEFAULT ((1)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SCWorkOrders_NoteFlag] DEFAULT ((0)),
[LastCheckOutUser] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastCheckOutLeaseID] [int] NULL,
[LastCheckOutDate] [datetime] NULL,
[InvoiceTo] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceMethod] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SCWorkOrders_NoteCount] DEFAULT ((0)),
[TaxExemptCodeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [PK_SCWorkOrders] PRIMARY KEY CLUSTERED ([WorkOrderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCWorkOrders] WITH NOCHECK ADD CONSTRAINT [FK_SCWorkOrders_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCWorkOrders] WITH NOCHECK ADD CONSTRAINT [FK_SCWorkOrders_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_NoteID_SCWorkOrderNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCWorkOrderNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_PartnerID_ShServicePartners] FOREIGN KEY ([PartnerID]) REFERENCES [dbo].[ShServicePartners] ([PartnerID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_ShipToID_ARCustomers] FOREIGN KEY ([ShipToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCWorkOrders] ADD CONSTRAINT [FK_SCWorkOrders_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO