CREATE TABLE [dbo].[SCProposals]
(
[ProposalID] [int] NOT NULL IDENTITY(1, 1),
[ProposalNumber] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Type] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Date] [datetime] NOT NULL,
[Batch] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillingID] [int] NULL,
[InvoiceID] [int] NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] 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,
[TermID] [int] NULL,
[TermDiscountRate] [float] NOT NULL,
[TermDiscountDate] [datetime] NULL,
[DueDate] [datetime] NOT 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,
[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,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DiscountRate] [float] NOT NULL,
[DiscountGLID] [int] NULL,
[FreightGLID] [int] NULL,
[Freight] [money] NOT NULL,
[TaxCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCProposals_Taxable] DEFAULT ((1)),
[Tax] [money] NOT NULL CONSTRAINT [DF_SCProposals_Tax] DEFAULT ((0)),
[GLID] [int] NOT NULL,
[BranchID] [int] NOT NULL,
[ARBranchID] [int] NOT NULL,
[Total] [money] NOT NULL CONSTRAINT [DF_SCProposals_Total] DEFAULT ((0)),
[ChargeMethodID] [int] NULL,
[ChargeAccountID] [int] NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCProposals_ChargeAccountInfo] DEFAULT (''),
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Void] [bit] NOT NULL CONSTRAINT [DF_SCProposals_Void] DEFAULT ((0)),
[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_SCProposals_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCProposals_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[ReportDefinitionGroupID] [int] NOT NULL,
[SendContactID] [int] NULL,
[SendMethodID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [PK_SCProposals] PRIMARY KEY CLUSTERED ([ProposalID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_BillingID_SCQBillings] FOREIGN KEY ([BillingID]) REFERENCES [dbo].[SCQBillings] ([BillingID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_GLID_GLAccounts1] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_ReportDefinitionGroupID_RPReportDefinitionGroups] FOREIGN KEY ([ReportDefinitionGroupID]) REFERENCES [dbo].[RPReportDefinitionGroups] ([ReportDefinitionGroupID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_SendContactID_CMContacts] FOREIGN KEY ([SendContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCProposals] ADD CONSTRAINT [FK_SCProposals_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO