Tables [dbo].[SOOrderDetailBins]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:47 AM Thursday, March 21, 2019
Last Modified1:16:09 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__SOOrderD__E76B25C7229EA76E: SODetailBinIDSODetailBinIDint4
False
1 - 1
Foreign Keys FK_SOOrderDetailBins_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\DetailIDSOIDint4
False
Foreign Keys FK_SOOrderDetailBins_SOID_SOOrderDetails: [dbo].[SOOrderDetails].SOID\DetailIDDetailIDint4
False
Foreign Keys FK_SOOrderDetailBins_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
False
Foreign Keys FK_SOOrderDetailBins_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_SOOrderDetailBins_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
True
Quantitydecimal(18,6)9
False
ConvFactordecimal(18,6)9
False
Canceleddecimal(18,6)9
False
((0))
Picketeddecimal(18,6)9
False
((0))
Shippeddecimal(18,6)9
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
Foreign Keys FK_SOOrderDetailBins_StockingCodeID_ICStockingCodes: [dbo].[ICStockingCodes].StockingCodeIDStockingCodeIDint4
False
((1))
Foreign Keys FK_SOOrderDetailBins_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
Fulfilleddecimal(18,6)9
False
((0))
SerialNumbervarchar(32)32
False
('')
BackOrdereddecimal(18,6)9
False
((0))
Notesvarchar(1024)1024
False
('')
Foreign Keys FK_SOOrderDetailBins_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnCostmoney8
False
((0))
OverriddenCostbit1
False
((0))
Foreign Keys FK_SOOrderDetailBins_OrigVendorID_APVendors: [dbo].[APVendors].OrigVendorIDOrigVendorIDint4
True
OrigReceiptDetailBinIDint4
True
OrigReceiptCostmoney8
False
((0))
OrigFulfillDetailBinIDint4
True
OrigReportMaterialBinIDint4
True
OrigCostmoney8
False
((0))
CalculatedOutCostmoney8
False
((0))
OutCostmoney8
False
((0))
OverrideOutCostbit1
False
((0))
OutCostExtendedmoney8
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SOOrderD__E76B25C7229EA76E: SODetailBinIDPK__SOOrderD__E76B25C7229EA76ESODetailBinID
True
80
NameColumns
FK_SOOrderDetailBins_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_SOOrderDetailBins_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SOOrderDetailBins_OrigVendorID_APVendorsOrigVendorID->[dbo].[APVendors].[VendorID]
FK_SOOrderDetailBins_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SOOrderDetailBins_SOID_SOOrderDetailsSOID->[dbo].[SOOrderDetails].[SOID]
DetailID->[dbo].[SOOrderDetails].[DetailID]
FK_SOOrderDetailBins_StockingCodeID_ICStockingCodesStockingCodeID->[dbo].[ICStockingCodes].[StockingCodeID]
FK_SOOrderDetailBins_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_SOOrderDetailBins_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[SOOrderDetailBins]
(
[SODetailBinID] [int] NOT NULL IDENTITY(1, 1),
[SOID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetailBins_Canceled] DEFAULT ((0)),
[Picketed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetailBins_Picketed] DEFAULT ((0)),
[Shipped] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetailBins_Shipped] 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_SOOrderDetailBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_LastUpdate] DEFAULT (getdate()),
[StockingCodeID] [int] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_StockingCodeID] DEFAULT ((1)),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_StockTypeID] DEFAULT ((1)),
[Fulfilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetailBins_FulFilled] DEFAULT ((0)),
[SerialNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrderDetailBins_SerialNumber] DEFAULT (''),
[BackOrdered] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOOrderDetailBins_BackOrdered] DEFAULT ((0)),
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOOrderDetailBins_Notes] DEFAULT (''),
[ReturnCodeID] [int] NULL,
[ReturnCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_ReturnCost] DEFAULT ((0)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_OverriddenCost] DEFAULT ((0)),
[OrigVendorID] [int] NULL,
[OrigReceiptDetailBinID] [int] NULL,
[OrigReceiptCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_OrigReceiptCost] DEFAULT ((0)),
[OrigFulfillDetailBinID] [int] NULL,
[OrigReportMaterialBinID] [int] NULL,
[OrigCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_OrigCost] DEFAULT ((0)),
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_OutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SOOrderDetailBins_OutCostExtended] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [PK__SOOrderD__E76B25C7229EA76E] PRIMARY KEY CLUSTERED  ([SODetailBinID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_OrigVendorID_APVendors] FOREIGN KEY ([OrigVendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_SOID_SOOrderDetails] FOREIGN KEY ([SOID], [DetailID]) REFERENCES [dbo].[SOOrderDetails] ([SOID], [DetailID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_StockingCodeID_ICStockingCodes] FOREIGN KEY ([StockingCodeID]) REFERENCES [dbo].[ICStockingCodes] ([StockingCodeID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOOrderDetailBins] ADD CONSTRAINT [FK_SOOrderDetailBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO