Tables [dbo].[SOFulfillDetailBins]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:45 AM Thursday, March 21, 2019
Last Modified1:15:46 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SOFulfillDetailBins_FulfillID_SOFulfillDetails: [dbo].[SOFulfillDetails].FulfillID\DetailIDFulfillIDint4
False
Foreign Keys FK_SOFulfillDetailBins_FulfillID_SOFulfillDetails: [dbo].[SOFulfillDetails].FulfillID\DetailIDDetailIDint4
False
Foreign Keys FK_SOFulfillDetailBins_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_SOFulfillDetailBins_BinID_ICBins: [dbo].[ICBins].BinIDBinIDint4
False
Quantitydecimal(18,6)9
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
Foreign Keys FK_SOFulfillDetailBins_SODetailBinID_SOOrderDetailBins: [dbo].[SOOrderDetailBins].SODetailBinIDSODetailBinIDint4
True
Canceleddecimal(18,6)9
False
((0))
Cluster Primary Key PK__SOFulfil__856191DD5BA50E94: FulFillDetailBinIDFulFillDetailBinIDint4
False
1 - 1
Costmoney8
False
((0))
ShipQuantitydecimal(18,6)9
False
((0))
ShipQuantityFulfilleddecimal(18,6)9
False
((0))
ShipQuantityReverseddecimal(18,6)9
False
((0))
Foreign Keys FK_SOFulFillDetailBins_ShippedBinID_ICBins: [dbo].[ICBins].ShippedBinIDShippedBinIDint4
True
ConvFactordecimal(18,6)9
False
((0))
Foreign Keys FK_SOFulfillDetailBins_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
Notesvarchar(1024)1024
False
('')
Foreign Keys FK_SOFulfillDetailBins_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnCostmoney8
False
((0))
OverriddenCostbit1
False
((0))
Foreign Keys FK_SOFulfillDetailBins_OrigVendorID_APVendors: [dbo].[APVendors].OrigVendorIDOrigVendorIDint4
True
OrigReceiptDetailBinIDint4
True
OrigReceiptCostmoney8
False
((0))
OrigFulfillDetailBinIDint4
True
AppliedFulfillDetailBinIDint4
True
OrigReportMaterialBinIDint4
True
AppliedReportMaterialBinIDint4
True
OrigCostmoney8
False
((0))
QuantityReverseddecimal(18,6)9
False
((0))
DistAmountmoney8
False
((0))
CalculatedOutCostmoney8
False
((0))
OutCostmoney8
False
((0))
OverrideOutCostbit1
False
((0))
OutCostExtendedmoney8
False
((0))
Foreign Keys FK_SOFulfillDetailBins_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SOFulfillDetailBins_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SOFulfillDetailBins_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SOFulfillDetailBins_IntercompanyGLID_GLAccounts: [dbo].[GLAccounts].IntercompanyGLIDIntercompanyGLIDint4
True
BillQuantitydecimal(18,6)9
False
((0))
DistBillAmountmoney8
False
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SOFulfil__856191DD5BA50E94: FulFillDetailBinIDPK__SOFulfil__856191DD5BA50E94FulFillDetailBinID
True
80
NameColumns
FK_SOFulfillDetailBins_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SOFulfillDetailBins_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_SOFulfillDetailBins_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SOFulfillDetailBins_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SOFulfillDetailBins_FulfillID_SOFulfillDetailsFulfillID->[dbo].[SOFulfillDetails].[FulfillID]
DetailID->[dbo].[SOFulfillDetails].[DetailID]
FK_SOFulfillDetailBins_IntercompanyGLID_GLAccountsIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_SOFulfillDetailBins_OrigVendorID_APVendorsOrigVendorID->[dbo].[APVendors].[VendorID]
FK_SOFulfillDetailBins_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SOFulFillDetailBins_ShippedBinID_ICBinsShippedBinID->[dbo].[ICBins].[BinID]
FK_SOFulfillDetailBins_SODetailBinID_SOOrderDetailBinsSODetailBinID->[dbo].[SOOrderDetailBins].[SODetailBinID]
FK_SOFulfillDetailBins_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_SOFulfillDetailBins_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[SOFulfillDetailBins]
(
[FulfillID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[WarehouseID] [int] NOT NULL,
[BinID] [int] NOT NULL,
[Quantity] [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_SOFulfillDetailBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[SODetailBinID] [int] NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_Canceled] DEFAULT ((0)),
[FulFillDetailBinID] [int] NOT NULL IDENTITY(1, 1),
[Cost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_Cost] DEFAULT ((0)),
[ShipQuantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_ShipQuantity] DEFAULT ((0)),
[ShipQuantityFulfilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_ShipQuantityFulfilled] DEFAULT ((0)),
[ShipQuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_ShipQuantityReversed] DEFAULT ((0)),
[ShippedBinID] [int] NULL,
[ConvFactor] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_ConvFactor] DEFAULT ((0)),
[StockTypeID] [int] NOT NULL,
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_Notes] DEFAULT (''),
[ReturnCodeID] [int] NULL,
[ReturnCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_ReturnCost] DEFAULT ((0)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_OverriddenCost] DEFAULT ((0)),
[OrigVendorID] [int] NULL,
[OrigReceiptDetailBinID] [int] NULL,
[OrigReceiptCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_OrigReceiptCost] DEFAULT ((0)),
[OrigFulfillDetailBinID] [int] NULL,
[AppliedFulfillDetailBinID] [int] NULL,
[OrigReportMaterialBinID] [int] NULL,
[AppliedReportMaterialBinID] [int] NULL,
[OrigCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_OrigCost] DEFAULT ((0)),
[QuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_QuantityReversed] DEFAULT ((0)),
[DistAmount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_DistAmount] DEFAULT ((0)),
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_OutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_OutCostExtended] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL,
[BillQuantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_BillQuantity] DEFAULT ((0)),
[DistBillAmount] [money] NOT NULL CONSTRAINT [DF_SOFulfillDetailBins_DistBillAmount] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [PK__SOFulfil__856191DD5BA50E94] PRIMARY KEY CLUSTERED  ([FulFillDetailBinID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_FulfillID_SOFulfillDetails] FOREIGN KEY ([FulfillID], [DetailID]) REFERENCES [dbo].[SOFulfillDetails] ([FulfillID], [DetailID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_OrigVendorID_APVendors] FOREIGN KEY ([OrigVendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulFillDetailBins_ShippedBinID_ICBins] FOREIGN KEY ([ShippedBinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_SODetailBinID_SOOrderDetailBins] FOREIGN KEY ([SODetailBinID]) REFERENCES [dbo].[SOOrderDetailBins] ([SODetailBinID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SOFulfillDetailBins] ADD CONSTRAINT [FK_SOFulfillDetailBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO