CREATE TABLE [dbo].[SOFulfillDetails]
(
[FulfillID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[SOID] [int] NULL,
[SODetailID] [int] NULL,
[ItemID] [int] NOT NULL,
[ConvFactor] [decimal] (16, 6) NOT NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Stocked] [bit] NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UMID] [int] NOT NULL,
[Price] [money] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[EquipmentID] [int] NULL,
[ContractID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[Bill] [bit] NOT NULL,
[GLID] [int] NULL,
[DeptID] [int] NULL,
[UnearnedRevenueGLID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Amount] DEFAULT ((0)),
[CostGLID] [int] NULL,
[CostDeptID] [int] NULL,
[CostAppliedGLID] [int] NULL,
[CostAppliedDeptID] [int] NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Cost] DEFAULT ((0)),
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_Canceled] DEFAULT ((0)),
[BackOrdered] [decimal] (18, 6) NOT NULL,
[EmployeeID] [int] 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_SOFulfillDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOFulfillDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_ChargeOutCost] DEFAULT ((0)),
[ContractItemLimitID] [int] NULL,
[ShipmentID] [int] NULL,
[ShipQuantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipQuantity] DEFAULT ((0)),
[ShipQuantityFulfilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipQuantityFulfilled] DEFAULT ((0)),
[ShipQuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipQuantityReversed] DEFAULT ((0)),
[ShipAmount] [money] NOT NULL CONSTRAINT [DF_SOFulFillDetails_ShipAmount] DEFAULT ((0)),
[FulFillDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumberWasAllocated] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_SerialNumberWasAllocated] DEFAULT ((0)),
[InvoiceID] [int] NULL,
[BillQuantity] [decimal] (18, 6) NOT NULL,
[BillAmount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_BillAmount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_UM] DEFAULT (''),
[Ordered] [decimal] (18, 6) NOT NULL,
[IsReturn] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_IsReturn] DEFAULT ((0)),
[IsRMAReturn] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_IsRMAReturn] DEFAULT ((0)),
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SOFulFillDetails_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SOFulFillDetails_OutCost] DEFAULT ((0)),
[UseBaseOutCost] [bit] NOT NULL CONSTRAINT [DF_SOFulFillDetails_UseBaseOutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SOFulFillDetails_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_OutCostExtended] DEFAULT ((0)),
[OutCostRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_OutCostRate] DEFAULT ((0)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_Remarks] DEFAULT (''),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetails_Notes] DEFAULT (''),
[ParentID] [int] NULL,
[RollUpPrice] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_RollUpPrice] DEFAULT ((0)),
[Hidden] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Hidden] DEFAULT ((0)),
[SortOrder] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_SortOrder] DEFAULT ((0)),
[Depth] [smallint] NOT NULL CONSTRAINT [DF_SOFulfillDetails_Depth] DEFAULT ((0)),
[ShipToContactID] [int] NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL,
[LineNumber] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ParentKitID] [int] NULL,
[DisplayPrice] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_DisplayPrice] DEFAULT ((0)),
[DisplayAmount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_DisplayAmount] DEFAULT ((0)),
[DisplayDiscount] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetails_DisplayDiscount] DEFAULT ((0)),
[KitComponentQuantity] [decimal] (18, 6) NULL,
[KitComponentWeighting] [decimal] (18, 6) NULL,
[TrackKitDiscount] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetails_TrackKitDiscount] DEFAULT ((0)),
[LocationNotes] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnitCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetails_UnitCost] DEFAULT ((0)),
[ShipToDetailID] [int] NOT NULL CONSTRAINT [DF_SOFulfillDetails_ShipToDetailID] DEFAULT ((1)),
[ContractDetailID] [int] NULL,
[ContractDetailLinkFlag] [int] NULL,
[TaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [PK_SOFulfillDetails] PRIMARY KEY CLUSTERED ([FulfillID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ContractDetailID_SCContractDetails] FOREIGN KEY ([ContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostAppliedDeptID_GLDepts5] FOREIGN KEY ([CostAppliedDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostAppliedGLID_GLAccounts5] FOREIGN KEY ([CostAppliedGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostDeptID_GLDepts5] FOREIGN KEY ([CostDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_CostGLID_GLAccounts5] FOREIGN KEY ([CostGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_EmployeeID_ShAgents] FOREIGN KEY ([EmployeeID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_FulfillID_SOFulfills] FOREIGN KEY ([FulfillID]) REFERENCES [dbo].[SOFulfills] ([FulfillID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_FulfillID_SOFulfillShipTos] FOREIGN KEY ([FulfillID], [ShipToDetailID]) REFERENCES [dbo].[SOFulfillShipTos] ([FulfillID], [DetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_GLID_GLAccounts5] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ShipmentID_SOShipments] FOREIGN KEY ([ShipmentID]) REFERENCES [dbo].[SOShipments] ([ShipmentID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_ShipToContactID_CMContacts] FOREIGN KEY ([ShipToContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [SODetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[SOFulfillDetails] ADD CONSTRAINT [FK_SOFulfillDetails_UnearnedRevenueGLID_GLAccounts5] FOREIGN KEY ([UnearnedRevenueGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO