Tables [dbo].[SCQAccrualEquipments]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:34 AM Thursday, March 21, 2019
Last Modified1:15:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCQAccrualEquipments: AccrualID\ContractDetailID\EquipmentDetailIDForeign Keys FK_SCQAccrualEquipments_AccrualID_SCQAccrualContracts: [dbo].[SCQAccrualContracts].AccrualID\ContractDetailIDAccrualIDint4
False
Cluster Primary Key PK_SCQAccrualEquipments: AccrualID\ContractDetailID\EquipmentDetailIDForeign Keys FK_SCQAccrualEquipments_AccrualID_SCQAccrualContracts: [dbo].[SCQAccrualContracts].AccrualID\ContractDetailIDContractDetailIDint4
False
Cluster Primary Key PK_SCQAccrualEquipments: AccrualID\ContractDetailID\EquipmentDetailIDEquipmentDetailIDint4
False
Foreign Keys FK_SCQAccrualEquipments_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
BaseAmountmoney8
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
BaseFromDatedatetime8
True
BaseToDatedatetime8
True
Foreign Keys FK_SCQAccrualEquipments_SCContractDetailID_SCContractDetails: [dbo].[SCContractDetails].SCContractDetailIDSCContractDetailIDint4
False
DistCodeIDint4
True
Foreign Keys FK_SCQAccrualEquipments_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCQAccrualEquipments_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCQAccrualEquipments_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
BillBaseFromDatedatetime8
True
BillBaseToDatedatetime8
True
LeaseAmountmoney8
False
((0))
PrincipalAmountmoney8
False
((0))
InterestAmountmoney8
False
((0))
LeasePostTermAmountmoney8
False
((0))
Foreign Keys FK_SCQAccrualEquipments_ContractDetailTypeID_SCContractDetailTypes: [dbo].[SCContractDetailTypes].ContractDetailTypeIDContractDetailTypeIDint4
False
((1))
SCContractDetailInstancedecimal(18,6)9
False
((0))
BaseAccrualTypeIDint4
False
((1))
Foreign Keys FK_SCQAccrualEquipments_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Descriptionvarchar(255)255
False
('')
Foreign Keys FK_SCQAccrualEquipments_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQAccrualEquipments: AccrualID\ContractDetailID\EquipmentDetailIDPK_SCQAccrualEquipmentsAccrualID, ContractDetailID, EquipmentDetailID
True
80
NameColumns
FK_SCQAccrualEquipments_AccrualID_SCQAccrualContractsAccrualID->[dbo].[SCQAccrualContracts].[AccrualID]
ContractDetailID->[dbo].[SCQAccrualContracts].[ContractDetailID]
FK_SCQAccrualEquipments_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQAccrualEquipments_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCQAccrualEquipments_ContractDetailTypeID_SCContractDetailTypesContractDetailTypeID->[dbo].[SCContractDetailTypes].[ContractDetailTypeID]
FK_SCQAccrualEquipments_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQAccrualEquipments_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCQAccrualEquipments_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCQAccrualEquipments_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCQAccrualEquipments_SCContractDetailID_SCContractDetailsSCContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
CREATE TABLE [dbo].[SCQAccrualEquipments]
(
[AccrualID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[EquipmentDetailID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[BaseAmount] [money] 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_SCQAccrualEquipments_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[SCContractDetailID] [int] NOT NULL,
[DistCodeID] [int] NULL,
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[BillBaseFromDate] [datetime] NULL,
[BillBaseToDate] [datetime] NULL,
[LeaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_LeaseAmount] DEFAULT ((0)),
[PrincipalAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_PrincipalAmount] DEFAULT ((0)),
[InterestAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_InterestAmount] DEFAULT ((0)),
[LeasePostTermAmount] [money] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_LeasePostTermAmount] DEFAULT ((0)),
[ContractDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_ContractDetailTypeID] DEFAULT ((1)),
[SCContractDetailInstance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_SCContractDetailInstance] DEFAULT ((0)),
[BaseAccrualTypeID] [int] NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_BaseAccrualTypeID] DEFAULT ((1)),
[ItemID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQAccrualEquipments_Description] DEFAULT (''),
[LocationID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [PK_SCQAccrualEquipments] PRIMARY KEY CLUSTERED  ([AccrualID], [ContractDetailID], [EquipmentDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_AccrualID_SCQAccrualContracts] FOREIGN KEY ([AccrualID], [ContractDetailID]) REFERENCES [dbo].[SCQAccrualContracts] ([AccrualID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_ContractDetailTypeID_SCContractDetailTypes] FOREIGN KEY ([ContractDetailTypeID]) REFERENCES [dbo].[SCContractDetailTypes] ([ContractDetailTypeID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQAccrualEquipments] ADD CONSTRAINT [FK_SCQAccrualEquipments_SCContractDetailID_SCContractDetails] FOREIGN KEY ([SCContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO