CREATE TABLE [dbo].[SOInvoiceDetails]
(
[InvoiceID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[SOID] [int] NULL,
[SODetailID] [int] NULL,
[ItemID] [int] NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UMID] [int] NOT NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConvFactor] [decimal] (16, 6) NOT NULL,
[Price] [money] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[Stocked] [bit] NOT NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[Bill] [bit] NOT NULL,
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_Amount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[CostGLID] [int] NULL,
[CostDeptID] [int] NULL,
[CostAppliedGLID] [int] NULL,
[CostAppliedDeptID] [int] NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_Cost] DEFAULT ((0)),
[Ordered] [decimal] (18, 6) NOT NULL,
[BackOrdered] [decimal] (18, 6) NOT NULL,
[Canceled] [decimal] (18, 6) NOT 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_SOInvoiceDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOInvoiceDetails_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_ChargeOutCost] DEFAULT ((0)),
[SerialNumberWasAllocated] [bit] NOT NULL CONSTRAINT [DF_SOInvoiceDetails_SerialNumberWasAllocated] DEFAULT ((0)),
[FulfillID] [int] NULL,
[FulfillDetailID] [int] NULL,
[TaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [PK_SOInvoiceDetails] PRIMARY KEY CLUSTERED ([InvoiceID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_CostAppliedDeptID_GLDepts3] FOREIGN KEY ([CostAppliedDeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_CostAppliedGLID_GLAccounts3] FOREIGN KEY ([CostAppliedGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_CostDeptID_GLDepts3] FOREIGN KEY ([CostDeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_CostGLID_GLAccounts3] FOREIGN KEY ([CostGLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_DeptID_GLDepts3] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts3] ([DeptID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_GLID_GLAccounts3] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts3] ([AccountID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_InvoiceID_SOInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[SOInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [SODetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SOInvoiceDetails] ADD CONSTRAINT [FK_SOInvoiceDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO