CREATE TABLE [dbo].[SOHFulFillDetails]
(
[HFulfillID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[SOID] [int] NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SODetailID] [int] NULL,
[ItemID] [int] NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConvFactor] [decimal] (18, 0) NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Stocked] [bit] NULL,
[Quantity] [decimal] (18, 0) NULL,
[UMID] [int] NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Price] [money] NULL,
[Discount] [decimal] (18, 0) NULL,
[EquipmentID] [int] NULL,
[EquipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractID] [int] NULL,
[ContractNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BSABillForServices] [bit] NULL,
[Bill] [bit] NULL,
[Amount] [money] NULL,
[Cost] [money] NULL,
[Canceled] [decimal] (18, 0) NULL,
[BackOrdered] [decimal] (18, 0) NULL,
[EmployeeID] [int] NULL,
[Employee] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriceSourceID] [int] NULL,
[PriceSource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SystemComputedPrice] [money] NULL,
[ReturnCodeID] [int] NULL,
[ReturnCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StockType] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OverriddenCost] [bit] NULL,
[ContractItemLimitID] [int] NULL,
[HShipmentID] [int] NULL,
[HShipmentNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipQuantity] [decimal] (18, 0) NULL,
[ShipQuantityFulfilled] [decimal] (18, 0) NULL,
[ShipQuantityReversed] [decimal] (18, 0) NULL,
[ShipAmount] [money] NULL,
[FulFillDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RMA] [bit] NULL,
[SerialNumberWasAllocated] [bit] NULL,
[HInvoiceID] [int] NULL,
[HInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillQuantity] [decimal] (18, 0) NULL,
[BillAmount] [money] NULL,
[TaxFlag] [int] NULL,
[Ordered] [decimal] (18, 0) NULL,
[IsReturn] [bit] NULL,
[IsRMAReturn] [bit] NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalculatedOutCost] [money] NULL,
[OutCost] [money] NULL,
[UseBaseOutCost] [bit] NULL,
[OverrideOutCost] [bit] NULL,
[OutCostExtended] [money] NULL,
[OutCostRate] [decimal] (18, 0) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [PK_SOHFulFillDetails] PRIMARY KEY CLUSTERED ([HFulfillID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_EmployeeID_ShAgents] FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_HFulfillID_SOHFulFills] FOREIGN KEY ([HFulfillID]) REFERENCES [dbo].[SOHFulFills] ([HFulfillID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_HInvoiceID_ARHInvoices] FOREIGN KEY ([HInvoiceID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_HShipmentID_SOHShipments] FOREIGN KEY ([HShipmentID]) REFERENCES [dbo].[SOHShipments] ([HShipmentID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [SODetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOHFulFillDetails] ADD CONSTRAINT [FK_SOHFulFillDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO