Tables [dbo].[SCReportMaterialBins]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:55:58 AM Thursday, March 21, 2019
Last Modified1:15:29 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SCReportMaterialBins_ReportID_SCReportMaterials: [dbo].[SCReportMaterials].ReportID\DetailIDReportIDint4
False
Foreign Keys FK_SCReportMaterialBins_ReportID_SCReportMaterials: [dbo].[SCReportMaterials].ReportID\DetailIDDetailIDint4
False
Foreign Keys FK_SCReportMaterialBins_WarehouseID_ICWarehouses: [dbo].[ICWarehouses].WarehouseIDWarehouseIDint4
False
Foreign Keys FK_SCReportMaterialBins_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
True
CallMaterialBinIDint4
True
ReportMaterialBinIDint4
False
1 - 1
Costmoney8
False
((0))
VoidCostmoney8
False
((0))
ConvFactordecimal(18,6)9
False
((0))
StockTypeIDint4
False
Notesvarchar(1024)1024
False
('')
Foreign Keys FK_SCReportMaterialBins_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnCostmoney8
False
((0))
OverriddenCostbit1
False
((0))
Foreign Keys FK_SCReportMaterialBins_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_SCReportMaterialBins_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCReportMaterialBins_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCReportMaterialBins_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCReportMaterialBins_IntercompanyGLID_GLAccounts: [dbo].[GLAccounts].IntercompanyGLIDIntercompanyGLIDint4
True
NameColumns
FK_SCReportMaterialBins_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCReportMaterialBins_BinID_ICBinsBinID->[dbo].[ICBins].[BinID]
FK_SCReportMaterialBins_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCReportMaterialBins_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCReportMaterialBins_IntercompanyGLID_GLAccountsIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_SCReportMaterialBins_OrigVendorID_APVendorsOrigVendorID->[dbo].[APVendors].[VendorID]
FK_SCReportMaterialBins_ReportID_SCReportMaterialsReportID->[dbo].[SCReportMaterials].[ReportID]
DetailID->[dbo].[SCReportMaterials].[DetailID]
FK_SCReportMaterialBins_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SCReportMaterialBins_WarehouseID_ICWarehousesWarehouseID->[dbo].[ICWarehouses].[WarehouseID]
CREATE TABLE [dbo].[SCReportMaterialBins]
(
[ReportID] [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_SCReportMaterialBins_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[CallMaterialBinID] [int] NULL,
[ReportMaterialBinID] [int] NOT NULL IDENTITY(1, 1),
[Cost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_Cost] DEFAULT ((0)),
[VoidCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_VoidCost] DEFAULT ((0)),
[ConvFactor] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCReportMaterialBins_ConvFactor] DEFAULT ((0)),
[StockTypeID] [int] NOT NULL,
[Notes] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCReportMaterialBins_Notes] DEFAULT (''),
[ReturnCodeID] [int] NULL,
[ReturnCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_ReturnCost] DEFAULT ((0)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_OverriddenCost] DEFAULT ((0)),
[OrigVendorID] [int] NULL,
[OrigReceiptDetailBinID] [int] NULL,
[OrigReceiptCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_OrigReceiptCost] DEFAULT ((0)),
[OrigFulfillDetailBinID] [int] NULL,
[AppliedFulfillDetailBinID] [int] NULL,
[OrigReportMaterialBinID] [int] NULL,
[AppliedReportMaterialBinID] [int] NULL,
[OrigCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_OrigCost] DEFAULT ((0)),
[QuantityReversed] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCReportMaterialBins_QuantityReversed] DEFAULT ((0)),
[DistAmount] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_DistAmount] DEFAULT ((0)),
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_OutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SCReportMaterialBins_OutCostExtended] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_BinID_ICBins] FOREIGN KEY ([BinID]) REFERENCES [dbo].[ICBins] ([BinID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_OrigVendorID_APVendors] FOREIGN KEY ([OrigVendorID]) REFERENCES [dbo].[APVendors] ([VendorID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_ReportID_SCReportMaterials] FOREIGN KEY ([ReportID], [DetailID]) REFERENCES [dbo].[SCReportMaterials] ([ReportID], [DetailID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SCReportMaterialBins] ADD CONSTRAINT [FK_SCReportMaterialBins_WarehouseID_ICWarehouses] FOREIGN KEY ([WarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
  • [dbo].[v_dtf_SCReportMaterialBins]