Tables [dbo].[SCReportMaterials]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
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 NullsDefault
Cluster Primary Key PK_SCReportMaterials: ReportID\DetailIDForeign Keys FK_SCReportMaterials_ReportID_SCReportMaterials: [dbo].[SCReportMaterials].ReportID\MoveOrderLinkedDetailIDForeign Keys FK_SCReportMaterials_ReportID_SCReports: [dbo].[SCReports].ReportIDReportIDint4
False
Cluster Primary Key PK_SCReportMaterials: ReportID\DetailIDDetailIDint4
False
Foreign Keys FK_SCReportMaterials_ItemID_ICItems1: [dbo].[ICItems1].ItemIDItemIDint4
True
SerialNumbervarchar(30)30
False
Descriptionvarchar(255)255
False
Quantitydecimal(18,6)9
False
Foreign Keys FK_SCReportMaterials_UMID_ICUnits: [dbo].[ICUnits].UMIDUMIDint4
False
UMvarchar(255)255
False
ConvFactordecimal(16,6)9
False
Pricemoney8
False
Discountdecimal(18,6)9
False
Billbit1
False
Stockedbit1
False
Foreign Keys FK_SCReportMaterials_GLID_GLAccounts5: [dbo].[GLAccounts5].GLIDGLIDint4
False
Foreign Keys FK_SCReportMaterials_DeptID_GLDepts5: [dbo].[GLDepts5].DeptIDDeptIDint4
True
Amountmoney8
False
((0))
TaxFlagint4
False
Foreign Keys FK_SCReportMaterials_CostGLID_GLAccounts5: [dbo].[GLAccounts5].CostGLIDCostGLIDint4
True
Foreign Keys FK_SCReportMaterials_CostDeptID_GLDepts5: [dbo].[GLDepts5].CostDeptIDCostDeptIDint4
True
Foreign Keys FK_SCReportMaterials_CostAppliedGLID_GLAccounts5: [dbo].[GLAccounts5].CostAppliedGLIDCostAppliedGLIDint4
True
Foreign Keys FK_SCReportMaterials_CostAppliedDeptID_GLDepts5: [dbo].[GLDepts5].CostAppliedDeptIDCostAppliedDeptIDint4
True
Costmoney8
False
((0))
VoidCostmoney8
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_SCReportMaterials_PriceSourceID_ARPriceSources: [dbo].[ARPriceSources].PriceSourceIDPriceSourceIDint4
False
((1))
SystemComputedPricemoney8
False
((0))
Foreign Keys FK_SCReportMaterials_ReturnCodeID_ICReturnCodes: [dbo].[ICReturnCodes].ReturnCodeIDReturnCodeIDint4
True
ReturnRemarksvarchar(255)255
False
('')
Foreign Keys FK_SCReportMaterials_StockTypeID_ICStockTypes: [dbo].[ICStockTypes].StockTypeIDStockTypeIDint4
False
((1))
OverriddenCostbit1
False
((0))
ChargeOutCostmoney8
False
((0))
WarrantyStartedbit1
False
((0))
IsWarrantiedbit1
False
((0))
TransactionWarrantyIDint4
True
Foreign Keys FK_SCReportMaterials_UsageStatusID_ICUsageStatuses: [dbo].[ICUsageStatuses].UsageStatusIDUsageStatusIDint4
False
((1))
ReqDatedatetime8
True
Foreign Keys FK_SCReportMaterials_DeliveryMethodID_ICDeliveryMethods: [dbo].[ICDeliveryMethods].DeliveryMethodIDDeliveryMethodIDint4
True
Canceleddecimal(18,6)9
False
((0))
Foreign Keys FK_SCReportMaterials_ContractItemLimitID_SCContractItemLimits: [dbo].[SCContractItemLimits].ContractItemLimitIDContractItemLimitIDint4
True
OutCostRatedecimal(18,6)9
False
((0))
CalculatedOutCostmoney8
False
((0))
OutCostmoney8
False
((0))
UseBaseOutCostbit1
False
((0))
OverrideOutCostbit1
False
((0))
OutCostExtendedmoney8
False
((0))
MoveOrderDetailbit1
False
((0))
Foreign Keys FK_SCReportMaterials_ReportID_SCReportMaterials: [dbo].[SCReportMaterials].ReportID\MoveOrderLinkedDetailIDMoveOrderLinkedDetailIDint4
True
MoveOrderLocationvarchar(128)128
True
Foreign Keys FK_SCReportMaterials_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCReportMaterials_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCReportMaterials_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCReportMaterials_IntercompanyGLID_GLAccounts: [dbo].[GLAccounts].IntercompanyGLIDIntercompanyGLIDint4
True
EarnedAmountmoney8
False
((0))
UnitCostmoney8
False
((0))
Foreign Keys FK_SCReportMaterials_TaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TaxFlagIDTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCReportMaterials: ReportID\DetailIDPK_SCReportMaterialsReportID, DetailID
True
80
NameColumns
FK_SCReportMaterials_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCReportMaterials_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCReportMaterials_ContractItemLimitID_SCContractItemLimitsContractItemLimitID->[dbo].[SCContractItemLimits].[ContractItemLimitID]
FK_SCReportMaterials_CostAppliedDeptID_GLDepts5CostAppliedDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCReportMaterials_CostAppliedGLID_GLAccounts5CostAppliedGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCReportMaterials_CostDeptID_GLDepts5CostDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCReportMaterials_CostGLID_GLAccounts5CostGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCReportMaterials_DeliveryMethodID_ICDeliveryMethodsDeliveryMethodID->[dbo].[ICDeliveryMethods].[DeliveryMethodID]
FK_SCReportMaterials_DeptID_GLDepts5DeptID->[dbo].[GLDepts5].[DeptID]
FK_SCReportMaterials_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCReportMaterials_GLID_GLAccounts5GLID->[dbo].[GLAccounts5].[AccountID]
FK_SCReportMaterials_IntercompanyGLID_GLAccountsIntercompanyGLID->[dbo].[GLAccounts].[AccountID]
FK_SCReportMaterials_ItemID_ICItems1ItemID->[dbo].[ICItems1].[ItemID]
FK_SCReportMaterials_PriceSourceID_ARPriceSourcesPriceSourceID->[dbo].[ARPriceSources].[PriceSourceID]
FK_SCReportMaterials_ReportID_SCReportMaterialsReportID->[dbo].[SCReportMaterials].[ReportID]
MoveOrderLinkedDetailID->[dbo].[SCReportMaterials].[DetailID]
FK_SCReportMaterials_ReportID_SCReportsReportID->[dbo].[SCReports].[ReportID]
FK_SCReportMaterials_ReturnCodeID_ICReturnCodesReturnCodeID->[dbo].[ICReturnCodes].[ReturnCodeID]
FK_SCReportMaterials_StockTypeID_ICStockTypesStockTypeID->[dbo].[ICStockTypes].[StockTypeID]
FK_SCReportMaterials_TaxFlagID_ShTaxFlagsTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCReportMaterials_UMID_ICUnitsUMID->[dbo].[ICUnits].[ID]
FK_SCReportMaterials_UsageStatusID_ICUsageStatusesUsageStatusID->[dbo].[ICUsageStatuses].[UsageStatusID]
CREATE TABLE [dbo].[SCReportMaterials]
(
[ReportID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[ItemID] [int] NULL,
[SerialNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Quantity] [decimal] (18, 6) NOT NULL,
[UMID] [int] NOT NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ConvFactor] [decimal] (16, 6) NOT NULL,
[Price] [money] NOT NULL,
[Discount] [decimal] (18, 6) NOT NULL,
[Bill] [bit] NOT NULL,
[Stocked] [bit] NOT NULL,
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_Amount] DEFAULT ((0)),
[TaxFlag] [int] NOT NULL,
[CostGLID] [int] NULL,
[CostDeptID] [int] NULL,
[CostAppliedGLID] [int] NULL,
[CostAppliedDeptID] [int] NULL,
[Cost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_Cost] DEFAULT ((0)),
[VoidCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_VoidCost] 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_SCReportMaterials_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCReportMaterials_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[PriceSourceID] [int] NOT NULL CONSTRAINT [DF_SCReportMaterials_PriceSourceID] DEFAULT ((1)),
[SystemComputedPrice] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_SystemComputedPrice] DEFAULT ((0)),
[ReturnCodeID] [int] NULL,
[ReturnRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCReportMaterials_ReturnRemarks] DEFAULT (''),
[StockTypeID] [int] NOT NULL CONSTRAINT [DF_SCReportMaterials_StockTypeID] DEFAULT ((1)),
[OverriddenCost] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterials_OverriddenCost] DEFAULT ((0)),
[ChargeOutCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_ChargeOutCost] DEFAULT ((0)),
[WarrantyStarted] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterials_WarrantyStarted] DEFAULT ((0)),
[IsWarrantied] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterials_IsWarrantied] DEFAULT ((0)),
[TransactionWarrantyID] [int] NULL,
[UsageStatusID] [int] NOT NULL CONSTRAINT [DF_SCReportMaterials_UsageStatusID] DEFAULT ((1)),
[ReqDate] [datetime] NULL,
[DeliveryMethodID] [int] NULL,
[Canceled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCReportMaterials_Canceled] DEFAULT ((0)),
[ContractItemLimitID] [int] NULL,
[OutCostRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCReportMaterials_OutCostRate] DEFAULT ((0)),
[CalculatedOutCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_CalculatedOutCost] DEFAULT ((0)),
[OutCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_OutCost] DEFAULT ((0)),
[UseBaseOutCost] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterials_UseBaseOutCost] DEFAULT ((0)),
[OverrideOutCost] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterials_OverrideOutCost] DEFAULT ((0)),
[OutCostExtended] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_OutCostExtended] DEFAULT ((0)),
[MoveOrderDetail] [bit] NOT NULL CONSTRAINT [DF_SCReportMaterials_MoveOrderDetail] DEFAULT ((0)),
[MoveOrderLinkedDetailID] [int] NULL,
[MoveOrderLocation] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[IntercompanyGLID] [int] NULL,
[EarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_EarnedAmount] DEFAULT ((0)),
[UnitCost] [money] NOT NULL CONSTRAINT [DF_SCReportMaterials_UnitCost] DEFAULT ((0)),
[TaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [PK_SCReportMaterials] PRIMARY KEY CLUSTERED  ([ReportID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_ContractItemLimitID_SCContractItemLimits] FOREIGN KEY ([ContractItemLimitID]) REFERENCES [dbo].[SCContractItemLimits] ([ContractItemLimitID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_CostAppliedDeptID_GLDepts5] FOREIGN KEY ([CostAppliedDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_CostAppliedGLID_GLAccounts5] FOREIGN KEY ([CostAppliedGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_CostDeptID_GLDepts5] FOREIGN KEY ([CostDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_CostGLID_GLAccounts5] FOREIGN KEY ([CostGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_DeliveryMethodID_ICDeliveryMethods] FOREIGN KEY ([DeliveryMethodID]) REFERENCES [dbo].[ICDeliveryMethods] ([DeliveryMethodID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_GLID_GLAccounts5] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_IntercompanyGLID_GLAccounts] FOREIGN KEY ([IntercompanyGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_ItemID_ICItems1] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems1] ([ItemID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_PriceSourceID_ARPriceSources] FOREIGN KEY ([PriceSourceID]) REFERENCES [dbo].[ARPriceSources] ([PriceSourceID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_ReportID_SCReportMaterials] FOREIGN KEY ([ReportID], [MoveOrderLinkedDetailID]) REFERENCES [dbo].[SCReportMaterials] ([ReportID], [DetailID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_ReportID_SCReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[SCReports] ([ReportID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_ReturnCodeID_ICReturnCodes] FOREIGN KEY ([ReturnCodeID]) REFERENCES [dbo].[ICReturnCodes] ([ReturnCodeID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_StockTypeID_ICStockTypes] FOREIGN KEY ([StockTypeID]) REFERENCES [dbo].[ICStockTypes] ([StockTypeID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_UMID_ICUnits] FOREIGN KEY ([UMID]) REFERENCES [dbo].[ICUnits] ([ID])
GO
ALTER TABLE [dbo].[SCReportMaterials] ADD CONSTRAINT [FK_SCReportMaterials_UsageStatusID_ICUsageStatuses] FOREIGN KEY ([UsageStatusID]) REFERENCES [dbo].[ICUsageStatuses] ([UsageStatusID])
GO