CREATE TABLE [dbo].[ICSalesServiceLedger]
(
[LedgerID] [int] NOT NULL IDENTITY(1, 1),
[Date] [datetime] NOT NULL,
[Period] [int] NOT NULL,
[TransactionID] [int] NOT NULL,
[TransactionTypeID] [int] NOT NULL,
[TransactionNumber] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NULL,
[BillToID] [int] NULL,
[ShipToID] [int] NULL,
[InvoiceID] [int] NULL,
[InvoiceTransactionTypeID] [int] NULL,
[InvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SOID] [int] NULL,
[SONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SalesRepID] [int] NULL,
[TechnicianID] [int] NULL,
[CallID] [int] NULL,
[ReportBillGroupID] [int] NULL,
[BranchID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [PK__ICSalesS__AE70E0AFCFEECB4F] PRIMARY KEY CLUSTERED ([LedgerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] WITH NOCHECK ADD CONSTRAINT [FK_ICSalesServiceLedger_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_CallID_SCCalls] FOREIGN KEY ([CallID]) REFERENCES [dbo].[SCCalls] ([CallID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] WITH NOCHECK ADD CONSTRAINT [FK_ICSalesServiceLedger_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] WITH NOCHECK ADD CONSTRAINT [FK_ICSalesServiceLedger_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_InvoiceTransactionTypeID_ShTransactionTypes] FOREIGN KEY ([InvoiceTransactionTypeID]) REFERENCES [dbo].[ShTransactionTypes] ([TransactionTypeID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_ReportBillGroupID_SCReportBillGroups] FOREIGN KEY ([ReportBillGroupID]) REFERENCES [dbo].[SCReportBillGroups] ([ReportBillGroupID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] WITH NOCHECK ADD CONSTRAINT [FK_ICSalesServiceLedger_ShipToID_ARCustomers] FOREIGN KEY ([ShipToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_SOID_SOOrders] FOREIGN KEY ([SOID]) REFERENCES [dbo].[SOOrders] ([SOID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[ICSalesServiceLedger] ADD CONSTRAINT [FK_ICSalesServiceLedger_TransactionTypeID_ShTransactionTypes] FOREIGN KEY ([TransactionTypeID]) REFERENCES [dbo].[ShTransactionTypes] ([TransactionTypeID])
GO